FCT_BNK_LOAN_ORIGINATION_TAT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP loan origination turnaround time. Includes the life cycle timestamps for Loan origination process and workflow steps

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_LOAN_ORIGINATION_TAT

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 ORIGINATION_BRANCH_CC CHARACTER VARYING(10) 10
5 ORIGINATION_BRANCH_NAME CHARACTER VARYING(105) 105
6 ORIGINATION_BRANCH_REGION CHARACTER VARYING(240) 240
7 ORIGINATION_OFFICER CHARACTER VARYING(254) 254
8 ORIGINATOR_NAME CHARACTER VARYING(372) 372
9 BORROWING_ENTITY CHARACTER VARYING(2509) 2509
10 ABN_ACN_NUMBER CHARACTER VARYING(30) 30
11 ANZSIC_DESCRIPTION CHARACTER VARYING(200) 200
12 IS_EXISTING_CUSTOMER CHARACTER(1) 1
13 LAST_NAME CHARACTER VARYING(50) 50
14 FIRST_NAME CHARACTER VARYING(50) 50
15 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
16 TOTAL_COMBINED_EXPOSURE DOUBLE PRECISION 8
17 JOINT_APPLICATION CHARACTER VARYING(1) 1
18 EMPLOYMENT_STATUS CHARACTER VARYING(400) 400
19 LOAN_PRODUCT_GROUP CHARACTER VARYING(105) 105
20 OFFER_DESC CHARACTER VARYING(120) 120
21 LOAN_PURPOSE_TYPE CHARACTER VARYING(400) 400
22 LOAN_SUBPURPOSE_TYPE CHARACTER VARYING(255) 255
23 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(20) 20
24 REMOTE_SETTLEMENT CHARACTER VARYING(1) 1
25 SETTLEMENT_DT TIMESTAMP 8
26 APP_SUBMITTED TIMESTAMP 8
27 OFFER_LTR_DISPATCHED TIMESTAMP 8
28 SUBMISSION_INCOMPLETE TIMESTAMP 8
29 SUBMISSION_SUBMITTED TIMESTAMP 8
30 APP_DATA_ENTRY_START TIMESTAMP 8
31 APP_DATA_ENTRY_END TIMESTAMP 8
32 APP_DATA_ENTRY_ENDTEAM CHARACTER VARYING(254) 254
33 CREDIT_ASSESS_START TIMESTAMP 8
34 CREDIT_ASSESS_END TIMESTAMP 8
35 CREDIT_ASSESS_ENDTEAM CHARACTER VARYING(100) 100
36 COLL_PERFORM_START TIMESTAMP 8
37 COLL_PERFORM_END TIMESTAMP 8
38 COLL_PERFORM_ENDTEAM CHARACTER VARYING(100) 100
39 PRELIM_VAL_START TIMESTAMP 8
40 PRELIM_VAL_END TIMESTAMP 8
41 PRELIM_VAL_ENDTEAM CHARACTER VARYING(100) 100
42 DOWNSELL_START CHARACTER VARYING(1) 1
43 DOWNSELL_END CHARACTER VARYING(1) 1
44 DOWNSELL_ENDTEAM CHARACTER VARYING(1) 1
45 EDIT_SUB_START TIMESTAMP 8
46 EDIT_SUB_END TIMESTAMP 8
47 EDIT_SUB_ENDTEAM CHARACTER VARYING(100) 100
48 WITHDRAW_SUB_START TIMESTAMP 8
49 WITHDRAW_SUB_END TIMESTAMP 8
50 WITHDRAW_SUB_ENDTEAM CHARACTER VARYING(100) 100
51 COLL_VALUER_START TIMESTAMP 8
52 COLL_VALUER_END TIMESTAMP 8
53 COLL_VALUER_ENDTEAM CHARACTER VARYING(100) 100
54 COLL_TITLESEARCH_START TIMESTAMP 8
55 COLL_TITLESEARCH_END TIMESTAMP 8
56 COLL_TITLESEARCH_ENDTEAM CHARACTER VARYING(100) 100
57 APP_VERI_START TIMESTAMP 8
58 APP_VERI_END TIMESTAMP 8
59 APP_VERI_ENDTEAM CHARACTER VARYING(100) 100
60 STRUCTURE_SOLN_START TIMESTAMP 8
61 STRUCTURE_SOLN_END TIMESTAMP 8
62 STRUCTURE_SOLN_ENDTEAM CHARACTER VARYING(100) 100
63 LMI_PROCESS_START TIMESTAMP 8
64 LMI_PROCESS_END TIMESTAMP 8
65 LMI_PROCESS_ENDTEAM CHARACTER VARYING(100) 100
66 CCI_PROCESS_START TIMESTAMP 8
67 CCI_PROCESS_END TIMESTAMP 8
68 CCI_PROCESS_ENDTEAM CHARACTER VARYING(100) 100
69 OFFER_GEN_DISP_START TIMESTAMP 8
70 OFFER_GEN_DISP_END TIMESTAMP 8
71 OFFER_GEN_DISP_ENDTEAM CHARACTER VARYING(100) 100
72 OFFER_ACCEPT_EXEC_START TIMESTAMP 8
73 OFFER_ACCEPT_EXEC_END TIMESTAMP 8
74 OFFER_ACCEPT_EXEC_ENDTEAM CHARACTER VARYING(100) 100
75 CREATE_ACCOUNT_START TIMESTAMP 8
76 CREATE_ACCOUNT_END TIMESTAMP 8
77 CREATE_ACCOUNT_ENDTEAM CHARACTER VARYING(254) 254
78 SETTLEMENT_INSTR_START TIMESTAMP 8
79 SETTLEMENT_INSTR_END TIMESTAMP 8
80 SETTLEMENT_INSTR_ENDTEAM CHARACTER VARYING(100) 100