CMP_CWB_POST_PERSON
Stores Post Process Person Information
Details
-
Schema: FUSION
-
Object owner: CMP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMP_CWB_POST_PERSON_PK |
PERSON_RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERSON_RUN_ID | NUMBER | 18 | Yes | PERSON_RUN_ID | |
| RUN_ID | NUMBER | 18 | Yes | RUN_ID | |
| PERSON_EVENT_ID | NUMBER | 18 | Yes | PERSON_EVENT_ID | |
| PLAN_ID | NUMBER | 18 | Yes | PLAN_ID | |
| PERIOD_ID | NUMBER | 18 | Yes | PERIOD_ID | |
| PERSON_ID | NUMBER | 18 | Yes | PERSON_ID | |
| ASSIGNMENT_ID | NUMBER | 18 | Yes | ASSIGNMENT_ID | |
| WORKER_NUMBER | VARCHAR2 | 30 | WORKER_NUMBER | ||
| THREAD_ID | NUMBER | THREAD_ID | |||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | BUSINESS_GROUP_ID | |
| BUSINESS_UNIT_ID | NUMBER | 18 | BUSINESS_UNIT_ID | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | LEGAL_ENTITY_ID | ||
| ORGANIZATION_ID | NUMBER | 18 | ORGANIZATION_ID | ||
| LOCATION_ID | NUMBER | 18 | LOCATION_ID | ||
| JOB_SET_ID | NUMBER | 18 | JOB_SET_ID | ||
| POSITION_ID | NUMBER | 18 | POSITION_ID | ||
| GRADE_SET_ID | NUMBER | 18 | GRADE_SET_ID | ||
| DUE_DATE | DATE | DUE_DATE | |||
| ACCESS_CODE | VARCHAR2 | 30 | ACCESS_CODE | ||
| EMP_STATUS_CODE | VARCHAR2 | 30 | EMP_STATUS_CODE | ||
| MGR_STATUS_CODE | VARCHAR2 | 30 | MGR_STATUS_CODE | ||
| EFFECTIVE_DATE | DATE | EFFECTIVE_DATE | |||
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 18 | ASSIGNMENT_STATUS_TYPE_ID | ||
| PRIMARY_FLAG | VARCHAR2 | 30 | PRIMARY_FLAG | ||
| START_DATE | DATE | START_DATE | |||
| ORIGINAL_START_DATE | DATE | ORIGINAL_START_DATE | |||
| ADJUSTED_SVC_DATE | DATE | ADJUSTED_SVC_DATE | |||
| EMPLOYMENT_CATEGORY | VARCHAR2 | 30 | EMPLOYMENT_CATEGORY | ||
| YEARS_EMPLOYED | NUMBER | YEARS_EMPLOYED | |||
| YEARS_IN_JOB | NUMBER | YEARS_IN_JOB | |||
| YEARS_IN_POSITION | NUMBER | YEARS_IN_POSITION | |||
| YEARS_IN_GRADE | NUMBER | YEARS_IN_GRADE | |||
| JOB_CHANGE_DATE | DATE | JOB_CHANGE_DATE | |||
| FUTURE_PROMOTION_DATE | DATE | FUTURE_PROMOTION_DATE | |||
| POSITION_CHANGE_DATE | DATE | POSITION_CHANGE_DATE | |||
| GRADE_CHANGE_DATE | DATE | GRADE_CHANGE_DATE | |||
| NORMAL_HOURS | NUMBER | NORMAL_HOURS | |||
| FTE_FACTOR | NUMBER | FTE_FACTOR | |||
| BASE_SALARY | NUMBER | BASE_SALARY | |||
| BASE_SALARY_CURRENCY | VARCHAR2 | 30 | BASE_SALARY_CURRENCY | ||
| BASE_SALARY_CHANGE_DATE | DATE | BASE_SALARY_CHANGE_DATE | |||
| BASE_SALARY_FREQUENCY | VARCHAR2 | 30 | BASE_SALARY_FREQUENCY | ||
| CURRENT_SALARY_ID | NUMBER | 18 | CURRENT_SALARY_ID | ||
| SALARY_BASIS_ID | NUMBER | 18 | SALARY_BASIS_ID | ||
| PAYROLL_ID | NUMBER | 18 | PAYROLL_ID | ||
| FREQUENCY | VARCHAR2 | 30 | FREQUENCY | ||
| PAY_ANNUALIZATION_FACTOR | NUMBER | PAY_ANNUALIZATION_FACTOR | |||
| PERFORMANCE_RATING | VARCHAR2 | 30 | PERFORMANCE_RATING | ||
| PERFORMANCE_RATING_TYPE | VARCHAR2 | 30 | PERFORMANCE_RATING_TYPE | ||
| PERFORMANCE_RATING_DATE | DATE | PERFORMANCE_RATING_DATE | |||
| NEW_BASE_SALARY | NUMBER | NEW_BASE_SALARY | |||
| BASE_SALARY_CHANGE_VAL | NUMBER | BASE_SALARY_CHANGE_VAL | |||
| RATE_FOUND_FLAG | VARCHAR2 | 1 | RATE_FOUND_FLAG | ||
| EMP_RECV_COUNT | NUMBER | EMP_RECV_COUNT | |||
| ELIG_FLAG | VARCHAR2 | 1 | ELIG_FLAG | ||
| PROMOTION_ID | NUMBER | 18 | PROMOTION_ID | ||
| ASG_CHANGE_DATE | DATE | ASG_CHANGE_DATE | |||
| JOB_ID | NUMBER | 18 | Job Id | ||
| GRADE_ID | NUMBER | 18 | GRADE_ID | ||
| PRM_STATIC_DATE | DATE | PRM_STATIC_DATE | |||
| PRM_POSTED_DATE | DATE | PRM_POSTED_DATE | |||
| POSITION_ID_POSTED | NUMBER | 18 | POSITION_ID_POSTED | ||
| POSITION_ID_NEW | NUMBER | 18 | POSITION_ID_NEW | ||
| ASSIGNMENT_ID_NEW | NUMBER | 18 | ASSIGNMENT_ID_NEW | ||
| JOB_ID_NEW | NUMBER | 18 | JOB_ID_NEW | ||
| GRADE_ID_NEW | NUMBER | 18 | GRADE_ID_NEW | ||
| PERSON_OK_FLAG | VARCHAR2 | 1 | PERSON_OK_FLAG | ||
| ACTUAL_TERMINATION_DATE | DATE | ACTUAL_TERMINATION_DATE | |||
| ANNUALIZATION_FACTOR_PLAN | NUMBER | ANNUALIZATION_FACTOR_PLAN | |||
| PREV_PAY_PROPOSAL | NUMBER | PREV_PAY_PROPOSAL | |||
| FUTURE_PAY_PROPOSAL | NUMBER | FUTURE_PAY_PROPOSAL | |||
| TOTAL_SALARY_POSTED | NUMBER | TOTAL_SALARY_POSTED | |||
| TOTAL_SALARY_PREV | NUMBER | TOTAL_SALARY_PREV | |||
| TOTAL_SALARY_NEW | NUMBER | TOTAL_SALARY_NEW | |||
| ACTION_ID_SALARY_POSTED | NUMBER | 18 | ACTION_ID_SALARY_POSTED | ||
| ACTION_OCCURRENCE_ID_POSTED | NUMBER | 18 | ACTION_OCCURRENCE_ID_POSTED | ||
| ACTION_REASON_ID | NUMBER | 18 | ACTION_REASON_ID | ||
| ACTION_REASON_ID_POSTED | NUMBER | 18 | ACTION_REASON_ID_POSTED | ||
| OPTION_PCT_VESTED_INIT | NUMBER | OPTION_PCT_VESTED_INIT | |||
| OPTION_VESTING_ROUNDING | VARCHAR2 | 30 | OPTION_VESTING_ROUNDING | ||
| STOCK_GRANT_SHARES_WS | NUMBER | STOCK_GRANT_SHARES_WS | |||
| POSTED_GRANT_SHARES | NUMBER | POSTED_GRANT_SHARES | |||
| POSTED_VESTED_SHARES | NUMBER | POSTED_VESTED_SHARES | |||
| POSTED_UNVESTED_SHARES | NUMBER | POSTED_UNVESTED_SHARES | |||
| POSTED_NEW_ASSIGNMENT_OVN | NUMBER | 9 | POSTED_NEW_ASSIGNMENT_OVN | ||
| STATUS_PERSON | VARCHAR2 | 30 | STATUS_PERSON | ||
| STATUS_POST_SALARY | VARCHAR2 | 30 | STATUS_POST_SALARY | ||
| STATUS_POST_ELEMENT | VARCHAR2 | 30 | STATUS_POST_ELEMENT | ||
| STATUS_POST_PROMOTIONS | VARCHAR2 | 30 | STATUS_POST_PROMOTIONS | ||
| STATUS_POST_RANKS | VARCHAR2 | 30 | STATUS_POST_RANKS | ||
| STATUS_POST_STOCKS | VARCHAR2 | 30 | STATUS_POST_STOCKS | ||
| STATUS_POST_ACCESS_UPDATE | VARCHAR2 | 30 | STATUS_POST_ACCESS_UPDATE | ||
| TOT_ROWS_POSTED_SALARY | NUMBER | TOT_ROWS_POSTED_SALARY | |||
| TOT_ROWS_POSTED_ELEMENT | NUMBER | TOT_ROWS_POSTED_ELEMENT | |||
| TOT_ROWS_POSTED_RANKS | NUMBER | TOT_ROWS_POSTED_RANKS | |||
| TOT_ROWS_TOPOST_RANKS | NUMBER | TOT_ROWS_TOPOST_RANKS | |||
| SALARY_BASIS_TYPE | VARCHAR2 | 30 | SALARY_BASIS_TYPE | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ASSIGNMENT_NAME | VARCHAR2 | 80 | ASSIGNMENT_NAME | ||
| ASSIGNMENT_NAME_NEW | VARCHAR2 | 80 | ASSIGNMENT_NAME_NEW | ||
| PERSON_ACTION_ID | NUMBER | 18 | PERSON_ACTION_ID | ||
| SALARY_RUN_ID | NUMBER | 18 | SALARY_RUN_ID | ||
| STOCK_RUN_ID | NUMBER | 18 | STOCK_RUN_ID | ||
| PROMOTION_RUN_ID | NUMBER | 18 | PROMOTION_RUN_ID | ||
| BACKOUT_REQUEST_ID | NUMBER | BACKOUT_REQUEST_ID | |||
| BACKOUT_PERSON_ACTION_ID | NUMBER | 18 | BACKOUT_PERSON_ACTION_ID | ||
| ATTR_SALARY_BASIS_ID | NUMBER | 18 | ATTR_SALARY_BASIS_ID | ||
| GRADE_LADDER_PGM_ID | NUMBER | 18 | GRADE_LADDER_PGM_ID | ||
| GRADE_STEP_ID | NUMBER | 18 | GRADE_STEP_ID | ||
| GRADE_STEP_ID_NEW | NUMBER | 18 | GRADE_STEP_ID_NEW |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMP_CWB_POST_PERSON_N1 | Non Unique | Default | ASSIGNMENT_ID, RUN_ID |
| CMP_CWB_POST_PERSON_PK | Unique | Default | PERSON_RUN_ID |
| CMP_CWB_POST_PERSON_U1 | Unique | FUSION_TS_TX_DATA | RUN_ID, PERSON_EVENT_ID |