Alias: IVDOL#
The INF_CV_ORGLEVELS table is used to import organization levels and related department codes into the software data structures. Organization levels redefine the organization structure of departments and allow alternate groupings of departments along regional, functional or other lines.Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ORG_LEVEL_CODE | Varchar2(16) | CODE | Y | |
| ORG_LEVEL_TYPE | Varchar2(30) | VARCHAR30 | Y | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| ENTITY_CODE | Varchar2(16) | CODE | ||
| POSITION_CODE | Varchar2(16) | CODE | ||
| DEPARTMENT_CODE | Varchar2(16) | CODE | ||
| PART_OF_ORG_LEVEL_CODE | Varchar2(16) | CODE | ||
| PART_OF_ORG_LEVEL_TYPE | Varchar2(30) | VARCHAR30 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
