RDM_BANK_BRANCH_LOCATIONS_HIST_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 SITE_NAME NATIONAL CHARACTER VARYING(50) 50
11 COST_CENTRE_OF NUMERIC(31,0) 19
12 COST_CENTRE_PS NATIONAL CHARACTER VARYING(100) 100
13 START_DATE TIMESTAMP 8
14 EFF_END_DATE TIMESTAMP 8
15 CFDM_BRCH_ID NUMERIC(31,0) 19
16 CRM_QUEUE_NAME NATIONAL CHARACTER VARYING(100) 100
17 COST_CENTRE_NAME NATIONAL CHARACTER VARYING(100) 100
18 CHANGE_TYPE NATIONAL CHARACTER VARYING(50) 50
19 LEVEL_2_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
20 LEVEL_2_CODE_NAME NATIONAL CHARACTER VARYING(250) 250
21 LEVEL_2_CODE_ID INTEGER 4
22 LEVEL_3_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
23 LEVEL_3_CODE_NAME NATIONAL CHARACTER VARYING(250) 250
24 LEVEL_3_CODE_ID INTEGER 4
25 LEVEL_4_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
26 LEVEL_4_CODE_NAME NATIONAL CHARACTER VARYING(250) 250
27 LEVEL_4_CODE_ID INTEGER 4
28 LEVEL_5_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
29 LEVEL_5_CODE_NAME NATIONAL CHARACTER VARYING(250) 250
30 LEVEL_5_CODE_ID INTEGER 4
31 LEVEL_6_CODE_CODE NATIONAL CHARACTER VARYING(250) 250
32 LEVEL_6_CODE_NAME NATIONAL CHARACTER VARYING(250) 250
33 LEVEL_6_CODE_ID INTEGER 4
34 SITE_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
35 SITE_TYPE_NAME NATIONAL CHARACTER VARYING(250) 250
36 SITE_TYPE_ID INTEGER 4
37 BC_CO_LOCATED_CODE NATIONAL CHARACTER VARYING(250) 250
38 BC_CO_LOCATED_NAME NATIONAL CHARACTER VARYING(250) 250
39 BC_CO_LOCATED_ID INTEGER 4
40 ADDRESS_1 NATIONAL CHARACTER VARYING(100) 100
41 ADDRESS_2 NATIONAL CHARACTER VARYING(100) 100
42 SUBURB NATIONAL CHARACTER VARYING(50) 50
43 STATE_CODE NATIONAL CHARACTER VARYING(250) 250
44 STATE_NAME NATIONAL CHARACTER VARYING(250) 250
45 STATE_ID INTEGER 4
46 POSTCODE NUMERIC(31,0) 19
47 STORE_PHONE_NUMBER NATIONAL CHARACTER VARYING(15) 15
48 PHONE NUMERIC(31,0) 19
49 FAX NATIONAL CHARACTER VARYING(15) 15
50 IPC NATIONAL CHARACTER VARYING(10) 10
51 EMAIL NATIONAL CHARACTER VARYING(100) 100
52 REMOTENESS_CODE NATIONAL CHARACTER VARYING(250) 250
53 REMOTENESS_NAME NATIONAL CHARACTER VARYING(250) 250
54 REMOTENESS_ID INTEGER 4
55 REMOTENESS_OF_PC NUMERIC(31,7) 19
56 LATITUDE NUMERIC(31,7) 19
57 LONGITUDE NUMERIC(31,7) 19
58 BUSINESS_BANKING NATIONAL CHARACTER VARYING(10) 10
59 EVERYDAY_BANKING NATIONAL CHARACTER VARYING(10) 10
60 FOREIGN_EXCHANGE NATIONAL CHARACTER VARYING(10) 10
61 LOAN_APPLICATION NATIONAL CHARACTER VARYING(10) 10
62 FREE_CUSTOMER_WIFI NATIONAL CHARACTER VARYING(10) 10
63 IB_KIOSK_IN_STORE NATIONAL CHARACTER VARYING(10) 10
64 FINANCIAL_PLANNING NATIONAL CHARACTER VARYING(10) 10
65 DISABILITY_ACCESS NATIONAL CHARACTER VARYING(10) 10
66 INSURANCE NATIONAL CHARACTER VARYING(10) 10
67 WORKSHOP NATIONAL CHARACTER VARYING(10) 10
68 OPENING_CLOSING_TIMES_CODE NATIONAL CHARACTER VARYING(250) 250
69 OPENING_CLOSING_TIMES_NAME NATIONAL CHARACTER VARYING(250) 250
70 OPENING_CLOSING_TIMES_ID INTEGER 4
71 MONDAY_FROM NATIONAL CHARACTER VARYING(12) 12
72 MONDAY_TO NATIONAL CHARACTER VARYING(12) 12
73 TUESDAY_FROM NATIONAL CHARACTER VARYING(12) 12
74 TUESDAY_TO NATIONAL CHARACTER VARYING(12) 12
75 WED_FROM NATIONAL CHARACTER VARYING(12) 12
76 WED_TO NATIONAL CHARACTER VARYING(12) 12
77 THURS_FROM NATIONAL CHARACTER VARYING(12) 12
78 THURS_TO NATIONAL CHARACTER VARYING(12) 12
79 FRI_FROM NATIONAL CHARACTER VARYING(12) 12
80 FRI_TO NATIONAL CHARACTER VARYING(12) 12
81 SAT_FROM NATIONAL CHARACTER VARYING(12) 12
82 SAT_TO NATIONAL CHARACTER VARYING(12) 12
83 SUN_FROM NATIONAL CHARACTER VARYING(12) 12
84 SUN_TO NATIONAL CHARACTER VARYING(12) 12
85 BRANCH_FEATURE_CC_CODE NATIONAL CHARACTER VARYING(250) 250
86 BRANCH_FEATURE_CC_NAME NATIONAL CHARACTER VARYING(250) 250
87 BRANCH_FEATURE_CC_ID INTEGER 4
88 ENTERDATETIME TIMESTAMP 8
89 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
90 ENTERVERSIONNUMBER INTEGER 4
91 LASTCHGDATETIME TIMESTAMP 8
92 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
93 LASTCHGVERSIONNUMBER INTEGER 4
94 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
95 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
96 CDC_RECORD_TYPE CHARACTER(14) 14
97 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
98 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8