Deliver Module

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.

Workflow

Process

S.No	Process
1	Check-In
2	Check-Out
3	Renew
4	Request
5	Bill Payment
6	Patron
7	Circulation Desk
8	Overdue and Courtesy Notices

Data Model

Entity:OLE_DLVR_CIRC_RECORD

Name	Max Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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 Len	Data Type	Default Value	Input Type	Action Event	Validation Type	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

Deliver Module

Description

Workflow

Process

Data Model

ERD