ddaap2_raw
Core Schemas
>
Silverlake
>
ddaap2_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 | |
| aatype | A/A Type | CHAR(2) | NULLABLE | STRING | 2 |
| aatdes | Type Description | CHAR(30) | NULLABLE | STRING | 30 |
| amaint | Maint Fee | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| afrat | FDIC Ins Rate | DEC(9,7) | NULLABLE | FLOAT | 9.7 |
| aftyp | FDIC Ins Bal Type | CHAR(1) | NULLABLE | STRING | 1 |
| arrat | Reserve Rate | DEC(5,3) | NULLABLE | FLOAT | 5.3 |
| aerat | Earnings Pos Rate | DEC(8,6) | NULLABLE | FLOAT | 8.6 |
| aodrat | Overdraft Rate | DEC(5,3) | NULLABLE | FLOAT | 5.3 |
| amincg | Minimum Charge | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| anrat | Earnings Neg Rate | DEC(8,6) | NULLABLE | FLOAT | 8.6 |
| aprsc | Print Ser Chg | CHAR(1) | NULLABLE | STRING | 1 |
| aprin | Print Interest | CHAR(1) | NULLABLE | STRING | 1 |
| afirst | Print 1st Stmt | CHAR(1) | NULLABLE | STRING | 1 |
| pcycle | Cycle Day | DEC(2,0) | NULLABLE | INTEGER | 2 |
| pcfreq | Cycle Frequency | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pcfrcd | Cycle Freq Code | CHAR(1) | NULLABLE | STRING | 1 |
| pcovr | Carry Over | DEC(2,0) | NULLABLE | INTEGER | 2 |
| pform | Print A/A Form | CHAR(1) | NULLABLE | STRING | 1 |
| prept | Print Report | CHAR(1) | NULLABLE | STRING | 1 |
| ploss | Charge Loss | CHAR(1) | NULLABLE | STRING | 1 |
| pitm1 | Auto Item 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp1 | Auto Type 1 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm2 | Auto Item 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp2 | Auto Type 2 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm3 | Auto Item 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp3 | Auto Type 3 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm4 | Auto Item 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp4 | Auto Type 4 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm5 | Auto Item 5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp5 | Auto Type 5 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm6 | Auto Item 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp6 | Auto Type 6 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm7 | Auto Item 7 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp7 | Auto Type 7 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm8 | Auto Item 8 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp8 | Auto Type 8 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm9 | Auto Item 9 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp9 | Auto Type 9 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm10 | Auto Item 10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp10 | Auto Type 10 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm11 | Auto Item 11 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp11 | Auto Type 11 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm12 | Auto Item 12 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp12 | Auto Type 12 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm13 | Auto Item 13 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp13 | Auto Type 13 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm14 | Auto Item 14 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp14 | Auto Type 14 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm15 | Auto Item 15 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp15 | Auto Type 15 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm16 | Auto Item 16 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp16 | Auto Type 16 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm17 | Auto Item 17 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp17 | Auto Type 17 | CHAR(2) | NULLABLE | STRING | 2 |
| pitm18 | Auto Item 18 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| ptyp18 | Auto Type 18 | CHAR(2) | NULLABLE | STRING | 2 |
| p2exd7 | Expiration Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| p2exd6 | Expiration Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| p2aurv | Auto revert after expire | CHAR(1) | NULLABLE | STRING | 1 |
| p2rvtp | Auto revert A/A type | CHAR(2) | NULLABLE | STRING | 2 |
| p2tpdy | Nbr days to retain type | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2biln | Create billing notice | CHAR(1) | NULLABLE | STRING | 1 |
| p2dued | Nbr days after bill for due date | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2psd1 | Nbr days for 1st past due notice | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2psd2 | Nbr days for 2nd past due notice | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2tierpos | Use tiered Balance POS | CHAR(1) | NULLABLE | STRING | 1 |
| p2tierneg | Use tiered Balance NEG | CHAR(1) | NULLABLE | STRING | 1 |
| p2balge1 | Balance GE for tier 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balge2 | Balance GE for tier 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balge3 | Balance GE for tier 3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balge4 | Balance GE for tier 4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balge5 | Balance GE for tier 5 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2ratege1 | Master rate for GE tier1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratege2 | Master rate for GE tier2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratege3 | Master rate for GE tier3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratege4 | Master rate for GE tier4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratege5 | Master rate for GE tier5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2balle1 | Balance LE for tier 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balle2 | Balance LE for tier 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balle3 | Balance LE for tier 3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balle4 | Balance LE for tier 4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2balle5 | Balance LE for tier 5 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2ratele1 | Master rate for LE tier1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratele2 | Master rate for LE tier2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratele3 | Master rate for LE tier3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratele4 | Master rate for LE tier4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2ratele5 | Master rate for LE tier5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| calcsep | Calc Pos/Neg Separately | CHAR(1) | NULLABLE | STRING | 1 |
| p2afrat_num_ | FDIC Insurance Rate | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2arrat_num_ | Reserve Rate Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aerat_num_ | Avg Coll earn cr rate Nbr | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2anrat_num_ | Neg Avg Col chg rate Nbr | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aodrat_num_ | Overdraft int rate Nbr | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aeratvar | Earn cr rate variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2aeratvcd | Earn cr rate variance code | CHAR(1) | NULLABLE | STRING | 1 |
| p2aeratflr | Earnings cr rate floor | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2aeratcei | Earnings cr rate ceiling | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2anratvar | Neg chg rate variance | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2anratvcd | Neg chg rate variance code | CHAR(1) | NULLABLE | STRING | 1 |
| p2anratflr | Negative chg rate floor | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2anratcei | Negative chg rate ceiling | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| pstmtopt | Send A/A Stmt to Optical | CHAR(1) | NULLABLE | STRING | 1 |
| pstmtnt | Send A/A Stmt to NetTeller | CHAR(1) | NULLABLE | STRING | 1 |
| pstmtprft | Print A/A Profit Stmt | CHAR(1) | NULLABLE | STRING | 1 |
| pstmtloss | Print A/A Loss Stmt | CHAR(1) | NULLABLE | STRING | 1 |
| p2anaplan | Analysis Plan | DEC(1,0) | NULLABLE | INTEGER | 1 |
| p2_num_daysaa | Nbr Days Auto Advance | DEC(2,0) | NULLABLE | INTEGER | 2 |
| p2_num_mntshd | Nbr Months Historical Data | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2wv_num_cyc | Nbr Cycles Waive Charge | DEC(3,0) | NULLABLE | INTEGER | 3 |
| afbal | FDIC Ins Max Balance | DEC(11,0) | NULLABLE | INTEGER | 11 |
| afrate | FDIC Excess Ins Rate | DEC(9,7) | NULLABLE | FLOAT | 9.7 |
| p2afrate_num_ | FDIC Excess Ins Rate | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aprcyend | Auto Process A/A at Cycle End | CHAR(1) | NULLABLE | STRING | 1 |
| p2apintexe | Pay Interest on Excess Earnings | CHAR(1) | NULLABLE | STRING | 1 |
| p2aexetbl1 | Excess Earnings Balance LE for Tier 1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2aexetrt1 | Excess Earnings Master rate for LE Tier 1 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aexetbl2 | Excess Earnings Balance LE for Tier 2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2aexetrt2 | Excess Earnings Master rate for LE Tier 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aexetbl3 | Excess Earnings Balance LE for Tier 3 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2aexetrt3 | Excess Earnings Master rate for LE Tier 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aexetbl4 | Excess Earnings Balance LE for Tier 4 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2aexetrt4 | Excess Earnings Master rate for LE Tier 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aexetbl5 | Excess Earnings Balance LE for Tier 5 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| p2aexetrt5 | Excess Earnings Master rate for LE Tier 5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| p2aadscamt | Discount Amount | DEC(7,2) | NULLABLE | FLOAT | 7.2 |
| p2aadscprc | Discount Percentage | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| p2aadscexp | Discount Expiration Date | DATE(4) | NULLABLE | STRING | 4 |
| ddacolid | Unique Row Id | BIGINT(8) | NULLABLE | INTEGER | 8 |
| ddacrtts | Row Create Timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| ddamntts | Row Last Maint Timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Thu Dec 12 2024