Library Operations

Library Operations

Table Name Lbo_Lbodad_Doc_Applity_Dtl

Table Comment Document Applicability Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lbodad_Seq_No	int	NOT NULL	Key Sequence No	Yes	No
Lbodad_Object	varchar(20)	NULL	If a value is selected in Applicability control in the header fields, then user will enter Aircraft Reg #, Model #, Part # here, for which current document applicability should apply.	No	No
Lbodad_Remarks	varchar(20)	NULL	some remarks on the applicability object entered in last column.	No	No
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	Yes
Lbodad_Rev_No	varchar(20)	NOT NULL	Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	Yes
Lbodad_Document_No	varchar(20)	NOT NULL	A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	Yes

Table Name Lbo_Lboddi_Doc_Dist_Info

Table Comment Document Distribution Informations
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lboddi_Fax	varchar(20)	NULL	Fax number of the member is fetched and displayed here. For new members added here, user has to enter their fax number. User can also update phone numbers of existing members.	No	No
Lboddi_Phone	varchar(20)	NULL	Phone number of the member is fetched and displayed here. For new members added here, user has to enter their contact number. User can also update phone numbers of existing members.	No	No
Lboddi_Email	varchar(20)	NULL	Email address of the member is fetched and displayed here. For new members added here, user has to enter their Email address. User can also update Email address of existing members.	No	No
Lboddi_Dist_Remarks	varchar(20)	NULL	Any remark relevant to the document distribution to the respective person is entered here.	No	No
Lboddi_Ack_Status	varchar(20)	NULL	Combo is to be loaded with pre defined values: Not Required, Pending and Required. The values mapped with each of the members in the Std. Distribution list will be defaulted here. User will select the status value for each the new user added here, and may modify the status value for existing users.	No	No
Lboddi_Codition	varchar(20)	NULL	Combo is loaded with pre defined values: Usable, Discarded. User has to select one of these for all the documents lying with all the members, populated/added in the multiline. The value states whether a particular copy with the associated member is usable or has been discarded.	No	No
Lboddi_Return_Date	datetime	NULL	The expected return date of the respective document for each of the members is recorded in this field. This is mandatory if the distribution type is "Returnable".	No	No
Lboddi_Std_Issue_Dur	int	NULL	Standard Issue Duration (in days)	No	No
Lboddi_Updated_By	varchar(20)	NOT NULL	The last login-user, who has updated the information on this page, is displayed here.	No	No
Lboddi_Reference		NULL	The reference information, for the members in the multiline/new members added, is entered here.	No	No
Lboddi_Updated_Date	datetime	NOT NULL	The last date, on which the distribution information for this document was updated, is displayed here.	No	No
Lboddi_Ack_Datetime	varchar(30)	NULL	If the member has acknowledged receipt of the document, then the date of acknowledgement and time tobe captured here.	No	No
Lboddi_Ack_User_Status	varchar(20)	NULL	This combo is a quick code to be loaded with various user defined values of Acknowledged Status, defined in Maintain Quick Codes	No	No
Lboddi_Ack_By	varchar(20)	NULL	If a person has already acknowledged receipt of the document, then it should be fetched and displayed here. Else the person who has received the document, but not yet acknowledged, is to be entered here. If a person does not have login rights like Suppliers, then librarian on their behalf can acknowledge here, by entering his/her own login-id.	No	No
Lboddi_Ack_Remarks		NULL	Remarks or comments given by each member with respect to the document can be captured in this field.	No	No
Lboddi_Timestamp	int	NOT NULL	Timestamp	No	No
Lboddi_Dist_Date	datetime	NOT NULL	The date on which the document was distributed to the user is entered/modified here. And if list is being prepared for distribution, then date of distribution can be mentioned here.	No	No
Lboddi_Seq_No	int	NOT NULL	Key Sequence No	Yes	No
Lboddi_User_Type	varchar(20)	NOT NULL	The ’user type’ of the member, to whom the document is to be distributed, is captured and displayed here. The combo is loaded with pre defined values: Library, Work center, Supplier, Customer, Employee, Others. For members not present in mapped Std. Distribution list, but entered directly here, user can select one of the above six categories. User can also change the category of the member from one to another, for that particular document distribution.	No	No
Lboddi_User_Info	varchar(20)	NULL	Any info on member as provided in Std. Distribution list is fetched here. User can edit this information. For members not present in mapped Std. Distribution list, but entered directly here, user can enter User information for them.	No	No
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	Yes
Lboddi_Rev_No	varchar(20)		Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	Yes
Lboddi_Document_No	varchar(20)		A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	Yes
Lboddi_Location	varchar(20)	NULL	The location of document distribution is entered in this field.	No	No
Lboddi_No_of_Copies	int	NOT NULL	Number of copies distributed to each of the member in the list, and to new members added, is to be entered here.	No	No
Lboddi_Dist_Reason	varchar(20)	NULL	Distribution reason for each of the members populated in the multiline, or new members added here, is to be entered in this field.	No	No
Lboddi_Media	varchar(20)	NOT NULL	The medium in which the document was distributed to each of the member populated/added in multiline is entered here. The combo is loaded with different media types that are user defined in Maintain Quick codes activity.	No	No
Lboddi_User_Name	varchar(20)	NULL	The login user for the user info identified (as recorded in Std. Distribution member list), will be displayed here. User can enter a new member name, by launching Help on User Name page.	No	No
Lboddi_Emp_Code	varchar(20)	NULL	The member name as recorded in Std. Distribution member list, will be displayed here. User can enter a new employee number, who is not a part of the mapped standard distribution list, by launching Help on Employee Number page.	No	No
Lboddi_Dist_Type	varchar(20)	NULL	The distribution type of the document for the concerned member is to be defaulted in the multiline. The combo is to be loaded with predefined values: Permanent, Returnable, and Returned. User can reset any of these values, for any of the members. And for new members added to list here, user can select any of the available three values.	No	No
Lboddi_Emp_OU	int	NULL	Employee OUInstance	No	No

Table Name Lbo_Lbodi_Document_Info

Table Comment This Table captures all information related to the document, classifies it under a user-defined category. Each of the document received in a library, can be provided a unique identifying reference as ’Document #’.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	No
Lbodi_Document_No	varchar(20)	NOT NULL	A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	No
Lbodi_Rev_No	varchar(20)	NOT NULL	Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	No
Lbodi_Library_No	varchar(20)	NOT NULL	The unique identifying reference allotted to the library. This is mandatory information.	No	No
Lbodi_Status	varchar(20)	NULL	Pre Defined values here are: Fresh, Active, Inactive, Revised, and Obsolete. This field is used to set the status of document concerned.	No	No
Lbodi_Doc_Title	varchar(20)	NOT NULL	A mandatory field. The title of the document or document name has to be entered here.	No	No
Lbodi_Doc_Type	varchar(20)	NULL	All Reference Document Type pages that are Active and have attribute ’Maintained in Library?’ flag set as ’ Yes’ in Common Masters in Create Reference Document Type, will be loaded in combo here. It’s a mandatory field	No	No
Lbodi_Doc_Cat	varchar(20)	NULL	Quick Codes defined for Document Category Quick Code Type in ’Active’ status will be loaded. The values for this combo are defined in maintain quick codes activity.	No	No
Lbodi_Doc_Subject	varchar(20)	NULL	A brief note on the subject to which the document relates to.	No	No
Lbodi_Doc_Purpose	varchar(20)	NULL	User defined quick codes will be loaded in this combo. Users can set/change the purpose of document here.	No	No
Lbodi_Doc_Nature	varchar(20)	NULL	User defined quick codes to be loaded in this combo here. On screen launch the existing document nature value for the particular document will be loaded here. It can be changed, to some other values loaded in the combo.	No	No
Lbodi_Doc_Class	varchar(20)	NULL	User defined quick codes to be loaded in this combo here. On screen launch the existing document class value for the particular document will be loaded here. It can be changed, to some other values loaded in the combo.	No	No
Lbodi_No_of_Copies	int	NOT NULL	Number of copies received for each of the documents at the time of registration is entered here.	No	No
Lbodi_Usable_Copies	int	NOT NULL	No of Usable Copies in the Library for the Document.	No	No
Lbodi_Discarded_Copies	int	NOT NULL	The number of copies discarded for the document concerned will be displayed here.	No	No
Lbodi_Appl_Lvel	varchar(20)	NULL	Provides user with facility to set applicability of the document. Applicability values loaded in combo are: Model, Aircraft, Part, Others.	No	No
Lbodi_Std_Dist_List	varchar(20)	NULL	All the active distribution lists will be loaded in the combo here. User can set/change the distribution list to which he wants the document to be associated with.	No	No
Lbodi_Source_Typ	varchar(20)	NULL	Provision for selecting the source of documents that are to be registered. Values loaded in combo are from the user defined Quick Codes in maintain Quick codes activity.	No	No
Lbodi_Doc_Ref_no	varchar(20)	NULL	User enterable field for entering a reference number to the document being registered.	No	No
Lbodi_Ref_Doc_Typ	varchar(20)	NULL	User can set a reference document type or change it. The combo will be loaded with the following Reference document types: Customer Order # Visit Package # Hangar Work Order # Work Scope # Technical Log # Engineering Order # Repair Order Others	No	No
Lbodi_Ref_Doc_Dtl	varchar(20)	NULL	The details pertaining to selected reference document type can be entered/modified by the user in this field. This will not be validated with the respective documents	No	No
Lbodi_Oth_Keyword1	varchar(20)	NULL	Key word related to document.	No	No
Lbodi_Oth_Keyword2	varchar(20)	NULL		No	No
Lbodi_Oth_Keyword3	varchar(20)	NULL		No	No
Lbodi_Web_Ref	varchar(20)	NULL	Web reference, if entered during registering document, will be fetched here. Or else, user can enter/edit web reference in this column.	No	No
Lbodi_Remarks	varchar(20)	NULL	Document reference #, if entered during registering document, will be fetched here. It is any reference for the document # under consideration.	No	No
Lbodi_Oth_Filename	varchar(20)	NULL	Other Filename Reference.	No	No
Lbodi_Filename	varchar(20)	NULL	Path of files that are to be attached, or tagged against the document, should be entered here.	No	No
Lbodi_Created_By	varchar(20)	NULL	Name of the login user who created the library information.	No	No
Lbodi_Created_date	datetime	NOT NULL	Date on which the library information is created.	No	No
Lbodi_Modified_By	varchar(20)	NULL	Name of the login user who is the last to modify respective library information.	No	No
Lbodi_Modified_Date	datetime	NULL	The last date on which the particular library information was modified.	No	No
Lbodi_Registered_By	varchar(20)	NULL	Name of the login user who registered the library information.	No	No
Lbodi_Registered_Date	datetime	NULL	The last date on which the particular library information was registered	No	No
Lbodi_Registered_At	varchar(20)	NULL	The place/location on which the particular library information was registered	No	No
Lbodi_Revised_By	varchar(20)	NULL	Name of the login user who is the last to revised respective library information.	No	No
Lbodi_Revised_Date	datetime	NULL	The last date on which the particular library information was revised.	No	No
Lbodi_Timestamp	int	NOT NULL	Timestamp	No	No
Lbodi_Archive	varchar(20)	NULL	Archive Flag-It wil be set to ’Y’, when the document is Registered from Archive Document Activity	No	No
Lbodi_Ref_Doc_OU	int	NULL	Reference document OU	No	No

Table Name Lbo_Lbodpc_Doc_Partnr_Corr

Table Comment Document Partner Correspondence
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lbodpc_Corr_Status	varchar(20)	NOT NULL	The values of this combo are to be loaded with user defined quick codes, for ’Corresponding Status’ quick code type.	No	No
Lbodpc_Partner_Remarks	varchar(20)	NULL	Remarks given by respective partner could be entered/modified in this column.	No	No
Lbodpc_Inchge_Remarks	varchar(20)		Library In-charge remarks relating to the concerned partner could be entered/modified here.	No	No
Lbodpc_Updated_Date	datetime	NOT NULL	The system date, as on which, the Partner details were updated for the last time, is displayed here.	No	No
Lbodpc_Reference	varchar(20)	NULL	Any reference for correspondence with the partner could be entered/modified here.	No	No
Lbodpc_Updated_By	varchar(20)	NOT NULL	The login user name, who updated the corresponding partner details, is displayed here.	No	No
Lbodpc_Timestamp	int	NOT NULL	Timestamp	No	No
Lbodpc_Document_No	varchar(20)	NOT NULL	A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	Yes
Lbodpc_Rev_No	varchar(20)	NOT NULL	Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	Yes
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	Yes
Lbodpc_Partner_Details	varchar(20)	NOT NULL	Details of partner, like name & contact information could be recorded here.	No	No
Lbodpc_Corr_Cat	varchar(20)	NOT NULL	The values of this combo are to be loaded with user defined quick codes, for ’Corresponding Category’ quick code type.	No	No
Lbodpc_Seq_No	int	NOT NULL	Key Sequence No	Yes	No
Lbodpc_Corr_Date	datetime	NOT NULL	The date of correspondence is to be entered in this field.	No	No

Table Name Lbo_Lbodpd_Doc_PubSrc_Dtl

Table Comment This Table records the details on its source as well as publishers.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lbodi_Receipt_Datetime	datetime	NULL	The date and time of receiving the documents have to be entered here.	No	No
Lbodi_Received_From	varchar(20)	NULL	Source name from which the document has come to the library. User enterable field. Can have any value.	No	No
Lbodi_Source_Typ	varchar(20)	NULL	Provision for selecting the source of documents that are to be registered. Values loaded in combo are from the user defined Quick Codes in maintain Quick codes activity.	No	No
Lbodi_Cost	int	NULL	The cost of the document is entered here, in the editable text box. Existing cost can also be updated here.	No	No
Lbodi_PO_Refno	varchar(20)	NULL	If purchase order was used for procuring the current document, then PO # is to be entered here.	No	No
Lbodi_Receipt_Ref	varchar(20)	NULL	Receipt reference number or details of the receipt, which was used while receiving documents in the library, is to be entered here. User can even update the existing values.	No	No
Lbodi_Currency	varchar(20)	NULL	If cost value is entered, then selection of one of the currency denominations is mandatory.	No	No
Lbodpd_Document_No	varchar(20)	NOT NULL	A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	Yes
Lbodpd_Rev_No	varchar(20)	NOT NULL	Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	Yes
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	Yes
Lbodi_Cont_Details	varchar(20)	NULL	The contact details of the publisher could be entered / modified in this field.	No	No
Lbodi_Publish_Ref	varchar(20)	NULL	The reference details of the publisher could be entered / modified in this field.	No	No
Lbodi_Publisher	varchar(45)	NULL	Publisher - who has printed or created the concerned document.	No	No
Lbodi_Publish_date	datetime	NULL	The date of publication of document has to be entered here.	No	No

Table Name Lbo_Lbodrd_Doc_RevPlcy_Dtl

Table Comment This table maintains the Revision/Policy details of the document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Lbodrd_Rev_Reason	varchar(20)	NULL	When a document undergoes revision, the reason for the same can be recorded here.	No	No
Lbodi_Revised_date	datetime	NULL	The date of revision of document has to be entered here. Should be entered only if all documents to be registered at that point of time have the same revision date.	No	No
Lbodrd_Superced_Action	varchar(20)	NULL	superseding Action combo according to following rules: &nbsp1) If Action on Prev Rev is ’As Required’ or ’None’ then load ’None’ &nbsp2)If Action on Prev Rev is ’Supercede Prev Rev’ then it has to be loaded with &nbspthe following values in the combo : None, Discard Locally, Return to Library.	No	No
Lbodrd_Rev_Implication	varchar(20)	NULL	The combo is to be loaded with user defined quick code values as created for the quick code type: ’Revision Implications’ in Maintain Quick Codes activity. This is to identify any implication because of the revision of the document #.	No	No
Lbodrd_Rev_Remarks	varchar(20)	NULL	When a document undergoes revision, the remarks for the same can be recorded here.	No	No
Lbodrd_Superced_Rev_No	varchar(20)	NULL	Superseding Revision No	No	No
Lbodrd_Rev_Action_Status	varchar(20)	NULL	The combo is to be loaded with user defined quick code values as created for the quick code type: ’Revision Action Status’ in Maintain Quick Codes activity. This could be related to the action taken with respect to the implication of the document revision.	No	No
Lbodrd_Document_No	varchar(20)	NOT NULL	A mandatory field. It is the unique identifying number to be entered by user, for identifying a particular document. Cannot be changed / modified later on.	Yes	Yes
Lbodrd_Rev_No	varchar(20)	NOT NULL	Some documents might have undergone revisions. The revision # of the current document being registered needs to be entered. Cannot be modified later.	Yes	Yes
Lbodi_OUInstance	int	NOT NULL	The Organization unit at which user has logged in the system, and created the Library Details.	Yes	Yes
Lbodrd_Rev_Action_On	varchar(20)	NULL	’Action on Previous Revision’ combo (in Revision Details/Policy tab page) with values: None, Supersede Previous Revision, As Required.	No	No
Lbodrd_Rev_Due_On	datetime	NULL	The next revision due date is to be entered here.	No	No
Lbodrd_Rev_Cycle	varchar(20)	NULL	Combo is to be loaded with Pre Defined values: Not Required, As Required, or Periodic. User can select any of these values to define the periodicity of document revision	No	No
Lbodrd_Rev_Interval	int	NULL	If the value in above combo is selected as: Required, then entering time interval value in this combo is mandatory.	No	No