FCT_BNK_QRM_APPLICATION_MASTER_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Extract for QRM showing OBP 'Application' details

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 APPLN_ID CHARACTER VARYING(50) 50
3 BANKING_TYPE CHARACTER VARYING(8) 8
4 APPLN_URGENCY CHARACTER VARYING(7) 7
5 PRE_APPRVD_FL CHARACTER VARYING(1) 1
6 CREATION_DATE CHARACTER VARYING(200) 200
7 RECEIVED_DATE CHARACTER VARYING(200) 200
8 COND_APPROVED_DATE CHARACTER VARYING(200) 200
9 COND_APPROVED_OFFICER CHARACTER VARYING(50) 50
10 UNCOND_APPROVED_DATE CHARACTER VARYING(200) 200
11 UNCOND_APPROVED_OFFICER CHARACTER VARYING(50) 50
12 SALES_BRANCH_CODE CHARACTER VARYING(10) 10
13 INITIATOR_IS_LENDER_FL CHARACTER VARYING(1) 1
14 LENDER_ID CHARACTER VARYING(254) 254
15 SUPP_OFFICER_ID CHARACTER VARYING(254) 254
16 WORKFLOW_STAGE CHARACTER VARYING(50) 50
17 WORKFLOW_STATUS CHARACTER VARYING(50) 50
18 WORKFLOW_ACTION CHARACTER VARYING(50) 50
19 CURR_WORKBASKET CHARACTER VARYING(100) 100
20 CURR_OPERATOR_ID CHARACTER VARYING(500) 500
21 ELECTRONIC_LODGEMENT_NO CHARACTER VARYING(50) 50
22 QUALITY_STANDARD_FLAG CHARACTER VARYING(1) 1
23 QUALITY_REASONS CHARACTER VARYING(1) 1
24 QUALITY_MEASURES_USER_ID CHARACTER VARYING(1) 1
25 BSN_LOAD_DT DATE 4
26 SUBMISSION_EXPIRY_DATE CHARACTER VARYING(200) 200
27 SUBMISSION_WITHDRAW_DATE CHARACTER VARYING(200) 200
28 SUBMISSION_OBJECT_STATUS CHARACTER(1) 1
29 APPLICATION_OBJECT_STATUS CHARACTER(1) 1
30 APPLICATION_STATUS CHARACTER VARYING(50) 50
31 APPLICATION_LAST_UPDATE_DATE CHARACTER VARYING(200) 200
32 APPLN_REQ_TYPE CHARACTER VARYING(20) 20
33 OFFER_LETTER_GENERATED_DATE CHARACTER VARYING(200) 200
34 OFFER_LETTER_ACCEPTANCE_DATE CHARACTER VARYING(200) 200