| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
ECFILEROWID |
Character(3) |
VARCHAR2(3) NOT NULL |
Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length.
|
| 2 |
WCB_REC_HDR |
Character(3) |
VARCHAR2(3) NOT NULL |
WCB Record Header
|
| 3 |
WCB_REC_TYP_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
WCB Record Type ID
|
| 4 |
WCB_REC_VERSION |
Number(3,0) |
SMALLINT NOT NULL |
WCB Record Version
|
| 5 |
WCB_VAR_REC_LENGTH |
Number(4,0) |
SMALLINT NOT NULL |
WCB Variable Record Length
|
| 6 |
WCB_REC_SEQ_NUM |
Character(4) |
VARCHAR2(4) NOT NULL |
WCB Record Sequence Number Tr
|
| 7 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
|
| 8 |
PREVENT_ACTN_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Preventative Action Code
|
| 9 |
OTHER_PREV_DESCR |
Character(40) |
VARCHAR2(40) NOT NULL |
Other Preventative Action Desc
|
| 10 |
WCB_REC_SEQ_NUM2 |
Number(4,0) |
SMALLINT NOT NULL |
WCB Record Sequence #2 Trailer
|
| 11 |
WCB_REC_TRLR |
Character(3) |
VARCHAR2(3) NOT NULL |
WCB Record Trailer
|
| 12 |
WCBFILLER |
Character(2) |
VARCHAR2(2) NOT NULL |
WCB Filler
|