FCT_HR_EMPLOYEE_LISTING_UNSECURED_V

Database

INSNZP01_HR

Schema

HRPADM

Type

VIEW

Description

 

Synonyms

SDSNZP02_BANK..UBAR_FCT_HR_EMPLOYEE_LISTING_UNSECURED_V

SDSNZP05_BANK..CBP_FCT_HR_EMPLOYEE_LISTING_UNSECURED_V

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 PERSONID BIGINT 8
3 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
4 PAYROLL_NUMBER CHARACTER VARYING(50) 50
5 FIRST_NAME CHARACTER VARYING(100) 100
6 PREFERRED_NAME CHARACTER VARYING(100) 100
7 SURNAME CHARACTER VARYING(100) 100
8 REPORTING_NAME CHARACTER VARYING(255) 255
9 EMPLOYEE_FTE NUMERIC(18,6) 19
10 HIRE_DATE TIMESTAMP 8
11 TERMINATIONDATE TIMESTAMP 8
12 IS_TERMINATED_CURRENT_FISCAL_YEAR CHARACTER VARYING(1) 1
13 IS_TERMINATED_LAST_12_MONTHS CHARACTER VARYING(1) 1
14 TENURE_COMPLETED_YRS NUMERIC(10,1) 19
15 TERMINATED_FLAG CHARACTER VARYING(10) 10
16 LEVEL_OF_WORK CHARACTER VARYING(50) 50
17 EMPLOYEE_HRS_PER_WEEK NUMERIC(6,2) 19
18 EMPLOYEE_GROUP_CODE CHARACTER VARYING(25) 25
19 EMPLOYEE_GROUP_NAME CHARACTER VARYING(50) 50
20 EMPLOYEE_CLASS_CODE CHARACTER VARYING(25) 25
21 EMPLOYEE_CLASS_NAME CHARACTER VARYING(255) 255
22 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
23 PAYROLL_STATUS_NAME CHARACTER VARYING(128) 128
24 POSITIONID INTEGER 4
25 POSITION_NUMBER CHARACTER VARYING(100) 100
26 POSITION_TITLE CHARACTER VARYING(256) 256
27 POSITION_FTE NUMERIC(18,2) 19
28 POSITION_LEVEL_OF_WORK INTEGER 4
29 SALARY_PLAN_CODE CHARACTER VARYING(50) 50
30 SALARY_PLAN_DESCRIPTION CHARACTER VARYING(128) 128
31 RFC_INDICATOR CHARACTER VARYING(1) 1
32 MATRIX_MANAGED CHARACTER VARYING(1) 1
33 LEADER_PROFILE_ID INTEGER 4
34 LEADER_PROFILE_DESCRIPTION CHARACTER VARYING(128) 128
35 JOB_FAMILY_ID INTEGER 4
36 JOB_FAMILY_DESCRIPTION CHARACTER VARYING(30) 30
37 JOB_SUBFAMILY_ID INTEGER 4
38 JOB_SUBFAMILY_DESCRIPTION CHARACTER VARYING(40) 40
39 WORK_ADDRESS CHARACTER VARYING(767) 767
40 WORK_CITY CHARACTER VARYING(50) 50
41 WORK_STATECODE CHARACTER VARYING(5) 5
42 WORK_POSTCODE CHARACTER VARYING(12) 12
43 IPCNO CHARACTER VARYING(50) 50
44 POSITION_START_DATE TIMESTAMP 8
45 CURRENT_POSITION_END_DATE TIMESTAMP 8
46 CONTRACT_END_DATE TIMESTAMP 8
47 EMAIL_ADDRESS CHARACTER VARYING(128) 128
48 FULLPART_CODE CHARACTER VARYING(50) 50
49 FULLPART_DESCRIPTION CHARACTER VARYING(128) 128
50 IS_HR_EMPLOYEE CHARACTER VARYING(1) 1
51 ORGANISATIONAL_UNIT_ID BIGINT 8
52 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
53 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
54 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
55 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
56 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
57 DIVISION_CODE CHARACTER VARYING(100) 100
58 DIVISION_NAME CHARACTER VARYING(100) 100
59 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
60 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
61 DEPARTMENT_CODE CHARACTER VARYING(100) 100
62 DEPARTMENT_NAME CHARACTER VARYING(100) 100
63 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
64 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
65 SECTION_CODE CHARACTER VARYING(100) 100
66 SECTION_NAME CHARACTER VARYING(100) 100
67 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
68 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
69 TEAM_CODE CHARACTER VARYING(100) 100
70 TEAM_NAME CHARACTER VARYING(100) 100
71 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
72 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
73 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
74 LEADER_PAYROLL_NUMBER CHARACTER VARYING(50) 50
75 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
76 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
77 LEADER_SURNAME CHARACTER VARYING(100) 100
78 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
79 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
80 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
81 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
82 LOR_PAYROLL_NUMBER CHARACTER VARYING(50) 50
83 LOR_FIRST_NAME CHARACTER VARYING(100) 100
84 LOR_PREFERRED_NAME CHARACTER VARYING(100) 100
85 LOR_SURNAME CHARACTER VARYING(100) 100
86 LOR_REPORTING_NAME CHARACTER VARYING(255) 255
87 LOR_POSITION_NUMBER CHARACTER VARYING(100) 100
88 LOR_POSITION_TITLE CHARACTER VARYING(256) 256
89 LOR_LEADER_PROFILE CHARACTER VARYING(128) 128
90 IS_LEADER CHARACTER VARYING(1) 1
91 OFFICER_CODE_ID INTEGER 4
92 OFFICER_CODE CHARACTER VARYING(50) 50
93 EFFECTIVEDATE TIMESTAMP 8
94 ACTION_DATE TIMESTAMP 8
95 REPORT_DATE DATE 4
96 BUSINESS_UNIT_LABEL_PATH CHARACTER VARYING(250) 250
97 DIVISION_LABEL_PATH CHARACTER VARYING(250) 250
98 DEPARTMENT_LABEL_PATH CHARACTER VARYING(250) 250
99 SECTION_LABEL_PATH CHARACTER VARYING(250) 250
100 TEAM_LABEL_PATH CHARACTER VARYING(250) 250
101 BUSINESS_UNIT_BK CHARACTER VARYING(100) 100
102 DIVISION_BK CHARACTER VARYING(100) 100
103 DEPARTMENT_BK CHARACTER VARYING(100) 100
104 SECTION_BK CHARACTER VARYING(100) 100
105 TEAM_BK CHARACTER VARYING(100) 100
106 ORGANISATIONAL_UNIT_BK CHARACTER VARYING(100) 100
107 EXTENDED_UNPAID_ABSENCE_FLAG INTEGER 4
108 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
109 HEADCOUNT_MTH INTEGER 4
110 TOTAL_FTE_MTH NUMERIC(38,10) 19