BAS_PARTIC_ELIG (SQL Table)	Index Back
BAS Participant Eligibility BAS_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.

BAS_PARTIC_ELIG

(SQL Table)

BAS Participant Eligibility

BAS_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.

Parent record: BAS_PARTIC

# 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 Record

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 flag used to indicate employee primary job
Y/N Table Edit

11 PRIMARY_FLAG2 Character(1) VARCHAR2(1) NOT NULL flag used to indicate employee primary job
Y/N Table Edit

#	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 Record
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	flag used to indicate employee primary job Y/N Table Edit
11	PRIMARY_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job Y/N Table Edit