| # |
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 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 6 |
COBRA_EVENT_DT |
Date(10) |
DATE |
COBRA Event Date
|
| 7 |
CBR_QUALIFY_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
COBRA Qualify Status
NQ=Not COBRA Qualified
QE=COBRA Qualify Error
QL=COBRA Qualified
QP=Qualify Pending
UN=Unprocessed
|
| 8 |
CBR_PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
COBRA Process Status
C=Closed for Processing
O=Open for Processing
V=Void
|
| 9 |
CBR_INIT_EVENT_STS |
Character(2) |
VARCHAR2(2) NOT NULL |
COBRA Initial Event Status
EC=Enrollment Complete
EE=Election Error
ER=Election Enrolled
ET=Election Entered
NQ=Not Qualified
NT=Notified
OE=Option Preparation Error
OP=Options Prepared
QL=Qualified
QP=Qualify Pending
|
| 10 |
CBR_SCND_EVENT_STS |
Character(2) |
VARCHAR2(2) NOT NULL |
COBRA Secondary Event Status
CE=Coverage Extended
NQ=Not Qualified
NT=Notified
QL=Qualified
QP=Qualify Pending
|
| 11 |
CBR_INIT_NOTIFY_DT |
Date(10) |
DATE |
COBRA Initial Notification Dt
|
| 12 |
CBR_INIT_PRINT_DT |
Date(10) |
DATE |
COBRA Initial Notify Print Dat
|
| 13 |
CBR_SCND_NOTIFY_DT |
Date(10) |
DATE |
COBRA Second Notification Date
|
| 14 |
COBRA_ELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
COBRA Election
E=Elect
W=Waive
|
| 15 |
COBRA_ELECT_DT |
Date(10) |
DATE |
COBRA Election Date
|
| 16 |
COBRA_WAIVE_DT |
Date(10) |
DATE |
COBRA Waive Date
|
| 17 |
COBRA_REVOKE_DT |
Date(10) |
DATE |
COBRA Revoke Date
|
| 18 |
COBRA_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
COBRA Generated Emplid
|
| 19 |
BAS_ASSIGN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
BenAdmin Assign Status
AE=Program Elig Assign Error
AN=Program Elig Assign None
AS=Program Elig Assigned
|
| 20 |
CBR_TERM_NOTIFY_DT |
Date(10) |
DATE |
COBRA Termination Notify Date
|
| 21 |
CBR_TERM_PRINT_DT |
Date(10) |
DATE |
COBRA Termination Print Dt
|
| 22 |
CBR_PAR_REPRCS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
COBRA Partic Reproc Indicator
N=Normal Processing
V=Void Participant
|