RGN_POSTAL_TBL

(SQL Table)
Index Back

Region Postal Table

Use the Region Postal Table to define postal codes and their corresponding address information. This table is used as a detail node in several trees.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY_POSTAL Character(15) VARCHAR2(15) NOT NULL Country Postal
2 CITY Character(30) VARCHAR2(30) NOT NULL City
3 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_TBL

4 COUNTY Character(30) VARCHAR2(30) NOT NULL County
5 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: INSTALLATION.COUNTRY

Prompt Table: COUNTRY_TBL