This dimension captures the Plan Details
Module: Compensation
PLAN_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PLAN_ID | NUMBER | 38 | 0 | True | Plan Identifier | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source Record Identifier | |||
STATUS_CODE | VARCHAR2 | 32 | Plan Status Code | DW_CMP_PLAN_STATUS_D_TL | PLAN_STATUS_CODE | ||
ANNUALIZATION_FACTOR | NUMBER | Plan Annualization Factor | |||||
CORPORATE_CURRENCY | VARCHAR2 | 16 | Corporate Currency of the Plan | ||||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group Identifier | |||
APPROVAL_MODE | VARCHAR2 | 32 | Approval Mode of the Plan | DW_CMP_APPROVAL_MODE_D_TL | APPROVAL_MODE_CODE | ||
SUBMIT_MODE | VARCHAR2 | 32 | Submit Mode of the Plan | DW_CMP_SUBMIT_MODE_D_TL | SUBMIT_MODE_CODE | ||
COMP_TYPE | VARCHAR2 | 32 | Component Type of the Plan | DW_CMP_COMP_TYPE_D_TL | COMP_TYPE_CODE | ||
FREQUENCY | VARCHAR2 | 32 | Frequency of the Plan | DW_CMP_PLAN_FREQUENCY_D_TL | PLAN_FREQUENCY_CODE |
Copyright © 2019, 2022, Oracle and/or its affiliates.