ACA_PER_ELIG (SQL Table)	Index Back
ACA Person Eligibility Person's Affordable Care Act (ACA) overall eligibility record.

ACA_PER_ELIG

(SQL Table)

ACA Person Eligibility

Person's Affordable Care Act (ACA) overall eligibility record.

Parent record: ACA_PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 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

6 SERVICE_HRS Signed Number(11,3) DECIMAL(9,3) NOT NULL Hours of Service

7 ACA_FREQ Character(1) VARCHAR2(1) NOT NULL ACA average service hours frequency
M=Monthly
W=Weekly
Default Value: W

8 ACA_EVAL_B_DT Date(10) DATE ACA Evaluation Begin Date.

9 ACA_EVAL_E_DT Date(10) DATE ACA Evaluation End Date.

10 ACA_ADMIN_B_DT Date(10) DATE ACA Administration Begin Date.

11 ACA_ADMIN_E_DT Date(10) DATE ACA Administration End Date.

12 ACA_STAB_B_DT Date(10) DATE ACA Stability Begin Date.

13 ACA_STAB_E_DT Date(10) DATE ACA Stability End Date.

14 ACA_CALC_METH Character(1) VARCHAR2(1) NOT NULL ACA Calculation method.
L=Look Back
M=Monthly
Default Value: L

15 TOT_HRS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Hours

16 ACA_WEEKS Number(6,2) DECIMAL(5,2) NOT NULL ACA Total Weeks.

17 ACA_NONASSESS_IND Character(1) VARCHAR2(1) NOT NULL ACA Non-Assessment Period indicator
Y/N Table Edit
Default Value: N

18 ACA_NONASSESS_RSN Character(3) VARCHAR2(3) NOT NULL ACA Non-Assessment Reason
FYR=First Year as ALE Period
ICS=Initial Period - Status Change
IHR=Initial Period - Hire
IRH=Initial Period - Rehire
WCS=Wait Period - Status Change
WHR=Wait Period - Hire
WRH=Wait Period - Rehire

19 ACA_NONASSESS_E_DT Date(10) DATE ACA Non-Assessment End Date

20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime

21 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ACA_GRP_ID	Character(3)	VARCHAR2(3) NOT NULL	ACA Common ID. Prompt Table: ACA_ID_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	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
6	SERVICE_HRS	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	Hours of Service
7	ACA_FREQ	Character(1)	VARCHAR2(1) NOT NULL	ACA average service hours frequency M=Monthly W=Weekly Default Value: W
8	ACA_EVAL_B_DT	Date(10)	DATE	ACA Evaluation Begin Date.
9	ACA_EVAL_E_DT	Date(10)	DATE	ACA Evaluation End Date.
10	ACA_ADMIN_B_DT	Date(10)	DATE	ACA Administration Begin Date.
11	ACA_ADMIN_E_DT	Date(10)	DATE	ACA Administration End Date.
12	ACA_STAB_B_DT	Date(10)	DATE	ACA Stability Begin Date.
13	ACA_STAB_E_DT	Date(10)	DATE	ACA Stability End Date.
14	ACA_CALC_METH	Character(1)	VARCHAR2(1) NOT NULL	ACA Calculation method. L=Look Back M=Monthly Default Value: L
15	TOT_HRS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Hours
16	ACA_WEEKS	Number(6,2)	DECIMAL(5,2) NOT NULL	ACA Total Weeks.
17	ACA_NONASSESS_IND	Character(1)	VARCHAR2(1) NOT NULL	ACA Non-Assessment Period indicator Y/N Table Edit Default Value: N
18	ACA_NONASSESS_RSN	Character(3)	VARCHAR2(3) NOT NULL	ACA Non-Assessment Reason FYR=First Year as ALE Period ICS=Initial Period - Status Change IHR=Initial Period - Hire IRH=Initial Period - Rehire WCS=Wait Period - Status Change WHR=Wait Period - Hire WRH=Wait Period - Rehire
19	ACA_NONASSESS_E_DT	Date(10)	DATE	ACA Non-Assessment End Date
20	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
21	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.