CCR_CC_POLICY_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REPORTINGDATE TIMESTAMP 8
2 SC_NUMOFINSTALMENTS BIGINT 8
3 INSUREDSICCODE CHARACTER VARYING(6) 6
4 CREATETIME TIMESTAMP 8
5 TOTALPROPERTIES BIGINT 8
6 UNDERWRITINGGROUP BIGINT 8
7 VERIFIED CHARACTER VARYING(1) 1
8 EFFECTIVEDATE TIMESTAMP 8
9 BEANVERSION BIGINT 8
10 SC_FINANCIALCOMPANY CHARACTER VARYING(20) 20
11 RETIRED BIGINT 8
12 RETURNTOWORKPRGM CHARACTER VARYING(1) 1
13 SC_PAYMENTMODE BIGINT 8
14 SC_BRAND BIGINT 8
15 PUBLICID CHARACTER VARYING(64) 64
16 RETROACTIVEDATE TIMESTAMP 8
17 FINANCIALINTERESTS CHARACTER VARYING(255) 255
18 POLICYSUFFIX CHARACTER VARYING(255) 255
19 SC_LEGACYNOOFCLAIMS BIGINT 8
20 POLICYNUMBER CHARACTER VARYING(40) 40
21 WCSTATES CHARACTER VARYING(255) 255
22 UPDATEUSERID BIGINT 8
23 POLICYTYPE BIGINT 8
24 ID BIGINT 8
25 STATUS BIGINT 8
26 POLICYSOURCE BIGINT 8
27 FOREIGNCOVERAGE CHARACTER VARYING(1) 1
28 POLICYRATINGPLAN BIGINT 8
29 LOADCOMMANDID BIGINT 8
30 PRODUCERCODE CHARACTER VARYING(255) 255
31 ORIGEFFECTIVEDATE TIMESTAMP 8
32 CREATEUSERID BIGINT 8
33 SC_INTERMEDTYPE BIGINT 8
34 UNDERWRITINGCO BIGINT 8
35 OTHERINSINFO CHARACTER VARYING(255) 255
36 SC_CHANNEL CHARACTER VARYING(20) 20
37 SC_QUICKASSISTRISKID CHARACTER VARYING(40) 40
38 VALIDATIONLEVEL BIGINT 8
39 COVERAGEFORM BIGINT 8
40 WCOTHERSTATES CHARACTER VARYING(255) 255
41 PARTICIPATION NUMERIC(4,1) 19
42 CANCELLATIONDATE TIMESTAMP 8
43 SC_RESPONSIBILITYCENTER CHARACTER VARYING(4) 4
44 NOTES CHARACTER VARYING(255) 255
45 SC_CANCELREASON BIGINT 8
46 TOTALVEHICLES BIGINT 8
47 SC_PREMIUMSTATUS BIGINT 8
48 SC_SERVICECENTER CHARACTER VARYING(4) 4
49 EXPIRATIONDATE TIMESTAMP 8
50 SC_LINEOFBUSINESS BIGINT 8
51 SC_UNDERWRITINGCOMPANY CHARACTER VARYING(20) 20
52 OTHERINSURANCE CHARACTER VARYING(1) 1
53 SC_MEMBERSHIPLEVEL BIGINT 8
54 SC_RENEWALMODE BIGINT 8
55 SC_POLICYFINANCIALS BIGINT 8
56 ARCHIVEPARTITION BIGINT 8
57 SC_ITCPERCENTAGE NUMERIC(4,1) 19
58 SC_MONEYOUTSTANDINGIND CHARACTER VARYING(1) 1
59 SC_POLICYINCEPTIONDATE TIMESTAMP 8
60 SC_WCN CHARACTER VARYING(255) 255
61 SC_STAMPDUTYEXEMPT CHARACTER VARYING(1) 1
62 SC_GSTEXEMPT CHARACTER VARYING(1) 1
63 SC_BURNINGCOSTS NUMERIC(18,2) 19
64 SC_MONEYOUTSTANDING CHARACTER VARYING(1) 1
65 SC_UNDERWRITINGCODE CHARACTER VARYING(5) 5
66 SC_GSTREGISTERED CHARACTER VARYING(1) 1
67 SC_GROSSPREMIUM NUMERIC(18,2) 19
68 SC_SCHEME CHARACTER VARYING(10) 10
69 SC_BRANCH CHARACTER VARYING(3) 3
70 SC_SOURCEPOLICYNUMBER CHARACTER VARYING(40) 40
71 SC_REGION CHARACTER VARYING(3) 3
72 SC_SOURCECOMPANY CHARACTER VARYING(3) 3
73 SC_SOURCECOVERAGE CHARACTER VARYING(2) 2
74 SC_DIVISION CHARACTER VARYING(1) 1
75 SC_REIMBURSEMENTSCHEDULEDFLAG CHARACTER VARYING(1) 1
76 SC_EXCESSFLAG BIGINT 8
77 SC_OLDESTJOINTPOLICYHOLDERDOB TIMESTAMP 8
78 SC_ISBURNINGCOSTS CHARACTER VARYING(1) 1
79 SC_NOMDEFREFNUMBER CHARACTER VARYING(10) 10
80 SC_REGISTRATIONSTATUS BIGINT 8
81 SC_DRIVERSTATUS BIGINT 8
82 SC_SUBCHANNEL CHARACTER VARYING(20) 20
83 BUSINESSSOURCE_EXT CHARACTER VARYING(4) 4
84 SALESPACKAGE_EXT CHARACTER VARYING(100) 100
85 SOURCECLIENTCD_EXT CHARACTER VARYING(2) 2
86 UNDERWRITINGSTATE_EXT BIGINT 8
87 COMMISSIONCD_EXT CHARACTER VARYING(2) 2
88 INSTALMENTSTATUSDATE_EXT TIMESTAMP 8
89 INSTALMENTSTATUSDESC_EXT CHARACTER VARYING(20) 20
90 LOYALTYREWARDDATE_EXT TIMESTAMP 8
91 INTERNALNPPOLICYNO_EXT CHARACTER VARYING(40) 40
92 POLICYSOURCESYSTEM_EXT BIGINT 8
93 ACCOUNTNUMBER CHARACTER VARYING(40) 40
94 ADMIN CHARACTER VARYING(1) 1
95 ASSIGNEDRISK CHARACTER VARYING(1) 1
96 CURRENCY BIGINT 8
97 POLICYSYSTEMPERIODID BIGINT 8
98 SOURCEBRAND_EXT BIGINT 8
99 POLICYHOLDERRELATIVESIZE_EXT BIGINT 8
100 BRANDMARKERLOB_EXT CHARACTER VARYING(10) 10
101 CORPORATEPARTNERFULLNAME_EXT CHARACTER VARYING(60) 60
102 CORPORATEPARTNERSHORTNAME_EXT CHARACTER VARYING(10) 10
103 BULKSCHEMEPOLICY_EXT BIGINT 8
104 ANZSICCODE_EXT CHARACTER VARYING(10) 10
105 EMPLOYERPLAN_EXT CHARACTER VARYING(500) 500