Masters
The requirements from the masters are identified below.
By default, all masters are append-only, in the sense that the records in the masters will be never deleted, unless explicitly stated. The records may be activated / deactivated as per roles.
A responsibility to view includes the authority to view a single record as well as view a list of records.
Bank Details
This pertains to the bank records in the database. Note that a given instance may serve more than one banks.
Updates to a bank record will always be done by a responsible person from ForeTech or Agent. Therefore there is no authorization needed to these changes. They happen directly to the database.
U0101
As a Superuser, I want to Create a Bank record
While creating a bank record, many other masters pertaining to the bank get populated to their initial defaults
- GL Codes
- Initial Roles and Role assignments
- Loan schemes
- etc TODO get full list
U0102
As a Superuser responsibility, I want to Update Bank details record
U0103
As a Superuser or Agent, I want to View Bank details
An agent can see only those banks for which they are an agent. But a superuser is able to see all the banks.
U0104
As a Superuser, I want to Activate / deactivate a bank
The reason for activation / deactivation of the bank is recorded.
Branch Details
This pertains to a branch of a bank.
U0201
As a Superuser, I want to Create a Branch record
U0202
As a Superuser, I want to Update Branch record
U0203
As a Superuser, Agent or a user with Branch viewer responsibility, I want to View Branch details
A superuser will be able to view the details of all branches. An agent or a user with requisite responsibility will be able to see only the branches of the bank that they are associated with.
U0204
As a Superuser, I want to Activate / deactivate a Branch
User Master
These are the bank users. They are the staff, the internal users. Bank customers are not included as the users. Nor are superusers and agents.
U0301
As a user with User creator responsibility, I want to Create a User record
U0302
As a user with User updater responsibility, I want to Update User record
U0303
As a user with User viewer responsibility, I want to View User details
U0304
As a user with User authoriser responsibility, I want to Activate / deactivate a User
U0305
As a user with User authoriser responsibility, I want to Authorize a User record create / change
Roles Master
Roles are defined at the bank level. Different banks may customize them differently.
U0401
As a user with Role creator responsibility, I want to Create a Role
U0402
As a user with Role updater responsibility, I want to Update a Role
This is the same responsibility that maps a role to the responsibilities.
U0403
As a user with Role viewer responsibility, I want to View Role
U0404
As a user with Role authoriser responsibility, I want to Activate / Deactivate GL Code
Role Assign Master
This is the mapping of Role to the responsibilities. The mapping / unmapping of this is already covered under Role updator story.
GL Code Master
GL Code stands for "General Ledger Code". Every GL code represents a different kind of transaction. It will be only a superuser on Foretech side who will create/ update/ activate GL codes.
U0601
As a user with GL Code creator responsibility, I want to Create GL Code
U0602
As a user with GL Code updater responsibility, I want to Update GL Code
U0603
As a user with GL Code viewer responsibility, I want to View GL Code
U0604
As a user with GL Code authoriser responsibility, I want to Activate / deactivate GL Code
U0605
As a user with GL Code authoriser responsibility, I want to Authorise a GL Code create / change
GL Group Master
GL group is a group of GL codes (transaction headers) as it appears in P&L or Balance sheet. Various transactions corresponding to the GL codes that are under a GL group are consolidated against the GL group.
U0701
As a user with GL Group creator responsibility, I want to Create GL Group
U0702
As a user with GL Group updater responsibility, I want to Update GL Group
U0703
As a user with GL Group viewer responsibility, I want to View GL Group
GL Category Master
GL Categories are categories of GL codes, such as Fixed Deposits, Saving Deposits, Share Capital, Term Loan etc.
U0801
As a user with GL Category creator responsibility, I want to Create a GL Category
U0802
As a user with GL Category updater responsibility, I want to Update GL Category
U0803
As a user with GL Category viewer responsibility, I want to View GL Category
Loan Scheme Master
These are the loan schemes / loan products that banks announce from time to time. Therefore they will be bank specific.
U0901
As a user with Loan Scheme creator responsibility, I want to Create a Loan Scheme
U0902
As a user with Loan Scheme updater responsibility, I want to Update Loan Scheme
U0903
As a user with Loan Scheme viewer responsibility, I want to View Loan Scheme
U0904
As a user with Loan Scheme authoriser responsibility, I want to Activate / deactivate Loan Scheme
U0905
As a user with Loan Scheme authoriser responsibility, I want to Authorize a Loan Scheme create/change
Loan Purpose Master
This is the list of loan purposes specific to bank.
U1001
As a user with Loan Purpose creator responsibility, I want to Create Loan Purpose master
U1002
As a user with Loan Purpose updater responsibility, I want to Update Loan Purpose master
U1003
As a user with Loan Purpose viewer responsibility, I want to View Loan Purpose master
Status Master
This is the status of Folio.
U1101
As a user with Status creator responsibility, I want to Create Status
U1102
As a user with Status updater responsibility, I want to Update Status
U1103
As a user with Status viewer responsibility, I want to View Status
Sector Master
This is the global loan sector master.
U1201
As a user with Sector creator responsibility, I want to Create a Loan Sector
U1202
As a user with Sector updater responsibility, I want to Update Loan Sector
U1203
As a user with Sector viewer responsibility, I want to View Loan Sector
NPA Asset Master
TODO Question: Should periodfrm and periodto fields be dates?
What do they contain?
U1301
As a user with NPA creator responsibility, I want to Create an NPA record
U1302
As a user with NPA updater responsibility, I want to Update NPA record
U1303
As a user with NPA viewer responsibility, I want to View NPA Assets
Category Master
The master contains loan categories. They are global.
U1401
As a user with Category creator responsibility, I want to Create a Loan Category
U1402
As a user with Category updater responsibility, I want to Update Loan Category
U1403
As a user with Category viewer responsibility, I want to View Loan Category
Loan Priority Sector Master
A priority sector master contains the bank's priority sectors. They can be at a higher granularity than the list of sectors. Therefore they are maintained separately in this master.
U1501
As a user with Loan Priority Sector creator responsibility, I want to Create Loan Priority Sector
U1502
As a user with Loan Priority Sector updater responsibility, I want to Update Loan Priority Sector
U1503
As a user with Loan Priority Sector viewer responsibility, I want to View Loan Priority Sector
Loan Interest Change Master
The loan interests will be specific to a bank, specific also to the type of loan.
U1601
As a user with Loan Interest creator responsibility, I want to Create Loan Interest Table record
U1602
As a user with Loan Interest viewer responsibility, I want to View Loan Interest master
U1603
As a user with Loan Interest authoriser responsibility, I want to Authorize a Loan Interest create
Deposit Interest Change Table Master
The deposit interests will be specific to a bank, specific also to the type of deposit (senior / NRI).
U1701
As a user with Deposit Interest creator responsibility, I want to Create Deposit Interest master
U1702
As a user with Deposit Interest viewer responsibility, I want to View Deposit Interest master
U1703
As a user with Deposit Interest authoriser responsibility, I want to Authorise Deposit Interest create
Loan Folio Charges Master
The master contains folio charges for loans.
U1801
As a user with Loan Folio Charges creator responsibility, I want to Create Loan Folio Charges master
U1802
As a user with Loan Folio Charges updater responsibility, I want to Update Loan Folio Charges master
U1803
As a user with Loan Folio Charges viewer responsibility, I want to View Loan Folio Charges master
Recovery Group Master
The master contains recovery group details.
U1901
As a user with Recovery Group creator responsibility, I want to Create Recovery Group master
U1902
As a user with Recovery Group updater responsibility, I want to Update Recovery Group master
U1903
As a user with Recovery Group viewer responsibility, I want to View Recovery Group master
Recovery Area Master
The master contains recovery area details.
U2001
As a user with Recovery Area creator responsibility, I want to Create Recovery Area master
U2002
As a user with Recovery Area updater responsibility, I want to Update Recovery Area master
U2003
As a user with Recovery Area viewer responsibility, I want to View Recovery Area master
Recovery Department Master
The master contains recovery department details.
U2101
As a user with Recovery Department creator responsibility, I want to Create Recovery Department master
U2102
As a user with Recovery Department updater responsibility, I want to Update Recovery Department master
U2103
As a user with Recovery Department viewer responsibility, I want to View Recovery Department master
Recovery Office Master
The master contains recovery office details.
U2201
As a user with Recovery Office creator responsibility, I want to Create Recovery Office master
U2202
As a user with Recovery Office updater responsibility, I want to Update Recovery Office master
U2203
As a user with Recovery Office viewer responsibility, I want to View Recovery Office master
Recovery Preference
U2301
As a user with Recovery Preference creator responsibility, I want to Create Recovery Preference master
U2302
As a user with Recovery Preference updater responsibility, I want to Update Recovery Preference master
U2303
As a user with Recovery Preference viewer responsibility, I want to View Recovery Preference master
GST Master
The is GST master (GST for Bank, different records for different percentage and gstof)
U2401
As a user with GST Master creator responsibility, I want to Create GST master record
U2402
As a user with GST Master updator responsibility, I want to Update GST master record
U2403
As a user with GST Master Viewer responsibility, I want to View GST master record
GST Item Master
The is GST item master.
U2501
As a user with GST item master creator responsibility, I want to Create GST item master record
U2502
As a user with GST item master updator responsibility, I want to Update GST item master record
U2503
As a user with GST item master viewer responsibility, I want to View GST item master record
Deposit Scheme Master
The is deposit scheme master.
U2601
As a user with Deposit scheme creator responsibility, I want to Create a deposit scheme record
U2602
As a user with Deposit scheme updator responsibility, I want to Update deposit scheme record
U2603
As a user with Deposit scheme viewer responsibility, I want to View Deposit scheme record
U2604
As a user with Deposit scheme authoriser responsibility, I want to Activate / deactivate a Deposit scheme
U2605
As a user with Deposit scheme authoriser responsibility, I want to Authorize a Deposit scheme record create / change
Goldsmith Master
The is gold smith master.
U2701
As a user with Goldsmith creator responsibility, I want to Create a goldsmith record
U2702
As a user with Goldsmith updator responsibility, I want to Update goldsmith record
U2703
As a user with Goldsmith viewer responsibility, I want to View goldsmith record
U2704
As a user with Goldsmith authoriser responsibility, I want to Authorize a goldsmith record create / change
Folio Master
The is Folio master.
U2801
As a user with Folio creator responsibility, I want to Create a folio record
U2802
As a user with Folio updator responsibility, I want to Update Folio record
U2803
As a user with Folio viewer responsibility, I want to View Folio record
U2804
As a user with Folio authoriser responsibility, I want to Authorize a Folio record create / change
Initials Master
The is Initials master.
Initials master does not have any roles or responsibilities associted with it. Therefore no user stories.
Customer Type Master
The is Customer type master.
U3001
As a user with Customer creator responsibility, I want to Create a customer record
U3002
As a user with Customer updator responsibility, I want to Update Customer record
U3003
As a user with Customer viewer responsibility, I want to View Customer record
Designation Master
The is Designation master.
U3101
As a user with Designation creator responsibility, I want to Create a Designation record
U3102
As a user with Designation updator responsibility, I want to Update Designation record
U3103
As a user with Designation viewer responsibility, I want to View Designation record
Caste Master
The is Caste master.
U3201
As a user with Caste creator responsibility, I want to Create a Caste record
U3202
As a user with Caste updator responsibility, I want to Update Caste record
U3203
As a user with Caste viewer responsibility, I want to View Caste record
Religion Master
The is Religion master.
U3301
As a user with Religion creator responsibility, I want to Create a Religion record
U3302
As a user with Religion updator responsibility, I want to Update Religion record
U3303
As a user with Religion viewer responsibility, I want to View Religion record
Nationality Master
The is Nationaity master.
U3401
As a user with Nationality creator responsibility, I want to Create a Nationality record
U3402
As a user with Nationality updator responsibility, I want to Update Nationality record
U3403
As a user with Nationality viewer responsibility, I want to View Nationality record
Occupation Master
The is Occupation master.
U3501
As a user with Occupation creator responsibility, I want to Create a Occupation record
U3502
As a user with Occupation updator responsibility, I want to Update Occupation record
U3503
As a user with Occupation viewer responsibility, I want to View Occupation record
Document Master
The is Document master.
U3601
As a user with Document creator responsibility, I want to Create a Document record
U3602
As a user with Document updator responsibility, I want to Update Document record
U3603
As a user with Document viewer responsibility, I want to View Document record
Document Type Master
The is Document type master.
U3701
As a user with Document type creator responsibility, I want to Create a Document type record
U3702
As a user with Document type updator responsibility, I want to Update Document type record
U3703
As a user with Document type viewer responsibility, I want to View Document type record
Folio Address Master
The is Folio Address master.
U3801
As a user with Folio address creator responsibility, I want to Create a folio address record
U3802
As a user with Folio address updator responsibility, I want to Update Folio address record
U3803
As a user with Folio address viewer responsibility, I want to View Folio address record
U3804
As a user with Folio address authoriser responsibility, I want to Authorize a Folio address create / change
Taluka Master
The is Taluka master.
U3901
As a user with Taluka creator responsibility, I want to Create a Taluka record
U3902
As a user with Taluka updator responsibility, I want to Update Taluka record
U3903
As a user with Taluka viewer responsibility, I want to View Taluka record
District Master
The is District master.
U4001
As a user with District creator responsibility, I want to Create a District record
U4002
As a user with District updator responsibility, I want to Update District record
U4003
As a user with District viewer responsibility, I want to View District record
State Master
The is State master.
U4101
As a user with State creator responsibility, I want to Create a State record
U4102
As a user with State updator responsibility, I want to Update State record
U4103
As a user with State viewer responsibility, I want to View State record
Contact Master
The is Contact master.
U4201
As a user with Contact creator responsibility, I want to Create a Contact record
U4202
As a user with Contact updator responsibility, I want to Update Contact record
U4203
As a user with Contact viewer responsibility, I want to View Contact record
U4204
As a user with Contact authoriser responsibility, I want to Authorize a Contact record create / change
Nomination Master
The is Nomination master.
U4301
As a user with Nomination creator responsibility, I want to Create a Nomination record
U4302
As a user with Nomination updator responsibility, I want to Update Nomination record
U4303
As a user with Nomination viewer responsibility, I want to View Nomination record
U4304
As a user with Nomination authoriser responsibility, I want to Authorize a Nomination record create / change
Identification Master
The is Identification master.
U4401
As a user with Identification creator responsibility, I want to Create a Identification record
U4402
As a user with Identification updator responsibility, I want to Update Identification record
U4403
As a user with Identification viewer responsibility, I want to View Identification record
U4404
As a user with Identification authoriser responsibility, I want to Authorize a Identification record create / change
Folio Bank Master
The is Folio Bank master.
U4501
As a user with Folio Bank creator responsibility, I want to Create a Folio Bank record
U4502
As a user with Folio Bank updator responsibility, I want to Update Folio Bank record
U4503
As a user with Folio Bank viewer responsibility, I want to View Folio Bank record
U4504
As a user with Folio Bank authoriser responsibility, I want to Authorize a Folio Bank record create / change
Director Master
The is Director master (Bank Director).
U4601
As a user with Director creator responsibility, I want to Create a Director record
U4602
As a user with Director updator responsibility, I want to Update Director record
U4603
As a user with Director viewer responsibility, I want to View Director record
U4604
As a user with Director authoriser responsibility, I want to Authorize a Director record create / change
Director Period Master
The is Director Period master (Period of Directorship).
U4701
As a user with Director Period creator responsibility, I want to Create a Director Period record
U4702
As a user with Director Period updator responsibility, I want to Update Director Period record
U4703
As a user with Director Period viewer responsibility, I want to View Director Period record
Corporate Master
The is Corporate master (Director info for Corporate Folio).
U4801
As a user with Corporate creator responsibility, I want to Create a Corporate record
U4802
As a user with Corporate updator responsibility, I want to Update Corporate record
U4803
As a user with Corporate viewer responsibility, I want to View Corporate record
U4804
As a user with Corporate authoriser responsibility, I want to Authorize a Corporate record create / change
Account Master
The is Account master.
U4901
As a user with Account creator responsibility, I want to Create an Account record
U4902
As a user with Account updator responsibility, I want to Update Account record
U4903
As a user with Account viewer responsibility, I want to View Account record
U4904
As a user with Account authoriser responsibility, I want to Authorize an Account record create / change
U4905
As a user with Account authoriser responsibility, I want to Activate / deactivate an Account
Booth Master
The is Booth master(Booth for Coop Bank election).
U5001
As a user with Booth creator responsibility, I want to Create a Booth record
U5002
As a user with Booth updator responsibility, I want to Update Booth record
U5003
As a user with Booth viewer responsibility, I want to View Booth record
Department / Area / Office / Installment change Master
U5101
As a user with Deposit installment change creator responsibility, I want to Create a Deposit installment change record
U5102
As a user with Deposit installment change authoriser responsibility, I want to Authorize a Deposit installment change record create
Vehicle Master
The is Vehicle master(Vehicle Loan).
U5201
As a user with Vehicle creator responsibility, I want to Create a Vehicle record
U5202
As a user with Vehicle updator responsibility, I want to Update Vehicle record
U5203
As a user with Vehicle viewer responsibility, I want to View Vehicle record
U5204
As a user with Vehicle authoriser responsibility, I want to Authorize a Vehicle record create / change
Gold Details Master
The is Gold Details master(Gold loan details).
U5301
As a user with Gold Details creator responsibility, I want to Create a Gold Details record
U5302
As a user with Gold Details updator responsibility, I want to Update Gold Details record
U5303
As a user with Gold Details viewer responsibility, I want to View Gold Details record
U5304
As a user with Gold Details authoriser responsibility, I want to Authorize a Gold Details record create / change
Receipts Master
The is Receipts master.
U5401
As a user with Receipts creator responsibility, I want to Create a Receipts record
U5402
As a user with Receipts updator responsibility, I want to Update Receipts record
U5403
As a user with Receipts viewer responsibility, I want to View Receipts record
U5404
As a user with Receipts authoriser responsibility, I want to Authorize a Receipts record create / change
Loan Master
The is Loan master.
U5501
As a user with Loan creator responsibility, I want to Create a Loan record
U5502
As a user with Loan updator responsibility, I want to Update Loan record
U5503
As a user with Loan viewer responsibility, I want to View Loan record
U5504
As a user with Loan authoriser responsibility, I want to Authorize a Loan record create / change
Insurance Master
The is Insurance master.
U5601
As a user with Insurance creator responsibility, I want to Create a Insurance record
U5602
As a user with Insurance updator responsibility, I want to Update Insurance record
U5603
As a user with Insurance viewer responsibility, I want to View Insurance record
U5604
As a user with Insurance authoriser responsibility, I want to Authorize a Insurance record create / change
U5605
As a user with Insurance authoriser responsibility, I want to Activate / deactivate a Insurance record
Surety Master
The is Surety master.
U5701
As a user with Surety creator responsibility, I want to Create a Surety record
U5702
As a user with Surety updator responsibility, I want to Update Surety record
U5703
As a user with Surety viewer responsibility, I want to View Surety record
U5704
As a user with Surety authoriser responsibility, I want to Authorize a Surety record create / change
U5705
As a user with Surety authoriser responsibility, I want to Activate / deactivate a Surety record
Pledge Account Master
The is Pledge Account master.
U5801
As a user with Pledge Account creator responsibility, I want to Create a Pledge Account record
U5802
As a user with Pledge Account updator responsibility, I want to Update Pledge Account record
U5803
As a user with Pledge Account viewer responsibility, I want to View Pledge Account record
U5804
As a user with Pledge Account authoriser responsibility, I want to Authorize a Pledge Account record create / change
Remarks Master
The is Remarks master.
U5901
As a user with Remarks creator responsibility, I want to Create a Remarks record
U5902
As a user with Remarks updator responsibility, I want to Update Remarks record
U5903
As a user with Remarks viewer responsibility, I want to View Remarks record
U5904
As a user with Remarks authoriser responsibility, I want to Authorize a Remarks record create / change
U5905
As a user with Remarks authoriser responsibility, I want to Activate / deactivate a Remarks record
Partner Master
The is Partner master.
U6001
As a user with Partner creator responsibility, I want to Create a Partner record
U6002
As a user with Partner updator responsibility, I want to Update Partner record
U6003
As a user with Partner viewer responsibility, I want to View Partner record
U6004
As a user with Partner authoriser responsibility, I want to Authorize a Partner record create / change
U6005
As a user with Partner authoriser responsibility, I want to Activate / deactivate a Partner record
Other Account Master
The is Other Account master (Related to other account).
U6101
As a user with Other Account creator responsibility, I want to Create an Other Account record
U6102
As a user with Other Account updator responsibility, I want to Update Other Account record
U6103
As a user with Other Account viewer responsibility, I want to View Other Account record
U6104
As a user with Other Account authoriser responsibility, I want to Authorize an Other Account record create / change
U6105
As a user with Other Account authoriser responsibility, I want to Activate / deactivate an Other Account record
Nominee Master
This is Nominee master (Nominee/ Guardian/ Proprietor/ Joint Holder Master).
U6201
As a user with Nominee creator responsibility, I want to Create a Nominee record
U6202
As a user with Nominee updator responsibility, I want to Update Nominee record
U6203
As a user with Nominee viewer responsibility, I want to View Nominee record
U6204
As a user with Nominee authoriser responsibility, I want to Authorize a Nominee record create / change
U6205
As a user with Nominee authoriser responsibility, I want to Activate / deactivate a Nominee record
Agent Master
This represents a superuser or bank agent.
U6301
As a Superuser, I want to Create a Superuser or an Agent.
U6302
As a Superuser, I want to Update a Superuser or an Agent.
U6303
As a Superuser, I want to View a Superuser or an Agent.
U6304
As a Superuser, I want to Activate / deactivate a Superuser or an Agent.
Bank Main Master
This represents a bank user.
U6401
As a Superuser, I want to Create a bank user.
U6402
As a Superuser, I want to Update a bank user.
U6403
As a Superuser, I want to View a bank user.
U6404
As a Superuser, I want to Activate / deactivate a bank user.