SCHED_IDEMPLIDBENEFIT_RCD_NBREVENT_IDEMPL_RCDBAS_ELIG_SRCA=ADDRESSES
J=JOB
ELIG_EFFDTELIG_EFFSEQN=Stop Primary
Y=Start Primary
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
BAS_PARTIC_ELIG(SQL Table) |
Index Back |
|---|---|
BAS Participant EligibilityBAS_PARTIC_ELIG is the record that contains pointers to the tables that contributed eligibility information to the processing of the event. Especially useful in multi-job environments as this information appears on the Event Summary Inquiry panel, providing a record of the jobs that existed when the event was processed. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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. |
| 4 | EVENT_ID |
Number(6,0) | INTEGER NOT NULL | Event Identification |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | BAS_ELIG_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Eligibility Source
A=ADDRESSES J=JOB |
| 7 | ELIG_EFFDT |
Date(10) | DATE | Eligibility Effective Date |
| 8 | ELIG_EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Eligibility Effective Sequence |
| 9 | PRIMARY_JOB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Primary Job used by applications other than HR
N=Stop Primary Y=Start Primary Y/N Table Edit |
| 10 | PRIMARY_FLAG1 | Character(1) | VARCHAR2(1) NOT NULL |
Include Job for Eligibility
Y/N Table Edit |
| 11 | PRIMARY_FLAG2 | Character(1) | VARCHAR2(1) NOT NULL |
Include Job for Deductions
Y/N Table Edit |