CREATE TABLE cmp_cwb_post_person (
    PERSON_RUN_ID                  NUMBER(18, 0),
    RUN_ID                         NUMBER(18, 0)    NOT NULL,
    PERSON_EVENT_ID                NUMBER(18, 0)    NOT NULL,
    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,
    WORKER_NUMBER                  VARCHAR2(120),
    THREAD_ID                      NUMBER       ,
    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_SET_ID                     NUMBER(18, 0),
    POSITION_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),
    EFFECTIVE_DATE                 DATE         ,
    ASSIGNMENT_STATUS_TYPE_ID      NUMBER(18, 0),
    PRIMARY_FLAG                   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         ,
    FUTURE_PROMOTION_DATE          DATE         ,
    POSITION_CHANGE_DATE           DATE         ,
    GRADE_CHANGE_DATE              DATE         ,
    NORMAL_HOURS                   NUMBER       ,
    FTE_FACTOR                     NUMBER       ,
    BASE_SALARY                    NUMBER       ,
    BASE_SALARY_CURRENCY           VARCHAR2(120),
    BASE_SALARY_CHANGE_DATE        DATE         ,
    BASE_SALARY_FREQUENCY          VARCHAR2(120),
    CURRENT_SALARY_ID              NUMBER(18, 0),
    SALARY_BASIS_ID                NUMBER(18, 0),
    PAYROLL_ID                     NUMBER(18, 0),
    FREQUENCY                      VARCHAR2(120),
    PAY_ANNUALIZATION_FACTOR       NUMBER       ,
    PERFORMANCE_RATING             VARCHAR2(120),
    PERFORMANCE_RATING_TYPE        VARCHAR2(120),
    PERFORMANCE_RATING_DATE        DATE         ,
    NEW_BASE_SALARY                NUMBER       ,
    BASE_SALARY_CHANGE_VAL         NUMBER       ,
    RATE_FOUND_FLAG                VARCHAR2(4)  ,
    EMP_RECV_COUNT                 NUMBER       ,
    ELIG_FLAG                      VARCHAR2(4)  ,
    PROMOTION_ID                   NUMBER(18, 0),
    ASG_CHANGE_DATE                DATE         ,
    JOB_ID                         NUMBER(18, 0),
    GRADE_ID                       NUMBER(18, 0),
    PRM_STATIC_DATE                DATE         ,
    PRM_POSTED_DATE                DATE         ,
    POSITION_ID_POSTED             NUMBER(18, 0),
    POSITION_ID_NEW                NUMBER(18, 0),
    ASSIGNMENT_ID_NEW              NUMBER(18, 0),
    JOB_ID_NEW                     NUMBER(18, 0),
    GRADE_ID_NEW                   NUMBER(18, 0),
    PERSON_OK_FLAG                 VARCHAR2(4)  ,
    ACTUAL_TERMINATION_DATE        DATE         ,
    ANNUALIZATION_FACTOR_PLAN      NUMBER       ,
    PREV_PAY_PROPOSAL              NUMBER       ,
    FUTURE_PAY_PROPOSAL            NUMBER       ,
    TOTAL_SALARY_POSTED            NUMBER       ,
    TOTAL_SALARY_PREV              NUMBER       ,
    TOTAL_SALARY_NEW               NUMBER       ,
    ACTION_ID_SALARY_POSTED        NUMBER(18, 0),
    ACTION_OCCURRENCE_ID_POSTED    NUMBER(18, 0),
    ACTION_REASON_ID               NUMBER(18, 0),
    ACTION_REASON_ID_POSTED        NUMBER(18, 0),
    OPTION_PCT_VESTED_INIT         NUMBER       ,
    OPTION_VESTING_ROUNDING        VARCHAR2(120),
    STOCK_GRANT_SHARES_WS          NUMBER       ,
    POSTED_GRANT_SHARES            NUMBER       ,
    POSTED_VESTED_SHARES           NUMBER       ,
    POSTED_UNVESTED_SHARES         NUMBER       ,
    POSTED_NEW_ASSIGNMENT_OVN      NUMBER(9, 0) ,
    STATUS_PERSON                  VARCHAR2(120),
    STATUS_POST_SALARY             VARCHAR2(120),
    STATUS_POST_ELEMENT            VARCHAR2(120),
    STATUS_POST_PROMOTIONS         VARCHAR2(120),
    STATUS_POST_RANKS              VARCHAR2(120),
    STATUS_POST_STOCKS             VARCHAR2(120),
    STATUS_POST_ACCESS_UPDATE      VARCHAR2(120),
    TOT_ROWS_POSTED_SALARY         NUMBER       ,
    TOT_ROWS_POSTED_ELEMENT        NUMBER       ,
    TOT_ROWS_POSTED_RANKS          NUMBER       ,
    TOT_ROWS_TOPOST_RANKS          NUMBER       ,
    SALARY_BASIS_TYPE              VARCHAR2(120),
    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),
    ASSIGNMENT_NAME                VARCHAR2(320),
    ASSIGNMENT_NAME_NEW            VARCHAR2(320),
    PERSON_ACTION_ID               NUMBER(18, 0),
    SALARY_RUN_ID                  NUMBER(18, 0),
    STOCK_RUN_ID                   NUMBER(18, 0),
    PROMOTION_RUN_ID               NUMBER(18, 0),
    BACKOUT_REQUEST_ID             NUMBER       ,
    BACKOUT_PERSON_ACTION_ID       NUMBER(18, 0),
    ATTR_SALARY_BASIS_ID           NUMBER(18, 0),
    GRADE_LADDER_PGM_ID            NUMBER(18, 0),
    GRADE_STEP_ID                  NUMBER(18, 0),
    GRADE_STEP_ID_NEW              NUMBER(18, 0),
    PERSON_RUN_ID                  NUMBER(18, 0),
    RUN_ID                         NUMBER(18, 0)    NOT NULL,
    PERSON_EVENT_ID                NUMBER(18, 0)    NOT NULL,
    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,
    WORKER_NUMBER                  VARCHAR2(120),
    THREAD_ID                      NUMBER       ,
    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_SET_ID                     NUMBER(18, 0),
    POSITION_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),
    EFFECTIVE_DATE                 DATE         ,
    ASSIGNMENT_STATUS_TYPE_ID      NUMBER(18, 0),
    PRIMARY_FLAG                   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         ,
    FUTURE_PROMOTION_DATE          DATE         ,
    POSITION_CHANGE_DATE           DATE         ,
    GRADE_CHANGE_DATE              DATE         ,
    NORMAL_HOURS                   NUMBER       ,
    FTE_FACTOR                     NUMBER       ,
    BASE_SALARY                    NUMBER       ,
    BASE_SALARY_CURRENCY           VARCHAR2(120),
    BASE_SALARY_CHANGE_DATE        DATE         ,
    BASE_SALARY_FREQUENCY          VARCHAR2(120),
    CURRENT_SALARY_ID              NUMBER(18, 0),
    SALARY_BASIS_ID                NUMBER(18, 0),
    PAYROLL_ID                     NUMBER(18, 0),
    FREQUENCY                      VARCHAR2(120),
    PAY_ANNUALIZATION_FACTOR       NUMBER       ,
    PERFORMANCE_RATING             VARCHAR2(120),
    PERFORMANCE_RATING_TYPE        VARCHAR2(120),
    PERFORMANCE_RATING_DATE        DATE         ,
    NEW_BASE_SALARY                NUMBER       ,
    BASE_SALARY_CHANGE_VAL         NUMBER       ,
    RATE_FOUND_FLAG                VARCHAR2(4)  ,
    EMP_RECV_COUNT                 NUMBER       ,
    ELIG_FLAG                      VARCHAR2(4)  ,
    PROMOTION_ID                   NUMBER(18, 0),
    ASG_CHANGE_DATE                DATE         ,
    JOB_ID                         NUMBER(18, 0),
    GRADE_ID                       NUMBER(18, 0),
    PRM_STATIC_DATE                DATE         ,
    PRM_POSTED_DATE                DATE         ,
    POSITION_ID_POSTED             NUMBER(18, 0),
    POSITION_ID_NEW                NUMBER(18, 0),
    ASSIGNMENT_ID_NEW              NUMBER(18, 0),
    JOB_ID_NEW                     NUMBER(18, 0),
    GRADE_ID_NEW                   NUMBER(18, 0),
    PERSON_OK_FLAG                 VARCHAR2(4)  ,
    ACTUAL_TERMINATION_DATE        DATE         ,
    ANNUALIZATION_FACTOR_PLAN      NUMBER       ,
    PREV_PAY_PROPOSAL              NUMBER       ,
    FUTURE_PAY_PROPOSAL            NUMBER       ,
    TOTAL_SALARY_POSTED            NUMBER       ,
    TOTAL_SALARY_PREV              NUMBER       ,
    TOTAL_SALARY_NEW               NUMBER       ,
    ACTION_ID_SALARY_POSTED        NUMBER(18, 0),
    ACTION_OCCURRENCE_ID_POSTED    NUMBER(18, 0),
    ACTION_REASON_ID               NUMBER(18, 0),
    ACTION_REASON_ID_POSTED        NUMBER(18, 0),
    OPTION_PCT_VESTED_INIT         NUMBER       ,
    OPTION_VESTING_ROUNDING        VARCHAR2(120),
    STOCK_GRANT_SHARES_WS          NUMBER       ,
    POSTED_GRANT_SHARES            NUMBER       ,
    POSTED_VESTED_SHARES           NUMBER       ,
    POSTED_UNVESTED_SHARES         NUMBER       ,
    POSTED_NEW_ASSIGNMENT_OVN      NUMBER(9, 0) ,
    STATUS_PERSON                  VARCHAR2(120),
    STATUS_POST_SALARY             VARCHAR2(120),
    STATUS_POST_ELEMENT            VARCHAR2(120),
    STATUS_POST_PROMOTIONS         VARCHAR2(120),
    STATUS_POST_RANKS              VARCHAR2(120),
    STATUS_POST_STOCKS             VARCHAR2(120),
    STATUS_POST_ACCESS_UPDATE      VARCHAR2(120),
    TOT_ROWS_POSTED_SALARY         NUMBER       ,
    TOT_ROWS_POSTED_ELEMENT        NUMBER       ,
    TOT_ROWS_POSTED_RANKS          NUMBER       ,
    TOT_ROWS_TOPOST_RANKS          NUMBER       ,
    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),
    SALARY_BASIS_TYPE              VARCHAR2(120),
    ASSIGNMENT_NAME                VARCHAR2(320),
    ASSIGNMENT_NAME_NEW            VARCHAR2(320),
    PERSON_ACTION_ID               NUMBER(18, 0),
    SALARY_RUN_ID                  NUMBER(18, 0),
    STOCK_RUN_ID                   NUMBER(18, 0),
    PROMOTION_RUN_ID               NUMBER(18, 0),
    BACKOUT_REQUEST_ID             NUMBER       ,
    BACKOUT_PERSON_ACTION_ID       NUMBER(18, 0),
    ATTR_SALARY_BASIS_ID           NUMBER(18, 0),
    GRADE_LADDER_PGM_ID            NUMBER(18, 0),
    GRADE_STEP_ID                  NUMBER(18, 0),
    GRADE_STEP_ID_NEW              NUMBER(18, 0),
    CONSTRAINT pk_cmp_cwb_post_person PRIMARY KEY (PERSON_RUN_ID, PERSON_RUN_ID)
);
