CCR_CC_CONTACT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LASTNAMEDENORM CHARACTER VARYING(90) 90
2 SC_PLACEDESC CHARACTER VARYING(255) 255
3 SC_INSURERNAME CHARACTER VARYING(255) 255
4 W9RECEIVED CHARACTER VARYING(1) 1
5 SC_PAYMENTMETHOD BIGINT 8
6 SC_OTHERPHONE CHARACTER VARYING(30) 30
7 CREATETIME TIMESTAMP 8
8 PRIMARYPHONE BIGINT 8
9 SC_ACCOUNTNUMBER CHARACTER VARYING(255) 255
10 ADDRESSBOOKFINGERPRINT CHARACTER VARYING(40) 40
11 SC_LANGUAGEPREF BIGINT 8
12 SC_PAYMENTTERMS BIGINT 8
13 PREFERRED CHARACTER VARYING(1) 1
14 EMPLOYEENUMBER CHARACTER VARYING(255) 255
15 FORMERNAME CHARACTER VARYING(90) 90
16 TAXSTATUS BIGINT 8
17 DATEOFBIRTH TIMESTAMP 8
18 ORGANIZATIONTYPE BIGINT 8
19 NUMDEPENDENTSU25 BIGINT 8
20 SC_GSTREGISTERED CHARACTER VARYING(1) 1
21 PRIMARYLANGUAGE BIGINT 8
22 LAWFIRMSPECIALTY BIGINT 8
23 VENDORTYPE BIGINT 8
24 LOADRELATEDCONTACTS CHARACTER VARYING(1) 1
25 OCCUPATION CHARACTER VARYING(80) 80
26 WITHHOLDINGRATE NUMERIC(4,1) 19
27 UPDATEUSERID BIGINT 8
28 MIDDLENAME CHARACTER VARYING(90) 90
29 CELLPHONE CHARACTER VARYING(30) 30
30 SC_AUTHPARTY CHARACTER VARYING(1) 1
31 AUTOTOWINGLICENSE CHARACTER VARYING(30) 30
32 MEDICALORGSPECIALTY BIGINT 8
33 PREFIX BIGINT 8
34 W9RECEIVEDDATE TIMESTAMP 8
35 FIRSTNAMEDENORM CHARACTER VARYING(90) 90
36 SC_OTHERPHONEDESC CHARACTER VARYING(255) 255
37 W9VALIDFROM TIMESTAMP 8
38 WORKPHONE CHARACTER VARYING(24) 24
39 SC_DECEASED CHARACTER VARYING(1) 1
40 VENUETYPE BIGINT 8
41 ADDRESSBOOKUID CHARACTER VARYING(64) 64
42 NAME CHARACTER VARYING(120) 120
43 SC_CELLPHONE CHARACTER VARYING(255) 255
44 SUBTYPE BIGINT 8
45 SC_PLACETYPE BIGINT 8
46 NOTES CHARACTER VARYING(2000) 2000
47 SC_CONTRACTUALAUTH CHARACTER VARYING(1) 1
48 LICENSENUMBER CHARACTER VARYING(20) 20
49 SC_INSURERCLAIMNUMBER CHARACTER VARYING(255) 255
50 LASTNAME CHARACTER VARYING(90) 90
51 LICENSESTATE BIGINT 8
52 SC_BSB CHARACTER VARYING(255) 255
53 NAMEDENORM CHARACTER VARYING(120) 120
54 SC_CONSOLVENDOR CHARACTER VARYING(1) 1
55 EMAILADDRESS1 CHARACTER VARYING(60) 60
56 MARITALSTATUS BIGINT 8
57 ATTORNEYLICENSE CHARACTER VARYING(30) 30
58 TAXFILINGSTATUS BIGINT 8
59 ADJUDICATIVEDOMAIN BIGINT 8
60 ATTORNEYSPECIALTY BIGINT 8
61 BEANVERSION BIGINT 8
62 ADJUDICATORLICENSE CHARACTER VARYING(30) 30
63 RETIRED BIGINT 8
64 SUFFIX BIGINT 8
65 SC_STAFFNUMBER CHARACTER VARYING(10) 10
66 SC_PAYMENTSERVICEACKDATE TIMESTAMP 8
67 TAXID CHARACTER VARYING(30) 30
68 FIRSTNAME CHARACTER VARYING(90) 90
69 HOMEPHONE CHARACTER VARYING(30) 30
70 SC_VENDORTYPE BIGINT 8
71 PUBLICID CHARACTER VARYING(64) 64
72 SC_SYSTEMCUSTOMERID CHARACTER VARYING(40) 40
73 AUTOREPAIRLICENSE CHARACTER VARYING(30) 30
74 NUMDEPENDENTSU18 BIGINT 8
75 NUMDEPENDENTS BIGINT 8
76 GENDER BIGINT 8
77 W9VALIDTO TIMESTAMP 8
78 SPECIALTYTYPE BIGINT 8
79 SC_ACCOUNTNAME CHARACTER VARYING(255) 255
80 SC_SPECIALTY CHARACTER VARYING(255) 255
81 ID BIGINT 8
82 SC_BUSINESSTYPE BIGINT 8
83 VENDORNUMBER CHARACTER VARYING(60) 60
84 FAXPHONE CHARACTER VARYING(30) 30
85 LOADCOMMANDID BIGINT 8
86 DOCTORSPECIALTY BIGINT 8
87 PRIMARYADDRESSID BIGINT 8
88 MEDICALLICENSE CHARACTER VARYING(30) 30
89 SC_CRMCUSTOMERID CHARACTER VARYING(40) 40
90 CREATEUSERID BIGINT 8
91 SC_PAYMENTSERVICEVENDORID CHARACTER VARYING(10) 10
92 SC_REMITTANCEDELIVERY BIGINT 8
93 SC_SENIORCARDNUMBER CHARACTER VARYING(10) 10
94 SC_BULKPAYMENTS CHARACTER VARYING(1) 1
95 EMAILADDRESS2 CHARACTER VARYING(60) 60
96 SC_PAYMENTSERVICECORRID CHARACTER VARYING(50) 50
97 SC_MEMBERSHIPLEVEL BIGINT 8
98 SC_INJURIES BIGINT 8
99 SCORE BIGINT 8
100 SC_NODEPENDANTADULTS BIGINT 8
101 AUTOSYNC BIGINT 8
102 SC_INTERPRETERREQD CHARACTER VARYING(1) 1
103 SC_CRIMINALRECORD BIGINT 8
104 SC_CRIMINALHISTORY CHARACTER VARYING(1) 1
105 SC_NODEPENDANTCHILDREN BIGINT 8
106 ADMIN CHARACTER VARYING(1) 1
107 SC_JOBTITLE CHARACTER VARYING(40) 40
108 SC_ISOVERSEAS CHARACTER VARYING(1) 1
109 ARCHIVEPARTITION BIGINT 8
110 VALIDATIONLEVEL BIGINT 8
111 SC_BIRTHCOUNTRY BIGINT 8
112 SC_HOSPITALNAME CHARACTER VARYING(40) 40
113 PREFERREDCURRENCY BIGINT 8
114 SC_DRIVERLICENCETYPE BIGINT 8
115 SC_PERSONQUESTIONS BIGINT 8
116 SC_ACN CHARACTER VARYING(10) 10
117 SC_ITCEPERCENTAGE BIGINT 8
118 SC_POLICYNUMBER CHARACTER VARYING(40) 40
119 SC_REGISTRATIONNUMBER CHARACTER VARYING(30) 30
120 SC_CLAIMINGTAXTHRESHOLD CHARACTER VARYING(1) 1
121 SC_PROVIDERNUMBER CHARACTER VARYING(64) 64
122 SC_TAXFILENUMBER CHARACTER VARYING(9) 9
123 SC_LANGUAGE BIGINT 8
124 SC_OLDPAYEEID CHARACTER VARYING(20) 20
125 SC_ABNSTATUS CHARACTER VARYING(1) 1
126 SC_PAYSTARTDATE TIMESTAMP 8
127 SC_PAYABLE CHARACTER VARYING(1) 1
128 SC_JURISSTATE BIGINT 8
129 SC_PAYENDDATE TIMESTAMP 8
130 SC_PROVIDERTALLYID CHARACTER VARYING(20) 20
131 SC_CENTRALBILLSERVICE CHARACTER VARYING(1) 1
132 SC_ITCEPREMIUMCONFIRMED CHARACTER VARYING(1) 1
133 SC_TRADINGNAME CHARACTER VARYING(120) 120
134 SC_GSTONBAS CHARACTER VARYING(1) 1
135 SC_SOURCECLIENT CHARACTER VARYING(10) 10
136 SC_GSTREGISTEREDFORITCE BIGINT 8
137 SC_OBSERVER CHARACTER VARYING(1) 1
138 SC_INSURERNOTIFIED CHARACTER VARYING(1) 1
139 SC_GSTONBASFORITCE BIGINT 8
140 SC_ISINSURED BIGINT 8
141 SC_CORRESPONDENCEDELIVERY BIGINT 8
142 SC_PERSONBEINGTOWED CHARACTER VARYING(1) 1
143 SC_WCREGUPDATETIME TIMESTAMP 8
144 SC_INSURERPOLICYNUMBER CHARACTER VARYING(255) 255
145 SC_INVOICEDOCTYPE BIGINT 8
146 SC_INSURERCOVERSTATUS BIGINT 8
147 SC_ISREPRESENTINGINSURED CHARACTER VARYING(1) 1
148 SC_DEPENDENTNUMBER BIGINT 8
149 SC_POLICYTYPE BIGINT 8
150 SC_IMPORTSTATUS BIGINT 8
151 SC_PORTAGENCYID BIGINT 8
152 SC_BANKNAME CHARACTER VARYING(255) 255
153 SC_SHARINGWITHQLDEFFECTIVE TIMESTAMP 8
154 SC_SHARINGWITHNSWEFFECTIVE TIMESTAMP 8
155 SC_IDENTIFICATION CHARACTER VARYING(10) 10
156 SC_FORMERFIRSTNAME CHARACTER VARYING(90) 90
157 SC_CTPINSURERCODE BIGINT 8
158 SC_IDENTIFICATIONSTATE BIGINT 8
159 SC_FORMERMIDDLENAME CHARACTER VARYING(90) 90
160 SC_SHARINGWITHNSW CHARACTER VARYING(1) 1
161 SC_SHARINGWITHSA CHARACTER VARYING(1) 1
162 SC_SHARINGWITHSAEFFECTIVE TIMESTAMP 8
163 SC_IDENTIFICATIONTYPE BIGINT 8
164 SC_ACCIDENTSEQUENCEKEY CHARACTER VARYING(20) 20
165 SC_SHARINGWITHQLD CHARACTER VARYING(1) 1
166 SC_RELATIONTOINSURED BIGINT 8
167 SC_EXCLUDESTPAFCLAIMS CHARACTER VARYING(1) 1
168 SC_ACCEPTSAWPCLAIMS CHARACTER VARYING(1) 1
169 SC_DATEOFBIRTHKNOWN BIGINT 8
170 SC_LOCATIONTYPE BIGINT 8
171 SC_ACCEPTSNONDRIVEABLE CHARACTER VARYING(1) 1
172 SC_PAYMENTNAME CHARACTER VARYING(130) 130
173 SC_ACTIVECONTACT CHARACTER VARYING(1) 1
174 SC_DRIVERLICENCESTATUS BIGINT 8
175 POSTALADDRESS BIGINT 8
176 SC_ACCEPTSTPVEHICLES CHARACTER VARYING(1) 1
177 SC_ADDITIONALINFO CHARACTER VARYING(200) 200
178 SC_LICENCECOUNTRY BIGINT 8
179 SC_OLDESTJOINTPOLICYHOLDERDOB TIMESTAMP 8
180 SC_ACCEPTSUME CHARACTER VARYING(1) 1
181 SC_ACTIVEPNETACCOUNT CHARACTER VARYING(1) 1
182 SC_VERSIONOFEVENTS CHARACTER VARYING(2000) 2000
183 SC_CONTACTPAYMENTACCOUNTSEQ BIGINT 8
184 SC_STATEMENTOBTAINED CHARACTER VARYING(1) 1
185 SC_SUSPENDED CHARACTER VARYING(1) 1
186 SC_ACCEPTSTPAFCLAIMS CHARACTER VARYING(1) 1
187 SC_SAMENOTIFICATIONSMS CHARACTER VARYING(1) 1
188 SC_SUSPENSIONTYPE BIGINT 8
189 SC_ORDERNOTIFICATIONEMAIL CHARACTER VARYING(255) 255
190 SC_USERNAME CHARACTER VARYING(30) 30
191 SC_VENDORSCORE BIGINT 8
192 SC_PROCESSTYPEEXISTS CHARACTER VARYING(1) 1
193 SC_RECOMMENDED CHARACTER VARYING(1) 1
194 SC_EXTSECURITYCREDID BIGINT 8
195 SC_ACCEPTSDRIVEABLE CHARACTER VARYING(1) 1
196 SC_VENDORENGAGEMENTTYPE BIGINT 8
197 SC_REMITTANCENOTIFICATIONEMAIL CHARACTER VARYING(2000) 2000
198 SC_REFERENCEID CHARACTER VARYING(30) 30
199 SC_ACCEPTSSMS CHARACTER VARYING(1) 1
200 SC_QUOTENOTIFICATIONSMS CHARACTER VARYING(255) 255
201 SC_SAMENOTIFICATIONEMAIL CHARACTER VARYING(1) 1
202 SC_MAKESAFENOTIFICATIONSMS CHARACTER VARYING(255) 255
203 SC_ORDERNOTIFICATIONSMS CHARACTER VARYING(255) 255
204 SC_SERVICEABLEPOSTCODENATIONAL CHARACTER VARYING(1) 1
205 MAKESAFE CHARACTER VARYING(1) 1
206 SC_QUOTENOTIFICATIONEMAIL CHARACTER VARYING(255) 255
207 SC_PORTFOLIOCODE CHARACTER VARYING(50) 50
208 SC_B2B_ENABLED CHARACTER VARYING(1) 1
209 AFTERHOURS CHARACTER VARYING(1) 1
210 SC_CONTRACTSTARTDATE TIMESTAMP 8
211 SC_CONTRACTENDDATE TIMESTAMP 8
212 SC_ALLOCATIONHUB CHARACTER VARYING(1) 1
213 SC_AUTOASSIGNANDINVITEREPAIRER CHARACTER VARYING(1) 1
214 SC_CONTRACTACTIVE CHARACTER VARYING(1) 1
215 SC_OPENTUESDAY CHARACTER VARYING(1) 1
216 SC_CLOSETIMESUNDAY TIMESTAMP 8
217 SC_OPENTIMESUNDAY TIMESTAMP 8
218 SC_CLOSETIMETUESDAY TIMESTAMP 8
219 SC_OPENTIMETHURSDAY TIMESTAMP 8
220 SC_CLOSETIMEFRIDAY TIMESTAMP 8
221 SC_CLOSETIMEMONDAY TIMESTAMP 8
222 SC_CLOSETIMETHURSDAY TIMESTAMP 8
223 SC_OPENSUNDAY CHARACTER VARYING(1) 1
224 SC_OPENTIMESATURDAY TIMESTAMP 8
225 SC_OPENTIMEFRIDAY TIMESTAMP 8
226 SC_OPENMONDAY CHARACTER VARYING(1) 1
227 SC_OPENTIMEMONDAY TIMESTAMP 8
228 SC_OPENTHURSDAY CHARACTER VARYING(1) 1
229 SC_OPENSATURDAY CHARACTER VARYING(1) 1
230 SC_CLOSETIMEWEDNESDAY TIMESTAMP 8
231 SC_OPENTIMEWEDNESDAY TIMESTAMP 8
232 SC_OPENFRIDAY CHARACTER VARYING(1) 1
233 SC_OPENTIMETUESDAY TIMESTAMP 8
234 SC_CLOSETIMESATURDAY TIMESTAMP 8
235 SC_OPENWEDNESDAY CHARACTER VARYING(1) 1
236 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
237 SC_EXTERNALASSESSOR CHARACTER VARYING(1) 1
238 SC_AVAILABILITYCOMMENT CHARACTER VARYING(250) 250
239 SC_RANKINGDATE TIMESTAMP 8
240 SC_RANKINGSCORE BIGINT 8
241 SC_RANKINGCOMMENT CHARACTER VARYING(250) 250
242 WATCHLISTPROVIDER_EXT CHARACTER VARYING(1) 1
243 AUTOPAYMENTALLOWED_EXT CHARACTER VARYING(1) 1
244 LICENCECLASS_EXT BIGINT 8
245 PARTYREFID_EXT CHARACTER VARYING(40) 40
246 ORACLEIMGUID_EXT CHARACTER VARYING(150) 150
247 POLICYSYSTEMID CHARACTER VARYING(256) 256
248 AGREEDFREQUENCYOFCONTACT_EXT BIGINT 8
249 PREFERREDCONTACTTIME_EXT CHARACTER VARYING(255) 255
250 VENDORTOCUSTOMERCOMMSMETHD_EXT BIGINT 8
251 SYSTEMINTEGRATED_EXT CHARACTER VARYING(1) 1
252 REPAIRERRELATIONSHIP_EXT BIGINT 8
253 LOCATIONREPAIRTYPE_EXT BIGINT 8
254 REASSIGNIFJOBDECLINE_EXT CHARACTER VARYING(1) 1
255 APIKEY CHARACTER VARYING(255) 255
256 CANMANAGEPROJECTS CHARACTER VARYING(1) 1
257 COMMENTS_EXT CHARACTER VARYING(2048) 2048
258 DAYPERIOD_EXT BIGINT 8
259 PROFITCENTRELOOKUPID_EXT CHARACTER VARYING(40) 40
260 CONTACTALLOWED_EXT BIGINT 8
261 CANUSENONSTANDARDGST_EXT CHARACTER VARYING(1) 1
262 ACCEPTSONLINEBOOKINGS CHARACTER(1) 1
263 BRANCHNAME_EXT CHARACTER VARYING(256) 256
264 CANVENDORSUBMITESTIMATE_EXT CHARACTER(1) 1
265 ACCEPTEMAIL_EXT CHARACTER VARYING(1) 1
266 FINANCIALSUPPLEMENTLOAN_EXT CHARACTER VARYING(1) 1
267 GOVERNMENTADMINISTEREDLOAN_EXT CHARACTER VARYING(1) 1
268 REJECTNOTIFICATIONS_EXT CHARACTER VARYING(1) 1
269 TAXRESIDENCYSTATUS_EXT BIGINT 8