INT_WCOM_POLICY_ITEM_TERM_PROPOSAL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 POLICY INTEGER 4
3 QTEPRDUCT CHARACTER(3) 3
4 POLICY_DUE_DATE INTEGER 4
5 AGREEMENT_TYPE_CDC CHARACTER VARYING(3) 3
6 END_CONSENT CHARACTER(1) 1
7 LOCATNREF INTEGER 4
8 CPSTAFF_CURRENT CHARACTER VARYING(10) 10
9 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
10 WORKCOVER_NUMBER CHARACTER(15) 15
11 ACQUIRE_MEMBERSHIP_NUMBER CHARACTER(15) 15
12 PREV_INSURANCE_YEARS SMALLINT 2
13 CPBUSSRC CHARACTER VARYING(10) 10
14 UW_CODE CHARACTER(8) 8
15 AGTACCTYP_NB CHARACTER VARYING(10) 10
16 NUMBER_OF_LOCATIONS BIGINT 8