CREATE TABLE cmp_cwb_person_info (
    PERSON_EVENT_ID               NUMBER(18, 0) ,
    PLAN_ID                       NUMBER(18, 0)     NOT NULL,
    PERIOD_ID                     NUMBER(18, 0)     NOT NULL,
    PERSON_ID                     NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ID                 NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ASSIGNMENT_ID      NUMBER(18, 0) ,
    CUSTOM_NAME                   VARCHAR2(1920),
    EMAIL_ADDRESS                 VARCHAR2(960) ,
    WORKER_NUMBER                 VARCHAR2(120) ,
    PERSON_NUMBER                 VARCHAR2(120) ,
    WS_MGR_PERSON_ID              NUMBER(18, 0) ,
    WS_MGR_ASSIGNMENT_ID          NUMBER(18, 0) ,
    WS_MGR_PERSON_EVENT_ID        NUMBER(18, 0) ,
    SUPERVISOR_ID                 NUMBER(18, 0) ,
    BUSINESS_GROUP_ID             NUMBER(18, 0)     NOT NULL,
    BUSINESS_UNIT_ID              NUMBER(18, 0) ,
    LEGAL_ENTITY_ID               NUMBER(18, 0) ,
    ORGANIZATION_ID               NUMBER(18, 0) ,
    LOCATION_ID                   NUMBER(18, 0) ,
    JOB_ID                        NUMBER(18, 0) ,
    JOB_SET_ID                    NUMBER(18, 0) ,
    POSITION_ID                   NUMBER(18, 0) ,
    GRADE_ID                      NUMBER(18, 0) ,
    GRADE_SET_ID                  NUMBER(18, 0) ,
    DUE_DATE                      DATE          ,
    ACCESS_CODE                   VARCHAR2(120) ,
    EMP_STATUS_CODE               VARCHAR2(120) ,
    MGR_STATUS_CODE               VARCHAR2(120) ,
    INTERCEPT_APPROVAL_FLAG       VARCHAR2(4)   ,
    APPROVAL_CODE                 VARCHAR2(120) ,
    APPROVAL_DATE                 DATE          ,
    APPROVAL_COMMENTS             CLOB          ,
    SUBMIT_CODE                   VARCHAR2(120) ,
    SUBMIT_DATE                   DATE          ,
    SUBMIT_COMMENTS               CLOB          ,
    BUDGET_STATUS_DATE            DATE          ,
    PROGRESS_STATUS_DATE          DATE          ,
    SUBMIT_STATUS_DATE            DATE          ,
    APPROVAL_STATUS_DATE          DATE          ,
    FULL_APPROVAL_STATUS_DATE     DATE          ,
    EFFECTIVE_DATE                DATE          ,
    ASSIGNMENT_STATUS_TYPE_ID     NUMBER(18, 0) ,
    PRIMARY_FLAG                  VARCHAR2(120) ,
    PLACEHOLDER_FLAG              VARCHAR2(4)   ,
    DATE_OF_BIRTH                 DATE          ,
    SEX                           VARCHAR2(120) ,
    ETHNICITY                     VARCHAR2(120) ,
    RELIGION                      VARCHAR2(120) ,
    DISABILITY_STATUS             VARCHAR2(120) ,
    WORK_TELEPHONE                VARCHAR2(240) ,
    NATIONALITY                   VARCHAR2(120) ,
    LEGISLATION_CODE              VARCHAR2(120) ,
    START_DATE                    DATE          ,
    ORIGINAL_START_DATE           DATE          ,
    ADJUSTED_SVC_DATE             DATE          ,
    EMPLOYMENT_CATEGORY           VARCHAR2(120) ,
    YEARS_EMPLOYED                NUMBER        ,
    YEARS_IN_JOB                  NUMBER        ,
    YEARS_IN_POSITION             NUMBER        ,
    YEARS_IN_GRADE                NUMBER        ,
    JOB_CHANGE_DATE               DATE          ,
    POSITION_CHANGE_DATE          DATE          ,
    GRADE_CHANGE_DATE             DATE          ,
    JOB_ATTRIBUTE1                VARCHAR2(600) ,
    JOB_ATTRIBUTE2                VARCHAR2(600) ,
    JOB_ATTRIBUTE3                VARCHAR2(600) ,
    JOB_ATTRIBUTE4                VARCHAR2(600) ,
    JOB_ATTRIBUTE5                VARCHAR2(600) ,
    JOB_ATTRIBUTE6                VARCHAR2(600) ,
    GRADE_ATTRIBUTE1              VARCHAR2(600) ,
    GRADE_ATTRIBUTE2              VARCHAR2(600) ,
    GRADE_ATTRIBUTE3              VARCHAR2(600) ,
    NORMAL_HOURS                  NUMBER        ,
    WORKING_HOURS                 NUMBER        ,
    FTE_FACTOR                    NUMBER        ,
    BASE_SALARY                   NUMBER        ,
    BASE_SALARY_CURRENCY          VARCHAR2(120) ,
    BASE_SALARY_FREQUENCY         VARCHAR2(120) ,
    BASE_SALARY_CHANGE_DATE       DATE          ,
    BASE_SALARY_CHANGE_VAL        NUMBER        ,
    PREVIOUS_BONUS                NUMBER        ,
    CURRENT_SALARY_ID             NUMBER(18, 0) ,
    SALARY_BASIS_ID               NUMBER(18, 0) ,
    PAYROLL_ID                    NUMBER(18, 0) ,
    FREQUENCY                     VARCHAR2(120) ,
    PAY_ANNUALIZATION_FACTOR      NUMBER        ,
    GRADE_ANNUALIZATION_FACTOR    NUMBER        ,
    GRADE_RATE_ID                 NUMBER(18, 0) ,
    GRADE_RATE_FREQUENCY          VARCHAR2(120) ,
    GRADE_MIN_VAL                 NUMBER        ,
    GRADE_MID_POINT               NUMBER        ,
    GRADE_MAX_VAL                 NUMBER        ,
    GRADE_QUARTILE                VARCHAR2(120) ,
    GRADE_QUINTILE                VARCHAR2(120) ,
    GRADE_DECILE                  VARCHAR2(120) ,
    GRADE_COMPARATIO              NUMBER        ,
    GRADE_PCT_IN_RANGE            NUMBER        ,
    PERFORMANCE_RATING            NUMBER(18, 0) ,
    PERFORMANCE_RATING_TYPE       VARCHAR2(120) ,
    PERFORMANCE_RATING_DATE       DATE          ,
    MGR_OVERRIDE_DATE             DATE          ,
    MGR_OVERRIDE_PERSON_ID        NUMBER(18, 0) ,
    CUSTOM_SEGMENT1               VARCHAR2(600) ,
    CUSTOM_SEGMENT2               VARCHAR2(600) ,
    CUSTOM_SEGMENT3               VARCHAR2(600) ,
    CUSTOM_SEGMENT4               VARCHAR2(600) ,
    CUSTOM_SEGMENT5               VARCHAR2(600) ,
    CUSTOM_SEGMENT6               VARCHAR2(600) ,
    CUSTOM_SEGMENT7               VARCHAR2(600) ,
    CUSTOM_SEGMENT8               VARCHAR2(600) ,
    CUSTOM_SEGMENT9               VARCHAR2(600) ,
    CUSTOM_SEGMENT10              VARCHAR2(600) ,
    CUSTOM_SEGMENT11              VARCHAR2(600) ,
    CUSTOM_SEGMENT12              VARCHAR2(4000),
    CUSTOM_SEGMENT13              VARCHAR2(4000),
    CUSTOM_SEGMENT14              VARCHAR2(4000),
    CUSTOM_SEGMENT15              VARCHAR2(4000),
    CUSTOM_SEGMENT16              NUMBER        ,
    CUSTOM_SEGMENT17              NUMBER        ,
    CUSTOM_SEGMENT18              NUMBER        ,
    CUSTOM_SEGMENT19              NUMBER        ,
    CUSTOM_SEGMENT20              NUMBER        ,
    CUSTOM_SEGMENT21              NUMBER        ,
    CUSTOM_SEGMENT22              NUMBER        ,
    CUSTOM_SEGMENT23              NUMBER        ,
    CUSTOM_SEGMENT24              NUMBER        ,
    CUSTOM_SEGMENT25              NUMBER        ,
    CUSTOM_SEGMENT26              NUMBER        ,
    CUSTOM_SEGMENT27              NUMBER        ,
    CUSTOM_SEGMENT28              NUMBER        ,
    CUSTOM_SEGMENT29              NUMBER        ,
    CUSTOM_SEGMENT30              NUMBER        ,
    CUSTOM_SEGMENT31              NUMBER        ,
    CUSTOM_SEGMENT32              NUMBER        ,
    CUSTOM_SEGMENT33              NUMBER        ,
    CUSTOM_SEGMENT34              NUMBER        ,
    CUSTOM_SEGMENT35              NUMBER        ,
    CUSTOM_SEGMENT36              NUMBER        ,
    CUSTOM_SEGMENT37              NUMBER        ,
    CUSTOM_SEGMENT38              NUMBER        ,
    CUSTOM_SEGMENT39              NUMBER        ,
    CUSTOM_SEGMENT40              NUMBER        ,
    CUSTOM_SEGMENT41              NUMBER        ,
    CUSTOM_SEGMENT42              NUMBER        ,
    CUSTOM_SEGMENT43              NUMBER        ,
    CUSTOM_SEGMENT44              NUMBER        ,
    CUSTOM_SEGMENT45              NUMBER        ,
    CUSTOM_SEGMENT46              NUMBER        ,
    CUSTOM_SEGMENT47              NUMBER        ,
    CUSTOM_SEGMENT48              NUMBER        ,
    CUSTOM_SEGMENT49              NUMBER        ,
    CUSTOM_SEGMENT50              NUMBER        ,
    ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    ATTRIBUTE1                    VARCHAR2(600) ,
    ATTRIBUTE2                    VARCHAR2(600) ,
    ATTRIBUTE3                    VARCHAR2(600) ,
    ATTRIBUTE4                    VARCHAR2(600) ,
    ATTRIBUTE5                    VARCHAR2(600) ,
    ATTRIBUTE6                    VARCHAR2(600) ,
    ATTRIBUTE7                    VARCHAR2(600) ,
    ATTRIBUTE8                    VARCHAR2(600) ,
    ATTRIBUTE9                    VARCHAR2(600) ,
    ATTRIBUTE10                   VARCHAR2(600) ,
    ATTRIBUTE11                   VARCHAR2(600) ,
    ATTRIBUTE12                   VARCHAR2(600) ,
    ATTRIBUTE13                   VARCHAR2(600) ,
    ATTRIBUTE14                   VARCHAR2(600) ,
    ATTRIBUTE15                   VARCHAR2(600) ,
    ATTRIBUTE16                   VARCHAR2(600) ,
    ATTRIBUTE17                   VARCHAR2(600) ,
    ATTRIBUTE18                   VARCHAR2(600) ,
    ATTRIBUTE19                   VARCHAR2(600) ,
    ATTRIBUTE20                   VARCHAR2(600) ,
    ATTRIBUTE21                   VARCHAR2(600) ,
    ATTRIBUTE22                   VARCHAR2(600) ,
    ATTRIBUTE23                   VARCHAR2(600) ,
    ATTRIBUTE24                   VARCHAR2(600) ,
    ATTRIBUTE25                   VARCHAR2(600) ,
    ATTRIBUTE26                   VARCHAR2(600) ,
    ATTRIBUTE27                   VARCHAR2(600) ,
    ATTRIBUTE28                   VARCHAR2(600) ,
    ATTRIBUTE29                   VARCHAR2(600) ,
    ATTRIBUTE30                   VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1             NUMBER        ,
    ATTRIBUTE_NUMBER2             NUMBER        ,
    ATTRIBUTE_NUMBER3             NUMBER        ,
    ATTRIBUTE_NUMBER4             NUMBER        ,
    ATTRIBUTE_NUMBER5             NUMBER        ,
    ATTRIBUTE_NUMBER6             NUMBER        ,
    ATTRIBUTE_NUMBER7             NUMBER        ,
    ATTRIBUTE_NUMBER8             NUMBER        ,
    ATTRIBUTE_NUMBER9             NUMBER        ,
    ATTRIBUTE_NUMBER10            NUMBER        ,
    ATTRIBUTE_NUMBER11            NUMBER        ,
    ATTRIBUTE_NUMBER12            NUMBER        ,
    ATTRIBUTE_NUMBER13            NUMBER        ,
    ATTRIBUTE_NUMBER14            NUMBER        ,
    ATTRIBUTE_NUMBER15            NUMBER        ,
    ATTRIBUTE_NUMBER16            NUMBER        ,
    ATTRIBUTE_NUMBER17            NUMBER        ,
    ATTRIBUTE_NUMBER18            NUMBER        ,
    ATTRIBUTE_NUMBER19            NUMBER        ,
    ATTRIBUTE_NUMBER20            NUMBER        ,
    ATTRIBUTE_DATE1               DATE          ,
    ATTRIBUTE_DATE2               DATE          ,
    ATTRIBUTE_DATE3               DATE          ,
    ATTRIBUTE_DATE4               DATE          ,
    ATTRIBUTE_DATE5               DATE          ,
    ATTRIBUTE_DATE6               DATE          ,
    ATTRIBUTE_DATE7               DATE          ,
    ATTRIBUTE_DATE8               DATE          ,
    ATTRIBUTE_DATE9               DATE          ,
    ATTRIBUTE_DATE10              DATE          ,
    ATTRIBUTE_DATE11              DATE          ,
    ATTRIBUTE_DATE12              DATE          ,
    ATTRIBUTE_DATE13              DATE          ,
    ATTRIBUTE_DATE14              DATE          ,
    ATTRIBUTE_DATE15              DATE          ,
    CAREER_LEVEL                  VARCHAR2(120) ,
    WORKER_POTENTIAL              NUMBER(18, 0) ,
    RISK_OF_LOSS                  NUMBER(18, 0) ,
    VETERAN_STATUS                VARCHAR2(120) ,
    NON_DISCRIMINATION_CODE       VARCHAR2(120) ,
    NEW_BASE_SALARY               NUMBER        ,
    NEW_GRADE_QUARTILE            VARCHAR2(120) ,
    NEW_GRADE_QUINTILE            VARCHAR2(120) ,
    NEW_GRADE_DECILE              VARCHAR2(120) ,
    NEW_GRADE_COMPARATIO          NUMBER        ,
    NEW_GRADE_PCT_IN_RANGE        NUMBER        ,
    ACTION_REASON_ID              NUMBER(18, 0) ,
    STMT_TEMPLATE_ID              NUMBER(18, 0) ,
    DO_NOT_POST_FLAG              VARCHAR2(4)   ,
    DYN_CALC_FLAG                 VARCHAR2(4)   ,
    REFRESH_MANAGER_FLAG          VARCHAR2(4)   ,
    REFRESH_ELIGIBILITY_FLAG      VARCHAR2(4)   ,
    ASSIGNMENT_POSTING_DATE       DATE          ,
    ASSIGNMENT_POSTED_DATE        DATE          ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    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) ,
    RVW_MGR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    RVW_MGR_PERSON_ID             NUMBER(18, 0) ,
    RVW_MGR_PERSON_EVENT_ID       NUMBER(18, 0) ,
    RVW_MGR_OVERRIDE_DATE         DATE          ,
    RVW_MGR_OVERRIDE_PERSON_ID    NUMBER(18, 0) ,
    SEC_MGR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    SEC_MGR_PERSON_ID             NUMBER(18, 0) ,
    SEC_MGR_PERSON_EVENT_ID       NUMBER(18, 0) ,
    SEC_MGR_ACCESS_CODE           VARCHAR2(120) ,
    RVW_MGR_ACCESS_CODE           VARCHAR2(120) ,
    REFRESH_SEC_MANAGER_FLAG      VARCHAR2(4)   ,
    REFRESH_RVW_MANAGER_FLAG      VARCHAR2(4)   ,
    SEC_MGR_OVERRIDE_DATE         DATE          ,
    SEC_MGR_OVERRIDE_PERSON_ID    NUMBER(18, 0) ,
    RANGE_DIFF_ID                 NUMBER(18, 0) ,
    SALARY_RANGE_DIFFERENTIAL     NUMBER        ,
    DUE_DATE_NOTIFIED_FLAG        VARCHAR2(4)   ,
    SALARY_BASIS_TYPE             VARCHAR2(120) ,
    OPEN_CLOSE_NOTIFIED_FLAG      VARCHAR2(4)   ,
    ASSIGNMENT_NAME               VARCHAR2(320) ,
    SALARY_RUN_ID                 NUMBER(18, 0) ,
    STOCK_RUN_ID                  NUMBER(18, 0) ,
    PROMOTION_RUN_ID              NUMBER(18, 0) ,
    REFRESH_WORKER_FLAG           VARCHAR2(4)   ,
    REQUEST_ID                    NUMBER(18, 0) ,
    DYN_CALC_SRC                  VARCHAR2(120) ,
    GRADE_MIN_LIMIT               NUMBER        ,
    SOURCE_ASSIGNMENT_ID          NUMBER(18, 0) ,
    GRADE_LADDER_PGM_ID           NUMBER(18, 0) ,
    GRADE_STEP_ID                 NUMBER(18, 0) ,
    CUSTOM_DATE_SEGMENT1          DATE          ,
    CUSTOM_DATE_SEGMENT2          DATE          ,
    CUSTOM_DATE_SEGMENT3          DATE          ,
    CUSTOM_DATE_SEGMENT4          DATE          ,
    CUSTOM_DATE_SEGMENT5          DATE          ,
    CUSTOM_DATE_SEGMENT6          DATE          ,
    EVALUATION_ID                 NUMBER(18, 0) ,
    PERSON_EVENT_ID               NUMBER(18, 0) ,
    PLAN_ID                       NUMBER(18, 0)     NOT NULL,
    PERIOD_ID                     NUMBER(18, 0)     NOT NULL,
    PERSON_ID                     NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ID                 NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ASSIGNMENT_ID      NUMBER(18, 0) ,
    CUSTOM_NAME                   VARCHAR2(1920),
    EMAIL_ADDRESS                 VARCHAR2(960) ,
    WORKER_NUMBER                 VARCHAR2(120) ,
    PERSON_NUMBER                 VARCHAR2(120) ,
    WS_MGR_PERSON_ID              NUMBER(18, 0) ,
    WS_MGR_ASSIGNMENT_ID          NUMBER(18, 0) ,
    WS_MGR_PERSON_EVENT_ID        NUMBER(18, 0) ,
    SUPERVISOR_ID                 NUMBER(18, 0) ,
    BUSINESS_GROUP_ID             NUMBER(18, 0)     NOT NULL,
    BUSINESS_UNIT_ID              NUMBER(18, 0) ,
    LEGAL_ENTITY_ID               NUMBER(18, 0) ,
    ORGANIZATION_ID               NUMBER(18, 0) ,
    LOCATION_ID                   NUMBER(18, 0) ,
    JOB_ID                        NUMBER(18, 0) ,
    JOB_SET_ID                    NUMBER(18, 0) ,
    POSITION_ID                   NUMBER(18, 0) ,
    GRADE_ID                      NUMBER(18, 0) ,
    GRADE_SET_ID                  NUMBER(18, 0) ,
    DUE_DATE                      DATE          ,
    ACCESS_CODE                   VARCHAR2(120) ,
    EMP_STATUS_CODE               VARCHAR2(120) ,
    MGR_STATUS_CODE               VARCHAR2(120) ,
    INTERCEPT_APPROVAL_FLAG       VARCHAR2(4)   ,
    APPROVAL_CODE                 VARCHAR2(120) ,
    APPROVAL_DATE                 DATE          ,
    APPROVAL_COMMENTS             CLOB          ,
    SUBMIT_CODE                   VARCHAR2(120) ,
    SUBMIT_DATE                   DATE          ,
    SUBMIT_COMMENTS               CLOB          ,
    BUDGET_STATUS_DATE            DATE          ,
    PROGRESS_STATUS_DATE          DATE          ,
    SUBMIT_STATUS_DATE            DATE          ,
    APPROVAL_STATUS_DATE          DATE          ,
    FULL_APPROVAL_STATUS_DATE     DATE          ,
    EFFECTIVE_DATE                DATE          ,
    ASSIGNMENT_STATUS_TYPE_ID     NUMBER(18, 0) ,
    PRIMARY_FLAG                  VARCHAR2(120) ,
    PLACEHOLDER_FLAG              VARCHAR2(4)   ,
    DATE_OF_BIRTH                 DATE          ,
    SEX                           VARCHAR2(120) ,
    ETHNICITY                     VARCHAR2(120) ,
    RELIGION                      VARCHAR2(120) ,
    DISABILITY_STATUS             VARCHAR2(120) ,
    WORK_TELEPHONE                VARCHAR2(240) ,
    NATIONALITY                   VARCHAR2(120) ,
    LEGISLATION_CODE              VARCHAR2(120) ,
    START_DATE                    DATE          ,
    ORIGINAL_START_DATE           DATE          ,
    ADJUSTED_SVC_DATE             DATE          ,
    EMPLOYMENT_CATEGORY           VARCHAR2(120) ,
    YEARS_EMPLOYED                NUMBER        ,
    YEARS_IN_JOB                  NUMBER        ,
    YEARS_IN_POSITION             NUMBER        ,
    YEARS_IN_GRADE                NUMBER        ,
    JOB_CHANGE_DATE               DATE          ,
    POSITION_CHANGE_DATE          DATE          ,
    GRADE_CHANGE_DATE             DATE          ,
    JOB_ATTRIBUTE1                VARCHAR2(600) ,
    JOB_ATTRIBUTE2                VARCHAR2(600) ,
    JOB_ATTRIBUTE3                VARCHAR2(600) ,
    JOB_ATTRIBUTE4                VARCHAR2(600) ,
    JOB_ATTRIBUTE5                VARCHAR2(600) ,
    JOB_ATTRIBUTE6                VARCHAR2(600) ,
    GRADE_ATTRIBUTE1              VARCHAR2(600) ,
    GRADE_ATTRIBUTE2              VARCHAR2(600) ,
    GRADE_ATTRIBUTE3              VARCHAR2(600) ,
    NORMAL_HOURS                  NUMBER        ,
    WORKING_HOURS                 NUMBER        ,
    FTE_FACTOR                    NUMBER        ,
    BASE_SALARY                   NUMBER        ,
    BASE_SALARY_CURRENCY          VARCHAR2(120) ,
    BASE_SALARY_FREQUENCY         VARCHAR2(120) ,
    BASE_SALARY_CHANGE_DATE       DATE          ,
    BASE_SALARY_CHANGE_VAL        NUMBER        ,
    PREVIOUS_BONUS                NUMBER        ,
    CURRENT_SALARY_ID             NUMBER(18, 0) ,
    SALARY_BASIS_ID               NUMBER(18, 0) ,
    PAYROLL_ID                    NUMBER(18, 0) ,
    FREQUENCY                     VARCHAR2(120) ,
    PAY_ANNUALIZATION_FACTOR      NUMBER        ,
    GRADE_ANNUALIZATION_FACTOR    NUMBER        ,
    GRADE_RATE_ID                 NUMBER(18, 0) ,
    GRADE_RATE_FREQUENCY          VARCHAR2(120) ,
    GRADE_MIN_VAL                 NUMBER        ,
    GRADE_MID_POINT               NUMBER        ,
    GRADE_MAX_VAL                 NUMBER        ,
    GRADE_QUARTILE                VARCHAR2(120) ,
    GRADE_QUINTILE                VARCHAR2(120) ,
    GRADE_DECILE                  VARCHAR2(120) ,
    GRADE_COMPARATIO              NUMBER        ,
    GRADE_PCT_IN_RANGE            NUMBER        ,
    PERFORMANCE_RATING            NUMBER(18, 0) ,
    PERFORMANCE_RATING_TYPE       VARCHAR2(120) ,
    PERFORMANCE_RATING_DATE       DATE          ,
    MGR_OVERRIDE_DATE             DATE          ,
    MGR_OVERRIDE_PERSON_ID        NUMBER(18, 0) ,
    CUSTOM_SEGMENT1               VARCHAR2(600) ,
    CUSTOM_SEGMENT2               VARCHAR2(600) ,
    CUSTOM_SEGMENT3               VARCHAR2(600) ,
    CUSTOM_SEGMENT4               VARCHAR2(600) ,
    CUSTOM_SEGMENT5               VARCHAR2(600) ,
    CUSTOM_SEGMENT6               VARCHAR2(600) ,
    CUSTOM_SEGMENT7               VARCHAR2(600) ,
    CUSTOM_SEGMENT8               VARCHAR2(600) ,
    CUSTOM_SEGMENT9               VARCHAR2(600) ,
    CUSTOM_SEGMENT10              VARCHAR2(600) ,
    CUSTOM_SEGMENT11              VARCHAR2(600) ,
    CUSTOM_SEGMENT12              VARCHAR2(4000),
    CUSTOM_SEGMENT13              VARCHAR2(4000),
    CUSTOM_SEGMENT14              VARCHAR2(4000),
    CUSTOM_SEGMENT15              VARCHAR2(4000),
    CUSTOM_SEGMENT16              NUMBER        ,
    CUSTOM_SEGMENT17              NUMBER        ,
    CUSTOM_SEGMENT18              NUMBER        ,
    CUSTOM_SEGMENT19              NUMBER        ,
    CUSTOM_SEGMENT20              NUMBER        ,
    CUSTOM_SEGMENT21              NUMBER        ,
    CUSTOM_SEGMENT22              NUMBER        ,
    CUSTOM_SEGMENT23              NUMBER        ,
    CUSTOM_SEGMENT24              NUMBER        ,
    CUSTOM_SEGMENT25              NUMBER        ,
    CUSTOM_SEGMENT26              NUMBER        ,
    CUSTOM_SEGMENT27              NUMBER        ,
    CUSTOM_SEGMENT28              NUMBER        ,
    CUSTOM_SEGMENT29              NUMBER        ,
    CUSTOM_SEGMENT30              NUMBER        ,
    CUSTOM_SEGMENT31              NUMBER        ,
    CUSTOM_SEGMENT32              NUMBER        ,
    CUSTOM_SEGMENT33              NUMBER        ,
    CUSTOM_SEGMENT34              NUMBER        ,
    CUSTOM_SEGMENT35              NUMBER        ,
    CUSTOM_SEGMENT36              NUMBER        ,
    CUSTOM_SEGMENT37              NUMBER        ,
    CUSTOM_SEGMENT38              NUMBER        ,
    CUSTOM_SEGMENT39              NUMBER        ,
    CUSTOM_SEGMENT40              NUMBER        ,
    CUSTOM_SEGMENT41              NUMBER        ,
    CUSTOM_SEGMENT42              NUMBER        ,
    CUSTOM_SEGMENT43              NUMBER        ,
    CUSTOM_SEGMENT44              NUMBER        ,
    CUSTOM_SEGMENT45              NUMBER        ,
    CUSTOM_SEGMENT46              NUMBER        ,
    CUSTOM_SEGMENT47              NUMBER        ,
    CUSTOM_SEGMENT48              NUMBER        ,
    CUSTOM_SEGMENT49              NUMBER        ,
    CUSTOM_SEGMENT50              NUMBER        ,
    ATTRIBUTE_CATEGORY            VARCHAR2(120) ,
    ATTRIBUTE1                    VARCHAR2(600) ,
    ATTRIBUTE2                    VARCHAR2(600) ,
    ATTRIBUTE3                    VARCHAR2(600) ,
    ATTRIBUTE4                    VARCHAR2(600) ,
    ATTRIBUTE5                    VARCHAR2(600) ,
    ATTRIBUTE6                    VARCHAR2(600) ,
    ATTRIBUTE7                    VARCHAR2(600) ,
    ATTRIBUTE8                    VARCHAR2(600) ,
    ATTRIBUTE9                    VARCHAR2(600) ,
    ATTRIBUTE10                   VARCHAR2(600) ,
    ATTRIBUTE11                   VARCHAR2(600) ,
    ATTRIBUTE12                   VARCHAR2(600) ,
    ATTRIBUTE13                   VARCHAR2(600) ,
    ATTRIBUTE14                   VARCHAR2(600) ,
    ATTRIBUTE15                   VARCHAR2(600) ,
    ATTRIBUTE16                   VARCHAR2(600) ,
    ATTRIBUTE17                   VARCHAR2(600) ,
    ATTRIBUTE18                   VARCHAR2(600) ,
    ATTRIBUTE19                   VARCHAR2(600) ,
    ATTRIBUTE20                   VARCHAR2(600) ,
    ATTRIBUTE21                   VARCHAR2(600) ,
    ATTRIBUTE22                   VARCHAR2(600) ,
    ATTRIBUTE23                   VARCHAR2(600) ,
    ATTRIBUTE24                   VARCHAR2(600) ,
    ATTRIBUTE25                   VARCHAR2(600) ,
    ATTRIBUTE26                   VARCHAR2(600) ,
    ATTRIBUTE27                   VARCHAR2(600) ,
    ATTRIBUTE28                   VARCHAR2(600) ,
    ATTRIBUTE29                   VARCHAR2(600) ,
    ATTRIBUTE30                   VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1             NUMBER        ,
    ATTRIBUTE_NUMBER2             NUMBER        ,
    ATTRIBUTE_NUMBER3             NUMBER        ,
    ATTRIBUTE_NUMBER4             NUMBER        ,
    ATTRIBUTE_NUMBER5             NUMBER        ,
    ATTRIBUTE_NUMBER6             NUMBER        ,
    ATTRIBUTE_NUMBER7             NUMBER        ,
    ATTRIBUTE_NUMBER8             NUMBER        ,
    ATTRIBUTE_NUMBER9             NUMBER        ,
    ATTRIBUTE_NUMBER10            NUMBER        ,
    ATTRIBUTE_NUMBER11            NUMBER        ,
    ATTRIBUTE_NUMBER12            NUMBER        ,
    ATTRIBUTE_NUMBER13            NUMBER        ,
    ATTRIBUTE_NUMBER14            NUMBER        ,
    ATTRIBUTE_NUMBER15            NUMBER        ,
    ATTRIBUTE_NUMBER16            NUMBER        ,
    ATTRIBUTE_NUMBER17            NUMBER        ,
    ATTRIBUTE_NUMBER18            NUMBER        ,
    ATTRIBUTE_NUMBER19            NUMBER        ,
    ATTRIBUTE_NUMBER20            NUMBER        ,
    ATTRIBUTE_DATE1               DATE          ,
    ATTRIBUTE_DATE2               DATE          ,
    ATTRIBUTE_DATE3               DATE          ,
    ATTRIBUTE_DATE4               DATE          ,
    ATTRIBUTE_DATE5               DATE          ,
    ATTRIBUTE_DATE6               DATE          ,
    ATTRIBUTE_DATE7               DATE          ,
    ATTRIBUTE_DATE8               DATE          ,
    ATTRIBUTE_DATE9               DATE          ,
    ATTRIBUTE_DATE10              DATE          ,
    ATTRIBUTE_DATE11              DATE          ,
    ATTRIBUTE_DATE12              DATE          ,
    ATTRIBUTE_DATE13              DATE          ,
    ATTRIBUTE_DATE14              DATE          ,
    ATTRIBUTE_DATE15              DATE          ,
    CAREER_LEVEL                  VARCHAR2(120) ,
    WORKER_POTENTIAL              NUMBER(18, 0) ,
    RISK_OF_LOSS                  NUMBER(18, 0) ,
    VETERAN_STATUS                VARCHAR2(120) ,
    NON_DISCRIMINATION_CODE       VARCHAR2(120) ,
    NEW_BASE_SALARY               NUMBER        ,
    NEW_GRADE_QUARTILE            VARCHAR2(120) ,
    NEW_GRADE_QUINTILE            VARCHAR2(120) ,
    NEW_GRADE_DECILE              VARCHAR2(120) ,
    NEW_GRADE_COMPARATIO          NUMBER        ,
    NEW_GRADE_PCT_IN_RANGE        NUMBER        ,
    ACTION_REASON_ID              NUMBER(18, 0) ,
    STMT_TEMPLATE_ID              NUMBER(18, 0) ,
    DO_NOT_POST_FLAG              VARCHAR2(4)   ,
    REFRESH_MANAGER_FLAG          VARCHAR2(4)   ,
    REFRESH_ELIGIBILITY_FLAG      VARCHAR2(4)   ,
    ASSIGNMENT_POSTING_DATE       DATE          ,
    ASSIGNMENT_POSTED_DATE        DATE          ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    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) ,
    RVW_MGR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    RVW_MGR_PERSON_ID             NUMBER(18, 0) ,
    RVW_MGR_PERSON_EVENT_ID       NUMBER(18, 0) ,
    RVW_MGR_OVERRIDE_DATE         DATE          ,
    RVW_MGR_OVERRIDE_PERSON_ID    NUMBER(18, 0) ,
    DYN_CALC_FLAG                 VARCHAR2(4)   ,
    SEC_MGR_ASSIGNMENT_ID         NUMBER(18, 0) ,
    SEC_MGR_PERSON_ID             NUMBER(18, 0) ,
    SEC_MGR_PERSON_EVENT_ID       NUMBER(18, 0) ,
    SEC_MGR_ACCESS_CODE           VARCHAR2(120) ,
    RVW_MGR_ACCESS_CODE           VARCHAR2(120) ,
    REFRESH_SEC_MANAGER_FLAG      VARCHAR2(4)   ,
    REFRESH_RVW_MANAGER_FLAG      VARCHAR2(4)   ,
    SEC_MGR_OVERRIDE_DATE         DATE          ,
    SEC_MGR_OVERRIDE_PERSON_ID    NUMBER(18, 0) ,
    RANGE_DIFF_ID                 NUMBER(18, 0) ,
    SALARY_RANGE_DIFFERENTIAL     NUMBER        ,
    DUE_DATE_NOTIFIED_FLAG        VARCHAR2(4)   ,
    SALARY_BASIS_TYPE             VARCHAR2(120) ,
    OPEN_CLOSE_NOTIFIED_FLAG      VARCHAR2(4)   ,
    ASSIGNMENT_NAME               VARCHAR2(320) ,
    SALARY_RUN_ID                 NUMBER(18, 0) ,
    STOCK_RUN_ID                  NUMBER(18, 0) ,
    PROMOTION_RUN_ID              NUMBER(18, 0) ,
    REFRESH_WORKER_FLAG           VARCHAR2(4)   ,
    REQUEST_ID                    NUMBER(18, 0) ,
    DYN_CALC_SRC                  VARCHAR2(120) ,
    GRADE_MIN_LIMIT               NUMBER        ,
    SOURCE_ASSIGNMENT_ID          NUMBER(18, 0) ,
    GRADE_LADDER_PGM_ID           NUMBER(18, 0) ,
    GRADE_STEP_ID                 NUMBER(18, 0) ,
    CUSTOM_DATE_SEGMENT1          DATE          ,
    CUSTOM_DATE_SEGMENT2          DATE          ,
    CUSTOM_DATE_SEGMENT3          DATE          ,
    CUSTOM_DATE_SEGMENT4          DATE          ,
    CUSTOM_DATE_SEGMENT5          DATE          ,
    CUSTOM_DATE_SEGMENT6          DATE          ,
    EVALUATION_ID                 NUMBER(18, 0) ,
    CONSTRAINT pk_cmp_cwb_person_info PRIMARY KEY (PERSON_EVENT_ID, PERSON_EVENT_ID)
);
