CREATE TABLE ben_extract_req_details (
    REQUEST_DETAIL_ID            NUMBER(18, 0) ,
    EXT_ATTRIBUTE1               VARCHAR2(1020),
    EXT_ATTRIBUTE2               VARCHAR2(1020),
    EXT_ATTRIBUTE3               VARCHAR2(1020),
    EXT_ATTRIBUTE4               VARCHAR2(1020),
    EXT_ATTRIBUTE5               VARCHAR2(1020),
    EXT_ATTRIBUTE6               VARCHAR2(1020),
    EXT_ATTRIBUTE7               VARCHAR2(1020),
    EXT_ATTRIBUTE8               VARCHAR2(1020),
    EXT_ATTRIBUTE9               VARCHAR2(1020),
    EXT_ATTRIBUTE10              VARCHAR2(1020),
    EXT_ATTRIBUTE11              VARCHAR2(1020),
    EXT_ATTRIBUTE12              VARCHAR2(1020),
    EXT_ATTRIBUTE13              VARCHAR2(1020),
    EXT_ATTRIBUTE14              VARCHAR2(1020),
    EXT_ATTRIBUTE15              VARCHAR2(1020),
    EXT_ATTRIBUTE16              VARCHAR2(1020),
    EXT_ATTRIBUTE17              VARCHAR2(1020),
    EXT_ATTRIBUTE18              VARCHAR2(1020),
    EXT_ATTRIBUTE19              VARCHAR2(1020),
    EXT_ATTRIBUTE20              VARCHAR2(1020),
    EXT_ATTRIBUTE21              VARCHAR2(1020),
    EXT_ATTRIBUTE22              VARCHAR2(1020),
    EXT_ATTRIBUTE23              VARCHAR2(1020),
    EXT_ATTRIBUTE24              VARCHAR2(1020),
    EXT_ATTRIBUTE25              VARCHAR2(1020),
    EXT_ATTRIBUTE26              VARCHAR2(1020),
    EXT_ATTRIBUTE27              VARCHAR2(1020),
    EXT_ATTRIBUTE28              VARCHAR2(1020),
    EXT_ATTRIBUTE29              VARCHAR2(1020),
    EXT_ATTRIBUTE30              VARCHAR2(1020),
    EXT_ATTRIBUTE31              VARCHAR2(1020),
    EXT_ATTRIBUTE32              VARCHAR2(1020),
    EXT_ATTRIBUTE33              VARCHAR2(1020),
    EXT_ATTRIBUTE34              VARCHAR2(1020),
    EXT_ATTRIBUTE35              VARCHAR2(1020),
    EXT_ATTRIBUTE36              VARCHAR2(1020),
    EXT_ATTRIBUTE37              VARCHAR2(1020),
    EXT_ATTRIBUTE38              VARCHAR2(1020),
    EXT_ATTRIBUTE39              VARCHAR2(1020),
    EXT_ATTRIBUTE40              VARCHAR2(1020),
    EXT_ATTRIBUTE41              VARCHAR2(1020),
    EXT_ATTRIBUTE42              VARCHAR2(1020),
    EXT_ATTRIBUTE43              VARCHAR2(1020),
    EXT_ATTRIBUTE44              VARCHAR2(1020),
    EXT_ATTRIBUTE45              VARCHAR2(1020),
    EXT_ATTRIBUTE46              VARCHAR2(1020),
    EXT_ATTRIBUTE47              VARCHAR2(1020),
    EXT_ATTRIBUTE48              VARCHAR2(1020),
    EXT_ATTRIBUTE49              VARCHAR2(1020),
    EXT_ATTRIBUTE50              VARCHAR2(1020),
    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(960) ,
    GRADE                        VARCHAR2(960) ,
    PAYROLL                      VARCHAR2(320) ,
    BASE_SALARY                  NUMBER        ,
    TRANSACTION_CODE             VARCHAR2(240) ,
    HOME_ADDRESS_LINE1           VARCHAR2(960) ,
    HOME_ADDRESS_LINE2           VARCHAR2(960) ,
    HOME_CITY                    VARCHAR2(320) ,
    HOME_STATE                   VARCHAR2(320) ,
    HOME_ZIP_CODE                VARCHAR2(320) ,
    HOME_PHONE                   VARCHAR2(320) ,
    WORK_ADDRESS_LINE1           VARCHAR2(960) ,
    WORK_ADDRESS_LINE2           VARCHAR2(960) ,
    WORK_CITY                    VARCHAR2(320) ,
    WORK_STATE                   VARCHAR2(320) ,
    WORK_ZIP_CODE                VARCHAR2(320) ,
    WORK_PHONE                   VARCHAR2(320) ,
    PLAN                         VARCHAR2(960) ,
    LEVEL_NAME                   VARCHAR2(960) ,
    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,
    ASSIGNMENT_ID                NUMBER(18, 0) ,
    BENEFIT_RELATION_ID          NUMBER(18, 0) ,
    PGM_ID                       NUMBER(18, 0) ,
    PL_ID                        NUMBER(18, 0) ,
    OPT_ID                       NUMBER(18, 0) ,
    PL_TYP_ID                    NUMBER(18, 0) ,
    PERSON_NUMBER                VARCHAR2(320) ,
    REQUEST_DETAIL_ID            NUMBER(18, 0) ,
    EXT_ATTRIBUTE1               VARCHAR2(1020),
    EXT_ATTRIBUTE2               VARCHAR2(1020),
    EXT_ATTRIBUTE3               VARCHAR2(1020),
    EXT_ATTRIBUTE4               VARCHAR2(1020),
    EXT_ATTRIBUTE5               VARCHAR2(1020),
    EXT_ATTRIBUTE6               VARCHAR2(1020),
    EXT_ATTRIBUTE7               VARCHAR2(1020),
    EXT_ATTRIBUTE8               VARCHAR2(1020),
    EXT_ATTRIBUTE9               VARCHAR2(1020),
    EXT_ATTRIBUTE10              VARCHAR2(1020),
    EXT_ATTRIBUTE11              VARCHAR2(1020),
    EXT_ATTRIBUTE12              VARCHAR2(1020),
    EXT_ATTRIBUTE13              VARCHAR2(1020),
    EXT_ATTRIBUTE14              VARCHAR2(1020),
    EXT_ATTRIBUTE15              VARCHAR2(1020),
    EXT_ATTRIBUTE16              VARCHAR2(1020),
    EXT_ATTRIBUTE17              VARCHAR2(1020),
    EXT_ATTRIBUTE18              VARCHAR2(1020),
    EXT_ATTRIBUTE19              VARCHAR2(1020),
    EXT_ATTRIBUTE20              VARCHAR2(1020),
    EXT_ATTRIBUTE21              VARCHAR2(1020),
    EXT_ATTRIBUTE22              VARCHAR2(1020),
    EXT_ATTRIBUTE23              VARCHAR2(1020),
    EXT_ATTRIBUTE24              VARCHAR2(1020),
    EXT_ATTRIBUTE25              VARCHAR2(1020),
    EXT_ATTRIBUTE26              VARCHAR2(1020),
    EXT_ATTRIBUTE27              VARCHAR2(1020),
    EXT_ATTRIBUTE28              VARCHAR2(1020),
    EXT_ATTRIBUTE29              VARCHAR2(1020),
    EXT_ATTRIBUTE30              VARCHAR2(1020),
    EXT_ATTRIBUTE31              VARCHAR2(1020),
    EXT_ATTRIBUTE32              VARCHAR2(1020),
    EXT_ATTRIBUTE33              VARCHAR2(1020),
    EXT_ATTRIBUTE34              VARCHAR2(1020),
    EXT_ATTRIBUTE35              VARCHAR2(1020),
    EXT_ATTRIBUTE36              VARCHAR2(1020),
    EXT_ATTRIBUTE37              VARCHAR2(1020),
    EXT_ATTRIBUTE38              VARCHAR2(1020),
    EXT_ATTRIBUTE39              VARCHAR2(1020),
    EXT_ATTRIBUTE40              VARCHAR2(1020),
    EXT_ATTRIBUTE41              VARCHAR2(1020),
    EXT_ATTRIBUTE42              VARCHAR2(1020),
    EXT_ATTRIBUTE43              VARCHAR2(1020),
    EXT_ATTRIBUTE44              VARCHAR2(1020),
    EXT_ATTRIBUTE45              VARCHAR2(1020),
    EXT_ATTRIBUTE46              VARCHAR2(1020),
    EXT_ATTRIBUTE47              VARCHAR2(1020),
    EXT_ATTRIBUTE48              VARCHAR2(1020),
    EXT_ATTRIBUTE49              VARCHAR2(1020),
    EXT_ATTRIBUTE50              VARCHAR2(1020),
    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(960) ,
    GRADE                        VARCHAR2(960) ,
    PAYROLL                      VARCHAR2(320) ,
    BASE_SALARY                  NUMBER        ,
    TRANSACTION_CODE             VARCHAR2(240) ,
    HOME_ADDRESS_LINE1           VARCHAR2(960) ,
    HOME_ADDRESS_LINE2           VARCHAR2(960) ,
    HOME_CITY                    VARCHAR2(320) ,
    HOME_STATE                   VARCHAR2(320) ,
    HOME_ZIP_CODE                VARCHAR2(320) ,
    HOME_PHONE                   VARCHAR2(320) ,
    WORK_ADDRESS_LINE1           VARCHAR2(960) ,
    WORK_ADDRESS_LINE2           VARCHAR2(960) ,
    WORK_CITY                    VARCHAR2(320) ,
    WORK_STATE                   VARCHAR2(320) ,
    WORK_ZIP_CODE                VARCHAR2(320) ,
    WORK_PHONE                   VARCHAR2(320) ,
    PLAN                         VARCHAR2(960) ,
    LEVEL_NAME                   VARCHAR2(960) ,
    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,
    ASSIGNMENT_ID                NUMBER(18, 0) ,
    BENEFIT_RELATION_ID          NUMBER(18, 0) ,
    PGM_ID                       NUMBER(18, 0) ,
    PL_ID                        NUMBER(18, 0) ,
    OPT_ID                       NUMBER(18, 0) ,
    PL_TYP_ID                    NUMBER(18, 0) ,
    PERSON_NUMBER                VARCHAR2(320) ,
    CONSTRAINT pk_ben_extract_req_details PRIMARY KEY (REQUEST_DETAIL_ID, REQUEST_DETAIL_ID)
);
