COUNTRYPrompt Table: COUNTRY_TBL
EO_ADDRESS_FIELDY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
EO_ADDR_FMT_TBL(SQL Table) |
Index Back |
|---|---|
Address fieldsThis record is a listing of the distinct address fields that are used in the makeup of the address. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | EO_ADDRESS_FIELD |
Character(18) | VARCHAR2(18) NOT NULL | Address field |
| 3 | EO_ADDR_FLD_LBL | Character(15) | VARCHAR2(15) NOT NULL | Address 2 Label |
| 4 | EO_USED_IN_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Used in search
Y/N Table Edit Default Value: N |
| 5 | EO_ADDR_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Address display
Y/N Table Edit Default Value: Y |
| 6 | EO_ADDR_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Address print
Y/N Table Edit Default Value: Y |
| 7 | EO_ADDR_LINE | Number(2,0) | SMALLINT NOT NULL | Address All |
| 8 | EO_ADDR_POSITION | Number(2,0) | SMALLINT NOT NULL | Address position number |
| 9 | EO_ADDR_FLD_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Address field over
Y/N Table Edit Default Value: N |
| 10 | EO_ADDR_PRE_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address pre separator |
| 11 | EO_ADDR_PST_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address post separator |