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 This column is for Oracle Internal use only. 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_ACTIVE_INACTIVE_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE' DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
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.