1. File Upload User Guide
  2. File Upload
  3. Branch Setup File Upload

1.3 Branch Setup File Upload

This topics describes the information to perform the bulk upload for the branch setup in Oracle Banking Liquidity Management.

File Type Supported - CSV

File Naming Convention - LMBranchParams_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 1-4 Branch Setup File Upload - Master Records

Sequence Attribute name Type Size Description
1 Discriminator* String 1 Denotes master record type. Default value is always “P”
2 Action* String 10 Denotes file operation type. Allowed values are new/modify
3 Bank Code* String 4 Code of the Bank
4 BIC Code* String 15 Denotes the BIC Code of the Branch
5 Branch Code* String 4 Code of the Branch
6 Branch Currency* String 3 Denotes Branch Local Currency
7 Branch Name* String 50 Name of the branch
8 City Id* String 50 Specifies the City Id
9 Country Id* String 10 Denotes the Country Id
10 Cross Border Hybrid Pool* String 1 Denotes accounts from the branch are allowed as Cross Border pool accounts in hybrid structures
11 Cross Border Hybrid Sweep* String 1 Denotes accounts from the branch are allowed as Cross Border sweep accounts in hybrid structures
12 Cross Border Pool* String 1 Indicates accounts from the branch are allowed to participate in Cross Border pool structures
13 Cross Border Sweep* String 1 Indicates accounts from the branch are allowed to participate in Cross Border sweep structures
14 Cross Ccy Hybrid Pool* String 1 Denotes accounts from the branch are allowed as Cross Currency pool accounts in hybrid structures
15 Cross Ccy Hybrid Sweep* String 1 Denotes accounts from the branch are allowed as Cross Currency sweep accounts in hybrid structures
16 Cross Ccy Pool* String 1 Indicates accounts from the branch are allowed to participate in Cross Currency pool structures
17 Cross Ccy Sweep* String 1 Indicates accounts from the branch are allowed to participate in Cross Currency sweep structures
18 Domestic Hybrid Pool* String 1 Denotes accounts from the branch are allowed as Domestic pool accounts in hybrid structures
19 Domestic Hybrid Sweep* String 1 Denotes accounts from the branch are allowed as Domestic sweep accounts in hybrid structures
20 Domestic Pool* String 1 Indicates accounts from the branch are allowed to participate in Domestic pool structures
21 Domestic Sweep* String 1 Indicates accounts from the branch are allowed to participate in Domestic sweep structures
22 Entity ID* String 50 Specifies the Entity ID for branch
23 Entity Name* String 105 Specifies the Entity name for branch
24 External System Id* String 35 Denotes the External System ID of the Branch
25 Fax String 20 Specifies the Fax details
26 Hybrid* String 1 Allow accounts of the branch in Hybrid (Combination of Sweep and Pool) structures
27 Is Balance Online* String 1 Denotes the Balance build method as online or offline
28 Latitude Number 15 Specifies the Latitude details
29 Line 1* String 100 Denotes the branch address details - Address Line 1
30 Line 2 String 100 Denotes the branch address details - Address Line 2
31 Line 3 String 100 Denotes the branch address details - Address Line 3
32 Line 4 String 100 Denotes the branch address details - Address Line 4
33 Longitude Number 15 Specifies the Longitude details
34 Phone Number String 13 Specifies the Phone Number
35 Pool* String 1 Allow accounts of the branch in pool structures
36 Region* String 100 Specifies the region of the Branch
37 Source System* String 35 Source System
38 Source System Branch Code String 4 Branch Code of the Source System
39 State Id String 10 Specifies the State Id
40 Sweep* String 1 Allow accounts of the branch in sweep structures
41 Time Zone* String 30 Specifies the Time Zone details
42 Branch Date* String 30 Indicates the Branch Date
43 Local Clearing Code String 50 Specifies the local clearing code for the branch
44 Is External* String 1 Indicates whether the branch is External or not
45 Bank Type String 10 Denotes the Bank Type
46 Zip String 10 Indicates the Zip Code
47 Host Code* String 8 Host Code
48 Balance Update Offset* Number 38 Defines the balance offset beyond which the balances are considered stale for offline balance fetch
49 Is Mt 942 String 1 Indicates whether the branch sends MT942 messages or not
50 Mt 942 Msg Type String 11 Denotes the MT942 message type
51 Rate Type String 8 Specify the Rate Type
52 Rate Code String 1 Specify the Rate Code

Table 1-5 Branch Setup File Upload - Child Record 1

Sequence Attribute name Type Size Description
1 Discriminator* String 15 Denotes the first child record type. Default value is always “AddnParameters”
2 Parameter Name* String 50 Indicates the Parameter Name
3 Parameter Value* String 300 Indicates the Parameter Value

Table 1-6 Branch Setup File Upload - Child Record 2

Sequence Attribute name Type Size Description
1 Discriminator* String 15 Denotes the second child record type. Default value is always “ExternalSystem”
2 External System Id* String 36 Denotes the External System Id for the branch
3 Message Type* String 20 Specifies the Message type for the selected external system Id
4 Method Name* String 100 Indicates the Method Name for the selected external system Id
5 Network Type* String 50 Specifies the Network type for the selected external system Id
6 Service Type* String 30 Denotes the Service type for the selected external system Id

Parent topic: File Upload