OLE E-Resource
Overview
https://jira.kuali.org/browse/OLE-2758Â and related linked tasks
Description
This document describes the process of creating a serial receiving record in order to receive individual issues of a serial title.
E-Resource Record presents a single, unified view of all information related to acquisition of an individual electronic resource or group of electronic resources, including titles, payment, licensing, administrative, and contact information. Â
Design: Technical
The technical design document shall lay out the high level design of how the E-Resource Document and the E-Instancescan be created . The details laid out shall include the Wire-frames for User Interface design, Data Element Layout, including the logical Database Design, Component Specifications including artifacts such as Class Diagram, State Chart Diagrams, OJB.xml specifications and Rules information.
Service Design and Implementation
Screen Flow Diagram
Layout use cases based on the screen flows indicating navigation between different screens.Â
Security
- Roles
OLE_Selector Â
OLE_Licenses Â
OLE_Acquisitions Â
OLE_Head Â
Collection Management Â
OLE_E-Resource Â
OLE_Cataloger Â
OLE_Circ_Staff Â
OLE_E-ResouceManager
- Permissions
Create, Edit, Delete, View E-Resource Records Â
Start Trial/ Licensing sub-workflow(s)Â
View E-Instance
Edit E-Instance
Relink E-Instance
Restore E-Instance
Delete E-InstanceÂ
Â
Component Design
- OBJ.xml
- State Chart Diagram
Service Contracts
Service Implementation
Process Diagram
Work-flow Diagram
Class Diagram :
ER Diagram :
Wireframes
UI Wire-frames Design
Main Tab
Instance Tab
PurchaseOrder Tab
Licenses Tab
Event Log Tab
Search
E-Instance Create
Sample KRAD UIs
Main Tab
PurchaseOrder Tab
Licenses Tab
EventLog Tab
E-Resource Search UI
Data Model
User Story : E-Resource Record
Entity: OLE_E_RES_REC_T
Name | Max Len | Data Type | Default Value | Input  Type | Action Event | Validation Type | Tab Index | Remarks |
E_RES_REC_ID | 10 | VARCHAR |  |  |  |  |  | E-Resource  Unique Identifier |
OBJ_ID | 36 | VARCHAR | Â | Â | Â | Â | Â | Object identifier |
VER_NBR | 8,0 | DECIMAL | Â | Â | Â | Â | Â | version number |
NM | 10 | VARCHAR | Â | Â | Â | Â | Â | Name of the E-Resource |
DESC | 800 | VARCHAR | Â | Â | Â | Â | Â | Description for the E-Resource |
PUBHR | 500 | VARCHAR | Â | Â | Â | Â | Â | Publisher |
GOKB_ID | 100 | VARCHAR | Â | Â | Â | Â | Â | GOKB identifier (not included 1.0) |
ISBN | 100 | VARCHAR | Â | Â | Â | Â | Â | shows the $a subfield of the ISBN/ISSN number if only 1 title is linked |
STAT_CD | 40 | VARCHAR |  |  |  |  |  | Status of the E-Resource  (reference from the user configurable status ) |
STAT_DT | Â | DATETIME | null | Â | Â | Â | Â | Status change date and time |
PLTFRM_PROV | 250 | VARCHAR | Â | Â | Â | Â | Â | pulls from the Platform provider(s) from Instance |
FD_CD | 10 | VARCHAR | Â | Â | Â | Â | Â | Fund Code (reference from the user configurable Fund Code) |
VNDR_HDR_GNRTD_ID | 10,8 | DECIMAL | Â | Â | Â | Â | Â | Vendor Code |
VNDR_DTL_ASND_ID | 10,8 | DECIMAL | Â | Â | Â | Â | Â | Â |
ESTD_PR | 40 | VARCHAR | Â | Â | Â | Â | Â | Estimated Price |
MTRL_TYP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Material Type Code (reference from the user configurable Material Type) |
CONT_TYP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Content Type Code (reference from the user configurable Content Type) |
ORD_TYP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Order Type Code (reference from the user configurable Order Type) |
PAYMT_TYP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Payment Type Code (reference from the user configurable Payment Type) |
FRMT_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Format Type Code (reference from the user configurable Format Type) |
PCKG_TYP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Package Type Code (reference from the user configurable Package Code, also this will be pulled in from GOKB) |
PCKG_SCP_ID | 10 | VARCHAR | Â | Â | Â | Â | Â | Package Scope Code (reference from the user configurable Package Scope, also this will be pulled in from GOKB) |
BRKBLE | 1 | VARCHAR | Â | Â | Â | Â | Â | User can check/ not check(This will be pulled in from GOKB) |
FD_TITLE_LST | 1 | VARCHAR | Â | Â | Â | Â | Â | User can check/ not check(This will be pulled in from GOKB) |
NTE | 800 | VARCHAR | Â | Â | Â | Â | Â | Notes about the Deal |
PUB_DISP_NOTE | 800 | VARCHAR | Â | Â | Â | Â | Â | Notes that should be displayed to the Public |
REQTR | 40 | VARCHAR | Â | Â | Â | Â | Â | Patron requesting the Resource |
SELTR | 40 | VARCHAR | Â | Â | Â | Â | Â | Librarian Requesting the Resource |
REQ_SEL_COMM | 800 | VARCHAR | Â | Â | Â | Â | Â | Explains the notes about the request |
REQ_PRTY_ID | 40 | VARCHAR | Â | Â | Â | Â | Â | Priority of the request |
TECH_REQ | 800 | VARCHAR | Â | Â | Â | Â | Â | Notes about Technical Restriction |
ACC_TYP_CD | 40 | VARCHAR | Â | Â | Â | Â | Â | Access Type (References the user configurable Access Tpe) |
NUM_SIMULT_USER | 8,0 | DECIMAL | Â | Â | Â | Â | Â | Number of Simultaneous users |
AUTHCAT_TYP_ID | 40 | VARCHAR | Â | Â | Â | Â | Â | Authentication Type (References the user configurable Authentication Type) |
ACC_LOC_ID | 40 | VARCHAR | Â | Â | Â | Â | Â | Access Location (References User Configurable Access Location) |
TRL_ND | 1 | VARCHAR | Â | Â | Â | Â | Â | Checks, when a trail workflow started else non editable |
TRL_STAT | 40 | VARCHAR | Â | Â | Â | Â | Â | Status of the created Trail document |
LIC_ND | 1 | VARCHAR | Â | Â | Â | Â | Â | Checks, when a License Request document workflow started else non editable |
LIC_REQ_STAT | 40 | VARCHAR | Â | Â | Â | Â | Â | Status of the created License Request document |
ODR_PAY_STAT | 40 | VARCHAR | Â | Â | Â | Â | Â | Status of the created PurchaseOrder document |
ACT_STAT | 40 | VARCHAR | Â | Â | Â | Â | Â | Status of the created Access document |
Operated as a Community Resource by the Open Library Foundation