DW_PARTY_SIC_CODE_TYPE_TL

Table to store the translations for SIC TYPE and SIC Code combinations.

Details

Module:

Key Columns

SIC_CODE_TYPE, SIC_CODE, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SIC_CODE_TYPE VARCHAR2 128 True SIC Code Type
SIC_CODE VARCHAR2 128 True SIC Code
LANGUAGE VARCHAR2 64 True Translation language
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source Record Identifier It is a unique combination of CODE_TYPE, CODE
NAME VARCHAR2 128 Business name or value of the code
DESCRIPTION VARCHAR2 256 Description of the code