DIM_HR_JOB_HIERARCHY_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 POSITIONID INTEGER 4
2 PERSONID BIGINT 8
3 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
4 POSITION_LEVEL INTEGER 4
5 ORGANISATIONAL_UNIT_ID BIGINT 8
6 IS_TERMINATED CHARACTER VARYING(1) 1
7 L01_POSITIONID INTEGER 4
8 L01_PERSONID BIGINT 8
9 L01_ORGANISATIONAL_UNIT_ID BIGINT 8
10 L02_POSITIONID INTEGER 4
11 L02_PERSONID BIGINT 8
12 L02_ORGANISATIONAL_UNIT_ID BIGINT 8
13 L03_POSITIONID INTEGER 4
14 L03_PERSONID BIGINT 8
15 L03_ORGANISATIONAL_UNIT_ID BIGINT 8
16 L04_POSITIONID INTEGER 4
17 L04_PERSONID BIGINT 8
18 L04_ORGANISATIONAL_UNIT_ID BIGINT 8
19 L05_POSITIONID INTEGER 4
20 L05_PERSONID BIGINT 8
21 L05_ORGANISATIONAL_UNIT_ID BIGINT 8
22 L06_POSITIONID INTEGER 4
23 L06_PERSONID BIGINT 8
24 L06_ORGANISATIONAL_UNIT_ID BIGINT 8
25 L07_POSITIONID INTEGER 4
26 L07_PERSONID BIGINT 8
27 L07_ORGANISATIONAL_UNIT_ID BIGINT 8
28 L08_POSITIONID INTEGER 4
29 L08_PERSONID BIGINT 8
30 L08_ORGANISATIONAL_UNIT_ID BIGINT 8
31 L09_POSITIONID INTEGER 4
32 L09_PERSONID BIGINT 8
33 L09_ORGANISATIONAL_UNIT_ID BIGINT 8
34 L10_POSITIONID INTEGER 4
35 L10_PERSONID BIGINT 8
36 L10_ORGANISATIONAL_UNIT_ID BIGINT 8
37 REPORTS_TO_PERSONID BIGINT 8
38 REPORTS_TO_POSITIONID INTEGER 4
39 REPORTS_TO_ORGANISATIONAL_UNIT_ID BIGINT 8
40 MOR_PERSONID BIGINT 8
41 MOR_POSITIONID INTEGER 4
42 MOR_ORGANISATIONAL_UNIT_ID BIGINT 8
43 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
44 DEPARTMENT_CODE CHARACTER VARYING(100) 100
45 TEAM_CODE CHARACTER VARYING(100) 100
46 IS_LEADER CHARACTER VARYING(1) 1