cdpar2_raw
Core Schemas
>
Silverlake
>
cdpar2_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 | |
| p2brno | Branch Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2regn | Region Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2xrfnbr | ARGO NUMBER | DEC(4,0) | NULLABLE | INTEGER | 4 |
| ptype | CD Type | CHAR(2) | NULLABLE | STRING | 2 |
| pdesc | Type Description | CHAR(20) | NULLABLE | STRING | 20 |
| pgroup | Group Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pgrpds | Group Description | CHAR(20) | NULLABLE | STRING | 20 |
| p2cost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| p2prod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2iqnm | Inquiry Name | CHAR(8) | NULLABLE | STRING | 8 |
| pcterm | CD Term | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pccode | CD Term Code | CHAR(1) | NULLABLE | STRING | 1 |
| piterm | Interest Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
| picode | Interest Term Code | CHAR(1) | NULLABLE | STRING | 1 |
| pmethd | Accrual Method | CHAR(1) | NULLABLE | STRING | 1 |
| pyrcod | Year Base Code | DEC(1,0) | NULLABLE | INTEGER | 1 |
| pevenc | Even Payments Code | CHAR(1) | NULLABLE | STRING | 1 |
| prate | Min interest rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| pratem | Max interest rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| prate_num_ | Variable Rate Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt2 | Balance Tier #2 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat2_num_ | Variable Rate #2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt3 | Balance Tier #3 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat3_num_ | Variable Rate #3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt4 | Balance Tier #4 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat4_num_ | Variable Rate #4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt5 | Balance Tier #5 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat5_num_ | Variable Rate #5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt6 | Balance Tier #6 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat6_num_ | Variable Rate #6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt7 | Balance Tier #7 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat7_num_ | Variable Rate #7 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt8 | Balance Tier #8 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat8_num_ | Variable Rate #8 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt9 | Balance Tier #9 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat9_num_ | Variable Rate #9 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pblrt0 | Balance Tier #10 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prat0_num_ | Variable Rate #10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| spltac | Split Acc Method? | CHAR(1) | NULLABLE | STRING | 1 |
| prenew | Renewable Code | CHAR(1) | NULLABLE | STRING | 1 |
| prnrt1 | Renewal Rate 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl2 | Renewal Amount 2 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt2 | Renewal Rate 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl3 | Renewal Amount 3 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt3 | Renewal Rate 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl4 | Renewal Amount 4 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt4 | Renewal Rate 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl5 | Renewal Amount 5 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt5 | Renewal Rate 5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl6 | Renewal Amount 6 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt6 | Renewal Rate 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl7 | Renewal Amount 7 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt7 | Renewal Rate 7 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl8 | Renewal Amount 8 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt8 | Renewal Rate 8 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl9 | Renewal Amount 9 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt9 | Renewal Rate 9 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnbl0 | Renewal Amount 10 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| prnrt0 | Renewal Rate 10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| prnnot | Print Renewal Notices | CHAR(1) | NULLABLE | STRING | 1 |
| prngrc | Grace Days Auto Renewal | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pb4rnw | # days for Renewal notc | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pb4mat | # days for maturity notc | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2esch | # days Escheat | DEC(5,0) | NULLABLE | INTEGER | 5 |
| piraty | IRA Type | CHAR(1) | NULLABLE | STRING | 1 |
| pidisp | Interest disposition | CHAR(1) | NULLABLE | STRING | 1 |
| pcomck | Combined int checks | CHAR(1) | NULLABLE | STRING | 1 |
| ppenty | Penalty type | CHAR(2) | NULLABLE | STRING | 2 |
| ppen59 | Calc Penalty aft 59 1/2 | CHAR(1) | NULLABLE | STRING | 1 |
| pwhcod | W/H code | DEC(1,0) | NULLABLE | INTEGER | 1 |
| pinclu | Exclude from stmt | CHAR(1) | NULLABLE | STRING | 1 |
| phmail | Hold mail | CHAR(1) | NULLABLE | STRING | 1 |
| pmatco | Maturity Date Required | CHAR(1) | NULLABLE | STRING | 1 |
| pstmtc | Statement Code | CHAR(1) | NULLABLE | STRING | 1 |
| palmty | ALM Type | CHAR(1) | NULLABLE | STRING | 1 |
| ppaple | Paperless Code | CHAR(1) | NULLABLE | STRING | 1 |
| ppalas | Pay accrued last Payment | CHAR(1) | NULLABLE | STRING | 1 |
| pratsc | Rate Schedule Code | CHAR(1) | NULLABLE | STRING | 1 |
| palnxt | Allow int date Past Mat | CHAR(1) | NULLABLE | STRING | 1 |
| pstmpa | Stmt/passbook code | CHAR(1) | NULLABLE | STRING | 1 |
| psic1 | SIC #1 | CHAR(1) | NULLABLE | STRING | 1 |
| psic2 | SIC #2 | CHAR(1) | NULLABLE | STRING | 1 |
| psic3 | SIC #3 | CHAR(1) | NULLABLE | STRING | 1 |
| psic4 | SIC #4 | CHAR(1) | NULLABLE | STRING | 1 |
| pexday | Forcast Extra Day | CHAR(1) | NULLABLE | STRING | 1 |
| pmldrt | Use Multi Deposit Rates | CHAR(1) | NULLABLE | STRING | 1 |
| pflcod | First-Last Rate On W/D | CHAR(1) | NULLABLE | STRING | 1 |
| p2stmd | Statement Description | CHAR(30) | NULLABLE | STRING | 30 |
| p2mndw | Mandatory WD of Int | CHAR(1) | NULLABLE | STRING | 1 |
| p2papy | Print APY Info | CHAR(1) | NULLABLE | STRING | 1 |
| pvrapy | Primary Var APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv2apy | Var Tier 2 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv3apy | Var Tier 3 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv4apy | Var Tier 4 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv5apy | Var Tier 5 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv6apy | Var Tier 6 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv7apy | Var Tier 7 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv8apy | Var Tier 8 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv9apy | Var Tier 9 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pv0apy | Var Tier 10 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| prnapy | Primary Renewal APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr2apy | Renewal Tier 2 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr3apy | Renewal Tier 3 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr4apy | Renewal Tier 4 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr5apy | Renewal Tier 5 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr6apy | Renewal Tier 6 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr7apy | Renewal Tier 7 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr8apy | Renewal Tier 8 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr9apy | Renewal Tier 9 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| pr0apy | Renewal Tier 10 APY | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| apybal | Maximum Bal for APY | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| p2lead | Check Lead Days | DEC(1,0) | NULLABLE | INTEGER | 1 |
| p2clsa | Closing Accrual/Suspense Difference | CHAR(1) | NULLABLE | STRING | 1 |
| p2apyt | APY Override Term | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2apyc | APY Override Term Code | CHAR(1) | NULLABLE | STRING | 1 |
| p2fnda | Check Funding Dep acct# | DEC(16,0) | NULLABLE | INTEGER | 16 |
| p2fndt | Check Funding Dep type | CHAR(1) | NULLABLE | STRING | 1 |
| p2100k | RECLASS CD Under 100K | CHAR(1) | NULLABLE | STRING | 1 |
| p2100t | RECLASS CD TYPE | CHAR(2) | NULLABLE | STRING | 2 |
| p2250k | RECLASS CD OVER 250K | CHAR(1) | NULLABLE | STRING | 1 |
| p2250t | RECLASS CD TYPE > 250K | CHAR(2) | NULLABLE | STRING | 2 |
| p2call | Call Report Code | CHAR(8) | NULLABLE | STRING | 8 |
| p2okar | Oakar Account Flag | CHAR(1) | NULLABLE | STRING | 1 |
| p2oins | Oakar Sold FDIC insure | CHAR(1) | NULLABLE | STRING | 1 |
| p2bif | BIF Member | CHAR(1) | NULLABLE | STRING | 1 |
| p2saif | SAIF Member | CHAR(1) | NULLABLE | STRING | 1 |
| p2fdic | Sold to FDIC Member | CHAR(1) | NULLABLE | STRING | 1 |
| p2dlyd | Delay interest # days | DEC(2,0) | NULLABLE | INTEGER | 2 |
| p2rsch | Rate Schedule | CHAR(10) | NULLABLE | STRING | 10 |
| p2dormd | # days till Dormant | DEC(5,0) | NULLABLE | INTEGER | 5 |
| p2dorr_num_ | skp rnw for Dormant | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2dorrn | count RN for Dormant | CHAR(1) | NULLABLE | STRING | 1 |
| p2rnag | Ren Rate Chg after grace | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024