Data Model User Story : E-Resource RecordEntity: 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