EXT_ORG_CD_TYPEPrompt Table: EXORGCDTYPE_VW
POSTAL_EPSPOST_PLACE_IND_EPSA=Add
E=Existing
EPS_REC_NBRY/N Table Edit
Default Value: N
C=Completed
E=Error
O=OK to Purge
Default Value: E
EPS_SUSP_DATA(SQL Table) |
Index Back |
|---|---|
EPS Suspense RecordThis record contains those EPS data rows which had some type of problem encountered while loading into the EPS setup table. Corrections to data in this table are manual corrections to the setup table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_CD_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Ext Org Code Type
Prompt Table: EXORGCDTYPE_VW |
| 2 | POSTAL_EPS |
Character(5) | VARCHAR2(5) NOT NULL | EPS Postal Code |
| 3 | POST_PLACE_IND_EPS |
Character(1) | VARCHAR2(1) NOT NULL |
Postal Place Indicator
A=Add E=Existing |
| 4 | EPS_REC_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | EPS Record Number |
| 5 | MARKET_NAME_EPS | Character(5) | VARCHAR2(5) NOT NULL | EPS Market Name |
| 6 | MARKET_CODE_EPS | Character(4) | VARCHAR2(4) NOT NULL | EPS Market Code |
| 7 | DUP_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Duplicate Indicator
Y/N Table Edit Default Value: N |
| 8 | STATUS_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Status
C=Completed E=Error O=OK to Purge Default Value: E |