cfmast_raw

Pipelined Data Sets > SilverLake > cfmast_raw

Column name	Description	Mode	Type	Length
__op	Contains the operation type. Values are I for insert, U for update, D for delete.	REQUIRED	STRING
__op_ts	operation timestamp added by export code	REQUIRED	TIMESTAMP
__uid	The Unique ID of this entry. Data, UUID, or GUID	REQUIRED	STRING
__ver	Mapping and Schema Version	REQUIRED	INTEGER
cfreci	Identifier \| CHAR(1)	NULLABLE	STRING	1
cfretn	Retention \| DEC(1,0)	NULLABLE	INTEGER	1
cfbnkn	Bank number \| DEC(3,0)	NULLABLE	INTEGER	3
cfbrnn	Branch number \| DEC(3,0)	NULLABLE	INTEGER	3
cfcif_num_	Customer number \| CHAR(7)	NULLABLE	STRING	7
cfsnme	Short name \| CHAR(20)	NULLABLE	STRING	20
cfseq_num_	Short name sequence \| DEC(3,0)	NULLABLE	INTEGER	3
cfsnph	Phonetic search key \| CHAR(10)	NULLABLE	STRING	10
cfsnp2	Phonetic search key 2 \| CHAR(10)	NULLABLE	STRING	10
cfinqc	Inquiry code \| CHAR(15)	NULLABLE	STRING	15
cfoffr	Officer code \| CHAR(6)	NULLABLE	STRING	6
cfempl	Employer name \| CHAR(35)	NULLABLE	STRING	35
cfinsc	Insider code \| CHAR(1)	NULLABLE	STRING	1
cfvipc	VIP customer \| CHAR(1)	NULLABLE	STRING	1
cfdead	Deceased customer flag \| CHAR(1)	NULLABLE	STRING	1
cfbada	Insufficient address \| CHAR(1)	NULLABLE	STRING	1
cfhldm	Hold mail code \| CHAR(1)	NULLABLE	STRING	1
cfproa	Profit analysis \| CHAR(1)	NULLABLE	STRING	1
cfforn	Foreign address \| CHAR(1)	NULLABLE	STRING	1
cfsic1	SIC #1 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic2	SIC #2 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic3	SIC #3 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic4	SIC #4 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic5	SIC #5 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic6	SIC #6 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic7	SIC #7 user defined \| CHAR(1)	NULLABLE	STRING	1
cfsic8	SIC #8 user defined \| CHAR(1)	NULLABLE	STRING	1
cfna1	Customer name \| CHAR(40)	NULLABLE	STRING	40
cfna2	Address line 1 \| CHAR(40)	NULLABLE	STRING	40
cfna3	Address line 2 \| CHAR(40)	NULLABLE	STRING	40
cfna4	City state zip \| CHAR(40)	NULLABLE	STRING	40
cfcity	City \| CHAR(20)	NULLABLE	STRING	20
cfstat	State \| CHAR(2)	NULLABLE	STRING	2
cfcras	CRA State Code \| DEC(2,0)	NULLABLE	INTEGER	2
cfcnty	County \| DEC(3,0)	NULLABLE	INTEGER	3
cfzip	Zip code \| DEC(9,0)	NULLABLE	INTEGER	9
cfzipd	Zip code delivery point \| CHAR(2)	NULLABLE	STRING	2
cfname	Customer full name \| CHAR(40)	NULLABLE	STRING	40
cffna	Customer first name \| CHAR(20)	NULLABLE	STRING	20
cffnal	Customer first name length \| DEC(2,0)	NULLABLE	INTEGER	2
cfmna	Customer middle name \| CHAR(20)	NULLABLE	STRING	20
cfmnal	Customer middle name length \| DEC(2,0)	NULLABLE	INTEGER	2
cfmnin	Name/initial inverted \| CHAR(1)	NULLABLE	STRING	1
cflna	Customer last name \| CHAR(20)	NULLABLE	STRING	20
cflnal	Customer last name length \| DEC(2,0)	NULLABLE	INTEGER	2
cfsfx	Customer name suffix \| CHAR(4)	NULLABLE	STRING	4
cfsfxl	Customer name suffix length \| DEC(1,0)	NULLABLE	INTEGER	1
cfnamc	Customer name control \| CHAR(4)	NULLABLE	STRING	4
cfexttl	CIF Expanded Title \| CHAR(70)	NULLABLE	STRING	70
cforgd	Original customer date (YYYYDDD) \| DEC(7,0)	NULLABLE	INTEGER	7
cforg6	Original customer date (MMDDYY) \| DEC(6,0)	NULLABLE	INTEGER	6
cfdlm	Date of last maintenance \| DEC(7,0)	NULLABLE	INTEGER	7
cfdlm6	Date of last maintenance \| DEC(6,0)	NULLABLE	INTEGER	6
cfhpho	Home phone \| DEC(10,0)	NULLABLE	INTEGER	10
cfbpho	Business phone \| DEC(10,0)	NULLABLE	INTEGER	10
cffsdt	Financial statement date \| DEC(7,0)	NULLABLE	INTEGER	7
cffsd6	Financial statement date \| DEC(6,0)	NULLABLE	INTEGER	6
cfssno	Tax ID number \| DEC(9,0)	NULLABLE	INTEGER	9
cfsscd	Tax ID type code \| CHAR(1)	NULLABLE	STRING	1
cfssfx	Tax ID suffix \| CHAR(1)	NULLABLE	STRING	1
cfbird	Date of birth (YYYYDDD) \| DEC(7,0)	NULLABLE	INTEGER	7
cfbir6	Date of birth (MMDDYY) \| DEC(6,0)	NULLABLE	INTEGER	6
cfsex	Sex \| CHAR(1)	NULLABLE	STRING	1
cfclas	Class \| CHAR(1)	NULLABLE	STRING	1
cfindi	Individual \| CHAR(1)	NULLABLE	STRING	1
cfincl	CRA Income level \| CHAR(1)	NULLABLE	STRING	1
cfsmsa	SMSA code \| DEC(5,0)	NULLABLE	INTEGER	5
cfcral	CRA Location \| DEC(9,0)	NULLABLE	INTEGER	9
cfcens	Census Tract \| DEC(7,2)	NULLABLE	FLOAT	7.2
cfbust	Business type \| DEC(4,0)	NULLABLE	INTEGER	4
cfnaics	NAICS Code \| CHAR(6)	NULLABLE	STRING	6
cfscla	Sub-class \| CHAR(1)	NULLABLE	STRING	1
cfgrup	CIF group code \| CHAR(1)	NULLABLE	STRING	1
cfccyc	CIF combined cycle \| DEC(2,0)	NULLABLE	INTEGER	2
cftins	TIN status \| CHAR(1)	NULLABLE	STRING	1
cftnd6	Status changed date \| DEC(6,0)	NULLABLE	INTEGER	6
cftndt	Status changed date \| DEC(7,0)	NULLABLE	INTEGER	7
cfwhcd	Fed W/H code \| DEC(1,0)	NULLABLE	INTEGER	1
cfwhpr	State W/H code \| DEC(1,0)	NULLABLE	INTEGER	1
cfwhdt	Fed W/H date (YYYYDDD) \| DEC(7,0)	NULLABLE	INTEGER	7
cfwhd6	Fed W/H date (MMDDYY) \| DEC(6,0)	NULLABLE	INTEGER	6
cfbnot	B notice flag \| CHAR(1)	NULLABLE	STRING	1
cfbnd6	Last IRS Notification \| DEC(6,0)	NULLABLE	INTEGER	6
cfbndt	Last IRS Notification \| DEC(7,0)	NULLABLE	INTEGER	7
cfaflg	ALIEN Flag \| CHAR(1)	NULLABLE	STRING	1
cfadt6	Last ALIEN Certification \| DEC(6,0)	NULLABLE	INTEGER	6
cfadat	Last ALIEN Certification \| DEC(7,0)	NULLABLE	INTEGER	7
cfdde6	Date Deceased \| DEC(6,0)	NULLABLE	INTEGER	6
cfddea	Date Deceased \| DEC(7,0)	NULLABLE	INTEGER	7
cfuic1	UIC #1 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic2	UIC #2 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic3	UIC #3 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic4	UIC #4 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic5	UIC #5 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic6	UIC #6 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic7	UIC #7 user defined \| CHAR(1)	NULLABLE	STRING	1
cfuic8	UIC #8 user defined \| CHAR(1)	NULLABLE	STRING	1
cfpic1	PIC #1 programmer use \| CHAR(2)	NULLABLE	STRING	2
cfpic2	PIC #2 programmer use \| CHAR(2)	NULLABLE	STRING	2
cfpdt1	Programmer DATE #1 \| DEC(7,0)	NULLABLE	INTEGER	7
cfpd61	Programmer DATE #1 \| DEC(6,0)	NULLABLE	INTEGER	6
cfpdt2	Programmer DATE #2 \| DEC(7,0)	NULLABLE	INTEGER	7
cfpd62	Programmer DATE #2 \| DEC(6,0)	NULLABLE	INTEGER	6
cfpam1	Programmer AMT #1 \| DEC(13,2)	NULLABLE	FLOAT	13.2
cfpam2	Programmer AMT #2 \| DEC(13,2)	NULLABLE	FLOAT	13.2
cfgrp_num_	Related Group Number \| DEC(7,0)	NULLABLE	INTEGER	7
cfcfsd	Most Recent F/S date \| DEC(7,0)	NULLABLE	INTEGER	7
cfcfs6	Most Recent F/S date \| DEC(6,0)	NULLABLE	INTEGER	6
cfltdt	Last Letter Sent date \| DEC(7,0)	NULLABLE	INTEGER	7
cfltd6	Last Letter Sent date \| DEC(6,0)	NULLABLE	INTEGER	6
cfwrth	Net Worth \| DEC(9,0)	NULLABLE	INTEGER	9
cfwvcd	F/S Waive Code \| CHAR(1)	NULLABLE	STRING	1
cfwvdt	F/S Waive Date \| DEC(7,0)	NULLABLE	INTEGER	7
cfwvd6	F/S Waive Date \| DEC(6,0)	NULLABLE	INTEGER	6
cftxrt	TAX Return Date \| DEC(7,0)	NULLABLE	INTEGER	7
cftxr6	TAX Return Date \| DEC(6,0)	NULLABLE	INTEGER	6
cftxet	TAX Extension Date \| DEC(7,0)	NULLABLE	INTEGER	7
cftxe6	TAX Extension Date \| DEC(6,0)	NULLABLE	INTEGER	6
cfirsa	I R S Address \| CHAR(40)	NULLABLE	STRING	40
cfirsc	I R S City \| CHAR(20)	NULLABLE	STRING	20
cfirss	I R S State \| CHAR(2)	NULLABLE	STRING	2
cfirsz	I R S Zip \| DEC(9,0)	NULLABLE	INTEGER	9
cfirsd	IRS delivery point \| CHAR(2)	NULLABLE	STRING	2
cfirsf	IRS Foreign delvry point \| CHAR(40)	NULLABLE	STRING	40
cfcass	CASS certification flag \| CHAR(1)	NULLABLE	STRING	1
cfleas	Lease Security flag \| CHAR(1)	NULLABLE	STRING	1
cffax1	Fax number \| DEC(10,0)	NULLABLE	INTEGER	10
cffax2	Other fax number \| DEC(10,0)	NULLABLE	INTEGER	10
cfcel1	Cell phone number \| DEC(10,0)	NULLABLE	INTEGER	10
cfcel2	Other cell phone number \| DEC(10,0)	NULLABLE	INTEGER	10
cfeml1	E-mail address \| CHAR(80)	NULLABLE	STRING	80
cfeml2	Other e-mail address \| CHAR(80)	NULLABLE	STRING	80
cfregp	Privacy Act opt out \| CHAR(1)	NULLABLE	STRING	1
cfrpd6	Privacy Act last notice sent date \| DEC(6,0)	NULLABLE	INTEGER	6
cfrpd7	Privacy Act last notice sent date \| DEC(7,0)	NULLABLE	INTEGER	7
cfnocall	CIF Do Not Call Flag \| CHAR(1)	NULLABLE	STRING	1
cfnclex6	CIF Do Not Call Flag Expiration Date 6 \| DEC(6,0)	NULLABLE	INTEGER	6
cfnclex7	CIF Do Not Call Flag Expiration Date 7 \| DEC(7,0)	NULLABLE	INTEGER	7
cfrskrt	CIF Risk Rating \| CHAR(6)	NULLABLE	STRING	6
cfrskd6	CIF Risk Rating Date \| DEC(6,0)	NULLABLE	INTEGER	6
cfrskd7	CIF Risk Rating Date \| DEC(7,0)	NULLABLE	INTEGER	7
cfrskby	CIF Risk Rated by Code \| CHAR(6)	NULLABLE	STRING	6
cfocpcd	CIF Occupation Code \| CHAR(50)	NULLABLE	STRING	50
cfaflopt	Affiliate Opt Out \| CHAR(1)	NULLABLE	STRING	1
cfaflexd6	Affiliate Opt Out Expiration Date \| DEC(6,0)	NULLABLE	INTEGER	6
cfaflexd7	Affiliate Opt Out Expiration Date \| DEC(7,0)	NULLABLE	INTEGER	7
cfaflecd6	Affiliate Opt Out Exception Date \| DEC(6,0)	NULLABLE	INTEGER	6
cfaflecd7	Affiliate Opt Out Exception Date \| DEC(7,0)	NULLABLE	INTEGER	7
cfaflexcd	Affiliate Opt Out Exception Code \| CHAR(2)	NULLABLE	STRING	2
salescf	CIF Sales Associate Code \| CHAR(15)	NULLABLE	STRING	15
cfbphx	Business Phone Extension \| DEC(6,0)	NULLABLE	INTEGER	6
cflang	Language Identifier \| CHAR(3)	NULLABLE	STRING	3
cfforc	Foreign Country \| CHAR(50)	NULLABLE	STRING	50
cfirsfc	IRS Foreign Country \| CHAR(50)	NULLABLE	STRING	50
cfaedt6	Alien Cert. Expiration \| DEC(6,0)	NULLABLE	INTEGER	6
cfaedat	Alien Cert. Expiration \| DEC(7,0)	NULLABLE	INTEGER	7
w8stat	W8 Status Code \| CHAR(1)	NULLABLE	STRING	1
w8type	W8 Type Code \| CHAR(3)	NULLABLE	STRING	3
w8lldt6	Date of Last W8 Letter \| DEC(6,0)	NULLABLE	INTEGER	6
w8lldat	Date of Last W8 Letter \| DEC(7,0)	NULLABLE	INTEGER	7
w8sts	W8 Programer Use \| DEC(1,0)	NULLABLE	INTEGER	1
cfdto6	Date entered \| DEC(6,0)	NULLABLE	INTEGER	6
cfdto7	Date entered \| DEC(7,0)	NULLABLE	INTEGER	7
cfpfa1	Phys Addr Line 1 \| CHAR(40)	NULLABLE	STRING	40
cfpfa2	Phys Addr Line 2 \| CHAR(40)	NULLABLE	STRING	40
cfpfcy	Phys Addr City \| CHAR(20)	NULLABLE	STRING	20
cfpfst	Phys Addr State \| CHAR(2)	NULLABLE	STRING	2
cfpfzc	Phys Addr Zip \| DEC(9,0)	NULLABLE	INTEGER	9
cfpfdp	Phys Addr Deliv Pt \| CHAR(2)	NULLABLE	STRING	2
cfdlac6	Date Last Contact \| DEC(6,0)	NULLABLE	INTEGER	6
cfdlac7	Date Last Contact \| DEC(7,0)	NULLABLE	INTEGER	7
cfpffd	Phys Addr Foreign Addr \| CHAR(40)	NULLABLE	STRING	40
cfpffc	Phys Addr Foreign Cntry \| CHAR(50)	NULLABLE	STRING	50
cfpffr	Phys Addr Foreign Flag \| CHAR(1)	NULLABLE	STRING	1
cftinmatch	IRS TIN Match Flag \| CHAR(1)	NULLABLE	STRING	1
cfmast_id	Unique row ID \| BIGINT(8)	NULLABLE	INTEGER	8
cfmcrtts	Row create timestamp \| TIMESTAMP LEN(26)	NULLABLE	STRING	26
cfmmntts	Row last maint timestamp \| TIMESTAMP LEN(26)	NULLABLE	STRING	26

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed Mar 4 2026