| 1 |
portfolio_date |
timestamp without time zone |
|
| 2 |
id_number |
character varying |
50 |
| 3 |
account_number |
bigint |
64 |
| 4 |
source_system |
character varying |
4 |
| 5 |
broker_originated_flag |
character varying |
1 |
| 6 |
qrm_account |
character varying |
75 |
| 7 |
i_code |
character varying |
20 |
| 8 |
aggregator_name |
character varying |
256 |
| 9 |
a_code |
character varying |
20 |
| 10 |
broker_name |
character varying |
511 |
| 11 |
broker_state |
character varying |
20 |
| 12 |
settlement_date |
timestamp without time zone |
|
| 13 |
face_amt |
numeric |
15 |
| 14 |
origination_amount |
numeric |
15 |
| 15 |
origination_interest |
numeric |
15 |
| 16 |
origination_interest_amount |
numeric |
15 |
| 17 |
channel |
character varying |
100 |
| 18 |
refinancing_party |
character varying |
100 |
| 19 |
payout_classification |
character varying |
100 |
| 20 |
date_open |
timestamp without time zone |
|
| 21 |
date_closed |
timestamp without time zone |
|
| 22 |
payout_date |
timestamp without time zone |
|
| 23 |
age_days |
integer |
32 |
| 24 |
switched_period |
character varying |
50 |
| 25 |
payout |
numeric |
15 |