WCB_IWWD_WD

(SQL Table)
Index Back

EDI Work Defn - IWWD

EDI Work Defn table for the BC WCB Worker's Compenstation board input.

# 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 SCHEDULE_SEQNUM Number(2,0) SMALLINT NOT NULL Schedule Sequence Number
10 HRS_PER_DAY Number(4,0) SMALLINT NOT NULL Hours Per Day
11 DAY_OF_WK_CD Character(2) VARCHAR2(2) NOT NULL Day of the Week Code
12 TIME_PERIOD_CD Character(1) VARCHAR2(1) NOT NULL Time Period
B=Biweekly
D=Day
H=Hour
M=Month
Q=Quarter
S=Semi-monthly
T=Ten-monthly
W=Week
Y=Year
13 SHIFT_DIFF_PCT Number(8,0) INTEGER NOT NULL Shift Differential Percent
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