Deliver Module

Unknown macro: {composition-setup}

Unknown macro: {deck}

Unknown macro: {card}

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.

Unknown macro: {card}

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

Unknown macro: {card}

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

Unknown macro: {card}