Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

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}


 

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

 

 

 

 

 

 

 

Unknown macro: {card}

  • No labels