FCT_HR_EMPLOYEE_LISTING_BW_HIST_UNSECURED_V

Database

INSNZP01_HR

Schema

HRPADM

Type

VIEW

Description

 

Synonyms

SDSNZP02_BANK..NROD_FCT_HR_EMPLOYEE_LISTING_BW_HIST_UNSECURED_V

SDSNZP05_BANK..CBA_FCT_HR_EMPLOYEE_LISTING_BW_HIST_UNSECURED_V

SDSNZP05_BANK..NROD_FCT_HR_EMPLOYEE_LISTING_BW_HIST_UNSECURED_V

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