- Created by Manoj Rawat (Unlicensed) , last modified by Vijay Padmanabhan on Jan 23, 2013
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 38 Next »
Description
Libraries purchase and catalog materials for the sole purpose of making those items available to Patrons and
other libraries or systems via circulation and discovery. The Deliver module covers the interactions between the
library, its collection, patrons and discovery systems. The Deliver processes include check in, check out, renew,
request, hold, managing patron accounts, notices, fines and fees, inter-library loan and course reserves.
S.No |
Process |
1 |
|
2 |
Check-Out |
3 |
Renew |
4 |
Request |
5 |
|
6 |
Patron |
7 |
Circulation Desk |
8 |
Overdue and Courtesy Notices |
Entity:OLE_DLVR_CIRC_RECORD
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
CIR_HIS_REC_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
LOAN_TRAN_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Loan Record |
CIRCULATION_POLICY_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Rules Record |
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Patron Record |
PTRN_TYP_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Patron Type Record |
AFFILIATION_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Affiliation Type Record |
DEPARTMENT_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Department Record |
OTHER_AFFILIATION |
40 |
varchar |
|
|
|
|
|
|
STATISTICAL_CATEGORY |
40 |
varchar |
|
|
|
|
|
|
ITM_ID |
40 |
varchar |
|
|
|
|
|
|
BIB_TIT |
500 |
varchar |
|
|
|
|
|
|
BIB_AUTH |
500 |
varchar |
|
|
|
|
|
|
BIB_EDITION |
500 |
varchar |
|
|
|
|
|
|
BIB_PUB |
500 |
varchar |
|
|
|
|
|
|
BIB_PUB_DT |
|
DATE |
|
|
|
|
|
|
BIB_ISBN |
50 |
varchar |
|
|
|
|
|
|
PROXY_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
DUE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
PAST_DUE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CIRC_LOC_ID |
40 |
varchar |
|
|
|
|
|
|
OPTR_CRTE_ID |
40 |
varchar |
|
|
|
|
|
|
OPTR_MODI_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
100 |
varchar |
|
|
|
|
|
|
OVRR_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
NUM_RENEWALS |
3 |
varchar |
|
|
|
|
|
|
NUM_OVERDUE_NOTICES_SENT |
3 |
varchar |
|
|
|
|
|
|
OVERDUE_NOTICE_DATE |
|
DATE |
|
|
|
|
|
|
OLE_RQST_ID |
40 |
varchar |
|
|
|
|
|
|
REPMNT_FEE_PTRN_BILL_ID |
40 |
varchar |
|
|
|
|
|
|
CHECK_IN_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CHECK_IN_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
CHECK_IN_MACH_ID |
100 |
varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_TEMP_CIRC_RECORD
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
TMP_CIR_HIS_REC_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
ITM_ID |
40 |
varchar |
|
|
|
|
|
|
CIRC_LOC_ID |
40 |
varchar |
|
|
|
|
|
|
CHECK_IN_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
Entity : OLE_DLVR_LOAN_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
LOAN_TRAN_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
CIRCULATION_POLICY_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Rules Record |
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Patron Record |
ITM_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Item Record |
PROXY_PTRN_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Patron Record |
CURR_DUE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
PAST_DUE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CIRC_LOC_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Circulation Location Record |
OPTR_CRTE_ID |
40 |
varchar |
|
|
|
|
|
|
OPTR_MODI_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
100 |
varchar |
|
|
|
|
|
|
OVRR_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
NUM_RENEWALS |
3 |
varchar |
|
|
|
|
|
|
NUM_OVERDUE_NOTICES_SENT |
3 |
varchar |
|
|
|
|
|
|
N_OVERDUE_NOTICE |
3 |
varchar |
|
|
|
|
|
|
OVERDUE_NOTICE_DATE |
|
DATE |
|
|
|
|
|
|
OLE_RQST_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Request Record |
REPMNT_FEE_PTRN_BILL_ID |
40 |
varchar |
|
|
|
|
|
Foreign Key from Patron Bill Payment Record |
CLAIMS_RET_IND |
1 |
varchar |
|
|
|
|
|
|
Entity : OLE_PTRN_BILL_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
PTRN_BILL_ID |
40 |
varchar |
|
|
|
|
|
|
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
PROXY_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
ITM_ID |
40 |
varchar |
|
|
|
|
|
|
ITM_BARCODE |
100 |
varchar |
|
|
|
|
|
|
FEE_TYP_ID |
40 |
varchar |
|
|
|
|
|
|
FEE_TYP_AMT |
8,2 |
decimal |
|
|
|
|
|
|
TOT_AMT_DUE |
8,2 |
Decimal |
|
|
|
|
|
|
UNPAID_BAL |
8,2 |
Decimal |
|
|
|
|
|
|
PAY_STATUS_ID |
40 |
varchar |
|
|
|
|
|
|
PAY_METHOD_ID |
40 |
varchar |
|
|
|
|
|
|
PAY_AMT |
8,2 |
Decimal |
|
|
|
|
|
|
PAY_DT |
|
DATE |
|
|
|
|
|
|
PAY_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
PAY_MACH_ID |
80 |
varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
OPTR_CRTE_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
80 |
varchar |
|
|
|
|
|
|
NOTE |
500 |
varchar |
|
|
|
|
|
|
Entity : OLE_PTRN_FEE_TYPE_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
FEE_TYP_ID |
40 |
varchar |
|
|
|
|
|
|
FEE_TYP_CD |
40 |
varchar |
|
|
|
|
|
|
FEE_TYP_NM |
100 |
varchar |
|
|
|
|
|
|
Entity : OLE_PTRN_SYS_GEN_BILL_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_PTRN_SYS_GEN_BILL_ID |
40 |
varchar |
|
|
|
|
|
|
PTRN_BILL_ID |
40 |
varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
|
datetime |
|
|
|
|
|
|
OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
80 |
varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_RQST_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_RQST_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
PO_LN_ITM_NO |
20 |
varchar |
|
|
|
|
|
|
ITM_ID |
40 |
varchar |
|
|
|
|
|
|
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
PTRN_Q_POS |
20 |
varchar |
|
|
|
|
|
|
PROXY_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
OLE_RQST_TYP_ID |
40 |
varchar |
|
|
|
|
|
|
CNTNT_DESC |
800 |
varchar |
|
|
|
|
|
|
CPY_FRMT |
80 |
varchar |
|
|
|
|
|
|
RQST_EXPIR_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
RCAL_NTC_SNT_DT |
|
DATE |
|
|
|
|
|
|
ONHLD_NTC_SNT_DT |
|
DATE |
|
|
|
|
|
|
LOAN_TRAN_ID |
40 |
varchar |
|
|
|
|
|
|
PCKUP_LOC_ID |
40 |
varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
OPTR_CRTE_ID |
40 |
varchar |
|
|
|
|
|
|
OPTR_MODI_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
100 |
varchar |
|
|
|
|
|
|
CIRC_LOC_ID |
40 |
varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_RQST_TYP_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_RQST_TYP_ID |
40 |
varchar |
|
|
|
|
|
|
OLE_RQST_TYP_CD |
40 |
varchar |
|
|
|
|
|
|
OLE_RQST_TYP_DESC |
100 |
varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_RQST_HSTRY_REC_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_RQST_HSTRY_REC_ID |
40 |
varchar |
|
|
|
|
|
|
OLE_RQST_ID |
40 |
varchar |
|
|
|
|
|
|
ITM_ID |
40 |
varchar |
|
|
|
|
|
|
PO_LN_ITM_NO |
40 |
varchar |
|
|
|
|
|
|
OLE_RQST_TYP_ID |
40 |
varchar |
|
|
|
|
|
|
PCKUP_LOC_ID |
40 |
varchar |
|
|
|
|
|
|
RQST_CRTE_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
RQST_MODI_OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
RQST_MACH_ID |
80 |
varchar |
|
|
|
|
|
|
RQST_CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
RQST_MODI_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
OPTR_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
80 |
varchar |
|
|
|
|
|
|
Entity : OLE_CRCL_DSK_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
Circ_loc_desk_ID |
40 |
varchar |
|
|
|
|
|
|
Circ_loc_desk_Code |
40 |
varchar |
|
|
|
|
|
|
Circ_loc_desk_Name |
100 |
varchar |
|
|
|
|
|
|
Circ_loc_desk_Desc |
400 |
varchar |
|
|
|
|
|
|
Active |
1 |
varchar |
|
|
|
|
|
|
Circ_loc_ID |
40 |
varchar |
|
|
|
|
|
Reference key for Location table |
Entity : OLE_MAP_CRCLDSK_OPTR
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
Cir_Desk_Optr_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
Person_ID |
40 |
varchar |
|
|
|
|
|
Reference key for Person record |
Circ_loc_desk_ID |
40 |
varchar |
|
|
|
|
|
Reference key for Circulation desk record |
Cir_Desk_Optr_Date |
|
DATE |
|
|
|
|
|
|
Entity : OLE_PTRN_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
OLE_PROXY_PTRN_REF_ID |
40 |
varchar |
|
|
|
|
|
|
BORR_TYP |
40 |
varchar |
|
|
|
|
|
|
GENERAL_BLOCK |
1 |
varchar |
|
|
|
|
|
|
GENERAL_BLOCK_NOTE |
1000 |
varchar |
|
|
|
|
|
|
PHOTOGRAPH |
|
BLOG |
|
|
|
|
|
|
DELIVERY_PRIVILEGE |
1 |
varchar |
|
|
|
|
|
|
PAGING_PRIVILEGE |
1 |
varchar |
|
|
|
|
|
|
ACTIVATION_DATE |
|
DATE |
|
|
|
|
|
|
EXPIRATION_DATE |
|
DATE |
|
|
|
|
|
|
SOURCE |
40 |
varchar |
|
|
|
|
|
|
AFFILIATION_ID |
40 |
varchar |
|
|
|
|
|
|
DEPARTMENT_ID |
40 |
varchar |
|
|
|
|
|
|
OTHER_AFFILIATION |
40 |
varchar |
|
|
|
|
|
|
STATISTICAL_CATEGORY |
40 |
varchar |
|
|
|
|
|
|
BARCODE |
100 |
varchar |
|
|
|
|
|
|
PASSWORD |
50 |
varchar |
|
|
|
|
|
|
AUTHENTICATION_ID |
50 |
varchar |
|
|
|
|
|
|
OTHER_ID |
50 |
varchar |
|
|
|
|
|
|
LOST_INVD_BARCODE |
20 |
varchar |
|
|
|
|
|
|
LOST_INVD_BARCODE_EFF_DT |
|
DATE |
|
|
|
|
|
|
STAFF_NOTE |
10001 |
varchar |
|
|
|
|
|
|
COURTESY_NOTICE_PREF |
1 |
varchar |
|
|
|
|
|
|
ACTV_IND |
1 |
varchar |
|
|
|
|
|
|
CRTE_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
MODI_DT_TIME |
|
DATETIME |
|
|
|
|
|
|
OPTR_CRTE_ID |
40 |
varchar |
|
|
|
|
|
|
OPTR_MODI_ID |
40 |
varchar |
|
|
|
|
|
|
MACH_ID |
80 |
varchar |
|
|
|
|
|
|
Entity : OLE_DLVR_PTRN_ADDR_T
Name |
Max |
Data Type |
Default Value |
Input Type |
Action Event |
Validation |
Tab Index |
Remarks |
OLE_DLVR_PTRN_ADDR_ID |
40 |
varchar |
|
|
|
|
|
System Generated |
OLE_PTRN_ID |
40 |
varchar |
|
|
|
|
|
|
ENTITY_ADDR_ID |
40 |
varchar |
|
|
|
|
|
|
TEXT_ADDR |
1000 |
varchar |
|
|
|
|
|
|
ADDR_SOURCE |
40 |
varchar |
|
|
|
|
|
|
ADDR_VERIFIED |
1 |
varchar |
|
|
|
|
|
|
ADDR_VALID_FROM |
|
DATE |
|
|
|
|
|
|
ADDR_VALID_TO |
|
DATE |
|
|
|
|
|
|
- No labels