BAS_P_ELIG_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	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.
6	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
8	BAS_ELIG_SRC	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Source A=ADDRESSES J=JOB
9	ELIG_EFFDT	Date(10)	DATE	Eligibility Effective Date
10	ELIG_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Eligibility Effective Sequence
11	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
12	PRIMARY_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job Y/N Table Edit
13	PRIMARY_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job Y/N Table Edit