ddparf_raw
Core Schemas
>
Silverlake
>
ddparf_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 | |
| pfcode | Fee code | CHAR(2) | NULLABLE | STRING | 2 |
| pfbr | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pfsc | Service charge code | CHAR(2) | NULLABLE | STRING | 2 |
| pfds1 | Fee description 1 | CHAR(30) | NULLABLE | STRING | 30 |
| pfds2 | Fee description 2 | CHAR(30) | NULLABLE | STRING | 30 |
| pfamt | Fee amount | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pfglbr | G/L offset branch | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pfglac | G/L offset account | DEC(7,0) | NULLABLE | INTEGER | 7 |
| pfglcc | G/L offset cost center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pfglpr | G/L offset product code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pfaait | Analysis item # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pfauto | Transaction Method | CHAR(1) | NULLABLE | STRING | 1 |
| pfdorc | Debit or Credit | CHAR(1) | NULLABLE | STRING | 1 |
| pfdeft | New account default | CHAR(1) | NULLABLE | STRING | 1 |
| pfoccstmt | Occurrence/Stmt code | CHAR(1) | NULLABLE | STRING | 1 |
| pfnumfree | Number free | DEC(2,0) | NULLABLE | INTEGER | 2 |
| refundfee | Fee being used as a refund | CHAR(1) | NULLABLE | STRING | 1 |
| pfnsfrvcd | NSF/OD Reversal code | CHAR(1) | NULLABLE | STRING | 1 |
| pfmina | Fee Minimum Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pfmaxa | Fee Maximum Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| pfovrcobal | Charge Off Bal affected | CHAR(1) | NULLABLE | STRING | 1 |
| ddparf_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| dpfcrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| dpfmntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024