ACA_EMP_MO_C20D

(SQL Table)
 Index Back

ACA Employee Monthly Code Data

Record for all ACA Employee Monthly Code Data

  • Audit Record: ACA_EMP_BK_C20D

    • # 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 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name
    3 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

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

    Default Value: 0

    6 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
    7 ACA_DATA_SRC Character(4) VARCHAR2(4) NOT NULL Source of the ACA data
    3=Third Party
    C=Component Interface
    M=Manual
    S=System

    Prompt Table: ACA_DATA_SOURCE

    8 ACA_DATA_STATUS Character(1) VARCHAR2(1) NOT NULL Status of the ACA data
    C=Replaced
    E=Error
    I=Initial Load
    M=Merged
    U=Updated
    V=Void
    W=Warning
    9 CHAR20_ALL Character(20) VARCHAR2(20) NOT NULL All Months indicator
    10 CHAR20_01 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    11 CHAR20_02 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    12 CHAR20_03 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    13 CHAR20_04 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    14 CHAR20_05 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    15 CHAR20_06 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    16 CHAR20_07 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    17 CHAR20_08 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    18 CHAR20_09 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    19 CHAR20_10 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    20 CHAR20_11 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    21 CHAR20_12 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing