FCT_EMP_CATEGORISED_METRICS

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_HEADER_ID BIGINT 8
2 LINES_LAST_UPDATE_DATE DATE 4
3 LINES_LAST_UPDATED_BY BIGINT 8
4 LINES_CODE_COMBINATION_ID BIGINT 8
5 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
6 EXPENSE_LINE_AMOUNT NUMERIC(18,6) 19
7 AVERAGE_COST_PER_ATTENDEE NUMERIC(37,25) 19
8 SET_OF_BOOKS_ID BIGINT 8
9 ATTRIBUTE_CATEGORY CHARACTER VARYING(80) 80
10 ATTRIBUTE1 CHARACTER VARYING(150) 150
11 CURRENCY_CODE CHARACTER VARYING(15) 15
12 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
13 EXCHANGE_RATE NUMERIC(18,6) 19
14 EXCHANGE_DATE DATE 4
15 VAT_CODE CHARACTER VARYING(30) 30
16 LINE_TYPE_LOOKUP_CODE CHARACTER VARYING(25) 25
17 LAST_UPDATE_LOGIN BIGINT 8
18 APPROVED_DATE TIMESTAMP 8
19 CREATION_DATE DATE 4
20 CREATED_BY BIGINT 8
21 DISTRIBUTION_LINE_NUMBER BIGINT 8
22 ORG_ID BIGINT 8
23 RECEIPT_VERIFIED_FLAG CHARACTER VARYING(1) 1
24 JUSTIFICATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
25 RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
26 RECEIPT_MISSING_FLAG CHARACTER VARYING(1) 1
27 JUSTIFICATION CHARACTER VARYING(240) 240
28 START_EXPENSE_DATE DATE 4
29 END_EXPENSE_DATE DATE 4
30 RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
31 RECEIPT_CONVERSION_RATE NUMERIC(18,6) 19
32 DAILY_AMOUNT NUMERIC(18,6) 19
33 RECEIPT_CURRENCY_AMOUNT NUMERIC(18,6) 19
34 WEB_PARAMETER_ID BIGINT 8
35 AMOUNT_INCLUDES_TAX_FLAG CHARACTER VARYING(1) 1
36 TAX_CODE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
37 TAX_CODE_ID BIGINT 8
38 CREDIT_CARD_TRX_ID BIGINT 8
39 COMPANY_PREPAID_INVOICE_ID BIGINT 8
40 LOCATION_ID BIGINT 8
41 ATTENDEES CHARACTER VARYING(240) 240
42 NUMBER_ATTENDEES BIGINT 8
43 TICKET_CLASS_CODE CHARACTER VARYING(30) 30
44 TICKET_NUMBER CHARACTER VARYING(80) 80
45 ITEMIZATION_PARENT_ID BIGINT 8
46 FLEX_CONCATENATED CHARACTER VARYING(240) 240
47 LOCATION CHARACTER VARYING(80) 80
48 CATEGORY_CODE CHARACTER VARYING(30) 30
49 ADJUSTMENT_REASON_CODE CHARACTER VARYING(30) 30
50 AP_VALIDATION_ERROR CHARACTER VARYING(240) 240
51 SUBMITTED_AMOUNT NUMERIC(18,6) 19
52 REPORT_LINE_ID BIGINT 8
53 ALLOCATION_REASON CHARACTER VARYING(240) 240
54 ALLOCATION_SPLIT_CODE CHARACTER VARYING(30) 30
55 IMAGE_RECEIPT_REQUIRED_FLAG CHARACTER VARYING(1) 1
56 TRX_ID BIGINT 8
57 VALIDATE_CODE CHARACTER VARYING(25) 25
58 CARD_PROGRAM_ID BIGINT 8
59 EXPENSED_AMOUNT NUMERIC(18,6) 19
60 REFERENCE_NUMBER CHARACTER VARYING(240) 240
61 TRANSACTION_TYPE CHARACTER VARYING(80) 80
62 TRANSACTION_DATE TIMESTAMP 8
63 TRANSACTION_AMOUNT NUMERIC(18,6) 19
64 DEBIT_FLAG CHARACTER VARYING(1) 1
65 BILLED_DATE TIMESTAMP 8
66 BILLED_AMOUNT NUMERIC(18,6) 19
67 BILLED_DECIMAL BIGINT 8
68 BILLED_CURRENCY_CODE CHARACTER VARYING(15) 15
69 POSTED_DATE TIMESTAMP 8
70 POSTED_AMOUNT NUMERIC(18,6) 19
71 POSTED_DECIMAL BIGINT 8
72 POSTED_CURRENCY_CODE CHARACTER VARYING(15) 15
73 CURRENCY_CONVERSION_EXPONENT BIGINT 8
74 CURRENCY_CONVERSION_RATE NUMERIC(18,6) 19
75 MIS_INDUSTRY_CODE CHARACTER VARYING(80) 80
76 SIC_CODE BIGINT 8
77 MERCHANT_NAME1 CHARACTER VARYING(240) 240
78 MERCHANT_NAME2 CHARACTER VARYING(80) 80
79 MERCHANT_ADDRESS1 CHARACTER VARYING(80) 80
80 MERCHANT_ADDRESS2 CHARACTER VARYING(80) 80
81 MERCHANT_ADDRESS3 CHARACTER VARYING(80) 80
82 MERCHANT_ADDRESS4 CHARACTER VARYING(80) 80
83 MERCHANT_CITY CHARACTER VARYING(80) 80
84 MERCHANT_PROVINCE_STATE CHARACTER VARYING(80) 80
85 MERCHANT_POSTAL_CODE CHARACTER VARYING(80) 80
86 MERCHANT_COUNTRY CHARACTER VARYING(80) 80
87 TOTAL_TAX NUMERIC(18,6) 19
88 LOCAL_TAX NUMERIC(18,6) 19
89 CREDIT_CARD_TRXN_LAST_UPDATE_DATE TIMESTAMP 8
90 CREDIT_CARD_TRXN_LAST_UPDATED_BY BIGINT 8
91 CREDIT_CARD_TRXN_LAST_UPDATE_LOGIN BIGINT 8
92 CREDIT_CARD_TRXN_CREATION_DATE TIMESTAMP 8
93 CREDIT_CARD_TRXN_CREATED_BY BIGINT 8
94 FOLIO_TYPE CHARACTER VARYING(80) 80
95 ATM_CASH_ADVANCE NUMERIC(18,6) 19
96 ATM_TRANSACTION_DATE TIMESTAMP 8
97 ATM_FEE_AMOUNT NUMERIC(18,6) 19
98 ATM_TYPE CHARACTER VARYING(80) 80
99 ATM_ID CHARACTER VARYING(80) 80
100 ATM_NETWORK_ID CHARACTER VARYING(80) 80
101 RESTAURANT_TIP_AMOUNT NUMERIC(18,6) 19
102 CAR_RENTAL_DATE TIMESTAMP 8
103 CAR_RETURN_DATE TIMESTAMP 8
104 CAR_RENTAL_LOCATION CHARACTER VARYING(80) 80
105 CAR_RENTAL_STATE CHARACTER VARYING(80) 80
106 CAR_RETURN_LOCATION CHARACTER VARYING(80) 80
107 CAR_RETURN_STATE CHARACTER VARYING(80) 80
108 CAR_RENTER_NAME CHARACTER VARYING(240) 240
109 CAR_RENTAL_DAYS CHARACTER VARYING(80) 80
110 CAR_RENTAL_AGREEMENT_NUMBER CHARACTER VARYING(80) 80
111 CAR_MILEAGE_AMOUNT NUMERIC(18,6) 19
112 CAR_DAILY_RATE NUMERIC(18,6) 19
113 HOTEL_ARRIVAL_DATE TIMESTAMP 8
114 HOTEL_DEPART_DATE TIMESTAMP 8
115 HOTEL_CHARGE_DESC CHARACTER VARYING(80) 80
116 HOTEL_GUEST_NAME CHARACTER VARYING(80) 80
117 HOTEL_STAY_DURATION NUMERIC(18,6) 19
118 HOTEL_ROOM_RATE NUMERIC(18,6) 19
119 HOTEL_HEALTH_AMOUNT NUMERIC(18,6) 19
120 HOTEL_RESTAURANT_AMOUNT NUMERIC(18,6) 19
121 HOTEL_STATE CHARACTER VARYING(80) 80
122 AIR_DEPARTURE_DATE TIMESTAMP 8
123 AIR_DEPARTURE_CITY CHARACTER VARYING(80) 80
124 AIR_ROUTING CHARACTER VARYING(80) 80
125 AIR_SERVICE_CLASS CHARACTER VARYING(80) 80
126 AIR_CARRIER_CODE CHARACTER VARYING(80) 80
127 AIR_TICKET_ISSUER CHARACTER VARYING(240) 240
128 AIR_ISSUER_CITY CHARACTER VARYING(80) 80
129 AIR_PASSENGER_NAME CHARACTER VARYING(80) 80
130 AIR_TICKET_NUMBER CHARACTER VARYING(80) 80
131 FINANCIAL_CATEGORY CHARACTER VARYING(80) 80
132 PAYMENT_FLAG CHARACTER VARYING(1) 1
133 CATEGORY CHARACTER VARYING(30) 30
134 EXPENSE_STATUS CHARACTER VARYING(30) 30
135 CC_COMPANY_PREPAID_INVOICE_ID BIGINT 8
136 CC_REQUEST_ID BIGINT 8
137 DISPUTE_DATE TIMESTAMP 8
138 PAYMENT_DUE_FROM_CODE CHARACTER VARYING(30) 30
139 TRX_AVAILABLE_DATE TIMESTAMP 8
140 CARD_ACCEPTOR_ID BIGINT 8
141 TRXN_DETAIL_FLAG CHARACTER VARYING(1) 1
142 DESCRIPTION CHARACTER VARYING(240) 240
143 CARD_ID BIGINT 8
144 VALIDATE_REQUEST_ID CHARACTER VARYING(50) 50
145 DEVICE_DOWNLOAD_FLAG CHARACTER VARYING(10) 10
146 CLAIM_TYPE CHARACTER VARYING(4) 4
147 REPORT_DISTRIBUTION_ID BIGINT 8
148 SEQUENCE_NUM BIGINT 8
149 EXP_DISTRIBUTIONS_LAST_UPDATE_DATE TIMESTAMP 8
150 EXP_DISTRIBUTIONS_LAST_UPDATED_BY BIGINT 8
151 EXP_DISTRIBUTIONS_CREATION_DATE TIMESTAMP 8
152 EXP_DISTRIBUTIONS_CREATED_BY BIGINT 8
153 EXP_DISTRIBUTIONS_LAST_UPDATE_LOGIN BIGINT 8
154 CODE_COMBINATION_ID BIGINT 8
155 SEGMENT1 CHARACTER VARYING(25) 25
156 SEGMENT2 CHARACTER VARYING(25) 25
157 SEGMENT3 CHARACTER VARYING(25) 25
158 PREPARER_MODIFIED_FLAG CHARACTER VARYING(1) 1
159 DISTRIBUTED_AMOUNT NUMERIC(18,6) 19
160 REIMBURSEMENT_TYPE CHARACTER VARYING(4) 4
161 COST_CENTER CHARACTER VARYING(25) 25
162 ACCOUNT_CODE CHARACTER VARYING(25) 25
163 EXP_DISTRIBUTIONS_CATEGORY_CODE CHARACTER VARYING(25) 25
164 EXP_DISTRIBUTIONS_RECEIPT_CURRENCY_CODE CHARACTER VARYING(15) 15
165 EXP_DISTRIBUTIONS_RECEIPT_CONVERSION_RATE NUMERIC(18,6) 19
166 EXP_DISTRIBUTIONS_RECEIPT_CURRENCY_AMOUNT NUMERIC(18,6) 19
167 EXP_DISTRIBUTIONS_WEB_PARAMETER_ID BIGINT 8
168 EMPLOYEE_NUMBER CHARACTER VARYING(40) 40
169 DERIVED_CAT1 CHARACTER VARYING(16) 16
170 ITEM_JUSTIFICATION_CAT CHARACTER VARYING(481) 481
171 DERIVED_CAT2 CHARACTER VARYING(81) 81
172 DERIVED_CAT3 CHARACTER VARYING(81) 81
173 CATEGORY_L2 CHARACTER VARYING(20) 20
174 CATEGORY_L1 CHARACTER VARYING(18) 18
175 EMP_TOTAL_OUTSTANDING_AMT NUMERIC(38,6) 19
176 EMP_NUMBER_OUTSTANDING_TXNS BIGINT 8
177 EMP_OLDEST_OUTSTANDING_MONTH TIMESTAMP 8
178 DUPLICATE_LINE_ID BIGINT 8
179 ALLOCATION_ID BIGINT 8
180 REVIEW_REASON CHARACTER VARYING(35) 35
181 MERCHANT_NAME CHARACTER VARYING(240) 240
182 EXPENSE_CLAIM_STATUS CHARACTER VARYING(30) 30
183 EMPLOYEE_NAME CHARACTER VARYING(201) 201
184 HIRE_DATE TIMESTAMP 8
185 TERMINATIONDATE TIMESTAMP 8
186 IS_TERMINATED_CURRENT_FISCAL_YEAR CHARACTER VARYING(1) 1
187 IS_TERMINATED_LAST_12_MONTHS CHARACTER VARYING(1) 1
188 TENURE_COMPLETED_YRS NUMERIC(10,1) 19
189 TERMINATED_FLAG CHARACTER VARYING(10) 10
190 EMPLOYEE_HRS_PER_WEEK NUMERIC(6,2) 19
191 PAYROLL_STATUS_CODE CHARACTER VARYING(50) 50
192 PAYROLL_STATUS_NAME CHARACTER VARYING(128) 128
193 POSITIONID INTEGER 4
194 POSITION_NUMBER CHARACTER VARYING(100) 100
195 POSITION_TITLE CHARACTER VARYING(256) 256
196 POSITION_FTE NUMERIC(18,2) 19
197 POSITION_LEVEL_OF_WORK INTEGER 4
198 LEADER_PROFILE_ID INTEGER 4
199 LEADER_PROFILE_DESCRIPTION CHARACTER VARYING(128) 128
200 JOB_FAMILY_ID INTEGER 4
201 JOB_FAMILY_DESCRIPTION CHARACTER VARYING(30) 30
202 JOB_SUBFAMILY_ID INTEGER 4
203 JOB_SUBFAMILY_DESCRIPTION CHARACTER VARYING(40) 40
204 WORK_ADDRESS CHARACTER VARYING(767) 767
205 WORK_CITY CHARACTER VARYING(50) 50
206 WORK_STATECODE CHARACTER VARYING(5) 5
207 WORK_POSTCODE CHARACTER VARYING(12) 12
208 IPCNO CHARACTER VARYING(50) 50
209 POSITION_START_DATE TIMESTAMP 8
210 CURRENT_POSITION_END_DATE TIMESTAMP 8
211 CONTRACT_END_DATE TIMESTAMP 8
212 FULLPART_CODE CHARACTER VARYING(50) 50
213 FULLPART_DESCRIPTION CHARACTER VARYING(128) 128
214 ORGANISATIONAL_UNIT_ID BIGINT 8
215 ORGANISATIONAL_UNIT_LEVEL_NAME CHARACTER VARYING(100) 100
216 BUSINESS_UNIT_CODE CHARACTER VARYING(100) 100
217 BUSINESS_UNIT_NAME CHARACTER VARYING(100) 100
218 BUSINESS_UNIT_CODE_CASCADE CHARACTER VARYING(100) 100
219 BUSINESS_UNIT_LABEL_CASCADE CHARACTER VARYING(100) 100
220 DIVISION_CODE CHARACTER VARYING(100) 100
221 DIVISION_NAME CHARACTER VARYING(100) 100
222 DIVISION_CODE_CASCADE CHARACTER VARYING(100) 100
223 DIVISION_LABEL_CASCADE CHARACTER VARYING(100) 100
224 DEPARTMENT_CODE CHARACTER VARYING(100) 100
225 DEPARTMENT_NAME CHARACTER VARYING(100) 100
226 DEPARTMENT_CODE_CASCADE CHARACTER VARYING(100) 100
227 DEPARTMENT_LABEL_CASCADE CHARACTER VARYING(100) 100
228 SECTION_CODE CHARACTER VARYING(100) 100
229 SECTION_NAME CHARACTER VARYING(100) 100
230 SECTION_CODE_CASCADE CHARACTER VARYING(100) 100
231 SECTION_LABEL_CASCADE CHARACTER VARYING(100) 100
232 TEAM_CODE CHARACTER VARYING(100) 100
233 TEAM_NAME CHARACTER VARYING(100) 100
234 TEAM_CODE_CASCADE CHARACTER VARYING(100) 100
235 TEAM_LABEL_CASCADE CHARACTER VARYING(100) 100
236 DEPARTMENT_COST_CENTRE CHARACTER VARYING(100) 100
237 LEADER_FIRST_NAME CHARACTER VARYING(100) 100
238 LEADER_PREFERRED_NAME CHARACTER VARYING(100) 100
239 LEADER_SURNAME CHARACTER VARYING(100) 100
240 LEADER_REPORTING_NAME CHARACTER VARYING(255) 255
241 LEADER_POSITION_NUMBER CHARACTER VARYING(100) 100
242 LEADER_POSITION_TITLE CHARACTER VARYING(256) 256
243 LEADER_LEADER_PROFILE CHARACTER VARYING(128) 128
244 IS_LEADER CHARACTER VARYING(1) 1
245 HR_EFFECTIVE_DATE TIMESTAMP 8
246 BUSINESS_UNIT_LABEL_PATH CHARACTER VARYING(250) 250
247 DIVISION_LABEL_PATH CHARACTER VARYING(250) 250
248 DEPARTMENT_LABEL_PATH CHARACTER VARYING(250) 250
249 SECTION_LABEL_PATH CHARACTER VARYING(250) 250
250 TEAM_LABEL_PATH CHARACTER VARYING(250) 250
251 EXTENDED_UNPAID_ABSENCE_FLAG INTEGER 4
252 EXTERNAL_COMPANY CHARACTER VARYING(255) 255
253 HEADCOUNT_MTH INTEGER 4
254 TOTAL_FTE_MTH NUMERIC(38,6) 19
255 EMP_DUPE_ROW_NUM BIGINT 8
256 LOB_FTE_MTH_TOTAL NUMERIC(38,6) 19
257 DIV_FTE_MTH_TOTAL NUMERIC(38,6) 19
258 DEPT_FTE_MTH_TOTAL NUMERIC(38,6) 19
259 REQUIRES_REVIEW_FLAG INTEGER 4
260 ROW_ID BIGINT 8