!!!Alias: IVDDP
The INF_CV_DEPARTMENTS table is used to import department codes and their attendant data into the software data structures.  Departments divide the organization  into manageable areas, defining the organization structure from a human resources management point of view.   Departments are usually a combination of functional areas of the organization such as sales, marketing and accounting,  cost centers such as stores, warehouses, theaters, branches and offices,  and production lines or product related processes such as forming, molding, finishing and quality assurance.
!!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]| |