FCT_PI_HOME_WORKLOAD_INSIGHT_TWB

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_DATE TIMESTAMP 8
2 REPORT_GROUP CHARACTER VARYING(60) 60
3 BRAND_NAME CHARACTER VARYING(256) 256
4 OPERATIONAL_LOB CHARACTER VARYING(16) 16
5 EVENT_NAME CHARACTER VARYING(256) 256
6 LOSS_CAUSE CHARACTER VARYING(256) 256
7 JOB_SIZE CHARACTER VARYING(40) 40
8 SUBLOSS_GROUP CHARACTER VARYING(18) 18
9 CLAIM_TYPE CHARACTER VARYING(256) 256
10 RECTIFICATION_FLAG CHARACTER VARYING(3) 3
11 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
12 MOULD_FLAG CHARACTER VARYING(256) 256
13 ASBESTOS_FLAG CHARACTER VARYING(256) 256
14 RISK_STATE_NAME CHARACTER VARYING(256) 256
15 RISK_ZONE_NAME CHARACTER VARYING(255) 255
16 RISK_POSTCODE CHARACTER VARYING(60) 60
17 EXPOSURE_TYPE CHARACTER VARYING(8) 8
18 VENDOR_NAME CHARACTER VARYING(255) 255
19 VENDOR_CATEGORY CHARACTER VARYING(10) 10
20 ASSESSMENT_TYPE CHARACTER VARYING(256) 256
21 EXCEPTION_STATUS CHARACTER VARYING(256) 256
22 JOB_TYPE CHARACTER VARYING(256) 256
23 STATUS_GROUP CHARACTER VARYING(256) 256
24 CLAIM_NUMBER CHARACTER VARYING(40) 40
25 JOB_NUMBER BIGINT 8
26 QUOTE_NUMBER CHARACTER VARYING(20) 20
27 JOB_FULFILLMENT_PATH CHARACTER VARYING(256) 256
28 JOB_COUNT NUMERIC(38,2) 19
29 JOB_LIFE NUMERIC(38,2) 19
30 JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
31 JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
32 MAKE_SAFE_OUTSTANDING_JOB_COUNT NUMERIC(38,2) 19
33 MAKE_SAFE_COMPLETED_JOB_COUNT NUMERIC(38,2) 19
34 MAKE_SAFE_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
35 MAKE_SAFE_OUTSTANDING_JOB_LIFE NUMERIC(38,2) 19
36 MAKE_SAFE_COMPLETED_JOB_LIFE NUMERIC(38,2) 19
37 MAKE_SAFE_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
38 MAKE_SAFE_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
39 ASSESS_REPORT_PENDING_JOB_COUNT NUMERIC(38,2) 19
40 ASSESS_REPORT_SUBMITTED_JOB_COUNT NUMERIC(38,2) 19
41 ASSESS_REPORT_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
42 ASSESS_REPORT_PENDING_JOB_LIFE NUMERIC(38,2) 19
43 ASSESS_REPORT_SUBMITTED_JOB_LIFE NUMERIC(38,2) 19
44 ASSESS_REPORT_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
45 ASSESS_REPORT_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
46 ASSESS_REPORT_AUTHORISED_OUTSTANDING_JOB_COUNT NUMERIC(38,2) 19
47 ASSESS_REPORT_AUTHORISED_COMPLETED_JOB_COUNT NUMERIC(38,2) 19
48 ASSESS_REPORT_AUTHORISED_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
49 ASSESS_REPORT_AUTHORISED_OUTSTANDING_JOB_LIFE NUMERIC(38,2) 19
50 ASSESS_REPORT_AUTHORISED_COMPLETED_JOB_LIFE NUMERIC(38,2) 19
51 ASSESS_REPORT_AUTHORISED_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
52 ASSESS_REPORT_AUTHORISED_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
53 DO_CHARGE_OUTSTANDING_JOB_COUNT NUMERIC(38,2) 19
54 DO_CHARGE_COMPLETED_JOB_COUNT NUMERIC(38,2) 19
55 DO_CHARGE_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
56 DO_CHARGE_OUTSTANDING_JOB_LIFE NUMERIC(38,2) 19
57 DO_CHARGE_COMPLETED_JOB_LIFE NUMERIC(38,2) 19
58 DO_CHARGE_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
59 DO_CHARGE_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
60 QUOTES_PENDING_JOB_COUNT NUMERIC(38,2) 19
61 QUOTES_SUBMITTED_JOB_COUNT NUMERIC(38,2) 19
62 QUOTES_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
63 QUOTES_PENDING_JOB_LIFE NUMERIC(38,2) 19
64 QUOTES_SUBMITTED_JOB_LIFE NUMERIC(38,2) 19
65 QUOTES_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
66 QUOTES_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19
67 QUOTES_AUTHORISED_OUTSTANDING_JOB_COUNT NUMERIC(38,2) 19
68 QUOTES_AUTHORISED_COMPLETED_JOB_COUNT NUMERIC(38,2) 19
69 QUOTES_AUTHORISED_EXCEPTION_JOB_COUNT NUMERIC(38,2) 19
70 QUOTES_AUTHORISED_OUTSTANDING_JOB_LIFE NUMERIC(38,2) 19
71 QUOTES_AUTHORISED_COMPLETED_JOB_LIFE NUMERIC(38,2) 19
72 QUOTES_AUTHORISED_JOB_ESTIMATE_AMOUNT NUMERIC(38,2) 19
73 QUOTES_AUTHORISED_JOB_ESTIMATE_COUNT NUMERIC(38,0) 19