CREATE TABLE ben_extract_details_arch (
    REQUEST_DETAIL_ID            NUMBER(18, 0) ,
    EXT_REQUEST_ID               NUMBER(18, 0)     NOT NULL,
    ENTERPRISE_ID                NUMBER(18, 0)     NOT NULL,
    PARENT_REQUEST_DETAIL_ID     NUMBER(18, 0) ,
    PERSON_ID                    NUMBER(18, 0)     NOT NULL,
    CARRIER_ID                   NUMBER(18, 0) ,
    FIRST_NAME                   VARCHAR2(960) ,
    LAST_NAME                    VARCHAR2(960) ,
    MIDDLE_NAME                  VARCHAR2(960) ,
    SUFFIX                       VARCHAR2(960) ,
    GENDER_FLAG                  VARCHAR2(120) ,
    NATIONAL_IDENTIFIER          VARCHAR2(120) ,
    DATE_OF_BIRTH                DATE          ,
    DATE_OF_DEATH                DATE          ,
    TERMINATION_DATE             DATE          ,
    MARITAL_STATUS               VARCHAR2(120) ,
    TOBACCO_USER                 VARCHAR2(120) ,
    DISABLED_FLAG                VARCHAR2(120) ,
    STUDENT_STATUS               VARCHAR2(120) ,
    EMAIL_ADDRESS_ID             VARCHAR2(240) ,
    EMPLOYEE_ID                  NUMBER(18, 0) ,
    EMPLOYMENT_ORGANIZATION      VARCHAR2(960) ,
    EMPLOYMENT_STATUS            VARCHAR2(240) ,
    HIRE_DATE                    DATE          ,
    ORIGINAL_DATE_OF_HIRE        DATE          ,
    JOB                          VARCHAR2(240) ,
    GRADE                        VARCHAR2(240) ,
    PAYROLL                      VARCHAR2(320) ,
    BASE_SALARY                  NUMBER        ,
    TRANSACTION_CODE             VARCHAR2(240) ,
    HOME_ADDRESS_LINE1           VARCHAR2(320) ,
    HOME_ADDRESS_LINE2           VARCHAR2(320) ,
    HOME_CITY                    VARCHAR2(320) ,
    HOME_STATE                   VARCHAR2(320) ,
    HOME_ZIP_CODE                VARCHAR2(320) ,
    HOME_PHONE                   VARCHAR2(320) ,
    WORK_ADDRESS_LINE1           VARCHAR2(320) ,
    WORK_ADDRESS_LINE2           VARCHAR2(320) ,
    WORK_CITY                    VARCHAR2(320) ,
    WORK_STATE                   VARCHAR2(320) ,
    WORK_ZIP_CODE                VARCHAR2(320) ,
    WORK_PHONE                   VARCHAR2(320) ,
    PLAN                         VARCHAR2(320) ,
    LEVEL_NAME                   VARCHAR2(320) ,
    LEVEL_CVG_START_DATE         DATE          ,
    LEVEL_CVG_END_DATE           DATE          ,
    COVERAGE_START_DATE          DATE          ,
    COVERAGE_END_DATE            DATE          ,
    COVERAGE_AMOUNT_APPROVED     NUMBER        ,
    COVERAGE_AMOUNT_PENDING      NUMBER        ,
    FSA_PLAN_YEAR                NUMBER        ,
    FSA_ANNUAL_TARGET            NUMBER        ,
    DIRECT_DEPOSIT_ROUTING       NUMBER        ,
    DIRECT_DEPOST_ACCOUNT        VARCHAR2(120) ,
    EE_PRETAX_COST               NUMBER        ,
    EE_POSTTAX_COST              NUMBER        ,
    EE_TOTAL_COST                NUMBER        ,
    PROVIDER_ID                  VARCHAR2(120) ,
    PROVIDER_NAME                VARCHAR2(240) ,
    PROVIDER_START_DATE          DATE          ,
    DPNT_RELATIONSHIP_TYPE       VARCHAR2(240) ,
    DPNT_FULL_TIME_STUDENT       VARCHAR2(120) ,
    ORGANIZATION_IDENTIFIER      VARCHAR2(1020),
    DEP_NAME                     VARCHAR2(1020),
    MARITAL_STATUS_START_DATE    DATE          ,
    TIER_COVERAGE_TYPE           VARCHAR2(320) ,
    EMPLOYMENT_LEVEL_CODE        VARCHAR2(320) ,
    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) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    REQUEST_DETAIL_ID            NUMBER(18, 0) ,
    EXT_REQUEST_ID               NUMBER(18, 0)     NOT NULL,
    ENTERPRISE_ID                NUMBER(18, 0)     NOT NULL,
    PARENT_REQUEST_DETAIL_ID     NUMBER(18, 0) ,
    PERSON_ID                    NUMBER(18, 0)     NOT NULL,
    CARRIER_ID                   NUMBER(18, 0) ,
    FIRST_NAME                   VARCHAR2(960) ,
    LAST_NAME                    VARCHAR2(960) ,
    MIDDLE_NAME                  VARCHAR2(960) ,
    SUFFIX                       VARCHAR2(960) ,
    GENDER_FLAG                  VARCHAR2(120) ,
    NATIONAL_IDENTIFIER          VARCHAR2(120) ,
    DATE_OF_BIRTH                DATE          ,
    DATE_OF_DEATH                DATE          ,
    TERMINATION_DATE             DATE          ,
    MARITAL_STATUS               VARCHAR2(120) ,
    TOBACCO_USER                 VARCHAR2(120) ,
    DISABLED_FLAG                VARCHAR2(120) ,
    STUDENT_STATUS               VARCHAR2(120) ,
    EMAIL_ADDRESS_ID             VARCHAR2(240) ,
    EMPLOYEE_ID                  NUMBER(18, 0) ,
    EMPLOYMENT_ORGANIZATION      VARCHAR2(960) ,
    EMPLOYMENT_STATUS            VARCHAR2(240) ,
    HIRE_DATE                    DATE          ,
    ORIGINAL_DATE_OF_HIRE        DATE          ,
    JOB                          VARCHAR2(240) ,
    GRADE                        VARCHAR2(240) ,
    PAYROLL                      VARCHAR2(320) ,
    BASE_SALARY                  NUMBER        ,
    TRANSACTION_CODE             VARCHAR2(240) ,
    HOME_ADDRESS_LINE1           VARCHAR2(320) ,
    HOME_ADDRESS_LINE2           VARCHAR2(320) ,
    HOME_CITY                    VARCHAR2(320) ,
    HOME_STATE                   VARCHAR2(320) ,
    HOME_ZIP_CODE                VARCHAR2(320) ,
    HOME_PHONE                   VARCHAR2(320) ,
    WORK_ADDRESS_LINE1           VARCHAR2(320) ,
    WORK_ADDRESS_LINE2           VARCHAR2(320) ,
    WORK_CITY                    VARCHAR2(320) ,
    WORK_STATE                   VARCHAR2(320) ,
    WORK_ZIP_CODE                VARCHAR2(320) ,
    WORK_PHONE                   VARCHAR2(320) ,
    PLAN                         VARCHAR2(320) ,
    LEVEL_NAME                   VARCHAR2(320) ,
    LEVEL_CVG_START_DATE         DATE          ,
    LEVEL_CVG_END_DATE           DATE          ,
    COVERAGE_START_DATE          DATE          ,
    COVERAGE_END_DATE            DATE          ,
    COVERAGE_AMOUNT_APPROVED     NUMBER        ,
    COVERAGE_AMOUNT_PENDING      NUMBER        ,
    FSA_PLAN_YEAR                NUMBER        ,
    FSA_ANNUAL_TARGET            NUMBER        ,
    DIRECT_DEPOSIT_ROUTING       NUMBER        ,
    DIRECT_DEPOST_ACCOUNT        VARCHAR2(120) ,
    EE_PRETAX_COST               NUMBER        ,
    EE_POSTTAX_COST              NUMBER        ,
    EE_TOTAL_COST                NUMBER        ,
    PROVIDER_ID                  VARCHAR2(120) ,
    PROVIDER_NAME                VARCHAR2(240) ,
    PROVIDER_START_DATE          DATE          ,
    DPNT_RELATIONSHIP_TYPE       VARCHAR2(240) ,
    DPNT_FULL_TIME_STUDENT       VARCHAR2(120) ,
    ORGANIZATION_IDENTIFIER      VARCHAR2(1020),
    DEP_NAME                     VARCHAR2(1020),
    MARITAL_STATUS_START_DATE    DATE          ,
    TIER_COVERAGE_TYPE           VARCHAR2(320) ,
    EMPLOYMENT_LEVEL_CODE        VARCHAR2(320) ,
    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) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    CONSTRAINT pk_ben_extract_details_arch PRIMARY KEY (REQUEST_DETAIL_ID, REQUEST_DETAIL_ID)
);
