jhdata_raw
Core Schemas
>
Silverlake
>
jhdata_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 | |
| jdstat | Information status | CHAR(1) | NULLABLE | STRING | 1 |
| jdbank | Bank number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| jdbr | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| jdname | Bank/branch name | CHAR(30) | NULLABLE | STRING | 30 |
| jdaddr | Address | CHAR(30) | NULLABLE | STRING | 30 |
| jdcsz | City state zip code | CHAR(30) | NULLABLE | STRING | 30 |
| jdtax_num_ | Taxpayer ID # | DEC(9,0) | NULLABLE | INTEGER | 9 |
| jdtele | Telephone number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| jdregn | Region number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| jdstan | State ID # | DEC(2,0) | NULLABLE | INTEGER | 2 |
| jdtren | Year end | DEC(4,0) | NULLABLE | INTEGER | 4 |
| jdwken | Week ending day | CHAR(9) | NULLABLE | STRING | 9 |
| jdbran | Branch accounting | CHAR(1) | NULLABLE | STRING | 1 |
| jdcutm | Branch cutoff time MON | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcutt | Branch cutoff time TUE | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcutw | Branch cutoff time WED | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcuth | Branch cutoff time THR | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcutf | Branch cutoff time FRI | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcuts | Branch cutoff time SAT | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdcutu | Branch cutoff time SUN | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jdlead | Bank check lead days | DEC(1,0) | NULLABLE | INTEGER | 1 |
| jdmodd | Demand modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmods | Savings modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodx | Club modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodt | Time modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodl | Loan modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodg | G/L modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodo | ODP modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdmodb | Safe Deposit modulus | CHAR(8) | NULLABLE | STRING | 8 |
| jdstax | Sales tax | CHAR(10) | NULLABLE | STRING | 10 |
| jhdata_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| jhdcrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| jhdmntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024