CFG_SAMPLE_ZIP (SQL Table)	Index Back
Sample Zip Code Reference This records contains latitude and longitude information for zip codes. This data was originally entered to support the ATM/Frame Relay configuration solution, which uses the distance between sites to calculate pricing. This data is sample data only and should not be considered accurate.

CFG_SAMPLE_ZIP

(SQL Table)

Sample Zip Code Reference

This records contains latitude and longitude information for zip codes. This data was originally entered to support the ATM/Frame Relay configuration solution, which uses the distance between sites to calculate pricing. This data is sample data only and should not be considered accurate.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

2 LATITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LATITUDE

3 LONGITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LONGITUDE

4 ZIP_CLASS Character(1) VARCHAR2(1) NOT NULL Zip Classification

5 PO_NAME Character(28) VARCHAR2(28) NOT NULL Post Office Name

6 STATE Character(6) VARCHAR2(6) NOT NULL State

7 COUNTY Character(30) VARCHAR2(30) NOT NULL County

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
2	LATITUDE	Signed Number(32,20)	DECIMAL(30,20) NOT NULL	LATITUDE
3	LONGITUDE	Signed Number(32,20)	DECIMAL(30,20) NOT NULL	LONGITUDE
4	ZIP_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Zip Classification
5	PO_NAME	Character(28)	VARCHAR2(28) NOT NULL	Post Office Name
6	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
7	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County