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   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_CODE_VALUES_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE'    
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.    

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