BENEFIT_RCD_NBREFFDTDefault Value: %date
EMPL_RCDN=Stop Primary
Y=Start Primary
R_BN_PRIJOB2(SQL Table) |
Index Back |
|---|---|
Primary Jobs RebuildingThis is a work table for Primary Jobs Table population used by utility BEN500.SQR. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | PRIMARY_JOB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Primary Job used by applications other than HR
N=Stop Primary Y=Start Primary |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 7 | JOB_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | employee employee record number |