Page Comparison

{composition-setup}

{deck:id=Kuali OLE}

{card:label=Overview}

{section}

{column:width=50%}

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.

{card}

{card:label = Workflow}
!Deliver-WF.jpg|thumbnail,border=1,width=100!
 
{card}

{card:label = Process}
| *S.No* | *            Process* |
| 1 | [Check-In|https://wiki.kuali.org/display/OLE/Check-In]\\ |
| 2 | Check-Out |
| 3 | Renew |
| 4 | Request |
| 5 | [Bill Payment|https://wiki.kuali.org/display/OLE/Bill+Payment] |
| 6 | Patron |
| 7 | Circulation Desk |
| 8 | Overdue and Courtesy Notices |

{card}



{card:label = Data Model}
*Entity:*{*}OLE_DLVR_CIRC_RECORD*


| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data* *Type* | *Default* *Value* | *Input* *Type* | *Action* *Event* | *Validation* \\
*Type* | *Tab* *Index* | *Remarks* |
| {color:#000000}CIR_HIS_REC_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | System Generated |
| {color:#000000}LOAN_TRAN_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Loan Record |
| {color:#000000}CIRCULATION_POLICY_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Rules Record |
| {color:#000000}OLE_PTRN_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Patron Record |
| {color:#000000}PTRN_TYP_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Patron Type Record |
| {color:#000000}AFFILIATION_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Affiliation Type Record |
| {color:#000000}DEPARTMENT_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Department Record |
| {color:#000000}{_}OTHER_AFFILIATION{_}{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}{_}STATISTICAL_CATEGORY{_}{color}\\ | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}ITM_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_TIT{color} | *500* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_AUTH{color} | *500* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_EDITION{color} | *500* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_PUB{color} | *500* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_PUB_DT{color} | \\ | DATE | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}BIB_ISBN{color} | *50* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}PROXY_PTRN_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}DUE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}PAST_DUE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CRTE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}MODI_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CIRC_LOC_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OPTR_CRTE_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OPTR_MODI_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}MACH_ID{color} | *100* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OVRR_OPTR_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}NUM_RENEWALS{color} | *3* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}NUM_OVERDUE_NOTICES_SENT{color}\\ | *3* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OVERDUE_NOTICE_DATE{color}\\ | \\ | DATE | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OLE_RQST_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}REPMNT_FEE_PTRN_BILL_ID{color}\\ | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CHECK_IN_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CHECK_IN_OPTR_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CHECK_IN_MACH_ID{color} | *100* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
\\
\\

*Entity : OLE_DLVR_TEMP_CIRC_RECORD*
\\
| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data* *Type* | *Default* *Value* | *Input* *Type* | *Action* *Event* | *Validation* \\
*Type* | *Tab* *Index* | *Remarks* |
| {color:#000000}TMP_CIR_HIS_REC_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | System Generated |
| {color:#000000}OLE_PTRN_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}ITM_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CIRC_LOC_ID{color} | *40* | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CHECK_IN_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
*Entity : OLE_DLVR_LOAN_T*
| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data* *Type* | *Default* *Value* | *Input* *Type* | *Action* *Event* | *Validation* \\
*Type* | *Tab* *Index* | *Remarks* |
| {color:#000000}LOAN_TRAN_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | System Generated |
| {color:#000000}CIRCULATION_POLICY_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Rules Record |
| {color:#000000}OLE_PTRN_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Patron Record |
| {color:#000000}ITM_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Item Record |
| {color:#000000}PROXY_PTRN_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Patron Record |
| {color:#000000}CURR_DUE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}PAST_DUE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CRTE_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}MODI_DT_TIME{color} | \\ | DATETIME | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}CIRC_LOC_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Circulation Location Record |
| {color:#000000}OPTR_CRTE_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OPTR_MODI_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}MACH_ID{color} | 100 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OVRR_OPTR_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}NUM_RENEWALS{color} | 3 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}NUM_OVERDUE_NOTICES_SENT{color} | 3 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}N_OVERDUE_NOTICE{color} | 3 | varchar | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OVERDUE_NOTICE_DATE{color} | \\ | DATE | \\ | \\ | \\ | \\ | \\ | \\ |
| {color:#000000}OLE_RQST_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Request Record |
| {color:#000000}REPMNT_FEE_PTRN_BILL_ID{color} | 40 | varchar | \\ | \\ | \\ | \\ | \\ | Foreign Key from Patron Bill Payment Record |
| {color:#000000}CLAIMS_RET_IND{color} | 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 | | | | | | |
| {color:#000000}PAY_STATUS_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}PAY_METHOD_ID{color} | 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*
| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data* *Type* | *Default* *Value* | *Input* *Type* | *Action* *Event* | *Validation* \\
*Type* | *Tab* *Index* | *Remarks* |
| {color:#000000}OLE_RQST_ID{color} | 40 | varchar | | | | | | System Generated |
| {color:#000000}PO_LN_ITM_NO{color} | 20 | varchar | | | | | | |
| {color:#000000}ITM_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}OLE_PTRN_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}PTRN_Q_POS{color} | 20 | varchar | | | | | | |
| {color:#000000}PROXY_PTRN_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}OLE_RQST_TYP_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}CNTNT_DESC{color} | 800 | varchar | | | | | | |
| {color:#000000}CPY_FRMT{color} | 80 | varchar | | | | | | |
| {color:#000000}RQST_EXPIR_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}RCAL_NTC_SNT_DT{color} | | DATE | | | | | | |
| {color:#000000}ONHLD_NTC_SNT_DT{color} | | DATE | | | | | | |
| {color:#000000}LOAN_TRAN_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}PCKUP_LOC_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}CRTE_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}MODI_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}OPTR_CRTE_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}OPTR_MODI_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}MACH_ID{color} | 100 | varchar | | | | | | |
| {color:#000000}CIRC_LOC_ID{color} | 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*
| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data Type* | *Default Value* | *Input Type* | *Action Event* | *Validation* \\
*Type* | *Tab Index* | *Remarks* |
| {color:#000000}OLE_RQST_HSTRY_REC_ID{color}\\ | 40 | varchar | | | | | | |
| {color:#000000}OLE_RQST_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}ITM_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}PO_LN_ITM_NO{color} | 40 | varchar | | | | | | |
| {color:#000000}OLE_RQST_TYP_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}PCKUP_LOC_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}RQST_CRTE_OPTR_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}RQST_MODI_OPTR_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}RQST_MACH_ID{color} | 80 | varchar | | | | | | |
| {color:#000000}RQST_CRTE_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}RQST_MODI_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}CRTE_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}OPTR_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}MACH_ID{color} | 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*
| {color:#000000}{*}Name{*}{color} | *Max* \\
*Len* | *Data Type* | *Default Value* | *Input Type* | *Action Event* | *Validation* \\
*Type* | *Tab Index* | *Remarks* |
| {color:#000000}OLE_PTRN_ID{color} | 40 | varchar | | | | | | System Generated |
| {color:#000000}OLE_PROXY_PTRN_REF_ID{color}\\ | 40 | varchar | | | | | | |
| {color:#000000}BORR_TYP{color} | 40 | varchar | | | | | | |
| {color:#000000}GENERAL_BLOCK{color} | 1 | varchar | | | | | | |
| {color:#000000}GENERAL_BLOCK_NOTE{color}\\ | 1000 | varchar | | | | | | |
| {color:#000000}{_}PHOTOGRAPH{_}{color} | | BLOG | | | | | | |
| {color:#000000}DELIVERY_PRIVILEGE{color} | 1 | varchar | | | | | | |
| {color:#000000}PAGING_PRIVILEGE{color} | 1 | varchar | | | | | | |
| {color:#000000}ACTIVATION_DATE{color} | | DATE | | | | | | |
| {color:#000000}EXPIRATION_DATE{color} | | DATE | | | | | | |
| {color:#000000}{_}SOURCE{_}{color} | 40 | varchar | | | | | | |
| {color:#000000}AFFILIATION_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}DEPARTMENT_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}{_}OTHER_AFFILIATION{_}{color} | 40 | varchar | | | | | | |
| {color:#000000}{_}STATISTICAL_CATEGORY{_}{color} | 40 | varchar | | | | | | |
| {color:#000000}BARCODE{color} | 100 | varchar | | | | | | |
| {color:#000000}{_}PASSWORD{_}{color} | 50 | varchar | | | | | | |
| {color:#000000}{_}AUTHENTICATION_ID{_}{color} | 50 | varchar | | | | | | |
| {color:#000000}{_}OTHER_ID{_}{color} | 50 | varchar | | | | | | |
| {color:#000000}{_}LOST_INVD_BARCODE{_}{color} | 20 | varchar | | | | | | |
| {color:#000000}{_}LOST_INVD_BARCODE_EFF_DT{_}{color} | | DATE | | | | | | |
| {color:#000000}STAFF_NOTE{color} | 10001 | varchar | | | | | | |
| {color:#000000}COURTESY_NOTICE_PREF{color} | 1 | varchar | | | | | | |
| {color:#000000}ACTV_IND{color} | 1 | varchar | | | | | | |
| {color:#000000}CRTE_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}MODI_DT_TIME{color} | | DATETIME | | | | | | |
| {color:#000000}OPTR_CRTE_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}OPTR_MODI_ID{color} | 40 | varchar | | | | | | |
| {color:#000000}MACH_ID{color} | 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 | | | | | | |
{card}

{card:label = ERD}


 !Deliver-ERD.jpg|thumbnail,border=1,height=100!

{card}

{deck}