hbacct_raw
Core Schemas
>
Silverlake
>
hbacct_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 | |
| hbcid | NetTeller ID | DEC(12,0) | NULLABLE | INTEGER | 12 |
| hbappl | Application | CHAR(1) | NULLABLE | STRING | 1 |
| hbact_num_ | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| hbatyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| hbsudo | Pseudo account number | CHAR(20) | NULLABLE | STRING | 20 |
| rfcif_num_ | Ref. CIF number | CHAR(7) | NULLABLE | STRING | 7 |
| rfact_num_ | Ref. Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| rfatyp | Ref. Account type | CHAR(1) | NULLABLE | STRING | 1 |
| rfrela | Ref. relationship | CHAR(5) | NULLABLE | STRING | 5 |
| hbira | IRA indicator | CHAR(1) | NULLABLE | STRING | 1 |
| sortac | Sort order | DEC(3,0) | NULLABLE | INTEGER | 3 |
| stopaa | Add stops AA counter | DEC(3,0) | NULLABLE | INTEGER | 3 |
| stophc | Add stops hard charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| tranaa | Transfer AA counter | DEC(3,0) | NULLABLE | INTEGER | 3 |
| tranhc | Transfer hard charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| stmtaa | Demand stmt AA counter | DEC(3,0) | NULLABLE | INTEGER | 3 |
| stmthc | Demand stmt hard charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| whenhc | When to hard charge | CHAR(1) | NULLABLE | STRING | 1 |
| allowp | Allow principal | CHAR(1) | NULLABLE | STRING | 1 |
| allowi | Allow interest | CHAR(1) | NULLABLE | STRING | 1 |
| opts | Sorted options to use | CHAR(36) | NULLABLE | STRING | 36 |
Last updated Thu Dec 12 2024