This dimension captures Worksheet Approval Details
Module: Compensation
APPROVAL_HISTORY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
APPROVAL_HISTORY_ID | NUMBER | 38 | 0 | True | Approval History Identifier | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Identifier | |||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Unit Identifier | |||
MGR_PERSON_EVENT_ID | NUMBER | 38 | 0 | Manager Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID | |
EMP_PERSON_EVENT_ID | NUMBER | 38 | 0 | Employee Person Event Identifier | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID | |
MGR_ASSIGNMENT_ID | NUMBER | 38 | 0 | Manager Assignment Identifier | |||
POOL_ID | NUMBER | 38 | 0 | Pool Identifier | DW_CMP_BUDGET_POOL_D | BUDGET_POOL_ID | |
ACTION_CODE | VARCHAR2 | 32 | Action Code | DW_CMP_WORKSHEET_STATUS_D_TL | WORKSHEET_STATUS_CODE | ||
ACTION_DATE | TIMESTAMP | Action Date |