!!!Alias: IVDDP
(INF_CV_DEPARTMENTS)
\\
Date sensitive department information.

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE_SUB_DIVISION]|Varchar2(16)|[CODE]|Y|
|[ENTITY_CODE_LEGAL]|Varchar2(16)|[CODE]| |
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[STANDING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[GENERIC_CODE]|Varchar2(16)|[CODE]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]| |
|[EXPIRY]|Date()|[EXPIRY]| |
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[DEPARTMENT_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[LOCATION_CODE_LOCATED_IN]|Varchar2(16)|[CODE]| |
|[WORK_RULE_CODE]|Varchar2(16)|[CODE]| |
|[PERSON_CODE]|Varchar2(16)|[CODE]| |
|[LOCATION_CODE_PAYDEST]|Varchar2(16)|[CODE]| |
|[AUTHORIZATION_CODE]|Varchar2(16)|[CODE]| |
|[POSITION_CODE]|Varchar2(16)|[CODE]| |
|[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[BURDEN_PERCENT]|Number(5)|[PERCENT]| |
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |
|[EEOC_FUNCTION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BATCH_CODE]|Varchar2(16)|[CODE]| |
|[INDUSTRY_CODE]|Varchar2(16)|[CODE]| |
|[OFFICE_CODE]|Varchar2(16)|[CODE]| |
|[BURDEN_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[DEPARTMENT_CODE_REPORTING_TO]|Varchar2(16)|[CODE]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |