WCB_MSGHD_EC(SQL Table) |
Index Back |
|---|---|
Staging Table - WCB Message HdStaging table for the BC WCB Worker's Compenstation board input. Message Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECTRANSID | Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | ECTRANSINOUTSW | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 4 | WCB_REC_HDR | Character(3) | VARCHAR2(3) NOT NULL | WCB Record Header |
| 5 | FV_IND_BC_CAN | Character(1) | VARCHAR2(1) NOT NULL | Fixed Variable Indicator |
| 6 | WCB_REC_VERSION | Number(3,0) | SMALLINT NOT NULL | WCB Record Version |
| 7 | SENDER_ID_BC_CAN | Character(5) | VARCHAR2(5) NOT NULL | Sender Electronic ID |
| 8 | MSG_ID_BC_CAN | Character(9) | VARCHAR2(9) NOT NULL | Message ID |
| 9 | RECEIVER_ID_BC_CAN | Character(5) | VARCHAR2(5) NOT NULL | Receiver Electronic ID |
| 10 | MESSAGE_SENT_DT_C | Character(10) | VARCHAR2(10) NOT NULL | Message Sent Dt C |
| 11 | MESSAGE_SENT_TM5 | Character(8) | VARCHAR2(8) NOT NULL | Message Sent Time |
| 12 | ACKKNWLG_REQD_SW | Character(1) | VARCHAR2(1) NOT NULL | Acknowlegement Required |
| 13 | SRCE_SFTWR_ID | Character(2) | VARCHAR2(2) NOT NULL | WCB Source Software ID |
| 14 | SRCE_SFTWR_VERS | Character(8) | VARCHAR2(8) NOT NULL | Source Software Version |
| 15 | SRCE_EMAIL_BC_CAN | Character(2) | VARCHAR2(2) NOT NULL | Source Email Services |
| 16 | SRCE_MBOX_BC_CAN | Character(40) | VARCHAR2(40) NOT NULL | Source Mailbox ID |
| 17 | DEST_EMAIL_BC_CAN | Character(2) | VARCHAR2(2) NOT NULL | Destination Email ID |
| 18 | DEST_MBOX_BC_CAN | Character(40) | VARCHAR2(40) NOT NULL | Destination Mailbox ID |
| 19 | TEST_PROD_INDCTR | Character(1) | VARCHAR2(1) NOT NULL | WCB Test or Prod Indicator |
| 20 | NUM_REC_BC_CAN | Number(4,0) | SMALLINT NOT NULL | Number of Records Transmitted |
| 21 | FILE_NAME_BC_CAN | Character(12) | VARCHAR2(12) NOT NULL | File Name Attached |
| 22 | FIELD_SEP_BC_CAN | Character(1) | VARCHAR2(1) NOT NULL | Variable Field Separator |
| 23 | WCB_FILR3 | Character(1) | VARCHAR2(1) NOT NULL | WCB Filler 3 |
| 24 | WCB_REC_TRLR | Character(3) | VARCHAR2(3) NOT NULL | WCB Record Trailer |
| 25 | WCB_FILR4 | Character(2) | VARCHAR2(2) NOT NULL | WCB Filler 4 |