cfpard_raw
Core Schemas
>
Silverlake
>
cfpard_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 | |
| appcod | Application Code | CHAR(1) | NULLABLE | STRING | 1 |
| appdes | Description | CHAR(20) | NULLABLE | STRING | 20 |
| appdol | Deposit or Loan totals | CHAR(1) | NULLABLE | STRING | 1 |
| appinq | Inquiry Type | CHAR(8) | NULLABLE | STRING | 8 |
| p2cost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| p2prod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| appdt1 | Date #1 Description | CHAR(20) | NULLABLE | STRING | 20 |
| usedf1 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appdt2 | Date #2 Description | CHAR(20) | NULLABLE | STRING | 20 |
| usedf2 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appdt3 | Date #3 Description | CHAR(20) | NULLABLE | STRING | 20 |
| usedf3 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appdt4 | Date #4 Description | CHAR(20) | NULLABLE | STRING | 20 |
| usedf4 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appds5 | Date #5 Description | CHAR(20) | NULLABLE | STRING | 20 |
| usedf5 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| usedf6 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appds6 | Date #6 Description | CHAR(20) | NULLABLE | STRING | 20 |
| appam1 | Amount #1 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf1 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appam2 | Amount #2 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf2 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appam3 | Amount #3 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf3 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appam4 | Amount #4 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf4 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appam5 | Amount #5 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf5 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appam6 | Amount #6 Description | CHAR(20) | NULLABLE | STRING | 20 |
| useaf6 | Display In Stmt Summary | CHAR(1) | NULLABLE | STRING | 1 |
| appdc1 | Amount #1 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| appdc2 | Amount #2 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| appdc3 | Amount #3 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| appdc4 | Amount #4 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| appdc5 | Amount #5 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| appdc6 | Amount #6 Decimal | DEC(1,0) | NULLABLE | INTEGER | 1 |
| apped1 | Amount #1 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| apped2 | Amount #2 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| apped3 | Amount #3 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| apped4 | Amount #4 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| apped5 | Amount #5 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| apped6 | Amount #6 Edit code | CHAR(1) | NULLABLE | STRING | 1 |
| appus1 | User field #1 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appus2 | User field #2 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appus3 | User field #3 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appus4 | User field #4 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appus5 | User field #5 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appus6 | User field #6 Desc | CHAR(20) | NULLABLE | STRING | 20 |
| appcom | Include Comb Stmt | CHAR(1) | NULLABLE | STRING | 1 |
| apppas | Passport Intergration | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024