DW_PROJECT_PLAN_TYPE_D

This table is used to store the plan types.

Details

Module: Project Control

Key Columns

PLAN_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_TYPE_ID NUMBER 38 0 True The system generated number that uniquely identifies the plan type
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
START_DATE DATE First effective date of the plan type
END_DATE DATE Last effective date of the plan type
PLAN_TYPE_CODE VARCHAR2 32 Plan Type Code
PLAN_CLASS_CODE VARCHAR2 32 Plan Class for the plan type
PLAN_OPTION_CODE VARCHAR2 32 Plan Option for the plan type