FCT_PI_HOME_SUPPLIER_PERFORMANCE_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CLAIM_LOSS_DATE DATE 4
4 CLAIM_NUMBER CHARACTER VARYING(40) 40
5 CLAIM_STATE CHARACTER VARYING(256) 256
6 LOSS_GROUP CHARACTER VARYING(15) 15
7 OPERATIONAL_LOB CHARACTER VARYING(16) 16
8 RISK_REGION CHARACTER VARYING(8) 8
9 RISK_STATE CHARACTER VARYING(256) 256
10 SUBLOSS_GROUP CHARACTER VARYING(18) 18
11 MOULD_FLAG CHARACTER VARYING(256) 256
12 JOB_ID BIGINT 8
13 JOB_CREATE_DATE DATE 4
14 QUOTE_ID BIGINT 8
15 CASH_SETTLE_LIABILITY CHARACTER VARYING(256) 256
16 CATEGORY_TYPE CHARACTER VARYING(256) 256
17 CATEGORY_TYPE_GROUP CHARACTER VARYING(60) 60
18 CATEGORY_TYPE_FILTER CHARACTER VARYING(60) 60
19 CATEGORY_SUB_TYPE CHARACTER VARYING(60) 60
20 CLAIM_TYPE CHARACTER VARYING(256) 256
21 EXPOSURE_TYPE CHARACTER VARYING(256) 256
22 JOB_FULFILMENT_PATH CHARACTER VARYING(256) 256
23 JOB_PAYMENT_APPLICATION CHARACTER VARYING(256) 256
24 JOB_STATUS CHARACTER VARYING(256) 256
25 VENDOR_ID CHARACTER VARYING(10) 10
26 CHECK_ISSUED_DATE DATE 4
27 CHEQUE_PAY_TO CHARACTER VARYING(255) 255
28 FIRST_AUTHORITY_REQUESTED_DATE DATE 4
29 FIRST_JOB_REPORT_SUBMIT_DATE DATE 4
30 FIRST_JOB_REQUEST_SUBMIT_DATE DATE 4
31 FIRST_QUOTE_RECEIVED_DATE DATE 4
32 INVOICE_RECEIVED_DATE DATE 4
33 JOB_GROSS_AMOUNT NUMERIC(38,2) 19
34 JOB_MAKESAFE_FLAG CHARACTER VARYING(3) 3
35 JOB_RECTIFICATION_FLAG CHARACTER VARYING(3) 3
36 AUTHORITY_LIFE_DAYS INTEGER 4
37 AUTHORITY_LIFE_FLAG SMALLINT 2
38 SUPPLY_COST NUMERIC(18,2) 19
39 SUPPLY_COST_FLAG SMALLINT 2
40 RESTORABILITY_WIN SMALLINT 2
41 RESTORABILITY_LOSE SMALLINT 2
42 JOB_ASSESS_REPORT_REQUESTED INTEGER 4
43 JOB_QUOTES_REQUESTED INTEGER 4
44 JOB_DO_AND_CHARGE_AUTHORISED INTEGER 4
45 JOB_MAKESAFE_ALLOCATIONS INTEGER 4
46 JOB_MAKESAFE_COMPLETE INTEGER 4
47 JOB_MAKESAFE_OUTSTANDING INTEGER 4
48 ASSESSMENT_LIFE_DAYS INTEGER 4
49 ASSESSMENT_LIFE_FLAG SMALLINT 2
50 QUOTE_LIFE_DAYS INTEGER 4
51 QUOTE_LIFE_FLAG SMALLINT 2
52 QUOTE_WITHIN_SLA_WIN SMALLINT 2
53 QUOTE_WITHIN_SLA_LOSE SMALLINT 2
54 EVENT_NAME CHARACTER VARYING(256) 256