SLN_APPLICATION
Description
Synonyms
SDSNZP02_BANK..EFS_SLN_APPLICATION
SDSNZP02_BANK..UBAR_SLN_APPLICATION
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SLN_APPLICATION_HIID | BIGINT | 8 |
| 2 | ACTION_CODE | CHARACTER(1) | 1 |
| 3 | APPLN_ID | CHARACTER VARYING(20) | 20 |
| 4 | BANKING_TYPE | CHARACTER VARYING(60) | 60 |
| 5 | APPLN_URGENCY | NUMERIC(6,2) | 19 |
| 6 | BASE_LOAN_AMT | NUMERIC(13,2) | 19 |
| 7 | TOTAL_LOAN_AMT | NUMERIC(13,2) | 19 |
| 8 | PRE_APPRVD_FL | CHARACTER(1) | 1 |
| 9 | TOTAL_FUNDING_AMT | NUMERIC(13,2) | 19 |
| 10 | CREATION_DATE | TIMESTAMP | 8 |
| 11 | RECEIVED_DATE | TIMESTAMP | 8 |
| 12 | COND_APPROVED_DATE | TIMESTAMP | 8 |
| 13 | COND_APPROVED_OFFICER | CHARACTER VARYING(12) | 12 |
| 14 | UNCOND_APPROVED_DATE | TIMESTAMP | 8 |
| 15 | UNCOND_APPROVED_OFFICER | CHARACTER VARYING(12) | 12 |
| 16 | EST_SETTLEMENT_DATE | TIMESTAMP | 8 |
| 17 | EST_FINANCE_DATE | TIMESTAMP | 8 |
| 18 | EST_MDR_DATE | TIMESTAMP | 8 |
| 19 | BROKER_CODE | CHARACTER VARYING(20) | 20 |
| 20 | SALES_BRANCH_CODE | CHARACTER VARYING(5) | 5 |
| 21 | INITIATOR_IS_LENDER_FL | CHARACTER(1) | 1 |
| 22 | LENDER_ID | CHARACTER VARYING(12) | 12 |
| 23 | SUPP_OFFICER_ID | CHARACTER VARYING(12) | 12 |
| 24 | FIRST_HOME_BUYER_FL | CHARACTER(1) | 1 |
| 25 | CAMPAIGN_BENEFIT_FL | CHARACTER(1) | 1 |
| 26 | WORKFLOW_STAGE | CHARACTER VARYING(60) | 60 |
| 27 | WORKFLOW_STATUS | CHARACTER VARYING(60) | 60 |
| 28 | WORKFLOW_ACTION | CHARACTER VARYING(60) | 60 |
| 29 | CURR_WORKBASKET | CHARACTER VARYING(60) | 60 |
| 30 | CURR_OPERATOR_ID | CHARACTER VARYING(12) | 12 |
| 31 | ACCREDITED_BROKER_CODE | CHARACTER VARYING(7) | 7 |
| 32 | ELECTRONIC_LODGEMENT_NO | CHARACTER VARYING(30) | 30 |
| 33 | QUALITY_STANDARD_FLAG | CHARACTER VARYING(1) | 1 |
| 34 | QUALITY_REASONS | CHARACTER VARYING(100) | 100 |
| 35 | QUALITY_MEASURES_USER_ID | CHARACTER VARYING(50) | 50 |
| 36 | SETT_BRCH_CODE | CHARACTER VARYING(5) | 5 |
| 37 | HAS_SPLIT | CHARACTER VARYING(1) | 1 |
| 38 | TCE | NUMERIC(13,2) | 19 |
| 39 | EXCEPTION_REASON_1 | CHARACTER VARYING(10) | 10 |
| 40 | EXCEPTION_REASON_2 | CHARACTER VARYING(10) | 10 |
| 41 | EXCEPTION_REASON_3 | CHARACTER VARYING(10) | 10 |
| 42 | GROSS_OCCUPATION_INCOME | NUMERIC(13,2) | 19 |
| 43 | ASSET_INCOME | NUMERIC(13,2) | 19 |
| 44 | PROPOSED_INCOME | NUMERIC(13,2) | 19 |
| 45 | NON_TAXABLE_INCOME | NUMERIC(13,2) | 19 |
| 46 | DELTA_TYPE | CHARACTER VARYING(1) | 1 |
| 47 | EFFECTIVE_STRT_DT | TIMESTAMP | 8 |
| 48 | EFFECTIVE_END_DT | TIMESTAMP | 8 |
| 49 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 50 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 51 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 52 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |