DIM_CI_RECOVERY_RESPONSIBLE_PARTY_INSURER

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CONTACT_ID BIGINT 8
3 INSURED_ID BIGINT 8
4 ADDRESS_ID BIGINT 8
5 TITLE CHARACTER VARYING(256) 256
6 FIRSTNAME CHARACTER VARYING(90) 90
7 LASTNAME CHARACTER VARYING(90) 90
8 WORKPHONE CHARACTER VARYING(24) 24
9 HOMEPHONE CHARACTER VARYING(30) 30
10 MOBILE CHARACTER VARYING(30) 30
11 EMAILADDRESS CHARACTER VARYING(60) 60
12 NAME CHARACTER VARYING(120) 120
13 PRIMARY_LEGAL_REP_ABN CHARACTER VARYING(30) 30
14 CONTACT_NAME CHARACTER VARYING(181) 181