FCT_BNK_PL_LOAN_ORIGINATION_ROFT_TAT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP05_BANK..FCT_BNK_PL_LOAN_ORIGINATION_ROFT_TAT_INSIGHT

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 FACILITY_ID CHARACTER VARYING(40) 40
4 ACCOUNT_NUMBER CHARACTER VARYING(100) 100
5 SUBMISSION_APPLICATION_STATUS CHARACTER VARYING(50) 50
6 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
7 DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
8 SUBMISSION_STATUS CHARACTER VARYING(50) 50
9 SUBMISSION_CREATION_DATE TIMESTAMP 8
10 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
11 PRIMARY_APPLICANT_PARTY_ID CHARACTER VARYING(40) 40
12 PRIMARY_APPLICANT_PARTY_TYPE CHARACTER VARYING(50) 50
13 FACILITY_REPORTING_AMOUNT NUMERIC(35,2) 19
14 TCE_AMOUNT NUMERIC(35,2) 19
15 DISBURSEMENT_AMOUNT NUMERIC(35,2) 19
16 LOAN_PRODUCT_GROUP CHARACTER VARYING(105) 105
17 OFFER_DESC CHARACTER VARYING(120) 120
18 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
19 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
20 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
21 PRODUCT_CODE CHARACTER VARYING(50) 50
22 OFFER_ID CHARACTER VARYING(40) 40
23 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
24 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
25 CONTRIBUTION_AMOUNT NUMERIC(35,2) 19
26 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
27 APPLICATION_RISK_GRADE CHARACTER VARYING(20) 20
28 ACCOUNT_TERM_MONTHS BIGINT 8
29 FIRST_NAME CHARACTER VARYING(50) 50
30 LAST_NAME CHARACTER VARYING(50) 50
31 ORIGINATION_BRANCH_CC CHARACTER VARYING(10) 10
32 ORIGINATION_BRANCH_NAME CHARACTER VARYING(105) 105
33 ORIGINATION_BRANCH_REGION CHARACTER VARYING(240) 240
34 ORIGINATION_STATE CHARACTER VARYING(30) 30
35 ORIGINATION_POST_CODE CHARACTER VARYING(30) 30
36 ORIGINATION_OFFICER CHARACTER VARYING(254) 254
37 ORIGINATOR_NAME CHARACTER VARYING(372) 372
38 BORROWING_ENTITY CHARACTER VARYING(2509) 2509
39 ABN_ACN_NUMBER CHARACTER VARYING(30) 30
40 ANZSIC_DESCRIPTION CHARACTER VARYING(200) 200
41 IS_EXISTING_CUSTOMER CHARACTER(1) 1
42 JOINT_APPLICATION CHARACTER VARYING(1) 1
43 REMOTE_SETTLEMENT CHARACTER VARYING(1) 1
44 APP_SUBMITTED TIMESTAMP 8
45 SETTLEMENT_DT TIMESTAMP 8
46 OFFER_LTR_DISPATCHED TIMESTAMP 8
47 SUBMISSION_SUBMITTED TIMESTAMP 8
48 SUBMISSION_INCOMPLETE TIMESTAMP 8
49 APP_DATA_ENTRY_START TIMESTAMP 8
50 APP_DATA_ENTRY_END TIMESTAMP 8
51 APP_DATA_ENTRY_ENDTEAM CHARACTER VARYING(254) 254
52 CREDIT_ASSESS_START TIMESTAMP 8
53 CREDIT_ASSESS_END TIMESTAMP 8
54 CREDIT_ASSESS_ENDTEAM CHARACTER VARYING(100) 100
55 PRELIM_VAL_START TIMESTAMP 8
56 PRELIM_VAL_END TIMESTAMP 8
57 PRELIM_VAL_ENDTEAM CHARACTER VARYING(100) 100
58 DOWNSELL_START CHARACTER VARYING(1) 1
59 DOWNSELL_END CHARACTER VARYING(1) 1
60 DOWNSELL_ENDTEAM CHARACTER VARYING(1) 1
61 EDIT_SUB_START TIMESTAMP 8
62 EDIT_SUB_END TIMESTAMP 8
63 EDIT_SUB_ENDTEAM CHARACTER VARYING(100) 100
64 WITHDRAW_SUB_START TIMESTAMP 8
65 WITHDRAW_SUB_END TIMESTAMP 8
66 WITHDRAW_SUB_ENDTEAM CHARACTER VARYING(100) 100
67 COLL_VALUER_START TIMESTAMP 8
68 COLL_VALUER_END TIMESTAMP 8
69 COLL_VALUER_ENDTEAM CHARACTER VARYING(100) 100
70 COLL_TITLESEARCH_START TIMESTAMP 8
71 COLL_TITLESEARCH_END TIMESTAMP 8
72 COLL_TITLESEARCH_ENDTEAM CHARACTER VARYING(100) 100
73 APP_VERI_START TIMESTAMP 8
74 APP_VERI_END TIMESTAMP 8
75 APP_VERI_ENDTEAM CHARACTER VARYING(100) 100
76 STRUCTURE_SOLN_START TIMESTAMP 8
77 STRUCTURE_SOLN_END TIMESTAMP 8
78 STRUCTURE_SOLN_ENDTEAM CHARACTER VARYING(100) 100
79 LMI_PROCESS_START TIMESTAMP 8
80 LMI_PROCESS_END TIMESTAMP 8
81 LMI_PROCESS_ENDTEAM CHARACTER VARYING(100) 100
82 CCI_PROCESS_START TIMESTAMP 8
83 CCI_PROCESS_END TIMESTAMP 8
84 CCI_PROCESS_ENDTEAM CHARACTER VARYING(100) 100
85 OFFER_GEN_DISP_START TIMESTAMP 8
86 OFFER_GEN_DISP_END TIMESTAMP 8
87 OFFER_GEN_DISP_ENDTEAM CHARACTER VARYING(100) 100
88 OFFER_ACCEPT_EXEC_START TIMESTAMP 8
89 OFFER_ACCEPT_EXEC_END TIMESTAMP 8
90 OFFER_ACCEPT_EXEC_ENDTEAM CHARACTER VARYING(100) 100
91 CREATE_ACCOUNT_START TIMESTAMP 8
92 CREATE_ACCOUNT_END TIMESTAMP 8
93 CREATE_ACCOUNT_ENDTEAM CHARACTER VARYING(254) 254
94 SETTLEMENT_INSTR_START TIMESTAMP 8
95 SETTLEMENT_INSTR_END TIMESTAMP 8
96 SETTLEMENT_INSTR_ENDTEAM CHARACTER VARYING(100) 100