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 :* *

Wiki Markup

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

label	Workflow

Image Added

Card

label	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

Card

label	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 | | | | | | | |

	40	varchar
PTRN_BILL_ID

| 40 | varchar | | | | | | | |

	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}

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

{color} | 20 | varchar | | | | | | | | {color:#000000}ITM_ID{color} | 40 | varchar | | | | | | | | {color:#000000}

	20	varchar
ITM_ID	40	varchar
OLE_PTRN_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
PTRN_Q_POS

{color} | 20 | varchar | | | | | | | | {color:#000000}

	20	varchar
PROXY_PTRN_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
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}

	40	varchar
CNTNT_DESC	800	varchar
CPY_FRMT	80	varchar
RQST_EXPIR_DT_TIME		DATETIME
RCAL_NTC_SNT_DT

{color} | | DATE | | | | | | | | {color:#000000}

		DATE
ONHLD_NTC_SNT_DT

{color} | | DATE | | | | | | | | {color:#000000}

		DATE
LOAN_TRAN_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
PCKUP_LOC_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
CRTE_DT_TIME

{color} | | DATETIME | | | | | | | | {color:#000000}

		DATETIME
MODI_DT_TIME

{color} | | DATETIME | | | | | | | | {color:#000000}

		DATETIME
OPTR_CRTE_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
OPTR_MODI_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}MACH_ID{color} | 100 | varchar | | | | | | | | {color:#000000}

	40	varchar
MACH_ID	100	varchar
CIRC_LOC_ID

{color} | 40 | varchar | | | | | | | *Entity :* *

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 | | | | | | | |

	40	varchar
OLE_RQST_TYP_CD

| 40 | varchar | | | | | | | |

	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}

Name	Max Len	Data Type	Default Value	Input Type	Action Event	Validation Type	Tab Index	Remarks
OLE_RQST_HSTRY_REC_ID

{color}\\ | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
OLE_RQST_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}ITM_ID{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
ITM_ID	40	varchar
PO_LN_ITM_NO

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
OLE_RQST_TYP_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
PCKUP_LOC_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
RQST_CRTE_OPTR_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
RQST_MODI_OPTR_ID

{color} | 40 | varchar | | | | | | | | {color:#000000}

	40	varchar
RQST_MACH_ID

{color} | 80 | varchar | | | | | | | | {color:#000000}

	80	varchar
RQST_CRTE_DT_

TIME{color} | | DATETIME | | | | | | | | {color:#000000}

TIME		DATETIME
RQST_MODI_DT_TIME

{color} | | DATETIME | | | | | | | | {color:#000000}

		DATETIME
CRTE_DT_TIME

{color} | | DATETIME | | | | | | | | {color:#000000}OPTR_ID{color} | 40 | varchar | | | | | | | | {color:#000000}MACH_ID{color} | 80 | varchar | | | | | | | *Entity* : *

		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 | | | | | | | |

	40	varchar
Circ_loc_desk_Code

| 40 | varchar | | | | | | | |

	40	varchar
Circ_loc_desk_Name

| 100 | varchar | | | | | | | |

	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}

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

{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* *:* *

	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 | |

	40	varchar						System Generated
OLE_PTRN_ID

| 40 | varchar | | | | | | | |

	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}

	40	varchar
TEXT_ADDR	1000	varchar
ADDR_SOURCE	40	varchar
ADDR_VERIFIED	1	varchar
ADDR_VALID_FROM		DATE
ADDR_VALID_TO		DATE

Card

label	ERD

Image Added

Version	Old Version 36	New Version 37
Changes made by	Vijay Padmanabhan	Vijay Padmanabhan
Saved on	Jan 23, 2013	Jan 23, 2013

Page Comparison

Versions Compared

Key