CMP_CWB_STORED_PERSON_DATA
Stores all relevant data to be used for workers statement generation
Details
-
Schema: FUSION
-
Object owner: CMP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMP_CWB_STORED_PERSON_DATA_PK |
PERSON_STMT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERSON_STMT_ID | NUMBER | 18 | Yes | PERSON_STMT_ID | |
| PERSON_EVENT_ID | NUMBER | 18 | Yes | PERSON_EVENT_ID | |
| PLAN_ID | NUMBER | 18 | Yes | PLAN_ID | |
| PERIOD_ID | NUMBER | 18 | Yes | PERIOD_ID | |
| ASSIGNMENT_ID | NUMBER | 18 | Yes | ASSIGNMENT_ID | |
| ASSIGNMENT_ASSIGNMENT_ID | NUMBER | 18 | ASSIGNMENT_ASSIGNMENT_ID | ||
| PERSON_ID | NUMBER | 18 | Yes | PERSON_ID | |
| STMT_TEMPLATE_ID | NUMBER | 18 | STMT_TEMPLATE_ID | ||
| STMT_RUN_REQUEST_ID | NUMBER | 18 | STMT_RUN_REQUEST_ID | ||
| PERSON_DATA_TYPE | VARCHAR2 | 10 | PERSON_DATA_TYPE | ||
| PERSON_NUMBER | VARCHAR2 | 30 | PERSON_NUMBER | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | 50 | ASSIGNMENT_NUMBER | ||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | BUSINESS_GROUP_ID | |
| COMPENSATION_ENABLED_FLAG | VARCHAR2 | 1 | COMPENSATION_ENABLED_FLAG | ||
| PLAN_ANNUALIZATION_FACTOR | NUMBER | PLAN_ANNUALIZATION_FACTOR | |||
| CORPORATE_CURRENCY | VARCHAR2 | 5 | CORPORATE_CURRENCY | ||
| PERIOD_DISPLAY_NAME | VARCHAR2 | 30 | PERIOD_DISPLAY_NAME | ||
| PERIOD_START_DATE | DATE | PERIOD_START_DATE | |||
| PERIOD_END_DATE | DATE | PERIOD_END_DATE | |||
| PERFORMANCE_DATE | DATE | PERFORMANCE_DATE | |||
| ASSIGNMENT_CHANGE_DATE | DATE | ASSIGNMENT_CHANGE_DATE | |||
| EMP_DISPLAY_NAME | VARCHAR2 | 240 | EMP_DISPLAY_NAME | ||
| EMP_FIRST_NAME | VARCHAR2 | 150 | EMP_FIRST_NAME | ||
| EMP_LAST_NAME | VARCHAR2 | 150 | EMP_LAST_NAME | ||
| EMP_KNOWN_AS | VARCHAR2 | 80 | EMP_KNOWN_AS | ||
| EMP_FULL_NAME | VARCHAR2 | 2000 | EMP_FULL_NAME | ||
| EMP_LIST_NAME | VARCHAR2 | 240 | EMP_LIST_NAME | ||
| EMP_ORDER_NAME | VARCHAR2 | 240 | EMP_ORDER_NAME | ||
| LVL1_MGR_DISPLAY_NAME | VARCHAR2 | 240 | LVL1_MGR_DISPLAY_NAME | ||
| LVL2_MGR_DISPLAY_NAME | VARCHAR2 | 240 | LVL2_MGR_DISPLAY_NAME | ||
| SUPERVISOR_DISPLAY_NAME | VARCHAR2 | 240 | SUPERVISOR_DISPLAY_NAME | ||
| SEC_MGR_DISPLAY_NAME | VARCHAR2 | 240 | SEC_MGR_DISPLAY_NAME | ||
| RVW_MGR_DISPLAY_NAME | VARCHAR2 | 240 | RVW_MGR_DISPLAY_NAME | ||
| EFFECTIVE_DATE | DATE | EFFECTIVE_DATE | |||
| LEGISLATION_CODE | VARCHAR2 | 30 | LEGISLATION_CODE | ||
| EMAIL_ADDRESS | VARCHAR2 | 240 | EMAIL_ADDRESS | ||
| 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 | ||
| PAYROLL_NAME | VARCHAR2 | 80 | PAYROLL_NAME | ||
| DATE_OF_BIRTH | DATE | DATE_OF_BIRTH | |||
| WORK_TELEPHONE | VARCHAR2 | 60 | WORK_TELEPHONE | ||
| WORKER_NUMBER | VARCHAR2 | 30 | WORKER_NUMBER | ||
| HOME_ADDRESS_ID | NUMBER | 18 | HOME_ADDRESS_ID | ||
| MAIL_ADDRESS_ID | NUMBER | 18 | MAIL_ADDRESS_ID | ||
| SEX | VARCHAR2 | 30 | SEX | ||
| ETHNICITY | VARCHAR2 | 30 | ETHNICITY | ||
| NATIONALITY | VARCHAR2 | 30 | NATIONALITY | ||
| EMP_STATUS_CODE | VARCHAR2 | 30 | EMP_STATUS_CODE | ||
| DISABILITY_STATUS | VARCHAR2 | 30 | DISABILITY_STATUS | ||
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 18 | ASSIGNMENT_STATUS_TYPE_ID | ||
| EMPLOYMENT_CATEGORY | VARCHAR2 | 30 | EMPLOYMENT_CATEGORY | ||
| CWB_PERF_RATING | NUMBER | 18 | CWB_PERF_RATING | ||
| ASG_CHANGE_DATE | DATE | ASG_CHANGE_DATE | |||
| PROM_UPDATE_DATE | DATE | PROM_UPDATE_DATE | |||
| JOB_ID | NUMBER | 18 | JOB_ID | ||
| NEW_JOB_ID | NUMBER | 18 | NEW_JOB_ID | ||
| JOB_CHANGE_DATE | DATE | JOB_CHANGE_DATE | |||
| YEARS_IN_JOB | NUMBER | YEARS_IN_JOB | |||
| POSITION_ID | NUMBER | 18 | POSITION_ID | ||
| NEW_POSITION_ID | NUMBER | 18 | NEW_POSITION_ID | ||
| POSITION_CHANGE_DATE | DATE | POSITION_CHANGE_DATE | |||
| YEARS_IN_POSITION | NUMBER | YEARS_IN_POSITION | |||
| GRADE_ID | NUMBER | 18 | GRADE_ID | ||
| NEW_GRADE_ID | NUMBER | 18 | NEW_GRADE_ID | ||
| GRADE_CHANGE_DATE | DATE | GRADE_CHANGE_DATE | |||
| YEARS_IN_GRADE | NUMBER | YEARS_IN_GRADE | |||
| GRADE_MIN_VAL | NUMBER | GRADE_MIN_VAL | |||
| GRADE_MAX_VAL | NUMBER | GRADE_MAX_VAL | |||
| GRADE_MID_POINT | NUMBER | GRADE_MID_POINT | |||
| GRADE_COMPARATIO | NUMBER | GRADE_COMPARATIO | |||
| NEW_GRADE_MIN_VAL | NUMBER | NEW_GRADE_MIN_VAL | |||
| NEW_GRADE_MAX_VAL | NUMBER | NEW_GRADE_MAX_VAL | |||
| NEW_GRADE_MID_POINT | NUMBER | NEW_GRADE_MID_POINT | |||
| NEW_GRADE_COMPARATIO | NUMBER | NEW_GRADE_COMPARATIO | |||
| ASSIGNMENT_NAME | VARCHAR2 | 80 | ASSIGNMENT_NAME | ||
| NEW_ASSIGNMENT_NAME | VARCHAR2 | 80 | NEW_ASSIGNMENT_NAME | ||
| ASSIGNMENT_POSTED_DATE | DATE | ASSIGNMENT_POSTED_DATE | |||
| ASSIGNMENT_POSTING_DATE | DATE | ASSIGNMENT_POSTING_DATE | |||
| ORIGINAL_START_DATE | DATE | ORIGINAL_START_DATE | |||
| START_DATE | DATE | START_DATE | |||
| YEARS_EMPLOYED | NUMBER | YEARS_EMPLOYED | |||
| WORKER_POTENTIAL | NUMBER | 18 | WORKER_POTENTIAL | ||
| RISK_OF_LOSS | NUMBER | 18 | RISK_OF_LOSS | ||
| WORKING_HOURS | NUMBER | WORKING_HOURS | |||
| NORMAL_HOURS | NUMBER | NORMAL_HOURS | |||
| BASE_SALARY_FREQUENCY | VARCHAR2 | 30 | BASE_SALARY_FREQUENCY | ||
| BASE_SALARY_CURRENCY | VARCHAR2 | 30 | BASE_SALARY_CURRENCY | ||
| BASE_SALARY | NUMBER | BASE_SALARY | |||
| ADJUSTED_BASE_SALARY | NUMBER | ADJUSTED_BASE_SALARY | |||
| NEW_BASE_SALARY | NUMBER | NEW_BASE_SALARY | |||
| BASE_SALARY_AMOUNT_CHANGE | NUMBER | BASE_SALARY_AMOUNT_CHANGE | |||
| BASE_SALARY_PERCENTAGE_CHANGE | NUMBER | BASE_SALARY_PERCENTAGE_CHANGE | |||
| FTE_FACTOR | NUMBER | FTE_FACTOR | |||
| PAY_ANNUALIZATION_FACTOR | NUMBER | PAY_ANNUALIZATION_FACTOR | |||
| BASE_SALARY_CHANGE_DATE | DATE | BASE_SALARY_CHANGE_DATE | |||
| CUSTOM_SEGMENT1 | VARCHAR2 | 150 | CUSTOM_SEGMENT1 | ||
| CUSTOM_SEGMENT2 | VARCHAR2 | 150 | CUSTOM_SEGMENT2 | ||
| CUSTOM_SEGMENT3 | VARCHAR2 | 150 | CUSTOM_SEGMENT3 | ||
| CUSTOM_SEGMENT4 | VARCHAR2 | 150 | CUSTOM_SEGMENT4 | ||
| CUSTOM_SEGMENT5 | VARCHAR2 | 150 | CUSTOM_SEGMENT5 | ||
| CUSTOM_SEGMENT6 | VARCHAR2 | 150 | CUSTOM_SEGMENT6 | ||
| CUSTOM_SEGMENT7 | VARCHAR2 | 150 | CUSTOM_SEGMENT7 | ||
| CUSTOM_SEGMENT8 | VARCHAR2 | 150 | CUSTOM_SEGMENT8 | ||
| CUSTOM_SEGMENT9 | VARCHAR2 | 150 | CUSTOM_SEGMENT9 | ||
| CUSTOM_SEGMENT10 | VARCHAR2 | 150 | CUSTOM_SEGMENT10 | ||
| CUSTOM_SEGMENT11 | VARCHAR2 | 150 | CUSTOM_SEGMENT11 | ||
| CUSTOM_SEGMENT12 | VARCHAR2 | 4000 | CUSTOM_SEGMENT12 | ||
| CUSTOM_SEGMENT13 | VARCHAR2 | 4000 | CUSTOM_SEGMENT13 | ||
| CUSTOM_SEGMENT14 | VARCHAR2 | 4000 | CUSTOM_SEGMENT14 | ||
| CUSTOM_SEGMENT15 | VARCHAR2 | 4000 | CUSTOM_SEGMENT15 | ||
| CUSTOM_SEGMENT16 | NUMBER | CUSTOM_SEGMENT16 | |||
| CUSTOM_SEGMENT17 | NUMBER | CUSTOM_SEGMENT17 | |||
| CUSTOM_SEGMENT18 | NUMBER | CUSTOM_SEGMENT18 | |||
| CUSTOM_SEGMENT19 | NUMBER | CUSTOM_SEGMENT19 | |||
| CUSTOM_SEGMENT20 | NUMBER | CUSTOM_SEGMENT20 | |||
| CUSTOM_SEGMENT21 | NUMBER | CUSTOM_SEGMENT21 | |||
| CUSTOM_SEGMENT22 | NUMBER | CUSTOM_SEGMENT22 | |||
| CUSTOM_SEGMENT23 | NUMBER | CUSTOM_SEGMENT23 | |||
| CUSTOM_SEGMENT24 | NUMBER | CUSTOM_SEGMENT24 | |||
| CUSTOM_SEGMENT25 | NUMBER | CUSTOM_SEGMENT25 | |||
| CUSTOM_SEGMENT26 | NUMBER | CUSTOM_SEGMENT26 | |||
| CUSTOM_SEGMENT27 | NUMBER | CUSTOM_SEGMENT27 | |||
| CUSTOM_SEGMENT28 | NUMBER | CUSTOM_SEGMENT28 | |||
| CUSTOM_SEGMENT29 | NUMBER | CUSTOM_SEGMENT29 | |||
| CUSTOM_SEGMENT30 | NUMBER | CUSTOM_SEGMENT30 | |||
| CUSTOM_SEGMENT31 | NUMBER | CUSTOM_SEGMENT31 | |||
| CUSTOM_SEGMENT32 | NUMBER | CUSTOM_SEGMENT32 | |||
| CUSTOM_SEGMENT33 | NUMBER | CUSTOM_SEGMENT33 | |||
| CUSTOM_SEGMENT34 | NUMBER | CUSTOM_SEGMENT34 | |||
| CUSTOM_SEGMENT35 | NUMBER | CUSTOM_SEGMENT35 | |||
| CUSTOM_SEGMENT36 | NUMBER | CUSTOM_SEGMENT36 | |||
| CUSTOM_SEGMENT37 | NUMBER | CUSTOM_SEGMENT37 | |||
| CUSTOM_SEGMENT38 | NUMBER | CUSTOM_SEGMENT38 | |||
| CUSTOM_SEGMENT39 | NUMBER | CUSTOM_SEGMENT39 | |||
| CUSTOM_SEGMENT40 | NUMBER | CUSTOM_SEGMENT40 | |||
| CUSTOM_SEGMENT41 | NUMBER | CUSTOM_SEGMENT41 | |||
| CUSTOM_SEGMENT42 | NUMBER | CUSTOM_SEGMENT42 | |||
| CUSTOM_SEGMENT43 | NUMBER | CUSTOM_SEGMENT43 | |||
| CUSTOM_SEGMENT44 | NUMBER | CUSTOM_SEGMENT44 | |||
| CUSTOM_SEGMENT45 | NUMBER | CUSTOM_SEGMENT45 | |||
| CUSTOM_SEGMENT46 | NUMBER | CUSTOM_SEGMENT46 | |||
| CUSTOM_SEGMENT47 | NUMBER | CUSTOM_SEGMENT47 | |||
| CUSTOM_SEGMENT48 | NUMBER | CUSTOM_SEGMENT48 | |||
| CUSTOM_SEGMENT49 | NUMBER | CUSTOM_SEGMENT49 | |||
| CUSTOM_SEGMENT50 | NUMBER | CUSTOM_SEGMENT50 | |||
| JOB_ATTRIBUTE1 | VARCHAR2 | 150 | JOB_ATTRIBUTE1 | ||
| JOB_ATTRIBUTE2 | VARCHAR2 | 150 | JOB_ATTRIBUTE2 | ||
| JOB_ATTRIBUTE3 | VARCHAR2 | 150 | JOB_ATTRIBUTE3 | ||
| JOB_ATTRIBUTE4 | VARCHAR2 | 150 | JOB_ATTRIBUTE4 | ||
| JOB_ATTRIBUTE5 | VARCHAR2 | 150 | JOB_ATTRIBUTE5 | ||
| JOB_ATTRIBUTE6 | VARCHAR2 | 150 | JOB_ATTRIBUTE6 | ||
| GRADE_ATTRIBUTE1 | VARCHAR2 | 150 | GRADE_ATTRIBUTE1 | ||
| GRADE_ATTRIBUTE2 | VARCHAR2 | 150 | GRADE_ATTRIBUTE2 | ||
| GRADE_ATTRIBUTE3 | VARCHAR2 | 150 | GRADE_ATTRIBUTE3 | ||
| NEW_ADJUSTED_BASE_SALARY | NUMBER | NEW_ADJUSTED_BASE_SALARY | |||
| FTE_ADJUSTMENT_FACTOR | NUMBER | FTE_ADJUSTMENT_FACTOR | |||
| FTE_ADJUSTED_SALARY | NUMBER | FTE_ADJUSTED_SALARY | |||
| NEW_FTE_ADJUSTED_SALARY | NUMBER | NEW_FTE_ADJUSTED_SALARY | |||
| FTE_ADJUSTED_SALARY_CHANGE | NUMBER | FTE_ADJUSTED_SALARY_CHANGE | |||
| PLAN_ELIG_FLAG | VARCHAR2 | 1 | PLAN_ELIG_FLAG | ||
| COMPONENT_ID1 | NUMBER | 18 | COMPONENT_ID1 | ||
| COMP1_NON_MONETARY_UOM | VARCHAR2 | 30 | COMP1_NON_MONETARY_UOM | ||
| COMP1_CURRENCY | VARCHAR2 | 30 | COMP1_CURRENCY | ||
| COMP1_ELIG_FLAG | VARCHAR2 | 1 | COMP1_ELIG_FLAG | ||
| COMP1_COMP_POSTED_DATE | DATE | COMP1_COMP_POSTED_DATE | |||
| COMP1_COMP_POSTING_DATE | DATE | COMP1_COMP_POSTING_DATE | |||
| COMP1_WS_VAL_LAST_UPD_DATE | DATE | COMP1_WS_VAL_LAST_UPD_DATE | |||
| COMP1_ELIG_SAL_VAL | NUMBER | COMP1_ELIG_SAL_VAL | |||
| COMP1_WS_VAL | NUMBER | COMP1_WS_VAL | |||
| COMP1_WS_VAL_PERCENTAGE | NUMBER | COMP1_WS_VAL_PERCENTAGE | |||
| COMP1_MISC1_VAL | NUMBER | COMP1_MISC1_VAL | |||
| COMP1_MISC2_VAL | NUMBER | COMP1_MISC2_VAL | |||
| COMP1_MISC3_VAL | NUMBER | COMP1_MISC3_VAL | |||
| COMP1_MISC4_VAL | NUMBER | COMP1_MISC4_VAL | |||
| COMP1_MISC5_VAL | NUMBER | COMP1_MISC5_VAL | |||
| COMP1_MISC6_VAL | NUMBER | COMP1_MISC6_VAL | |||
| COMP1_PRIOR_WS_VAL | NUMBER | COMP1_PRIOR_WS_VAL | |||
| COMP1_PRIOR_WS_VAL_DATE | DATE | COMP1_PRIOR_WS_VAL_DATE | |||
| COMP1_WS_MAX_VAL | NUMBER | COMP1_WS_MAX_VAL | |||
| COMP1_WS_MAX_VAL_PERCENTAGE | NUMBER | COMP1_WS_MAX_VAL_PERCENTAGE | |||
| COMP1_WS_MIN_VAL | NUMBER | COMP1_WS_MIN_VAL | |||
| COMP1_WS_MIN_VAL_PERCENTAGE | NUMBER | COMP1_WS_MIN_VAL_PERCENTAGE | |||
| COMP1_REC_VAL | NUMBER | COMP1_REC_VAL | |||
| COMP1_REC_VAL_PERCENTAGE | NUMBER | COMP1_REC_VAL_PERCENTAGE | |||
| COMP1_REC_MAX_VAL | NUMBER | COMP1_REC_MAX_VAL | |||
| COMP1_REC_MAX_VAL_PERCENTAGE | NUMBER | COMP1_REC_MAX_VAL_PERCENTAGE | |||
| COMP1_REC_MIN_VAL | NUMBER | COMP1_REC_MIN_VAL | |||
| COMP1_REC_MIN_VAL_PERCENTAGE | NUMBER | COMP1_REC_MIN_VAL_PERCENTAGE | |||
| COMPONENT_ID2 | NUMBER | 18 | COMPONENT_ID2 | ||
| COMP2_NON_MONETARY_UOM | VARCHAR2 | 30 | COMP2_NON_MONETARY_UOM | ||
| COMP2_CURRENCY | VARCHAR2 | 30 | COMP2_CURRENCY | ||
| COMP2_ELIG_FLAG | VARCHAR2 | 1 | COMP2_ELIG_FLAG | ||
| COMP2_COMP_POSTED_DATE | DATE | COMP2_COMP_POSTED_DATE | |||
| COMP2_COMP_POSTING_DATE | DATE | COMP2_COMP_POSTING_DATE | |||
| COMP2_WS_VAL_LAST_UPD_DATE | DATE | COMP2_WS_VAL_LAST_UPD_DATE | |||
| COMP2_ELIG_SAL_VAL | NUMBER | COMP2_ELIG_SAL_VAL | |||
| COMP2_WS_VAL | NUMBER | COMP2_WS_VAL | |||
| COMP2_WS_VAL_PERCENTAGE | NUMBER | COMP2_WS_VAL_PERCENTAGE | |||
| COMP2_MISC1_VAL | NUMBER | COMP2_MISC1_VAL | |||
| COMP2_MISC2_VAL | NUMBER | COMP2_MISC2_VAL | |||
| COMP2_MISC3_VAL | NUMBER | COMP2_MISC3_VAL | |||
| COMP2_MISC4_VAL | NUMBER | COMP2_MISC4_VAL | |||
| COMP2_MISC5_VAL | NUMBER | COMP2_MISC5_VAL | |||
| COMP2_MISC6_VAL | NUMBER | COMP2_MISC6_VAL | |||
| COMP2_PRIOR_WS_VAL | NUMBER | COMP2_PRIOR_WS_VAL | |||
| COMP2_PRIOR_WS_VAL_DATE | DATE | COMP2_PRIOR_WS_VAL_DATE | |||
| COMP2_WS_MAX_VAL | NUMBER | COMP2_WS_MAX_VAL | |||
| COMP2_WS_MAX_VAL_PERCENTAGE | NUMBER | COMP2_WS_MAX_VAL_PERCENTAGE | |||
| COMP2_WS_MIN_VAL | NUMBER | COMP2_WS_MIN_VAL | |||
| COMP2_WS_MIN_VAL_PERCENTAGE | NUMBER | COMP2_WS_MIN_VAL_PERCENTAGE | |||
| COMP2_REC_VAL | NUMBER | COMP2_REC_VAL | |||
| COMP2_REC_VAL_PERCENTAGE | NUMBER | COMP2_REC_VAL_PERCENTAGE | |||
| COMP2_REC_MAX_VAL | NUMBER | COMP2_REC_MAX_VAL | |||
| COMP2_REC_MAX_VAL_PERCENTAGE | NUMBER | COMP2_REC_MAX_VAL_PERCENTAGE | |||
| COMP2_REC_MIN_VAL | NUMBER | COMP2_REC_MIN_VAL | |||
| COMP2_REC_MIN_VAL_PERCENTAGE | NUMBER | COMP2_REC_MIN_VAL_PERCENTAGE | |||
| COMPONENT_ID3 | NUMBER | 18 | COMPONENT_ID3 | ||
| COMP3_NON_MONETARY_UOM | VARCHAR2 | 30 | COMP3_NON_MONETARY_UOM | ||
| COMP3_CURRENCY | VARCHAR2 | 30 | COMP3_CURRENCY | ||
| COMP3_ELIG_FLAG | VARCHAR2 | 1 | COMP3_ELIG_FLAG | ||
| COMP3_COMP_POSTED_DATE | DATE | COMP3_COMP_POSTED_DATE | |||
| COMP3_COMP_POSTING_DATE | DATE | COMP3_COMP_POSTING_DATE | |||
| COMP3_WS_VAL_LAST_UPD_DATE | DATE | COMP3_WS_VAL_LAST_UPD_DATE | |||
| COMP3_ELIG_SAL_VAL | NUMBER | COMP3_ELIG_SAL_VAL | |||
| COMP3_WS_VAL | NUMBER | COMP3_WS_VAL | |||
| COMP3_WS_VAL_PERCENTAGE | NUMBER | COMP3_WS_VAL_PERCENTAGE | |||
| COMP3_MISC1_VAL | NUMBER | COMP3_MISC1_VAL | |||
| COMP3_MISC2_VAL | NUMBER | COMP3_MISC2_VAL | |||
| COMP3_MISC3_VAL | NUMBER | COMP3_MISC3_VAL | |||
| COMP3_MISC4_VAL | NUMBER | COMP3_MISC4_VAL | |||
| COMP3_MISC5_VAL | NUMBER | COMP3_MISC5_VAL | |||
| COMP3_MISC6_VAL | NUMBER | COMP3_MISC6_VAL | |||
| COMP3_PRIOR_WS_VAL | NUMBER | COMP3_PRIOR_WS_VAL | |||
| COMP3_PRIOR_WS_VAL_DATE | DATE | COMP3_PRIOR_WS_VAL_DATE | |||
| COMP3_WS_MAX_VAL | NUMBER | COMP3_WS_MAX_VAL | |||
| COMP3_WS_MAX_VAL_PERCENTAGE | NUMBER | COMP3_WS_MAX_VAL_PERCENTAGE | |||
| COMP3_WS_MIN_VAL | NUMBER | COMP3_WS_MIN_VAL | |||
| COMP3_WS_MIN_VAL_PERCENTAGE | NUMBER | COMP3_WS_MIN_VAL_PERCENTAGE | |||
| COMP3_REC_VAL | NUMBER | COMP3_REC_VAL | |||
| COMP3_REC_VAL_PERCENTAGE | NUMBER | COMP3_REC_VAL_PERCENTAGE | |||
| COMP3_REC_MAX_VAL | NUMBER | COMP3_REC_MAX_VAL | |||
| COMP3_REC_MAX_VAL_PERCENTAGE | NUMBER | COMP3_REC_MAX_VAL_PERCENTAGE | |||
| COMP3_REC_MIN_VAL | NUMBER | COMP3_REC_MIN_VAL | |||
| COMP3_REC_MIN_VAL_PERCENTAGE | NUMBER | COMP3_REC_MIN_VAL_PERCENTAGE | |||
| COMPONENT_ID4 | NUMBER | 18 | COMPONENT_ID4 | ||
| COMP4_NON_MONETARY_UOM | VARCHAR2 | 30 | COMP4_NON_MONETARY_UOM | ||
| COMP4_CURRENCY | VARCHAR2 | 30 | COMP4_CURRENCY | ||
| COMP4_ELIG_FLAG | VARCHAR2 | 1 | COMP4_ELIG_FLAG | ||
| COMP4_COMP_POSTED_DATE | DATE | COMP4_COMP_POSTED_DATE | |||
| COMP4_COMP_POSTING_DATE | DATE | COMP4_COMP_POSTING_DATE | |||
| COMP4_WS_VAL_LAST_UPD_DATE | DATE | COMP4_WS_VAL_LAST_UPD_DATE | |||
| COMP4_ELIG_SAL_VAL | NUMBER | COMP4_ELIG_SAL_VAL | |||
| COMP4_WS_VAL | NUMBER | COMP4_WS_VAL | |||
| COMP4_WS_VAL_PERCENTAGE | NUMBER | COMP4_WS_VAL_PERCENTAGE | |||
| COMP4_MISC1_VAL | NUMBER | COMP4_MISC1_VAL | |||
| COMP4_MISC2_VAL | NUMBER | COMP4_MISC2_VAL | |||
| COMP4_MISC3_VAL | NUMBER | COMP4_MISC3_VAL | |||
| COMP4_MISC4_VAL | NUMBER | COMP4_MISC4_VAL | |||
| COMP4_MISC5_VAL | NUMBER | COMP4_MISC5_VAL | |||
| COMP4_MISC6_VAL | NUMBER | COMP4_MISC6_VAL | |||
| COMP4_PRIOR_WS_VAL | NUMBER | COMP4_PRIOR_WS_VAL | |||
| COMP4_PRIOR_WS_VAL_DATE | DATE | COMP4_PRIOR_WS_VAL_DATE | |||
| COMP4_WS_MAX_VAL | NUMBER | COMP4_WS_MAX_VAL | |||
| COMP4_WS_MAX_VAL_PERCENTAGE | NUMBER | COMP4_WS_MAX_VAL_PERCENTAGE | |||
| COMP4_WS_MIN_VAL | NUMBER | COMP4_WS_MIN_VAL | |||
| COMP4_WS_MIN_VAL_PERCENTAGE | NUMBER | COMP4_WS_MIN_VAL_PERCENTAGE | |||
| COMP4_REC_VAL | NUMBER | COMP4_REC_VAL | |||
| COMP4_REC_VAL_PERCENTAGE | NUMBER | COMP4_REC_VAL_PERCENTAGE | |||
| COMP4_REC_MAX_VAL | NUMBER | COMP4_REC_MAX_VAL | |||
| COMP4_REC_MAX_VAL_PERCENTAGE | NUMBER | COMP4_REC_MAX_VAL_PERCENTAGE | |||
| COMP4_REC_MIN_VAL | NUMBER | COMP4_REC_MIN_VAL | |||
| COMP4_REC_MIN_VAL_PERCENTAGE | NUMBER | COMP4_REC_MIN_VAL_PERCENTAGE | |||
| COMPONENT_ID5 | NUMBER | 18 | COMPONENT_ID5 | ||
| COMP5_NON_MONETARY_UOM | VARCHAR2 | 30 | COMP5_NON_MONETARY_UOM | ||
| COMP5_CURRENCY | VARCHAR2 | 30 | COMP5_CURRENCY | ||
| COMP5_ELIG_FLAG | VARCHAR2 | 1 | COMP5_ELIG_FLAG | ||
| COMP5_COMP_POSTED_DATE | DATE | COMP5_COMP_POSTED_DATE | |||
| COMP5_COMP_POSTING_DATE | DATE | COMP5_COMP_POSTING_DATE | |||
| COMP5_WS_VAL_LAST_UPD_DATE | DATE | COMP5_WS_VAL_LAST_UPD_DATE | |||
| COMP5_ELIG_SAL_VAL | NUMBER | COMP5_ELIG_SAL_VAL | |||
| COMP5_WS_VAL | NUMBER | COMP5_WS_VAL | |||
| COMP5_WS_VAL_PERCENTAGE | NUMBER | COMP5_WS_VAL_PERCENTAGE | |||
| COMP5_MISC1_VAL | NUMBER | COMP5_MISC1_VAL | |||
| COMP5_MISC2_VAL | NUMBER | COMP5_MISC2_VAL | |||
| COMP5_MISC3_VAL | NUMBER | COMP5_MISC3_VAL | |||
| COMP5_MISC4_VAL | NUMBER | COMP5_MISC4_VAL | |||
| COMP5_MISC5_VAL | NUMBER | COMP5_MISC5_VAL | |||
| COMP5_MISC6_VAL | NUMBER | COMP5_MISC6_VAL | |||
| COMP5_PRIOR_WS_VAL | NUMBER | COMP5_PRIOR_WS_VAL | |||
| COMP5_PRIOR_WS_VAL_DATE | DATE | COMP5_PRIOR_WS_VAL_DATE | |||
| COMP5_WS_MAX_VAL | NUMBER | COMP5_WS_MAX_VAL | |||
| COMP5_WS_MAX_VAL_PERCENTAGE | NUMBER | COMP5_WS_MAX_VAL_PERCENTAGE | |||
| COMP5_WS_MIN_VAL | NUMBER | COMP5_WS_MIN_VAL | |||
| COMP5_WS_MIN_VAL_PERCENTAGE | NUMBER | COMP5_WS_MIN_VAL_PERCENTAGE | |||
| COMP5_REC_VAL | NUMBER | COMP5_REC_VAL | |||
| COMP5_REC_VAL_PERCENTAGE | NUMBER | COMP5_REC_VAL_PERCENTAGE | |||
| COMP5_REC_MAX_VAL | NUMBER | COMP5_REC_MAX_VAL | |||
| COMP5_REC_MAX_VAL_PERCENTAGE | NUMBER | COMP5_REC_MAX_VAL_PERCENTAGE | |||
| COMP5_REC_MIN_VAL | NUMBER | COMP5_REC_MIN_VAL | |||
| COMP5_REC_MIN_VAL_PERCENTAGE | NUMBER | COMP5_REC_MIN_VAL_PERCENTAGE | |||
| RATING_OVERALL_STATUS | VARCHAR2 | 16 | RATING_OVERALL_STATUS | ||
| RATING_OVERALL_COMMENTS | VARCHAR2 | 4000 | RATING_OVERALL_COMMENTS | ||
| OVERALL_CALCULATED_RATING | NUMBER | 18 | OVERALL_CALCULATED_RATING | ||
| OVERALL_PERF_RATING_ID | NUMBER | 18 | OVERALL_PERF_RATING_ID | ||
| COMP_CALCULATED_RATING | NUMBER | 18 | COMP_CALCULATED_RATING | ||
| COMP_PERF_RATING_ID | NUMBER | 18 | COMP_PERF_RATING_ID | ||
| GOAL_CALCULATED_RATING | NUMBER | 18 | GOAL_CALCULATED_RATING | ||
| GOAL_PERF_RATING_ID | NUMBER | 18 | GOAL_PERF_RATING_ID | ||
| 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. | ||
| DEV_GOAL_CALCULATED_RATING | NUMBER | 18 | DEV_GOAL_CALCULATED_RATING | ||
| DEV_GOAL_PERF_RATING_ID | NUMBER | 18 | DEV_GOAL_PERF_RATING_ID | ||
| GRADE_STEP_ID | NUMBER | 18 | GRADE_STEP_ID | ||
| GRADE_LADDER_ID | NUMBER | 18 | GRADE_LADDER_ID | ||
| NEW_GRADE_STEP_ID | NUMBER | 18 | NEW_GRADE_STEP_ID | ||
| CALIBRATION_STATUS | VARCHAR2 | 30 | Calibration Status |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMP_CWB_STORED_PERSON_DATA_N1 | Non Unique | Default | PERIOD_ID, PLAN_ID |
| CMP_CWB_STORED_PERSON_DATA_N2 | Non Unique | Default | ASSIGNMENT_ID, PERIOD_ID, PLAN_ID |
| CMP_CWB_STORED_PERSON_DATA_PK | Unique | Default | PERSON_STMT_ID |