EMPLIDBENEFIT_RCD_NBRCOBRA_EVENT_IDDEPENDENT_BENEF01=default
MSGIDMSGDATA1MSGDATA2MSGDATA3COBRA_MESSAGE(SQL Table) |
Index Back |
|---|---|
COBRA Message TableCOBRA_Message is a record that is used to store messages (usually errors that must be resolved) that are generated by the COBOL job of the COBRA Administration product. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_RCD_NBR |
Number(3,0) | SMALLINT NOT NULL | Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number. |
| 3 | COBRA_EVENT_ID |
Number(3,0) | SMALLINT NOT NULL | Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated. |
| 4 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 5 | MSGID |
Character(6) | VARCHAR2(6) NOT NULL | Message ID |
| 6 | MSGDATA1 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 7 | MSGDATA2 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 8 | MSGDATA3 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |