DIM_HR_ORGANISATIONAL_UNIT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER(3) 3
2 BUSINESS_UNIT_BK CHARACTER VARYING(100) 100
3 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
4 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
5 BUSINESS_UNIT_LABEL CHARACTER VARYING(100) 100
6 BUSINESS_UNIT_CAPTION CHARACTER VARYING(100) 100
7 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
8 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
9 BUSINESS_UNIT_LABEL_PATH CHARACTER VARYING(250) 250
10 DIVISION_BK CHARACTER VARYING(100) 100
11 DIVISION_CODE CHARACTER VARYING(100) 100
12 DIVISION_NAME CHARACTER VARYING(100) 100
13 DIVISION_LABEL CHARACTER VARYING(100) 100
14 DIVISION_CAPTION CHARACTER VARYING(100) 100
15 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
16 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
17 DIVISION_LABEL_PATH CHARACTER VARYING(250) 250
18 DEPARTMENT_BK CHARACTER VARYING(100) 100
19 DEPARTMENT_CODE CHARACTER VARYING(100) 100
20 DEPARTMENT_NAME CHARACTER VARYING(100) 100
21 DEPARTMENT_LABEL CHARACTER VARYING(100) 100
22 DEPARTMENT_CAPTION CHARACTER VARYING(100) 100
23 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
24 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
25 DEPARTMENT_LABEL_PATH CHARACTER VARYING(250) 250
26 SECTION_BK CHARACTER VARYING(100) 100
27 SECTION_CODE CHARACTER VARYING(100) 100
28 SECTION_NAME CHARACTER VARYING(100) 100
29 SECTION_LABEL CHARACTER VARYING(100) 100
30 SECTION_CAPTION CHARACTER VARYING(100) 100
31 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
32 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
33 SECTION_LABEL_PATH CHARACTER VARYING(250) 250
34 TEAM_BK CHARACTER VARYING(100) 100
35 TEAM_CODE CHARACTER VARYING(100) 100
36 TEAM_NAME CHARACTER VARYING(100) 100
37 TEAM_LABEL CHARACTER VARYING(100) 100
38 TEAM_CAPTION CHARACTER VARYING(100) 100
39 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
40 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
41 TEAM_LABEL_PATH CHARACTER VARYING(250) 250
42 ORGANISATIONAL_UNIT_BK CHARACTER VARYING(100) 100
43 ORGANISATIONAL_UNIT_CODE CHARACTER VARYING(100) 100
44 ORGANISATIONAL_UNIT_ID BIGINT 8
45 ORGANISATIONAL_UNIT_LABEL CHARACTER VARYING(100) 100
46 ORGANISATIONAL_UNIT_CAPTION CHARACTER VARYING(100) 100
47 ORGANISATIONAL_UNIT_LEVEL_NUMBER INTEGER 4
48 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
49 COST_CENTER_NUMBER CHARACTER VARYING(100) 100
50 EFFECTIVESTATUS INTEGER 4
51 MDS_STAGE_ACQUISITION_SK INTEGER 4
52 PROC_TS TIMESTAMP 8
53 PUBLISH CHARACTER(1) 1
54 QUERY_CURRENT_FLAG CHARACTER(1) 1
55 INSERT_JOB_ID INTEGER 4
56 UPDATE_JOB_ID INTEGER 4