R_BN_PRIJOB1(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 Rcd Nbr |
| 4 | PRIMARY_ERN | Number(4,0) | SMALLINT NOT NULL | Benefits Pre Upgrade Step primary_ern value set by client |
| 5 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 8 | JOB_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | EmplID Record Number Job |