cfmast_raw
Core Schemas
>
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 |
Last updated Thu Dec 12 2024