SCC_POST_AV_VW(SQL View) |
Index Back |
---|---|
Post codesUsed in populating drop downs when dynamic prompts are used in address format setup. This is marked not to be available for selection as a prompt in the address format setup (via EO_ADDR_LKP_VW1). |
SELECT DISTINCT COUNTRY , POSTAL FROM PS_EO_ADDR_VALIDAT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
2 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |