INT_PI_HOME_JOB

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CCX_SC_JOB_ID BIGINT 8
2 CCR_CCX_SC_JOB_ACTUALCOMPLETIONDATE TIMESTAMP 8
3 CCR_CCX_SC_JOB_JOBAPPROVEDDATE TIMESTAMP 8
4 CCR_CCX_SC_JOB_AUTHISSUED TIMESTAMP 8
5 CCR_CCX_SC_JOB_CLAIMID BIGINT 8
6 CCR_CCX_SC_JOB_CREATETIME TIMESTAMP 8
7 CCR_CCX_SC_JOB_ESTIMATEDAMOUNT NUMERIC(18,2) 19
8 CCR_CCX_SC_JOB_MAKESAFE CHARACTER VARYING(1) 1
9 CCR_CCX_SC_JOB_SC_AUTHORISEDAMOUNT NUMERIC(18,2) 19
10 CCR_CCX_SC_JOB_SC_RECTIFICATIONJOB CHARACTER VARYING(1) 1
11 CCR_CCX_SC_JOB_BLDGITEMSEST NUMERIC(18,2) 19
12 CCR_CCX_SC_JOB_UPDATETIME TIMESTAMP 8
13 CCR_CCX_SC_JOB_SETTLEMENTESTIMATEPROVIDER BIGINT 8
14 CCR_CC_CONTACT_ID BIGINT 8
15 CCR_CC_CONTACT_NAMEDENORM CHARACTER VARYING(120) 120
16 CCR_CC_CONTACT_SC_PAYMENTSERVICEVENDORID CHARACTER VARYING(10) 10
17 CCR_CCX_SC_JOB_SC_RECTIFICATIONVENDORID BIGINT 8
18 CCR_CC_CONTACT_SC_PAYMENTSERVICEVENDORID_REC CHARACTER VARYING(10) 10
19 CCR_CCX_SC_JOB_CHECKPAYAPPLICATION BIGINT 8
20 CCR_CCX_SC_JOB_EXPOSUREID BIGINT 8
21 CCR_CCX_SC_JOB_EXPOSURETYPE BIGINT 8
22 CCR_CCX_SC_JOB_FULFILMENTPATH BIGINT 8
23 CCR_CCX_SC_JOB_JOBSTATUS BIGINT 8
24 CCR_CCX_SC_JOB_QUOTENUMBER BIGINT 8
25 CCR_CCX_SC_JOB_SC_CASHSETTLELIABILITY BIGINT 8
26 CCR_CCX_SC_JOB_SC_QUOTETYPE BIGINT 8
27 CCR_CCX_SC_JOB_SC_VENDORTRADETYPE BIGINT 8
28 CCR_CCX_SC_JOB_SC_REPAIRORSUPPLY BIGINT 8
29 HOME_ASSIST_FLAG CHARACTER VARYING(1) 1
30 VENDOR_NAME_ON_JOB CHARACTER VARYING(180) 180
31 CONTACT_VENDOR_TRADE_TYPE CHARACTER VARYING(10) 10
32 VENDOR_NAME_REALIGNED CHARACTER VARYING(180) 180
33 FINAL_CONTACT_NAME CHARACTER VARYING(181) 181
34 ORIGINAL_VENDOR_NAME CHARACTER VARYING(180) 180
35 JOB_COUNT SMALLINT 2
36 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
37 CCR_CC_CONTACT_SC_PAYMENTSERVICEVENDORID_SEP CHARACTER VARYING(10) 10