INT_CI_CLAIM_CONTACT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_CONTACT_CLAIM_ID BIGINT 8
2 CLAIM_CONTACT_ABN_NUMBER CHARACTER VARYING(30) 30
3 PROVIDER_NUMBER CHARACTER VARYING(30) 30
4 DEPENDENT_UNIQUE_NUMBER BIGINT 8
5 CLAIMANT_FLAG INTEGER 4
6 CONTACT_PROHIBITED_FLAG INTEGER 4
7 DEPENDENT_COUNT NUMERIC(38,0) 19
8 DEPENDENT_TYPE_FLAG INTEGER 4
9 CHILD_DEPENDENT_COUNT NUMERIC(38,0) 19
10 ADULT_DEPENDENT_COUNT NUMERIC(38,0) 19
11 PREFERRED_CONTACT_FLAG INTEGER 4
12 AUTHORISED_PARTY_FLAG INTEGER 4
13 VENDORS_SMS_SEND_FLAG INTEGER 4
14 CONTACT_BIRTH_DATE TIMESTAMP 8
15 CONTACT_BIRTH_DATE_ID INTEGER 4
16 CLAIM_CONTACT_UPDATE_TIME TIMESTAMP 8
17 CLAIM_CONTACT_UPDATE_TIME_ID INTEGER 4
18 CLAIM_CONTACT_CREATE_TIME TIMESTAMP 8
19 CLAIM_CONTACT_CREATE_TIME_ID INTEGER 4
20 CLAIM_CONTACT_UPDATE_USER_ID BIGINT 8
21 CLAIM_CONTACT_CREATE_USER_ID BIGINT 8
22 CONTACT_UPDATE_TIME TIMESTAMP 8
23 CONTACT_UPDATE_TIME_ID INTEGER 4
24 CONTACT_CREATE_TIME TIMESTAMP 8
25 CONTACT_CREATE_TIME_ID INTEGER 4
26 CONTACT_UPDATE_USER_ID BIGINT 8
27 CONTACT_CREATE_USER_ID BIGINT 8
28 GENDER_ID BIGINT 8
29 CONTACT_ROLE_ID BIGINT 8
30 CLAIMCONTACTID BIGINT 8
31 ROLE BIGINT 8
32 BIRTH_COUNTRY_ID BIGINT 8
33 MARITAL_STATUS_ID BIGINT 8
34 DEPENDENT_FULL_TIME_STUDENT_TYPE_ID BIGINT 8
35 DEPENDENT_TYPE_ID BIGINT 8
36 DEPENDENT_RESIDING_AT_HOME_TYPE_ID BIGINT 8
37 DEPENDENT_WORKING_SPOUSE_TYPE_ID BIGINT 8
38 CONTACT_PAYMENT_METHOD_ID BIGINT 8
39 CONTACT_PAYMENT_TERMS_ID BIGINT 8
40 CLAIM_CONTACT_CONTACT_ID BIGINT 8
41 CONTACT_HOME_PHONE CHARACTER VARYING(30) 30
42 CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
43 CONTACT_LAST_NAME CHARACTER VARYING(90) 90
44 CONTACT_PREFIX BIGINT 8
45 NAME CHARACTER VARYING(120) 120
46 CLAIM_CONTACT_ORGANISATION_FLAG INTEGER 4
47 CONTACT_NAME CHARACTER VARYING(181) 181
48 CLAIM_CONTACT_NAME CHARACTER VARYING(181) 181
49 CLAIM_CONTACT_ID BIGINT 8
50 DEPENDENCY_PERCENT BIGINT 8
51 CLAIM_CONTACT_AGE NUMERIC(9,0) 19
52 CLAIM_CONTACT_AGE_BAND CHARACTER VARYING(12) 12
53 CLAIM_CONTACT_MATTER_ID BIGINT 8
54 CLAIM_CONTACT_NEGOTIATION_ID BIGINT 8
55 CLAIM_CONTACT_EXPOSURE_ID BIGINT 8
56 CLAIM_CONTACT_POLICY_ID BIGINT 8
57 CLAIM_CONTACT_INCIDENT_ID BIGINT 8
58 CC_CLAIMCONTACT_ID BIGINT 8
59 CLAIM_POLICY_ID BIGINT 8