lnparq_raw
Core Schemas
>
Silverlake
>
lnparq_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 | |
| pqfee_num_ | FEE NUMBER | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqtype | LOAN TYPE | CHAR(2) | NULLABLE | STRING | 2 |
| pqstmd | STATEMENT DESCRIPTION | CHAR(30) | NULLABLE | STRING | 30 |
| pqcptl | CAPITALIZED | CHAR(1) | NULLABLE | STRING | 1 |
| pqacap | ACCRUE ON CAPITALIZED | CHAR(1) | NULLABLE | STRING | 1 |
| pqcapb | CAPITALIZE WHEN BILLED | CHAR(1) | NULLABLE | STRING | 1 |
| pqothp | Collect Chgs at payoff | CHAR(1) | NULLABLE | STRING | 1 |
| pqcptc | CAPITALIZING TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqrvtc | REVERSE CPTL TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqpmtc | SPLIT PAYMENT TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqrptc | REVERSE PMT TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqwvtc | WAIVE TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqpatc | PAY ASSESSED TRAN CODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqibas | INTEREST BASE | DEC(1,0) | NULLABLE | INTEGER | 1 |
| pqrat_num_ | RATE NUMBER | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqrat2 | RATE FOR BALANCE 2 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal2 | BALANCE FOR RATE 2 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat3 | RATE FOR BALANCE 3 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal3 | BALANCE FOR RATE 3 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat4 | RATE FOR BALANCE 4 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal4 | BALANCE FOR RATE 4 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat5 | RATE FOR BALANCE 5 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal5 | BALANCE FOR RATE 5 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat6 | RATE FOR BALANCE 6 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal6 | BALANCE FOR RATE 6 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat7 | RATE FOR BALANCE 7 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal7 | BALANCE FOR RATE 7 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat8 | RATE FOR BALANCE 8 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal8 | BALANCE FOR RATE 8 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat9 | RATE FOR BALANCE 9 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal9 | BALANCE FOR RATE 9 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqrat0 | RATE FOR BALANCE 10 | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqbal0 | BALANCE FOR RATE 10 | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqatyp | ACCRUAL TYPE | CHAR(1) | NULLABLE | STRING | 1 |
| pqaspl | USE SPLIT RATE ACCRUALS | CHAR(1) | NULLABLE | STRING | 1 |
| pqmxbl | MAX BALANCE TO ACCRUE | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqfamt | FEE AMOUNT | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| pqfdol | ADV DOLLARS TO CHG FEE | DEC(9,0) | NULLABLE | INTEGER | 9 |
| pqfpct | CHARGE PERCENTAGE | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| pqfmin | CHARGE MININUM AMT | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| pqfmax | CHARGE MAXIMUM AMT | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| pqgrbr | GL RCV BRANCH | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqglr_num_ | GL RCV ACCOUNT | DEC(7,0) | NULLABLE | INTEGER | 7 |
| pqgrcs | GL RCV COST CENTER | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pqgrpr | GL RCV PROD CODE | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqrds1 | GL RCV DESCRIPTION 1 | CHAR(40) | NULLABLE | STRING | 40 |
| pqrds2 | GL RCV DESCRIPTION 2 | CHAR(40) | NULLABLE | STRING | 40 |
| pqrds3 | GL RCV DESCRIPTION 3 | CHAR(40) | NULLABLE | STRING | 40 |
| pqrds4 | GL RCV DESCRIPTION 4 | CHAR(40) | NULLABLE | STRING | 40 |
| pqgibr | GL INC BRANCH | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqgli_num_ | GL INC ACCOUNT | DEC(7,0) | NULLABLE | INTEGER | 7 |
| pqgics | GL INC COST CENTER | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pqgipr | GL INC PROD CODE | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqids1 | GL INC DESCRIPTION 1 | CHAR(40) | NULLABLE | STRING | 40 |
| pqids2 | GL INC DESCRIPTION 2 | CHAR(40) | NULLABLE | STRING | 40 |
| pqids3 | GL INC DESCRIPTION 3 | CHAR(40) | NULLABLE | STRING | 40 |
| pqids4 | GL INC DESCRIPTION 4 | CHAR(40) | NULLABLE | STRING | 40 |
| pqreoccur | REOCCURING FEE? | CHAR(1) | NULLABLE | STRING | 1 |
| pqinclpmt | INCLUDE FEE IN SCHED PMT AMOUNT | CHAR(1) | NULLABLE | STRING | 1 |
| pqfreq | DEFAULT REOCCUR FREQUENCY | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqfreqcd | DEFAULT REOCCUR FREQUENCY CODE | CHAR(1) | NULLABLE | STRING | 1 |
| pqsemdy1 | DEFAULT SEMI MONTHLY 1ST DAY | DEC(2,0) | NULLABLE | INTEGER | 2 |
| pqsemdy2 | DEFAULT SEMI MONTHLY 2ST DAY | DEC(2,0) | NULLABLE | INTEGER | 2 |
| pqassestc | ASSESSING TRANCODE | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqreassopt | DEFAULT ASSET OPTION | CHAR(1) | NULLABLE | STRING | 1 |
| pqaprc | Include in APR Calc | CHAR(1) | NULLABLE | STRING | 1 |
| pqinclfc | Include in Finance Chg | CHAR(1) | NULLABLE | STRING | 1 |
| pqrutc | Uncap fee Payment Reversal T/C | DEC(5,0) | NULLABLE | INTEGER | 5 |
| pqrcvinfe | Shadow Fee Recovered as Income/Fee | CHAR(1) | NULLABLE | STRING | 1 |
| pqincrglp | Increase GL Prin for Cap Fees | CHAR(1) | NULLABLE | STRING | 1 |
| pqshgbr | Shadow GL Branch | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqshac_num_ | Shadow GL Account Number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| pqshcs | Shadow GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pqshpc | Shadow GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pqsds2 | Shadow GL Description 2 | CHAR(40) | NULLABLE | STRING | 40 |
| pqfcalc | Default Fee Calc Code | CHAR(3) | NULLABLE | STRING | 3 |
| pqredom | Default reoccur freq day of month | DEC(2,0) | NULLABLE | INTEGER | 2 |
| pqsfbasis | Shadow Fee Basis | CHAR(1) | NULLABLE | STRING | 1 |
| pqsfeerseq | Shadow Fee Recovery Sequence | DEC(4,0) | NULLABLE | INTEGER | 4 |
| pqrowid | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| pqcrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| pqmntts | Row maintenance 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