FCT_CFO_HR_FTE_INSIGHT_330

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LEVEL_01_CODE CHARACTER VARYING(150) 150
2 LEVEL_01_NAME CHARACTER VARYING(240) 240
3 LEVEL_02_CODE CHARACTER VARYING(150) 150
4 LEVEL_02_NAME CHARACTER VARYING(240) 240
5 LEVEL_03_CODE CHARACTER VARYING(150) 150
6 LEVEL_03_NAME CHARACTER VARYING(240) 240
7 LEVEL_04_CODE CHARACTER VARYING(150) 150
8 LEVEL_04_NAME CHARACTER VARYING(240) 240
9 LEVEL_05_CODE CHARACTER VARYING(150) 150
10 LEVEL_05_NAME CHARACTER VARYING(240) 240
11 LEVEL_06_CODE CHARACTER VARYING(150) 150
12 LEVEL_06_NAME CHARACTER VARYING(240) 240
13 LEVEL_07_CODE CHARACTER VARYING(150) 150
14 LEVEL_07_NAME CHARACTER VARYING(240) 240
15 LEVEL_08_CODE CHARACTER VARYING(150) 150
16 LEVEL_08_NAME CHARACTER VARYING(240) 240
17 LEVEL_09_CODE CHARACTER VARYING(150) 150
18 LEVEL_09_NAME CHARACTER VARYING(240) 240
19 LEVEL_10_CODE CHARACTER VARYING(150) 150
20 LEVEL_10_NAME CHARACTER VARYING(240) 240
21 USERID CHARACTER VARYING(50) 50
22 FIRST_NAME CHARACTER VARYING(100) 100
23 LAST_NAME CHARACTER VARYING(100) 100
24 REPORTING_MONTH CHARACTER VARYING(200) 200
25 PERIOD CHARACTER VARYING(200) 200
26 CAL_MONTH INTEGER 4
27 FIN_MONTH INTEGER 4
28 CAL_YEAR INTEGER 4
29 FIN_YEAR BIGINT 8
30 EMPLOYEE_GROUP_CODE CHARACTER VARYING(10) 10
31 EMPLOYEE_GROUP_NAME CHARACTER VARYING(50) 50
32 EMPLOYEE_CLASS_CODE CHARACTER VARYING(24) 24
33 EMPLOYEE_CLASS_NAME CHARACTER VARYING(266) 266
34 COST_CENTRE_CODE CHARACTER VARYING(100) 100
35 EMPLOYEE_FTE_MTH NUMERIC(7,6) 19
36 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
37 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
38 DIVISION_CODE CHARACTER VARYING(100) 100
39 DIVISION_NAME CHARACTER VARYING(100) 100
40 DEPARTMENT_CODE CHARACTER VARYING(100) 100
41 DEPARTMENT_NAME CHARACTER VARYING(100) 100
42 SECTION_CODE CHARACTER VARYING(100) 100
43 SECTION_NAME CHARACTER VARYING(100) 100
44 TEAM_CODE CHARACTER VARYING(100) 100
45 TEAM_NAME CHARACTER VARYING(100) 100
46 HIRE_DATE TIMESTAMP 8
47 END_DATE TIMESTAMP 8
48 WORK_ADDRESS CHARACTER VARYING(767) 767
49 WORK_CITY CHARACTER VARYING(50) 50
50 WORK_STATECODE CHARACTER VARYING(5) 5
51 WORK_POSTCODE CHARACTER VARYING(12) 12
52 EMAIL_ADDRESS CHARACTER VARYING(128) 128
53 LEADER_PAYROLL_NUMBER CHARACTER VARYING(50) 50
54 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
55 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
56 LEADER_PREFERRED_FIRST_NAME CHARACTER VARYING(100) 100
57 LEADER_SURNAME CHARACTER VARYING(100) 100
58 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
59 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
60 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
61 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
62 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
63 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
64 PAYROLL_STATUS_DESCRIPTION CHARACTER VARYING(128) 128
65 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
66 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
67 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
68 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
69 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
70 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100