SDW_TSLND_APPLICATION

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..UBAR_SDW_TSLND_APPLICATION

SDSNZP05_BANK..CBP_SDW_TSLND_APPLICATION

Columns
# Name Data Type Length
1 APPLICATION_ID CHARACTER VARYING(20) 20
2 BANKING_TYPE CHARACTER VARYING(60) 60
3 APPLICATION_URGENCY NUMERIC(38,0) 19
4 PREAPPROVED_FLAG CHARACTER VARYING(1) 1
5 INITIATOR_IS_LENDER_FLAG CHARACTER VARYING(1) 1
6 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
7 CAMPAIGN_BENEFIT_FLAG CHARACTER VARYING(1) 1
8 WORKFLOW_STAGE CHARACTER VARYING(60) 60
9 WORKFLOW_STATUS CHARACTER VARYING(60) 60
10 WORKFLOW_ACTION CHARACTER VARYING(60) 60
11 CURRENT_WORKBASKET CHARACTER VARYING(60) 60
12 ELECTRONIC_LODGEMENT_NO CHARACTER VARYING(30) 30
13 QUALITY_STANDARD_FLAG CHARACTER VARYING(1) 1
14 QUALITY_REASONS CHARACTER VARYING(100) 100
15 CREATION_DATE TIMESTAMP 8
16 RECEIEVED_DT TIMESTAMP 8
17 CDTL_APPROVAL_DT TIMESTAMP 8
18 UCDTL_APPROVAL_DT TIMESTAMP 8
19 ESTIMATED_SETTLEMENT_DT TIMESTAMP 8
20 ESTIMATED_FINANCE_DT TIMESTAMP 8
21 ESTIMATED_MDR_DATE TIMESTAMP 8
22 MIN_CUSTOMER_NAME CHARACTER VARYING(80) 80
23 DERIVED_CURRENT_WORKBASKET CHARACTER VARYING(60) 60
24 BSN_LOAD_DT TIMESTAMP 8
25 HAS_SPLIT CHARACTER VARYING(1) 1
26 TOT_CST_ESR NUMERIC(14,2) 19
27 EXCEPTION_REASON_1 CHARACTER VARYING(10) 10
28 EXCEPTION_REASON_2 CHARACTER VARYING(10) 10
29 EXCEPTION_REASON_3 CHARACTER VARYING(10) 10
30 GROSS_OCCUPATION_INCOME NUMERIC(13,2) 19
31 ASSET_INCOME NUMERIC(13,2) 19
32 PROPOSED_INCOME NUMERIC(13,2) 19
33 NON_TAXABLE_INCOME NUMERIC(13,2) 19
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8