INT_OBP_EFS_MIGRATED_FACILITY_EOD_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | APPLICATION_FACILITY_EFS_DIM_ID | CHARACTER VARYING(93) | 93 |
| 2 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 3 | FACILITY_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | APPLICATION_ID | CHARACTER VARYING(50) | 50 |
| 5 | LATEST_BORROWER_ACCEPTANCE_DATE | TIMESTAMP | 8 |
| 6 | LASTEST_APPLICATION_RECEIVED_DATE | TIMESTAMP | 8 |
| 7 | LATEST_SETTLEMENT_DATE | TIMESTAMP | 8 |
| 8 | FIRST_HOME_BUYER_FLAG | CHARACTER VARYING(1) | 1 |
| 9 | FACILITY_MATURITY_DATE | TIMESTAMP | 8 |
| 10 | EFFECTIVE_START_DATE | TIMESTAMP | 8 |
| 11 | EFFECTIVE_END_DATE | TIMESTAMP | 8 |