INT_PI_HOME_ASSESSMENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_ASSESSMENTSOURCE_ID BIGINT 8
2 CCR_CC_INCIDENT_CLAIMID BIGINT 8
3 ASSESSMENT_ASSIGNED_DATE TIMESTAMP 8
4 ASSESSMENT_COMPLETE_DATE TIMESTAMP 8
5 ASSESSMENT_CLOSED_DATE TIMESTAMP 8
6 ASSESSMENT_RAISED_DATE TIMESTAMP 8
7 ASSESSMENT_RECEIVED_DATE TIMESTAMP 8
8 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSENDDT TIMESTAMP 8
9 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSREQUIREDBYDT TIMESTAMP 8
10 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSSTARTDT TIMESTAMP 8
11 CCR_CC_ASSESSMENTSOURCE_SC_COLLECTEXCESSIND CHARACTER VARYING(1) 1
12 CCR_CC_ASSESSMENTSOURCE_SC_ESTIMATECOMPLETEDATE TIMESTAMP 8
13 CCR_CC_ASSESSMENTSOURCE_ASSESSORID BIGINT 8
14 CCR_CC_ASSESSMENTSOURCE_INCIDENTID BIGINT 8
15 CCR_CC_ASSESSMENTSOURCE_SC_ACTION BIGINT 8
16 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSATRISKADDRESS CHARACTER VARYING(1) 1
17 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSCANCELREASON BIGINT 8
18 CCR_CC_ASSESSMENTSOURCE_SC_ASSESSSOURCESUBTYPE BIGINT 8
19 CCR_CC_ASSESSMENTSOURCE_SC_GROUPID BIGINT 8
20 CCR_CC_ASSESSMENTSOURCE_SC_JOBNUMBEREXTERNAL CHARACTER VARYING(255) 255
21 CCR_CC_ASSESSMENTSOURCE_SC_JOBSTATUSEXTERNAL CHARACTER VARYING(255) 255
22 CCR_CC_ASSESSMENTSOURCE_SC_USERID BIGINT 8
23 CCR_CC_CONTACT_ID BIGINT 8
24 CCR_CC_CONTACT_NAMEDENORM CHARACTER VARYING(120) 120
25 CCR_CC_CONTACT_SC_USERNAME CHARACTER VARYING(30) 30
26 CCR_CCTL_ASSESSMENTEVENT_NAME CHARACTER VARYING(256) 256
27 CCR_CCTL_SC_ASSESSSOURCETYPE_NAME CHARACTER VARYING(256) 256
28 ASSESSMENT_CATEGORY CHARACTER VARYING(11) 11
29 ASSESSOR_NAME CHARACTER VARYING(181) 181
30 CONTACT_TIMELINESS_FLAG INTEGER 4
31 INITIAL_LOSS_ASSESSMENT_FLAG SMALLINT 2
32 ASSESSMENT_COUNT SMALLINT 2
33 WORKING_HOURS_TO_CONTACT NUMERIC(25,6) 19