hbmast_raw
Core Schemas
>
Silverlake
>
hbmast_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 | |
| cifno | CIF number | CHAR(7) | NULLABLE | STRING | 7 |
| hbcid | NetTeller ID | DEC(12,0) | NULLABLE | INTEGER | 12 |
| hbpin | PIN | CHAR(25) | NULLABLE | STRING | 25 |
| hbstat | Status | CHAR(1) | NULLABLE | STRING | 1 |
| accall | Access all accounts | CHAR(1) | NULLABLE | STRING | 1 |
| alwtfr | Allow transfers | CHAR(1) | NULLABLE | STRING | 1 |
| tfbyat | Transfer by account/type | CHAR(1) | NULLABLE | STRING | 1 |
| vwrate | View rates | CHAR(1) | NULLABLE | STRING | 1 |
| alwdwn | Allow downloads | CHAR(1) | NULLABLE | STRING | 1 |
| alwstm | Allow statements | CHAR(1) | NULLABLE | STRING | 1 |
| alwspi | Allow stop inquiry | CHAR(1) | NULLABLE | STRING | 1 |
| alwspa | Allow stop additions | CHAR(1) | NULLABLE | STRING | 1 |
| alprin | Allow principal | CHAR(1) | NULLABLE | STRING | 1 |
| alint | Allow interest | CHAR(1) | NULLABLE | STRING | 1 |
| vwdda | View demand accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwsav | View savings accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwxcl | View club accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwtim | View time accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwira | View IRA accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwloan | View loan accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwodp | View ODP accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwsdb | View SDB accounts | CHAR(1) | NULLABLE | STRING | 1 |
| vwnjha | View non-JHA accounts | CHAR(1) | NULLABLE | STRING | 1 |
| tfdddd | Transfer DD to DD | CHAR(1) | NULLABLE | STRING | 1 |
| tfddsv | Transfer DD to SV | CHAR(1) | NULLABLE | STRING | 1 |
| tfddxc | Transfer DD to XC | CHAR(1) | NULLABLE | STRING | 1 |
| tfddcd | Transfer DD to CD | CHAR(1) | NULLABLE | STRING | 1 |
| tfddln | Transfer DD to LN | CHAR(1) | NULLABLE | STRING | 1 |
| tfddod | Transfer DD to OD | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvdd | Transfer SV to DD | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvsv | Transfer SV to SV | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvxc | Transfer SV to XC | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvcd | Transfer SV to CD | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvln | Transfer SV to LN | CHAR(1) | NULLABLE | STRING | 1 |
| tfsvod | Transfer SV to OD | CHAR(1) | NULLABLE | STRING | 1 |
| tflndd | Transfer LN to DD | CHAR(1) | NULLABLE | STRING | 1 |
| tflnsv | Transfer LN to SV | CHAR(1) | NULLABLE | STRING | 1 |
| tflnxc | Transfer LN to XC | CHAR(1) | NULLABLE | STRING | 1 |
| tflncd | Transfer LN to CD | CHAR(1) | NULLABLE | STRING | 1 |
| tfoddd | Transfer OD to DD | CHAR(1) | NULLABLE | STRING | 1 |
| tfodsv | Transfer OD to SV | CHAR(1) | NULLABLE | STRING | 1 |
| tfodxc | Transfer OD to XC | CHAR(1) | NULLABLE | STRING | 1 |
| tfodcd | Transfer OD to CD | CHAR(1) | NULLABLE | STRING | 1 |
| firdt6 | First access date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| firdt7 | First access date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lacdt6 | Last access date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lacdt7 | Last access date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lactim | Last access time | DEC(6,0) | NULLABLE | INTEGER | 6 |
| maint6 | Last maintenance date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| maint7 | Last maintenance date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| signlf | Times signed on LTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
| signyr | Times signed on YTD | DEC(5,0) | NULLABLE | INTEGER | 5 |
| signcy | Times signed on cycle | DEC(5,0) | NULLABLE | INTEGER | 5 |
| hbrel1 | Relationship code 1 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel2 | Relationship code 2 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel3 | Relationship code 3 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel4 | Relationship code 4 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel5 | Relationship code 5 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel6 | Relationship code 6 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel7 | Relationship code 7 | CHAR(1) | NULLABLE | STRING | 1 |
| hbrel8 | Relationship code 8 | CHAR(1) | NULLABLE | STRING | 1 |
| E-mail address | CHAR(80) | NULLABLE | STRING | 80 | |
| typacc | Type of account | CHAR(1) | NULLABLE | STRING | 1 |
| cpacnm | ACH company name | CHAR(16) | NULLABLE | STRING | 16 |
| cpdfil | Download file name | CHAR(10) | NULLABLE | STRING | 10 |
| cpdtyp | Download file type | CHAR(1) | NULLABLE | STRING | 1 |
| cpdlpb | D/L prior day balance | CHAR(1) | NULLABLE | STRING | 1 |
| cpdlph | D/L prior day history | CHAR(1) | NULLABLE | STRING | 1 |
| cpdlcb | D/L current day balance | CHAR(1) | NULLABLE | STRING | 1 |
| cpupld | Allow upload | CHAR(1) | NULLABLE | STRING | 1 |
| pgdwnl | Upload download library | CHAR(10) | NULLABLE | STRING | 10 |
| feacct | Charge account | DEC(16,0) | NULLABLE | INTEGER | 16 |
| feacty | Charge account type | CHAR(1) | NULLABLE | STRING | 1 |
| feaitm | A/A item# | DEC(3,0) | NULLABLE | INTEGER | 3 |
| achac_num_ | Account for ACH charge | DEC(16,0) | NULLABLE | INTEGER | 16 |
| achaty | Acct. type for ACH chg | CHAR(1) | NULLABLE | STRING | 1 |
| achitm | ACH A/A item# | DEC(3,0) | NULLABLE | INTEGER | 3 |
| bairid | BAI receiver id | CHAR(9) | NULLABLE | STRING | 9 |
| baiuri | BAI ultimate receiver id | CHAR(9) | NULLABLE | STRING | 9 |
| msrnda | Statement retention | DEC(3,0) | NULLABLE | INTEGER | 3 |
| hbalsw | Allow sweep balances | CHAR(1) | NULLABLE | STRING | 1 |
| hbalop | Allow ODP balances | CHAR(1) | NULLABLE | STRING | 1 |
| hbalbp | Allow BP balances | CHAR(1) | NULLABLE | STRING | 1 |
| hbalol | Allow OD limit balance | CHAR(1) | NULLABLE | STRING | 1 |
| hbalmf | Allow MF balance | CHAR(1) | NULLABLE | STRING | 1 |
| hbsaft | Show AFT in transfers | CHAR(1) | NULLABLE | STRING | 1 |
| hbsraf | Show related AFT trans | CHAR(1) | NULLABLE | STRING | 1 |
| hbdycl | # days for closed accts | DEC(3,0) | NULLABLE | INTEGER | 3 |
| hbenot | Email not/stmt option | CHAR(1) | NULLABLE | STRING | 1 |
| hbalre | Allow rel. acct emails | CHAR(1) | NULLABLE | STRING | 1 |
| netchg | NetTeller hard charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| netchw | When to hard charge NetT | CHAR(1) | NULLABLE | STRING | 1 |
| achihc | ACH hard charge item# | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| achbat | ACH A/A batch | DEC(3,0) | NULLABLE | INTEGER | 3 |
| achbhc | ACH hard charge batch | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| achupl | ACH A/A upload | DEC(3,0) | NULLABLE | INTEGER | 3 |
| achuhc | ACH hard charge upload | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| hctime | When to hard charge | CHAR(1) | NULLABLE | STRING | 1 |
| hbalpb | Allow to pay bills | CHAR(1) | NULLABLE | STRING | 1 |
| hbbpty | Bill Pay type | CHAR(2) | NULLABLE | STRING | 2 |
| hbbpd6 | Org. date bill pay | DEC(6,0) | NULLABLE | INTEGER | 6 |
| hbbpd7 | Org. date bill pay | DEC(7,0) | NULLABLE | INTEGER | 7 |
| hbbpcy | Bill pay cycles | DEC(9,0) | NULLABLE | INTEGER | 9 |
| hbbpfr | # of free bill pay items | DEC(15,0) | NULLABLE | INTEGER | 15 |
| hbacst | Activity Status | CHAR(1) | NULLABLE | STRING | 1 |
| hbalwr | Allow Wires | CHAR(1) | NULLABLE | STRING | 1 |
| hbcmidno | Comp Lvl ID Number | DEC(12,0) | NULLABLE | INTEGER | 12 |
| hbavltab | AVL FUNDS LINK TABLE# | DEC(4,0) | NULLABLE | INTEGER | 4 |
| hbupdemail | Update CIF EMail | CHAR(1) | NULLABLE | STRING | 1 |
| hbavldsp | ACCT LIST TABLE# | DEC(4,0) | NULLABLE | INTEGER | 4 |
| hbavlbp | BP FUNDS TABLE# | DEC(4,0) | NULLABLE | INTEGER | 4 |
| hbavltrd | TRANSFER LINK TABLE# | DEC(4,0) | NULLABLE | INTEGER | 4 |
| mobemailnt | Mobile Email Address | CHAR(80) | NULLABLE | STRING | 80 |
| hbtextnot | Text not/stmt option | CHAR(1) | NULLABLE | STRING | 1 |
| hbalrtext | Allow rel. acct Texts | CHAR(1) | NULLABLE | STRING | 1 |
| hbaldliwr | Allow DLI Wires | CHAR(1) | NULLABLE | STRING | 1 |
| hbdlicomno | DLI Co Level ID Num | DEC(12,0) | NULLABLE | INTEGER | 12 |
| recuachitm | ReCur ACH A/A item# | DEC(3,0) | NULLABLE | INTEGER | 3 |
| recuachihc | Recu ACH hard chg itm# | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| recuachbat | ReCur ACH A/A batch | DEC(3,0) | NULLABLE | INTEGER | 3 |
| recuachbhc | ReCur ACH hard chg bat | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| achenlmt | Enforce NT ID ACH limit | CHAR(1) | NULLABLE | STRING | 1 |
| achprdalmt | Total ACH per Day limit | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| sdaachitm | Same Day ACH A/A item# | DEC(3,0) | NULLABLE | INTEGER | 3 |
| sdaachihc | S/D ACH hard chg item# | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| sdaachbat | Same Day ACH A/A batch | DEC(3,0) | NULLABLE | INTEGER | 3 |
| sdaachbhc | S/D ACH hard chg batch | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| userclass | User Classification | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024