PRINT_IDEMPLIDPrompt Table: CBR_PRNT_PAR_V1
BENEFIT_RCD_NBRPrompt Table: CBR_PRNT_PAR_V2
COBRA_EVENT_IDPrompt Table: CBR_PRNT_PAR_V3
DEPENDENT_BENEF01=default
Prompt Table: CBR_PRNT_PAR_V4
Y/N Table Edit
Default Value: N
CBR_PRNT_PARTIC(SQL Table) |
Index Back |
|---|---|
COBRA Participant ReprintCBR_Prnt_Partic is a record that allows the user to establish an id for reprinting letters for a specified set of COBRA participants. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRINT_ID |
Character(6) | VARCHAR2(6) NOT NULL | Print ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: CBR_PRNT_PAR_V1 |
| 3 | 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.
Prompt Table: CBR_PRNT_PAR_V2 |
| 4 | COBRA_EVENT_ID |
Number(3,0) | SMALLINT NOT NULL |
Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
Prompt Table: CBR_PRNT_PAR_V3 |
| 5 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: CBR_PRNT_PAR_V4 |
| 6 | REPRINT_ALL_DEPS | Character(1) | VARCHAR2(1) NOT NULL |
Reprint all Dependents
Y/N Table Edit Default Value: N |