Library

Table Name Lib_Libdml_Dist_Member_Lst

Table Comment Distribution Member List. This table stores the Member contact informations.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Libdml_Dist_Type

varchar(20)

NULL

Identifies if the distribution of the document to the user is on permanent or returnable basis; would be defaulted/used during actual document distribution.

No

No

Libdml_Ack_flag

 

 

Identifies if the distribution of the document to the user requires acknowledgement or not; would be defaulted/used during actual document distribution

 

 

Libdml_Emp_OU

int

 

Employee OU Instance

 

 

Libdml_Emp_code

varchar(20)

 

A valid employee Number if the user type is employee. (Mandatory if the user type is employee)

 

 

Libdml_Email

varchar(255)

 

User’s email id.

 

 

Libdml_Phone

 

 

User’s contact phone number.

 

 

Libdml_Fax

 

 

User’s fax number.

 

 

Libdml_Comments

 

 

Any remarks related to that employee, or distribution to him/her.

 

 

Libdml_Library_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the library. This is mandatory information.

Yes

Yes

Libdml_Std_Distribution_No

 

 

The unique identifying number for a distribution list. Can’t be modified or deleted

 

 

Libdml_OUInstance

int

 

The Organization unit at which user has logged in the system, and created the Library Details.

 

 

Libdml_User_name

varchar(255)

NULL

Valid login user name of the user .

No

No

Libdml_User_Info

varchar(20)

 

Information of the User identified as the member of the list.

 

 

Libdml_Seq_No

int

NOT NULL

Key Sequence Key

Yes

 

Libdml_User_Type

varchar(20)

NULL

To identify different types of users in a distribution list. Various Pre Defined user types are: Library, Work Center, Supplier, Customer, Employee, Others

No

 

Table Name Lib_Libli_Library_Info

Table Comment Library Information table. This table stores the Library Name, Status, Location, etc.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Libli_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Library Details.

Yes

No

Libli_Library_No

varchar(20)

 

The unique identifying reference allotted to the library. This is mandatory information. Can’t be modified or deleted

 

 

Libli_Library_Name

varchar(255)

NULL

Name - given to the library. This is mandatory information.

No

 

Libli_Library_Category

varchar(20)

 

The category to which the library is associated. The combo gets loaded with values defined in quick codes. Category value can be changed

 

 

Libli_Status

 

 

Sets status of library as: Active or Inactive. Status value can be reset.

 

 

Libli_Location

 

 

Facility to record location of the library.

 

 

Libli_Address

varchar(255)

 

Facility to record complete address of the library.

 

 

Libli_Primary_Contperson

 

 

User Name of the Primary contact person of the library.

 

 

Libli_Phone

 

 

Contact phone number of the library.

 

 

Libli_Fax

 

 

Fax # of the Library

 

 

Libli_Email

 

 

Email of the library or of the primary contact person

 

 

Libli_Created_By

 

 

Name of the login user who created the library information.

 

 

Libli_Created_date

datetime

 

Date on which the library information is created.

 

 

Libli_Modified_By

varchar(255)

 

Name of the login user who is the last to modify respective library information.

 

 

Libli_Modified_Date

datetime

 

The last date on which the particular library information was modified.

 

 

Libli_Timestamp

int

 

Timestamp

 

 

Table Name Lib_Liblid_Lib_Inchge_Dtl

Table Comment Facilitates to define responsible employees for a library as library in-charge.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Liblid_Remarks

varchar(255)

NULL

Facilitates to add any remarks on that particular user

No

No

Liblid_default_flag

varchar(20)

 

Facilitates the user to set one of the In-charges as default for the particular library. Facilitates for modification.

 

 

Liblid_Emp_Code

 

 

Employee # of the library In-Charge. Employee # mapped to the User Name is displayed from Employee Information.

 

 

Liblid_Emp_OU

int

 

Employee OU Instance

 

 

Liblid_OUInstance

 

NOT NULL

The Organization unit at which user has logged in the system, and created the Library Details.

Yes

Yes

Liblid_user_name

varchar(255)

 

Allows user to specify a User name and designate him/her as library in-charge.

 

No

Liblid_Library_No

varchar(20)

 

The unique identifying reference allotted to the library.This is mandatory information.

 

Yes

Table Name Lib_LibPrm_parameter_dtl

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

LibPrm_ComponentName

varchar(20)

NOT NULL

Component Code

Yes

No

LibPrm_ParamCategory

 

 

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

 

 

LibPrm_ParamType

 

 

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

 

 

LibPrm_ParamCode

 

 

Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

 

 

LibPrm_Langid

int

 

Language id. This is the language id of the record.

 

 

LibPrm_ParamDesc

varchar(20)

NULL

Description of the Param Code

No

 

LibPrm_sort_by

int

 

The order in which the values are populated.

 

 

LibPrm_CreationDate

datetime

 

Date of Creation

 

 

Table Name Lib_LibQcd_Quick_Code_Dtl

Table Comment Quick Code details table. Will stores the quick codes defined for all the quick code types

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

LibQcd_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Library Details.

Yes

Yes

LibQcd_Type

varchar(20)

 

The applicable values for this filter are: 1) Document Category2) Document Class3) Document Nature4) Document Purpose5) Source Type6) Media7) Library Category8) Revision Implications9) Rev. Action Status10) Ack. User Status11) Correspondence Category12) Correspondence Status These values would be Pre defined

 

 

LibQcd_Quick_Code

 

 

Any user enterable value that is to be associated with the above mentioned quick code type.

 

No

LibQcd_Desc

varchar(80)

NULL

A brief description on that quick code

No

 

LibQcd_Default_flag

varchar(20)

 

Provision to set the quick code as default for the quick code type selected above. This default value will be loaded automatically in the quick code type combo, in all the User Interfaces where it is used. This default value can later be reset, and some other quick code value could be made as default for the selected quick code type. Only one quick code could be set as default for each quick code type.

 

 

LibQcd_Status

 

 

Enables to set the selected quick code value as Active or Inactive. Only active quick code values would be made available for quick code types during transactions Can be reset again.

 

 

LibQcd_CreatedDate

datetime

 

Date on which Quick Code was created

 

 

LibQcd_Created_By

varchar(255)

 

User who has created the Quick Code

 

 

LibQcd_ModifiedDate

datetime

 

Date on which Quick code was modified

 

 

LibQcd_Modified_By

varchar(255)

 

User who has modified the quick code

 

 

LibQcd_Timestamp

int

 

Time Stamp

 

 

Table Name Lib_LibQch_Quick_Code_Hdr

Table Comment Quick Code Header table. This table stores mandatory falg for all the Quick code types

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

LibQch_OUInstance

int

NOT NULL

The Organization unit at which user has logged in the system, and created the Library Details.

Yes

No

LibQch_Type

varchar(20)

 

The applicable values for this filter are: 1) Document Category2) Document Class3) Document Nature4) Document Purpose5) Source Type6) Media7) Library Category8) Revision Implications9) Rev. Action Status10) Ack. User Status11) Correspondence Category12) Correspondence Status These values would be Pre defined

 

 

LibQch_Mandatory_Flag

 

NULL

Mandatory "Yes" or "No" flag Provision to set whether the Quick Code Type selected in header combo should be Mandatory or Non-mandatory, for the different User-Interfaces, in Library and Library Operations business components. The system would ensure that the Quick Code values of all the mandatory quick code types are specified during any transactions. Can be reset again.

No

 

LibQch_Updated_Date

datetime

 

Date on which Quick code was modified

 

 

LibQch_Updated_By

varchar(255)

 

User who has modified the quick code

 

 

LibQch_Timestamp

int

 

Time Stamp

 

 

Table Name Lib_Libsdl_Std_Dist_Lst

Table Comment Standard Distribution List. List the Std. Distribution List Name, No of members for the list, Remarks.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

Libsdl_Created_Date

datetime

NULL

Date on which the Distribution List information is created

No

No

Libsdl_Created_By

varchar(255)

 

Name of the login user who created the Distribution List information.

 

 

Libsdl_Remarks

 

 

Any remarks related to information on the list

 

 

Libsdl_Modified_By

 

 

Name of the login user who is the last to modify respective Distribution List Information.

 

 

Libsdl_Modified_Date

datetime

 

The last date on which the particular Distribution List  was modified..

 

 

Libsdl_Timestamp

int

 

Timestamp

 

 

Libsdl_Library_No

varchar(20)

NOT NULL

The unique identifying reference allotted to the library. This is mandatory information.

Yes

Yes

Libsdl_OUInstance

int

 

The Organization unit at which user has logged in the system, and created the Library Details.

 

 

Libsdl_No_of_Members

 

NULL

Count of Number of members in the list.

No

No

Libsdl_Status

varchar(20)

 

Provision to set list status as Active or Inactive. It can be changed later

 

 

Libsdl_Std_Distribution_No

 

NOT NULL

The unique identifying number for a distribution list. Can’t be modified or deleted

Yes

 

Libsdl_Dist_Name

 

NULL

Name - given to the above mentioned distribution list number.

No

 

Table Name Lib_set_option_dtl

Table Comment Library management set option detail table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

setoptdtl_ouinstance

int

NOT NULL

OU Instance

Yes

No

SetOptdtl_OptKeyCode

varchar(20)

 

Unique key word to identify the option setting parameter.

 

 

setoptdtl_status

 

NULL

Status of the setting whether defined or not defined.

No

 

setoptdtl_value

int

 

Value of the set option parameter.

 

 

setoptdtl_modiifedby

varchar(255)

 

Last modified user.

 

 

setoptdtl_modifieddate

datetime

 

Last modified date.

 

 

Table Name Lib_set_option_hdr

Table Comment Library management set option header table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

setopthdr_ouinstance

int

NOT NULL

OU Instance for which options are set.

No

No

setopthdr_createdby

varchar(255)

NULL

Created user name.

 

 

setopthdr_createddate

datetime

 

Set options created date.

 

 

setopthdr_modiifedby

varchar(255)

 

Modified user name.

 

 

setopthdr_modifieddate

datetime

 

Modified date.

 

 

setopthdr_timestamp

int

 

Time stamp

 

 

Table Name Lib_set_option_Param_values

Table Comment Library management set option parameter value table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SetOpt_OptKeyCode

varchar(20)

NOT NULL

Unique key word to identify the set option parameter.

Yes

No

SetOpt_Metadata_type

 

NULL

Classification of set option parameters.

No

 

SetOpt_paramcode

 

 

Parameter code.

 

 

SetOpt_paramDesc

 

 

Parameter description

 

 

SetOpt_permittedvalue

varchar(150)

 

Permitted values description. This is a text field by concatenating all the permitted values.

 

 

SetOpt_Mandatory_Check

varchar(25)

 

Flag to check if the parameter is mandatory.

 

 

SetOpt_Sotrby

int

 

Sort by flag.

 

 

Setopt_createdDate

datetime

 

Created date.