BAS_ELIG_ACAELG (SQL Table)	Index Back
BenAdmin Elig ACA Status BAS_ELIG_ACAELG is one of the records that identify benefit program/option eligibility criteria. It is used to record what employee's status is eligible for a given benefit program and/or option. It is created online by the Eligibility panels under Benefits Administration tables. The information is used for processing Benefits Administration.

BAS_ELIG_ACAELG

(SQL Table)

BenAdmin Elig ACA Status

BAS_ELIG_ACAELG is one of the records that identify benefit program/option eligibility criteria. It is used to record what employee's status is eligible for a given benefit program and/or option. It is created online by the Eligibility panels under Benefits Administration tables. The information is used for processing Benefits Administration.

Parent record: BAS_ELIG_RULES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ELIG_RULES_ID Character(4) VARCHAR2(4) NOT NULL Eligibility Rules ID
Prompt Table: BAS_ELIG_RULES

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 ACA_GRP_ID Character(3) VARCHAR2(3) NOT NULL ACA Coomon ID.
Prompt Table: ACA_ID_TBL

4 BN_ACA_ELIG_IND Character(1) VARCHAR2(1) NOT NULL ACA (Affordable Care Act) Eligibility Indicator
A=Always Eligible
E=Eligible
I=Ineligible
U=To be determined
X=Excluded

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ELIG_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Eligibility Rules ID Prompt Table: BAS_ELIG_RULES
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	ACA_GRP_ID	Character(3)	VARCHAR2(3) NOT NULL	ACA Coomon ID. Prompt Table: ACA_ID_TBL
4	BN_ACA_ELIG_IND	Character(1)	VARCHAR2(1) NOT NULL	ACA (Affordable Care Act) Eligibility Indicator A=Always Eligible E=Eligible I=Ineligible U=To be determined X=Excluded