ACA_DX_EMP_CH4D

(SQL Table)
Index Back

ACA Form Code Series 1 Ranking

ACA Form Code Series 1 Ranking

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACA_DAT_EXTRACT_ID Character(10) VARCHAR2(10) NOT NULL Extract ID for the ACA data
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
4 ACA_EMP_DATA_ID Character(4) VARCHAR2(4) NOT NULL ID for the employee ACA data
CDS1=Offer of Coverage Code
CDS2=SafeHarbor & OtherRelief Codes
HRZP=HRA Zip Code
LCST=Self-Only Lowest Premium Cost
LCSV=Self Low Cost Base Benefits
LCSX=Self Low Cost BA No Credit
LCSY=Self Low Cost BA With Credit
OHRA=HRA Silver Plan
OHRB=HRA Employer Contrib Base Ben
OHRD=HRA Employer Contrib Ben Admin
OHRR=HRA Empl Required Contribution
5 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
6 CHAR4_DEF Character(4) VARCHAR2(4) NOT NULL Monthly Default Value
7 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.

Y/N Table Edit

Default Value: N

8 ASOF_DAY_INMONTH Character(4) VARCHAR2(4) NOT NULL Day month values used for ACA processing
D1MN=First Day
LDMN=Last Day
MMDD=Specified Day
9 ACA_AS_OF_DD Number(2,0) SMALLINT NOT NULL As of Day
10 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: ACA_DTEX_SQL_VW

  • 11 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N