ACA_EMP_BK_C20D

(SQL Table)
Index Back

ACA Employee Monthly Zip code

Audit Record for all ACA Employee Monthly Zip code Data

  • Audit Record: ACA_EMP_BK_CH4D
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    4 ACA_DAT_EXTRACT_ID Character(10) VARCHAR2(10) NOT NULL Extract ID for the ACA data
    5 ACA_ALE_MEMBER Character(3) VARCHAR2(3) NOT NULL Used to contain value of ALE Member name
    6 ACA_CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL 1094-C/1095-C Calendar Year
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

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

    Default Value: 0

    9 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
    10 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

    11 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    12 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
    13 CHAR20_ALL Character(20) VARCHAR2(20) NOT NULL All Months indicator
    14 CHAR20_01 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    15 CHAR20_02 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    16 CHAR20_03 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    17 CHAR20_04 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    18 CHAR20_05 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    19 CHAR20_06 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    20 CHAR20_07 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    21 CHAR20_08 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    22 CHAR20_09 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    23 CHAR20_10 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    24 CHAR20_11 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing
    25 CHAR20_12 Character(20) VARCHAR2(20) NOT NULL Values used for ACA processing