DW_INTERNAL_ORG_CLASS_D

This table stores the Organizations classifications and related informations

Details

Module:

Key Columns

ORGANIZATION_ID, CLASSIFICATION_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ORGANIZATION_ID NUMBER 38 0 True Organization Identifier, Translation in DW_INTERNAL_ORG_D_TL table.    
CLASSIFICATION_CODE VARCHAR2 64   True Seeded classifications code for organizations.    
SOURCE_RECORD_ID VARCHAR2 128     Uniquely identifies Organization Identifier and its Classification    
EFFECTIVE_START_DATE DATE       Classification effective start date    
EFFECTIVE_END_DATE DATE       Classification effective end date    
STATUS_CODE VARCHAR2 32     Indicates if an organization is active or inactive. For translation, refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE'    
SET_ID NUMBER 38 0   Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.    
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from Legal Entity, Translation in DW_LEGISLATION_D_TL table.