Developer Programs

Learn

Docs

cfmast_raw

Core Schemas > Silverlake > cfmast_raw
Column nameDescriptionModeTypeLength
__opContains the operation type. Values are I for insert, U for update, D for delete.REQUIREDSTRING
__op_tsoperation timestamp added by export codeREQUIREDTIMESTAMP
__uidThe Unique ID of this entry. Data, UUID, or GUIDREQUIREDSTRING
__verMapping and Schema VersionREQUIREDINTEGER
cfreciIdentifier | CHAR(1)NULLABLESTRING1
cfretnRetention | DEC(1,0)NULLABLEINTEGER1
cfbnknBank number | DEC(3,0)NULLABLEINTEGER3
cfbrnnBranch number | DEC(3,0)NULLABLEINTEGER3
cfcif_num_Customer number | CHAR(7)NULLABLESTRING7
cfsnmeShort name | CHAR(20)NULLABLESTRING20
cfseq_num_Short name sequence | DEC(3,0)NULLABLEINTEGER3
cfsnphPhonetic search key | CHAR(10)NULLABLESTRING10
cfsnp2Phonetic search key 2 | CHAR(10)NULLABLESTRING10
cfinqcInquiry code | CHAR(15)NULLABLESTRING15
cfoffrOfficer code | CHAR(6)NULLABLESTRING6
cfemplEmployer name | CHAR(35)NULLABLESTRING35
cfinscInsider code | CHAR(1)NULLABLESTRING1
cfvipcVIP customer | CHAR(1)NULLABLESTRING1
cfdeadDeceased customer flag | CHAR(1)NULLABLESTRING1
cfbadaInsufficient address | CHAR(1)NULLABLESTRING1
cfhldmHold mail code | CHAR(1)NULLABLESTRING1
cfproaProfit analysis | CHAR(1)NULLABLESTRING1
cffornForeign address | CHAR(1)NULLABLESTRING1
cfsic1SIC #1 user defined | CHAR(1)NULLABLESTRING1
cfsic2SIC #2 user defined | CHAR(1)NULLABLESTRING1
cfsic3SIC #3 user defined | CHAR(1)NULLABLESTRING1
cfsic4SIC #4 user defined | CHAR(1)NULLABLESTRING1
cfsic5SIC #5 user defined | CHAR(1)NULLABLESTRING1
cfsic6SIC #6 user defined | CHAR(1)NULLABLESTRING1
cfsic7SIC #7 user defined | CHAR(1)NULLABLESTRING1
cfsic8SIC #8 user defined | CHAR(1)NULLABLESTRING1
cfna1Customer name | CHAR(40)NULLABLESTRING40
cfna2Address line 1 | CHAR(40)NULLABLESTRING40
cfna3Address line 2 | CHAR(40)NULLABLESTRING40
cfna4City state zip | CHAR(40)NULLABLESTRING40
cfcityCity | CHAR(20)NULLABLESTRING20
cfstatState | CHAR(2)NULLABLESTRING2
cfcrasCRA State Code | DEC(2,0)NULLABLEINTEGER2
cfcntyCounty | DEC(3,0)NULLABLEINTEGER3
cfzipZip code | DEC(9,0)NULLABLEINTEGER9
cfzipdZip code delivery point | CHAR(2)NULLABLESTRING2
cfnameCustomer full name | CHAR(40)NULLABLESTRING40
cffnaCustomer first name | CHAR(20)NULLABLESTRING20
cffnalCustomer first name length | DEC(2,0)NULLABLEINTEGER2
cfmnaCustomer middle name | CHAR(20)NULLABLESTRING20
cfmnalCustomer middle name length | DEC(2,0)NULLABLEINTEGER2
cfmninName/initial inverted | CHAR(1)NULLABLESTRING1
cflnaCustomer last name | CHAR(20)NULLABLESTRING20
cflnalCustomer last name length | DEC(2,0)NULLABLEINTEGER2
cfsfxCustomer name suffix | CHAR(4)NULLABLESTRING4
cfsfxlCustomer name suffix length | DEC(1,0)NULLABLEINTEGER1
cfnamcCustomer name control | CHAR(4)NULLABLESTRING4
cfexttlCIF Expanded Title | CHAR(70)NULLABLESTRING70
cforgdOriginal customer date (YYYYDDD) | DEC(7,0)NULLABLEINTEGER7
cforg6Original customer date (MMDDYY) | DEC(6,0)NULLABLEINTEGER6
cfdlmDate of last maintenance | DEC(7,0)NULLABLEINTEGER7
cfdlm6Date of last maintenance | DEC(6,0)NULLABLEINTEGER6
cfhphoHome phone | DEC(10,0)NULLABLEINTEGER10
cfbphoBusiness phone | DEC(10,0)NULLABLEINTEGER10
cffsdtFinancial statement date | DEC(7,0)NULLABLEINTEGER7
cffsd6Financial statement date | DEC(6,0)NULLABLEINTEGER6
cfssnoTax ID number | DEC(9,0)NULLABLEINTEGER9
cfsscdTax ID type code | CHAR(1)NULLABLESTRING1
cfssfxTax ID suffix | CHAR(1)NULLABLESTRING1
cfbirdDate of birth (YYYYDDD) | DEC(7,0)NULLABLEINTEGER7
cfbir6Date of birth (MMDDYY) | DEC(6,0)NULLABLEINTEGER6
cfsexSex | CHAR(1)NULLABLESTRING1
cfclasClass | CHAR(1)NULLABLESTRING1
cfindiIndividual | CHAR(1)NULLABLESTRING1
cfinclCRA Income level | CHAR(1)NULLABLESTRING1
cfsmsaSMSA code | DEC(5,0)NULLABLEINTEGER5
cfcralCRA Location | DEC(9,0)NULLABLEINTEGER9
cfcensCensus Tract | DEC(7,2)NULLABLEFLOAT7.2
cfbustBusiness type | DEC(4,0)NULLABLEINTEGER4
cfnaicsNAICS Code | CHAR(6)NULLABLESTRING6
cfsclaSub-class | CHAR(1)NULLABLESTRING1
cfgrupCIF group code | CHAR(1)NULLABLESTRING1
cfccycCIF combined cycle | DEC(2,0)NULLABLEINTEGER2
cftinsTIN status | CHAR(1)NULLABLESTRING1
cftnd6Status changed date | DEC(6,0)NULLABLEINTEGER6
cftndtStatus changed date | DEC(7,0)NULLABLEINTEGER7
cfwhcdFed W/H code | DEC(1,0)NULLABLEINTEGER1
cfwhprState W/H code | DEC(1,0)NULLABLEINTEGER1
cfwhdtFed W/H date (YYYYDDD) | DEC(7,0)NULLABLEINTEGER7
cfwhd6Fed W/H date (MMDDYY) | DEC(6,0)NULLABLEINTEGER6
cfbnotB notice flag | CHAR(1)NULLABLESTRING1
cfbnd6Last IRS Notification | DEC(6,0)NULLABLEINTEGER6
cfbndtLast IRS Notification | DEC(7,0)NULLABLEINTEGER7
cfaflgALIEN Flag | CHAR(1)NULLABLESTRING1
cfadt6Last ALIEN Certification | DEC(6,0)NULLABLEINTEGER6
cfadatLast ALIEN Certification | DEC(7,0)NULLABLEINTEGER7
cfdde6Date Deceased | DEC(6,0)NULLABLEINTEGER6
cfddeaDate Deceased | DEC(7,0)NULLABLEINTEGER7
cfuic1UIC #1 user defined | CHAR(1)NULLABLESTRING1
cfuic2UIC #2 user defined | CHAR(1)NULLABLESTRING1
cfuic3UIC #3 user defined | CHAR(1)NULLABLESTRING1
cfuic4UIC #4 user defined | CHAR(1)NULLABLESTRING1
cfuic5UIC #5 user defined | CHAR(1)NULLABLESTRING1
cfuic6UIC #6 user defined | CHAR(1)NULLABLESTRING1
cfuic7UIC #7 user defined | CHAR(1)NULLABLESTRING1
cfuic8UIC #8 user defined | CHAR(1)NULLABLESTRING1
cfpic1PIC #1 programmer use | CHAR(2)NULLABLESTRING2
cfpic2PIC #2 programmer use | CHAR(2)NULLABLESTRING2
cfpdt1Programmer DATE #1 | DEC(7,0)NULLABLEINTEGER7
cfpd61Programmer DATE #1 | DEC(6,0)NULLABLEINTEGER6
cfpdt2Programmer DATE #2 | DEC(7,0)NULLABLEINTEGER7
cfpd62Programmer DATE #2 | DEC(6,0)NULLABLEINTEGER6
cfpam1Programmer AMT #1 | DEC(13,2)NULLABLEFLOAT13.2
cfpam2Programmer AMT #2 | DEC(13,2)NULLABLEFLOAT13.2
cfgrp_num_Related Group Number | DEC(7,0)NULLABLEINTEGER7
cfcfsdMost Recent F/S date | DEC(7,0)NULLABLEINTEGER7
cfcfs6Most Recent F/S date | DEC(6,0)NULLABLEINTEGER6
cfltdtLast Letter Sent date | DEC(7,0)NULLABLEINTEGER7
cfltd6Last Letter Sent date | DEC(6,0)NULLABLEINTEGER6
cfwrthNet Worth | DEC(9,0)NULLABLEINTEGER9
cfwvcdF/S Waive Code | CHAR(1)NULLABLESTRING1
cfwvdtF/S Waive Date | DEC(7,0)NULLABLEINTEGER7
cfwvd6F/S Waive Date | DEC(6,0)NULLABLEINTEGER6
cftxrtTAX Return Date | DEC(7,0)NULLABLEINTEGER7
cftxr6TAX Return Date | DEC(6,0)NULLABLEINTEGER6
cftxetTAX Extension Date | DEC(7,0)NULLABLEINTEGER7
cftxe6TAX Extension Date | DEC(6,0)NULLABLEINTEGER6
cfirsaI R S Address | CHAR(40)NULLABLESTRING40
cfirscI R S City | CHAR(20)NULLABLESTRING20
cfirssI R S State | CHAR(2)NULLABLESTRING2
cfirszI R S Zip | DEC(9,0)NULLABLEINTEGER9
cfirsdIRS delivery point | CHAR(2)NULLABLESTRING2
cfirsfIRS Foreign delvry point | CHAR(40)NULLABLESTRING40
cfcassCASS certification flag | CHAR(1)NULLABLESTRING1
cfleasLease Security flag | CHAR(1)NULLABLESTRING1
cffax1Fax number | DEC(10,0)NULLABLEINTEGER10
cffax2Other fax number | DEC(10,0)NULLABLEINTEGER10
cfcel1Cell phone number | DEC(10,0)NULLABLEINTEGER10
cfcel2Other cell phone number | DEC(10,0)NULLABLEINTEGER10
cfeml1E-mail address | CHAR(80)NULLABLESTRING80
cfeml2Other e-mail address | CHAR(80)NULLABLESTRING80
cfregpPrivacy Act opt out | CHAR(1)NULLABLESTRING1
cfrpd6Privacy Act last notice sent date | DEC(6,0)NULLABLEINTEGER6
cfrpd7Privacy Act last notice sent date | DEC(7,0)NULLABLEINTEGER7
cfnocallCIF Do Not Call Flag | CHAR(1)NULLABLESTRING1
cfnclex6CIF Do Not Call Flag Expiration Date 6 | DEC(6,0)NULLABLEINTEGER6
cfnclex7CIF Do Not Call Flag Expiration Date 7 | DEC(7,0)NULLABLEINTEGER7
cfrskrtCIF Risk Rating | CHAR(6)NULLABLESTRING6
cfrskd6CIF Risk Rating Date | DEC(6,0)NULLABLEINTEGER6
cfrskd7CIF Risk Rating Date | DEC(7,0)NULLABLEINTEGER7
cfrskbyCIF Risk Rated by Code | CHAR(6)NULLABLESTRING6
cfocpcdCIF Occupation Code | CHAR(50)NULLABLESTRING50
cfafloptAffiliate Opt Out | CHAR(1)NULLABLESTRING1
cfaflexd6Affiliate Opt Out Expiration Date | DEC(6,0)NULLABLEINTEGER6
cfaflexd7Affiliate Opt Out Expiration Date | DEC(7,0)NULLABLEINTEGER7
cfaflecd6Affiliate Opt Out Exception Date | DEC(6,0)NULLABLEINTEGER6
cfaflecd7Affiliate Opt Out Exception Date | DEC(7,0)NULLABLEINTEGER7
cfaflexcdAffiliate Opt Out Exception Code | CHAR(2)NULLABLESTRING2
salescfCIF Sales Associate Code | CHAR(15)NULLABLESTRING15
cfbphxBusiness Phone Extension | DEC(6,0)NULLABLEINTEGER6
cflangLanguage Identifier | CHAR(3)NULLABLESTRING3
cfforcForeign Country | CHAR(50)NULLABLESTRING50
cfirsfcIRS Foreign Country | CHAR(50)NULLABLESTRING50
cfaedt6Alien Cert. Expiration | DEC(6,0)NULLABLEINTEGER6
cfaedatAlien Cert. Expiration | DEC(7,0)NULLABLEINTEGER7
w8statW8 Status Code | CHAR(1)NULLABLESTRING1
w8typeW8 Type Code | CHAR(3)NULLABLESTRING3
w8lldt6Date of Last W8 Letter | DEC(6,0)NULLABLEINTEGER6
w8lldatDate of Last W8 Letter | DEC(7,0)NULLABLEINTEGER7
w8stsW8 Programer Use | DEC(1,0)NULLABLEINTEGER1
cfdto6Date entered | DEC(6,0)NULLABLEINTEGER6
cfdto7Date entered | DEC(7,0)NULLABLEINTEGER7
cfpfa1Phys Addr Line 1 | CHAR(40)NULLABLESTRING40
cfpfa2Phys Addr Line 2 | CHAR(40)NULLABLESTRING40
cfpfcyPhys Addr City | CHAR(20)NULLABLESTRING20
cfpfstPhys Addr State | CHAR(2)NULLABLESTRING2
cfpfzcPhys Addr Zip | DEC(9,0)NULLABLEINTEGER9
cfpfdpPhys Addr Deliv Pt | CHAR(2)NULLABLESTRING2
cfdlac6Date Last Contact | DEC(6,0)NULLABLEINTEGER6
cfdlac7Date Last Contact | DEC(7,0)NULLABLEINTEGER7
cfpffdPhys Addr Foreign Addr | CHAR(40)NULLABLESTRING40
cfpffcPhys Addr Foreign Cntry | CHAR(50)NULLABLESTRING50
cfpffrPhys Addr Foreign Flag | CHAR(1)NULLABLESTRING1
cftinmatchIRS TIN Match Flag | CHAR(1)NULLABLESTRING1
cfmast_idUnique row ID | BIGINT(8)NULLABLEINTEGER8
cfmcrttsRow create timestamp | TIMESTAMP LEN(26)NULLABLESTRING26
cfmmnttsRow last maint timestamp | TIMESTAMP LEN(26)NULLABLESTRING26
Last updated Thu Dec 12 2024