FCT_HR_EMPLOYEE_ORGANISATION_HISTORY_V

Database

INSNZP01_HR

Schema

HRPADM

Type

VIEW

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_FCT_HR_EMPLOYEE_ORGANISATION_HISTORY_V

SDSNZP05_BANK..CBP_FCT_HR_EMPLOYEE_ORGANISATION_HISTORY_V

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 PERSONID INTEGER 4
3 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
4 PAYROLL_NUMBER CHARACTER VARYING(50) 50
5 FIRST_NAME CHARACTER VARYING(100) 100
6 SURNAME CHARACTER VARYING(100) 100
7 PREFERRED_FIRST_NAME CHARACTER VARYING(100) 100
8 PREFERRED_NAME CHARACTER VARYING(100) 100
9 REPORTING_NAME CHARACTER VARYING(255) 255
10 EFFECTIVEDATE TIMESTAMP 8
11 EFFECTIVE_END_DATE TIMESTAMP 8
12 ORGANISATIONAL_UNIT_ID BIGINT 8
13 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
14 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
15 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
16 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
17 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
18 DIVISION_CODE CHARACTER VARYING(100) 100
19 DIVISION_NAME CHARACTER VARYING(100) 100
20 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
21 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
22 DEPARTMENT_CODE CHARACTER VARYING(100) 100
23 DEPARTMENT_NAME CHARACTER VARYING(100) 100
24 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
25 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
26 SECTION_CODE CHARACTER VARYING(100) 100
27 SECTION_NAME CHARACTER VARYING(100) 100
28 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
29 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
30 TEAM_CODE CHARACTER VARYING(100) 100
31 TEAM_NAME CHARACTER VARYING(100) 100
32 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
33 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100