INT_OBP_EFS_APPLICATIONS_LIFE_CYCLE_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 FACILITY_ID CHARACTER VARYING(40) 40
3 FIRST_APPLICATION_LODGEMENT_DATE DATE 4
4 LAST_APPLICATION_LODGEMENT_DATE DATE 4
5 FIRST_CONDITIONAL_APPROVAL_DATE DATE 4
6 LAST_CONDITIONAL_APPROVAL_DATE DATE 4
7 FIRST_STRUCTURE_SOLN_CONFIRMED_DATE DATE 4
8 LAST_STRUCTURE_SOLN_CONFIRMED_DATE DATE 4
9 FIRST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE DATE 4
10 LAST_APPLICATION_UNCONDITIONAL_APPROVAL_DATE DATE 4
11 FIRST_OFFER_LETTER_DISPATCH_DATE DATE 4
12 LAST_OFFER_LETTER_DISPATCH_DATE DATE 4
13 FIRST_OFFER_LETTER_ACCEPTANCE_DATE DATE 4
14 LAST_OFFER_LETTER_ACCEPTANCE_DATE DATE 4
15 EFFECTIVE_START_DATE DATE 4
16 EFFECTIVE_END_DATE DATE 4