CREATE TABLE ben_aca_reporting (
    ACA_REPORTING_ID          NUMBER(18, 0) ,
    PERSON_ID                 NUMBER(18, 0) ,
    DPNT_PERSON_ID            NUMBER(18, 0) ,
    YEAR                      NUMBER(18, 0) ,
    EFFECTIVE_DATE            DATE          ,
    BENFIT_RELATION_ID        NUMBER(18, 0) ,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    ASSIGNMENT_ID             NUMBER(18, 0) ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    ACA_FULL_PART_TIME        VARCHAR2(400) ,
    ACA_LINE_NO               VARCHAR2(400) ,
    ACA_CODE                  VARCHAR2(4000),
    ACA_OVERRIDE_CODE         VARCHAR2(4000),
    OVERRIDEN_BY              VARCHAR2(4000),
    OVERRIDEN_DATE            DATE          ,
    OVERRIDE_REASON           VARCHAR2(4000),
    ACA_NUMBER1               NUMBER        ,
    ACA_NUMBER2               NUMBER        ,
    ACA_NUMBER3               NUMBER        ,
    ACA_NUMBER4               NUMBER        ,
    ACA_NUMBER5               NUMBER        ,
    ACA_NUMBER6               NUMBER        ,
    ACA_NUMBER7               NUMBER        ,
    ACA_NUMBER8               NUMBER        ,
    ACA_NUMBER9               NUMBER        ,
    ACA_NUMBER10              NUMBER        ,
    ACA_NUMBER11              NUMBER        ,
    ACA_NUMBER12              NUMBER        ,
    ACA_CHAR1                 VARCHAR2(4000),
    ACA_CHAR2                 VARCHAR2(4000),
    ACA_CHAR3                 VARCHAR2(4000),
    ACA_CHAR4                 VARCHAR2(4000),
    ACA_CHAR5                 VARCHAR2(4000),
    ACA_CHAR6                 VARCHAR2(4000),
    ACA_CHAR7                 VARCHAR2(4000),
    ACA_CHAR8                 VARCHAR2(4000),
    ACA_CHAR9                 VARCHAR2(4000),
    ACA_CHAR10                VARCHAR2(4000),
    ACA_CHAR11                VARCHAR2(4000),
    ACA_CHAR12                VARCHAR2(4000),
    ACA_DATE1                 DATE          ,
    ACA_DATE2                 DATE          ,
    ACA_DATE3                 DATE          ,
    ACA_DATE4                 DATE          ,
    ACA_DATE5                 DATE          ,
    ACA_DATE6                 DATE          ,
    ACA_DATE7                 DATE          ,
    ACA_DATE8                 DATE          ,
    ACA_DATE9                 DATE          ,
    ACA_DATE10                DATE          ,
    ACA_DATE11                DATE          ,
    ACA_DATE12                DATE          ,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    PROGRAM_APP_NAME          VARCHAR2(120) ,
    PROGRAM_NAME              VARCHAR2(120) ,
    PROGRAM_UPDATE_DATE       DATE          ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    ACA_REPORTING_ID          NUMBER(18, 0) ,
    PERSON_ID                 NUMBER(18, 0) ,
    DPNT_PERSON_ID            NUMBER(18, 0) ,
    YEAR                      NUMBER(18, 0) ,
    EFFECTIVE_DATE            DATE          ,
    BENFIT_RELATION_ID        NUMBER(18, 0) ,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    ASSIGNMENT_ID             NUMBER(18, 0) ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    ACA_FULL_PART_TIME        VARCHAR2(400) ,
    ACA_LINE_NO               VARCHAR2(400) ,
    ACA_CODE                  VARCHAR2(4000),
    ACA_OVERRIDE_CODE         VARCHAR2(4000),
    OVERRIDEN_BY              VARCHAR2(4000),
    OVERRIDEN_DATE            DATE          ,
    OVERRIDE_REASON           VARCHAR2(4000),
    ACA_NUMBER1               NUMBER        ,
    ACA_NUMBER2               NUMBER        ,
    ACA_NUMBER3               NUMBER        ,
    ACA_NUMBER4               NUMBER        ,
    ACA_NUMBER5               NUMBER        ,
    ACA_NUMBER6               NUMBER        ,
    ACA_NUMBER7               NUMBER        ,
    ACA_NUMBER8               NUMBER        ,
    ACA_NUMBER9               NUMBER        ,
    ACA_NUMBER10              NUMBER        ,
    ACA_NUMBER11              NUMBER        ,
    ACA_NUMBER12              NUMBER        ,
    ACA_CHAR1                 VARCHAR2(4000),
    ACA_CHAR2                 VARCHAR2(4000),
    ACA_CHAR3                 VARCHAR2(4000),
    ACA_CHAR4                 VARCHAR2(4000),
    ACA_CHAR5                 VARCHAR2(4000),
    ACA_CHAR6                 VARCHAR2(4000),
    ACA_CHAR7                 VARCHAR2(4000),
    ACA_CHAR8                 VARCHAR2(4000),
    ACA_CHAR9                 VARCHAR2(4000),
    ACA_CHAR10                VARCHAR2(4000),
    ACA_CHAR11                VARCHAR2(4000),
    ACA_CHAR12                VARCHAR2(4000),
    ACA_DATE1                 DATE          ,
    ACA_DATE2                 DATE          ,
    ACA_DATE3                 DATE          ,
    ACA_DATE4                 DATE          ,
    ACA_DATE5                 DATE          ,
    ACA_DATE6                 DATE          ,
    ACA_DATE7                 DATE          ,
    ACA_DATE8                 DATE          ,
    ACA_DATE9                 DATE          ,
    ACA_DATE10                DATE          ,
    ACA_DATE11                DATE          ,
    ACA_DATE12                DATE          ,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    PROGRAM_APP_NAME          VARCHAR2(120) ,
    PROGRAM_NAME              VARCHAR2(120) ,
    PROGRAM_UPDATE_DATE       DATE          ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    CONSTRAINT pk_ben_aca_reporting PRIMARY KEY (ACA_REPORTING_ID, ACA_REPORTING_ID)
);
