Rice2.x Framework
OLE Location information will be maintained in the ole-rice2 schema and developed in the ole-rice2 application using the new KRAD maintenance doc framework. This will also be in line with the Instance Editor which has location component to it and being developed using the ole-rice2 framework.
1. Location Maintenance (Create/Update)
a. KRAD Design: A simple KRAD maintenance document will be used to create and update a new or an existing Location record.
b. Participants:
c. Framework: Rice2.x
2. Location Search
a. KRAD Design: A simple KRAD maintenance document will be used to create and update a new or an existing Location record.
b. Participants:
c. Framework: Rice2.x
3. Location Level Maintenance (Create/Update)
a. KRAD Design: A simple KRAD maintenance document will be used to create and update a new or an existing Location Level record.
b. Participants:
c. Framework: Rice2.x
4. Local Level Search
a. KRAD Design: A simple KRAD maintenance document will be used to create and update a new or an existing Location Level record.
b. Participants:
c. Framework: Rice2.x
5. Batch Ingest
a. KRAD Design: The ingest screen is going to be similar to the Staff Upload screen in OLE_Rice2.x. Its a simple KRAD form with a view.xml and a controller.
b. Participants:
c. Framework: Rice2.x
d. Workflow
6. Security
a. Roles:
- Operator - Create new Shelving Locations but not new Libraries.
- User- Create new Locations and Libraries for any campus.
- Shelving Location Administrator - Create and edit Shelving Locations.
- Location Administrator - Create and edit institutions, campuses, libraries and collections.Create, view and edit Location levels
b. Permissions to do the following on the below entities:
Location Level
a) Create
b) Edit
c) View(Inquiry)
Location
a) Create
b) Edit
c) View(Inquiry)
Upload Locations
a) Create/Update
7. Services
8. Data Model:The DM for Patron is going to reside in the Rice2.x Schema
Tables involved as per the requirement given in LocationhandlinginOLE.pdf and JIRA No. OLE-2558 OLE_LOCN_LEVEL_T and OLE_LOCN_T
OLE_LOCN_LEVEL_T:
- LEVEL_ID – varchar2(40)(Primary key)
- OBJ_ID – varchar2(Not Null)
- VER_NBR – Number(8)(Not Null)
- LEVEL_CD – varchar2(40)(Unique & Not Null)
- LEVEL_NAME – varchar2(100)(Not Null)
- PARENT_LEVEL – varchar2(40) (Nullable) - References OLE_LOCN_LEVEL_T.LEVEL_ID. Varchar2(40)
OLE_LOCN_T:
- LOCN_ID - varchar2(40)(Primary Key)
- OBJ_ID – varchar2(36)(Not Null)
- VER_NBR – Number(8)(Not Null)
- LOCN_CD – varchar2(40)(Unique & Not Null)
- LOCN_NAME – varchar2(200)(Not Null)
- LEVEL_ID - varchar2(40)(Not Null) - References OLE_LOCN_LEVEL_T.LEVEL_ID.
- PARENT_LOCN_ID – varchar2(40)(Nullable)- References OLE_LOCN_T.LOCN_ID