SLN_APPLICATION_MASTER
Description
Synonyms
SDSNZP02_BANK..AS516_SLN_APPLICATION_MASTER
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | 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 | TRF_INSERT_DATE | TIMESTAMP | 8 |
| 32 | ACCREDITED_BROKER_CODE | CHARACTER VARYING(10) | 10 |
| 33 | BUS_DATE | TIMESTAMP | 8 |
| 34 | ELECTRONIC_LODGEMENT_NO | CHARACTER VARYING(30) | 30 |
| 35 | QUALITY_STANDARD_FLAG | CHARACTER VARYING(1) | 1 |
| 36 | QUALITY_REASONS | CHARACTER VARYING(100) | 100 |
| 37 | QUALITY_MEASURES_USER_ID | CHARACTER VARYING(50) | 50 |
| 38 | SETT_BRCH_CODE | CHARACTER VARYING(5) | 5 |
| 39 | HAS_SPLIT | CHARACTER(1) | 1 |
| 40 | TCEY | NUMERIC(13,2) | 19 |
| 41 | EXCEPTION_REASON_1 | CHARACTER VARYING(10) | 10 |
| 42 | EXCEPTION_REASON_2 | CHARACTER VARYING(10) | 10 |
| 43 | EXCEPTION_REASON_3 | CHARACTER VARYING(10) | 10 |
| 44 | GROSS_OCCUPATION_INCOME | NUMERIC(13,2) | 19 |
| 45 | ASSET_INCOME | NUMERIC(13,2) | 19 |
| 46 | PROPOSED_INCOME | NUMERIC(13,2) | 19 |
| 47 | NON_TAXABLE_INCOME | NUMERIC(13,2) | 19 |
| 48 | HH1_NO_OF_ADULT | INTEGER | 4 |
| 49 | HH1_NO_OF_DEPENDENTS | INTEGER | 4 |
| 50 | HH2_NO_OF_ADULT | INTEGER | 4 |
| 51 | HH2_NO_OF_DEPENDENTS | INTEGER | 4 |
| 52 | NO_OF_HOUSEHOLD | INTEGER | 4 |
| 53 | HH1_CUST_ENTERED_EXPENSE | NUMERIC(13,2) | 19 |
| 54 | HH1_CTR_CALCULATED_EXPENSE | NUMERIC(13,2) | 19 |
| 55 | HH2_CUST_ENTERED_EXPENSE | NUMERIC(13,2) | 19 |
| 56 | HH2_CTR_CALCULATED_EXPENSE | NUMERIC(13,2) | 19 |
| 57 | HH1_NET_INCOME | NUMERIC(13,2) | 19 |
| 58 | HH2_NET_INCOME | NUMERIC(13,2) | 19 |
| 59 | EXISTING_REPAYMENTS | NUMERIC(13,2) | 19 |
| 60 | SENSITISED_EXISTING_REPAYMENT | NUMERIC(13,2) | 19 |
| 61 | NEW_REPAYMENT | NUMERIC(13,2) | 19 |
| 62 | NEW_REPAYMENT_SENSITISED | NUMERIC(13,2) | 19 |
| 63 | ACTUAL_PROPOSED_INCOME | NUMERIC(13,2) | 19 |
| 64 | HH1_APPLICATION_TYPE | CHARACTER VARYING(100) | 100 |
| 65 | HH2_APPLICATION_TYPE | CHARACTER VARYING(100) | 100 |
| 66 | ARRANGEMENT_LVR | NUMERIC(13,2) | 19 |
| 67 | IS_EL_APPLICATION | CHARACTER VARYING(20) | 20 |
| 68 | DATA_DATE | TIMESTAMP | 8 |
| 69 | LOAD_ID | INTEGER | 4 |
| 70 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 71 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 72 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 73 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |