| # |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 9 |
LONG_TERM_SEQNUM |
Number(2,0) |
SMALLINT NOT NULL |
Long Term Earnings Seqnum
|
| 10 |
LONG_TRM_ERNS_WCB |
Number(8,0) |
INTEGER NOT NULL |
Long Term Earnings WCB
|
| 11 |
PERIOD_START_DT_C |
Character(10) |
VARCHAR2(10) NOT NULL |
Period Start Date C
|
| 12 |
PERIOD_END_DATE_C |
Character(10) |
VARCHAR2(10) NOT NULL |
Period End Date C
|
| 13 |
DATE_CHG_REASON |
Character(200) |
VARCHAR2(200) NOT NULL |
Date Change Reason
|
| 14 |
WCB_REC_SEQ_NUM2 |
Number(4,0) |
SMALLINT NOT NULL |
WCB Record Sequence #2 Trailer
|
| 15 |
WCB_REC_TRLR |
Character(3) |
VARCHAR2(3) NOT NULL |
WCB Record Trailer
|
| 16 |
WCBFILLER |
Character(2) |
VARCHAR2(2) NOT NULL |
WCB Filler
|