BILL_PER_CDEMPLIDMSGIDMSGDATA1MSGDATA2MSGDATA3BEN_BI_MESSAGE(SQL Table) |
Index Back |
|---|---|
Ben Billing Error MessagesBEN_BI_MESSAGE is a record that is used to store messages (usually errors that must be resolved) that are generated by the Charge Calculation Cobol job of the Benefits Billing product. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BILL_PER_CD |
Character(4) | VARCHAR2(4) NOT NULL | Billing Period |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | MSGID |
Character(6) | VARCHAR2(6) NOT NULL | Message ID |
| 4 | MSGDATA1 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 5 | MSGDATA2 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 6 | MSGDATA3 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |