ACA_PER_DTL (SQL Table)	Index Back
ACA Person Eligibility Detail Person's Affordable Care Act (ACA) eligibility detail record.

ACA_PER_DTL

(SQL Table)

ACA Person Eligibility Detail

Person's Affordable Care Act (ACA) eligibility detail 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.

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

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

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: JOB

6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: ACA_CMPY_TBL

7 ACA_HOURS Signed Number(9,2) DECIMAL(7,2) NOT NULL ACA Total Hours.

8 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

9 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.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: JOB
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: ACA_CMPY_TBL
7	ACA_HOURS	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	ACA Total Hours.
8	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
9	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.