INT_CLAIM_INTERMEDIARY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 CCR_CC_CLAIMCONTACT_CLAIMID BIGINT 8
3 POLICY_INTERMEDIARY_BROKER_ID BIGINT 8
4 POLICY_INTERMEDIARY_AGENT_ID BIGINT 8
5 POLICY_INTERMEDIARY_CORPAGENT_ID BIGINT 8
6 POLICY_INTERMEDIARY_BROKER_NAME CHARACTER VARYING(120) 120
7 POLICY_INTERMEDIARY_AGENT_NAME CHARACTER VARYING(120) 120
8 POLICY_INTERMEDIARY_CORPAGENT_NAME CHARACTER VARYING(120) 120
9 POLICY_INTERMEDIARY_BROKER_SC_SYSTEMCUSTOMERID CHARACTER VARYING(40) 40
10 POLICY_INTERMEDIARY_AGENT_SC_SYSTEMCUSTOMERID CHARACTER VARYING(40) 40
11 POLICY_INTERMEDIARY_CORPAGENT_SC_SYSTEMCUSTOMERID CHARACTER VARYING(40) 40
12 FLEETMANAGER_NAME CHARACTER VARYING(181) 181
13 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120