FCT_CFO_HR_FTE_INSIGHT_330_BK1709

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

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 HOME_ADDRESSLINE1 CHARACTER VARYING(255) 255
53 HOME_ADDRESSLINE2 CHARACTER VARYING(255) 255
54 HOME_ADDRESSLINE3 CHARACTER VARYING(255) 255
55 HOME_SUBURB CHARACTER VARYING(200) 200
56 HOME_STATE CHARACTER VARYING(5) 5
57 HOME_POSTCODE CHARACTER VARYING(200) 200
58 HOME_COUNTRY CHARACTER VARYING(3) 3
59 EMAIL_ADDRESS CHARACTER VARYING(128) 128
60 LEADER_PAYROLL_NUMBER CHARACTER VARYING(50) 50
61 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
62 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
63 LEADER_PREFERRED_FIRST_NAME CHARACTER VARYING(100) 100
64 LEADER_SURNAME CHARACTER VARYING(100) 100
65 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
66 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
67 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
68 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
69 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
70 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
71 PAYROLL_STATUS_DESCRIPTION CHARACTER VARYING(128) 128
72 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
73 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
74 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
75 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
76 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
77 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100