EXT_ORG_IDPrompt Table: EXT_ORG_TBL
EXT_ORG_CD_TYPEPrompt Table: EXORGCDTYPE_VW
POSTAL_EPSEPS_ZIPMRKT_VW(SQL View) |
Index Back |
|---|---|
EPS Zip to Market viewThis view links the 'Zip To Market' data from EPS to an External Organization for use by Search/Match. |
| SELECT A.EXT_ORG_ID , A.EXT_ORG_CD_TYPE , A.POSTAL_EPS , B.MARKET_NAME_EPS , B.MARKET_CODE_EPS FROM PS_EXT_ORG_CODES A , PS_EPS_ZIPMRKT_TBL B WHERE A.EXT_ORG_CD_TYPE=B.EXT_ORG_CD_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | EXT_ORG_CD_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Ext Org Code Type
Prompt Table: EXORGCDTYPE_VW |
| 3 | POSTAL_EPS |
Character(5) | VARCHAR2(5) NOT NULL | EPS Postal Code |
| 4 | MARKET_NAME_EPS | Character(5) | VARCHAR2(5) NOT NULL | EPS Market Name |
| 5 | MARKET_CODE_EPS | Character(4) | VARCHAR2(4) NOT NULL | EPS Market Code |