HCI_EOADDRFMTVW(SQL View) |
Index Back |
|---|---|
Address fieldsThis interface view is a listing of the distinct address fields that are used in the makeup of the address. |
| SELECT A.COUNTRY ,A.EO_ADDRESS_FIELD ,A.EO_ADDR_FLD_SEQ ,A.EO_ADDR_FLD_LBL ,A.EO_MAX_LENGTH ,A.EO_ADDR_LKP_FLG ,A.EO_ADDR_LKP_TBL ,A.EO_ADDR_LKP_FLD ,A.EO_ADDR_LKP_DESCR ,A.EO_ADDR_LKP_FMT ,A.EO_USED_IN_SRCH ,A.EO_ADDR_DISPLAY ,A.EO_ADDR_PRINT ,A.EO_ADDR_LINE ,A.EO_ADDR_POSITION ,A.EO_ADDR_FLD_OVR ,A.EO_ADDR_PRE_SEP ,A.EO_ADDR_PST_SEP ,A.REQUIRED_FLG FROM %Table(EO_ADDR_FMT_TBL) A |
| # | 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
Prompt Table: EO_ADDR_SBR_VW |
| 3 | EO_ADDR_FLD_SEQ | Number(3,0) | SMALLINT NOT NULL | Addres Field Entry Sequence Number |
| 4 | EO_ADDR_FLD_LBL | Character(30) | VARCHAR2(30) NOT NULL | Address 2 Label |
| 5 | EO_MAX_LENGTH | Number(3,0) | SMALLINT NOT NULL |
Maximum Length
Default Value: 1 |
| 6 | EO_ADDR_LKP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Address field lookup flag
Y/N Table Edit Default Value: N |
| 7 | EO_ADDR_LKP_TBL | Character(15) | VARCHAR2(15) NOT NULL |
Address field lookup table
Prompt Table: EO_ADDR_LKP_VW1 |
| 8 | EO_ADDR_LKP_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Address field lookup field
Prompt Table: EO_ADDR_LKP_DVW |
| 9 | EO_ADDR_LKP_DESCR | Character(18) | VARCHAR2(18) NOT NULL |
Address field lookup description field
Prompt Table: EO_ADDR_LKP_DVW |
| 10 | EO_ADDR_LKP_FMT | Character(4) | VARCHAR2(4) NOT NULL |
Address field lookup format:
D - Drop Down
P - Prompt
D=Drop Down P=Prompt Table |
| 11 | EO_USED_IN_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Used in search
Y/N Table Edit Default Value: N |
| 12 | EO_ADDR_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Address display
Y/N Table Edit Default Value: Y |
| 13 | EO_ADDR_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Address print
Y/N Table Edit Default Value: Y |
| 14 | EO_ADDR_LINE | Number(2,0) | SMALLINT NOT NULL | Address All |
| 15 | EO_ADDR_POSITION | Number(2,0) | SMALLINT NOT NULL | Address position number |
| 16 | EO_ADDR_FLD_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Address field over
Y/N Table Edit Default Value: N |
| 17 | EO_ADDR_PRE_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address pre separator |
| 18 | EO_ADDR_PST_SEP | Character(3) | VARCHAR2(3) NOT NULL | Address post separator |
| 19 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |