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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.