DW_DEPARTMENT_D

This table stores the Departments information

Details

Module:

Key Columns

DEPARTMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DEPARTMENT_ID NUMBER 38 0 True Department Id, Translation in DW_INTERNAL_ORG_D_TL table.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Uniquely identifies a Department
MANAGER_NAME VARCHAR2 999 This is the name of the manager of the department
MANAGER_PERSON_NUMBER VARCHAR2 32 This is the person number of the manager of the department
LOCATION_ID NUMBER 38 0 Department Location Id
PHONE_NUMBER VARCHAR2 256 Department Location Phone Number
FAX_NUMBER VARCHAR2 256 Department Location Fax Number
EMAIL_ADDRESS VARCHAR2 256 Department Location Email Address
ADDRESS_LINE_1 VARCHAR2 256 Department Location Address Line 1
ADDRESS_LINE_2 VARCHAR2 256 Department Location Address Line 2
CITY_CODE VARCHAR2 128 Department Location City or Town
POSTAL_CODE VARCHAR2 32 Department Location Postal Code
COUNTY_CODE VARCHAR2 128 Department Location County
STATE_PROV_CODE VARCHAR2 128 Department Location State Or Province
COUNTRY_CODE VARCHAR2 64 Department Location Country
STATUS_CODE VARCHAR2 32 Indicates if an department 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
EFFECTIVE_START_DATE DATE Organization effective start date, date range within which the row is effective.
EFFECTIVE_END_DATE DATE Organization effective end date, date range within which the row is effective.