RDM_BANK_BRANCH_LOCATIONS_1

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

TABLE

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 DEPARTMENT_CODE NATIONAL CHARACTER VARYING(250) 250
20 DEPARTMENT_NAME NATIONAL CHARACTER VARYING(250) 250
21 DEPARTMENT_ID INTEGER 4
22 REGION_CODE NATIONAL CHARACTER VARYING(250) 250
23 REGION_NAME NATIONAL CHARACTER VARYING(250) 250
24 REGION_ID INTEGER 4
25 HUB_CODE NATIONAL CHARACTER VARYING(250) 250
26 HUB_NAME NATIONAL CHARACTER VARYING(250) 250
27 HUB_ID INTEGER 4
28 SITE_TYPE_CODE NATIONAL CHARACTER VARYING(250) 250
29 SITE_TYPE_NAME NATIONAL CHARACTER VARYING(250) 250
30 SITE_TYPE_ID INTEGER 4
31 BC_CO_LOCATED_CODE NATIONAL CHARACTER VARYING(250) 250
32 BC_CO_LOCATED_NAME NATIONAL CHARACTER VARYING(250) 250
33 BC_CO_LOCATED_ID INTEGER 4
34 ADDRESS_1 NATIONAL CHARACTER VARYING(100) 100
35 ADDRESS_2 NATIONAL CHARACTER VARYING(100) 100
36 SUBURB NATIONAL CHARACTER VARYING(50) 50
37 STATE_CODE NATIONAL CHARACTER VARYING(250) 250
38 STATE_NAME NATIONAL CHARACTER VARYING(250) 250
39 STATE_ID INTEGER 4
40 POSTCODE NUMERIC(31,0) 19
41 STORE_PHONE_NUMBER NATIONAL CHARACTER VARYING(15) 15
42 PHONE NUMERIC(31,0) 19
43 FAX NATIONAL CHARACTER VARYING(15) 15
44 IPC NATIONAL CHARACTER VARYING(10) 10
45 EMAIL NATIONAL CHARACTER VARYING(100) 100
46 REMOTENESS_CODE NATIONAL CHARACTER VARYING(250) 250
47 REMOTENESS_NAME NATIONAL CHARACTER VARYING(250) 250
48 REMOTENESS_ID INTEGER 4
49 REMOTENESS_OF_PC NUMERIC(31,7) 19
50 LATITUDE NUMERIC(31,7) 19
51 LONGITUDE NUMERIC(31,7) 19
52 BUSINESS_BANKING_CODE NATIONAL CHARACTER VARYING(250) 250
53 BUSINESS_BANKING_NAME NATIONAL CHARACTER VARYING(250) 250
54 BUSINESS_BANKING_ID INTEGER 4
55 EVERYDAY_BANKING_CODE NATIONAL CHARACTER VARYING(250) 250
56 EVERYDAY_BANKING_NAME NATIONAL CHARACTER VARYING(250) 250
57 EVERYDAY_BANKING_ID INTEGER 4
58 FOREIGN_EXCHANGE_CODE NATIONAL CHARACTER VARYING(250) 250
59 FOREIGN_EXCHANGE_NAME NATIONAL CHARACTER VARYING(250) 250
60 FOREIGN_EXCHANGE_ID INTEGER 4
61 LOAN_APPLICATION_CODE NATIONAL CHARACTER VARYING(250) 250
62 LOAN_APPLICATION_NAME NATIONAL CHARACTER VARYING(250) 250
63 LOAN_APPLICATION_ID INTEGER 4
64 FREE_CUSTOMER_WIFI_CODE NATIONAL CHARACTER VARYING(250) 250
65 FREE_CUSTOMER_WIFI_NAME NATIONAL CHARACTER VARYING(250) 250
66 FREE_CUSTOMER_WIFI_ID INTEGER 4
67 IB_KIOSK_IN_STORE_CODE NATIONAL CHARACTER VARYING(250) 250
68 IB_KIOSK_IN_STORE_NAME NATIONAL CHARACTER VARYING(250) 250
69 IB_KIOSK_IN_STORE_ID INTEGER 4
70 FINANCIAL_PLANNING_CODE NATIONAL CHARACTER VARYING(250) 250
71 FINANCIAL_PLANNING_NAME NATIONAL CHARACTER VARYING(250) 250
72 FINANCIAL_PLANNING_ID INTEGER 4
73 DISABILITY_ACCESS_CODE NATIONAL CHARACTER VARYING(250) 250
74 DISABILITY_ACCESS_NAME NATIONAL CHARACTER VARYING(250) 250
75 DISABILITY_ACCESS_ID INTEGER 4
76 INSURANCE_CODE NATIONAL CHARACTER VARYING(250) 250
77 INSURANCE_NAME NATIONAL CHARACTER VARYING(250) 250
78 INSURANCE_ID INTEGER 4
79 WORKSHOP_CODE NATIONAL CHARACTER VARYING(250) 250
80 WORKSHOP_NAME NATIONAL CHARACTER VARYING(250) 250
81 WORKSHOP_ID INTEGER 4
82 OPENING_CLOSING_TIMES NATIONAL CHARACTER VARYING(109) 109
83 MONDAY_FROM NATIONAL CHARACTER VARYING(12) 12
84 MONDAY_TO NATIONAL CHARACTER VARYING(12) 12
85 TUESDAY_FROM NATIONAL CHARACTER VARYING(12) 12
86 TUESDAY_TO NATIONAL CHARACTER VARYING(12) 12
87 WED_FROM NATIONAL CHARACTER VARYING(12) 12
88 WED_TO NATIONAL CHARACTER VARYING(12) 12
89 THURS_FROM NATIONAL CHARACTER VARYING(12) 12
90 THURS_TO NATIONAL CHARACTER VARYING(12) 12
91 FRI_FROM NATIONAL CHARACTER VARYING(12) 12
92 FRI_TO NATIONAL CHARACTER VARYING(12) 12
93 SAT_FROM NATIONAL CHARACTER VARYING(12) 12
94 SAT_TO NATIONAL CHARACTER VARYING(12) 12
95 SUN_FROM NATIONAL CHARACTER VARYING(12) 12
96 SUN_TO NATIONAL CHARACTER VARYING(12) 12
97 ENTERDATETIME TIMESTAMP 8
98 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
99 ENTERVERSIONNUMBER INTEGER 4
100 LASTCHGDATETIME TIMESTAMP 8
101 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
102 LASTCHGVERSIONNUMBER INTEGER 4
103 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
104 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
105 CDC_RECORD_TYPE CHARACTER(14) 14
106 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
107 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8