| Data Dictionary -- Library | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | Lib_Libdml_Dist_Member_Lst | Library management set option detail table. |
| 2 | Lib_Liblid_Lib_Inchge_Dtl | Library management set option header table. |
| 3 | Lib_Libli_Library_Info | Library management set option parameter value table. |
| 4 | Lib_LibPrm_parameter_dtl | Distribution Member List. This table stores the Member contact informations. |
| 5 | Lib_LibQcd_Quick_Code_Dtl | Library Information table. This table stores the Library Name, Status, Location, etc. |
| 6 | Lib_LibQch_Quick_Code_Hdr | Facilitates to define responsible employees for a library as library in-charge. |
| 7 | Lib_Libsdl_Std_Dist_Lst | Stores Parameter detail information. In this component, this table needs to store only search criteria message |
| 8 | Lib_set_option_dtl | Quick Code details table. Will stores the quickcodes detined for all the quick code types |
| 9 | Lib_set_option_hdr | Quick Code Header table. This table stores mandatory falg for all the Quick code types |
| 10 | Lib_set_option_Param_values | Standard Distribution List. List the Std. Distribution List Name, No of members for the list, Remarks. |
| Table Name : | |
| Comment : | Library management set option detail table. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Libdml_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| Libdml_Library_No | udd_documentno | varchar(40) | No | The unique identifying reference allotted to the library.This is mandatory information. | Yes |
| Libdml_Std_Distribution_No | udd_documentno | varchar(40) | No | The unique identifying number for a distribution list. Cant be modified or deleted | Yes |
| Libdml_Seq_No | udd_seqno | int(4) | No | Key Sequence Key | Yes |
| Libdml_User_Type | udd_flag | varchar(25) | Yes | To identify different types of users in a distribution list. Various Pre Defined user types are: Library, Work Center, Supplier, Customer, Employee, Others | No |
| Libdml_User_Info | udd_suppliername | varchar(40) | Yes | Information of the User identified as the member of the list. | No |
| Libdml_User_name | udd_hrusername | varchar(25) | Yes | Valid login user name of the user . | No |
| Libdml_Emp_code | udd_hrempcode | varchar(20) | Yes | A valid employee Number if the user type is employee. (Mandatory if the user type is employee) | No |
| Libdml_Emp_OU | udd_ctxt_ouinstance | int(4) | Yes | Employee OUInstance | No |
| Libdml_Dist_Type | udd_flag | varchar(25) | Yes | 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 |
| Libdml_Ack_flag | udd_designparamcode | varchar(5) | Yes | Identifies if the distribution of the document to the user requires acknowledgement or not; would be defaulted/used during actual document distribution | No |
| Libdml_Phone | udd_communicationid | varchar(70) | Yes | Users contact phone number. | No |
| Libdml_Fax | udd_communicationid | varchar(70) | Yes | Users fax number. | No |
| Libdml_Email | udd_communicationid | varchar(70) | Yes | Users email id. | No |
| Libdml_Comments | udd_txt255 | varchar(255) | Yes | Any remarks related to that employee, or distribution to him/her. | No |
| Table Name : | |
| Comment : | Library management set option header table. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Liblid_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| Liblid_Library_No | udd_documentno | varchar(40) | No | The unique identifying reference allotted to the library.This is mandatory information. | Yes |
| Liblid_user_name | udd_hrusername | varchar(25) | No | Allows user to specify a User name and designate him/her as library in-charge. | Yes |
| Liblid_default_flag | udd_designparamcode | varchar(5) | Yes | Facilitates the user to set one of the In-charges as default for the particular library. Facilitates for modification. | No |
| Liblid_Remarks | udd_txt255 | varchar(255) | Yes | Facilitates to add any remarks on that particular user | No |
| Liblid_Emp_Code | udd_hrempcode | varchar(20) | Yes | Employee # of the library In-Charge. Employee # mapped to the User Name is displayed from Employee Information. | No |
| Liblid_Emp_OU | udd_ctxt_ouinstance | int(4) | Yes | Employee OUInstance | No |
| Table Name : | |
| Comment : | Library management set option parameter value table. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Libli_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| Libli_Library_No | udd_documentno | varchar(40) | No | The unique identifying reference allotted to the library.This is mandatory information. Cant be modified or deleted | Yes |
| Libli_Library_Name | udd_txt255 | varchar(255) | Yes | Name - given to the library. This is mandatory information. | No |
| Libli_Library_Category | udd_quickcodes | varchar(25) | Yes | The category to which the library is associated. The combo gets loaded with values defined in quick codes. Category value can be changed | No |
| Libli_Status | udd_designparamcode | varchar(5) | Yes | Sets status of library as: Active or Inactive. Status value can be reset. | No |
| Libli_Location | udd_organizationunit | varchar(40) | Yes | Facility to record location of the library. | No |
| Libli_Address | udd_txt255 | varchar(255) | Yes | Facility to record complete address of the library. | No |
| Libli_Primary_Contperson | udd_hrusername | varchar(25) | Yes | User Name of the Primary contact person of the library. | No |
| Libli_Phone | udd_communicationid | varchar(70) | Yes | Contact phone number of the library. | No |
| Libli_Fax | udd_communicationid | varchar(70) | Yes | Fax # of the Library | No |
| Libli_Email | udd_communicationid | varchar(70) | Yes | Email of the library or of the primary contact person | No |
| Libli_Created_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who created the library information. | No |
| Libli_Created_date | _datetime_8 | datetime(8) | Yes | Date on which the library information is created. | No |
| Libli_Modified_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who is the last to modify respective library information. | No |
| Libli_Modified_Date | _datetime_8 | datetime(8) | Yes | The last date on which the particular library information was modified. | No |
| Libli_Timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| Table Name : | |
| Comment : | Distribution Member List. This table stores the Member contact informations. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LibPrm_ComponentName | udd_ctxt_component | varchar(20) | No | Component Code | Yes |
| LibPrm_ParamCategory | udd_paramcategory | varchar(10) | No | 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. | Yes |
| LibPrm_ParamType | udd_paramtype | varchar(25) | No | 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. | Yes |
| LibPrm_ParamCode | udd_paramcode | varchar(30) | No | Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes |
| LibPrm_Langid | udd_ctxt_language | int(4) | No | Language id. This is the language id of the record. | Yes |
| LibPrm_ParamDesc | udd_paramdesc | varchar(30) | Yes | Description of the Param Code | No |
| LibPrm_sort_by | udd_seqno | int(4) | Yes | The order in which the values are populated. | No |
| LibPrm_CreationDate | _datetime_8 | datetime(8) | Yes | Date of Creation | No |
| Table Name : | |
| Comment : | Library Information table. This table stores the Library Name, Status, Location, etc. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LibQcd_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| LibQcd_Quick_Code | udd_quickcodes | varchar(25) | No | Any user enterable value that is to be associated with the above mentioned quick code type. | Yes |
| LibQcd_Type | udd_designparamcode | varchar(5) | No | 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 Category | Yes |
| LibQcd_Desc | udd_txt80 | varchar(80) | Yes | A brief description on that quick code | No |
| LibQcd_Status | udd_designparamcode | varchar(5) | Yes | 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. | No |
| LibQcd_Default_flag | udd_designparamcode | varchar(5) | Yes | 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 s | No |
| LibQcd_CreatedDate | _datetime_8 | datetime(8) | Yes | Date on which Quick Code was created | No |
| LibQcd_Created_By | udd_ctxt_user | varchar(30) | Yes | User who has created the Quick Code | No |
| LibQcd_ModifiedDate | _datetime_8 | datetime(8) | Yes | Date on which Quick code was modified | No |
| LibQcd_Modified_By | udd_ctxt_user | varchar(30) | Yes | User who has modified the quick code | No |
| LibQcd_Timestamp | udd_timestamp | int(4) | Yes | TimeStamp | No |
| Table Name : | |
| Comment : | Facilitates to define responsible employees for a library as library in-charge. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| LibQch_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| LibQch_Type | udd_designparamcode | varchar(5) | No | 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 Category | Yes |
| LibQch_Mandatory_Flag | udd_designparamcode | varchar(5) | Yes | 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 | No |
| LibQch_Updated_Date | _datetime_8 | datetime(8) | Yes | Date on which Quick code was modified | No |
| LibQch_Updated_By | udd_ctxt_user | varchar(30) | Yes | User who has modified the quick code | No |
| LibQch_Timestamp | udd_timestamp | int(4) | Yes | TimeStamp | No |
| Table Name : | |
| Comment : | Stores Parameter detail information. In this component, this table needs to store only search criteria message |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Libsdl_OUInstance | udd_ctxt_ouinstance | int(4) | No | The Organization unit at which user has logged in the system, and created the Library Details. | Yes |
| Libsdl_Library_No | udd_documentno | varchar(40) | No | The unique identifying reference allotted to the library.This is mandatory information. | Yes |
| Libsdl_Std_Distribution_No | udd_documentno | varchar(40) | No | The unique identifying number for a distribution list. Cant be modified or deleted | Yes |
| Libsdl_Dist_Name | udd_custname | varchar(40) | Yes | Name - given to the above mentioned distribution list number. | No |
| Libsdl_Status | udd_designparamcode | varchar(5) | Yes | Provision to set list status as Active or Inactive. It can be changed later | No |
| Libsdl_No_of_Members | udd_count | int(4) | Yes | Count of Number of members in the list. | No |
| Libsdl_Remarks | udd_txt255 | varchar(255) | Yes | Any remarks related to information on the list | No |
| Libsdl_Created_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who created the Distribution List information. | No |
| Libsdl_Created_Date | _datetime_8 | datetime(8) | Yes | Date on which the Distribution List information is created | No |
| Libsdl_Modified_By | udd_ctxt_user | varchar(30) | Yes | Name of the login user who is the last to modify respective Distribution List Information. | No |
| Libsdl_Modified_Date | _datetime_8 | datetime(8) | Yes | The last date on which the particular Distribution List was modified.. | No |
| Libsdl_Timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| Table Name : | |
| Comment : | Quick Code details table. Will stores the quickcodes detined for all the quick code types |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| setoptdtl_ouinstance | udd_ctxt_ouinstance | int(4) | No | OU Instance | No |
| SetOptdtl_OptKeyCode | udd_documentno | varchar(40) | No | Unique key word to identify the option setting parameter. | No |
| setoptdtl_status | udd_paramcode | varchar(30) | Yes | Status of the setting whether defined or not defined. | No |
| setoptdtl_value | udd_groupno | int(4) | Yes | Value of the set option parameter. | No |
| setoptdtl_modiifedby | udd_ctxt_user | varchar(30) | Yes | Last modified user. | No |
| setoptdtl_modifieddate | _datetime_8 | datetime(8) | Yes | Last modified date. | No |
| replication_key | _BIGINT_8 | Bigint(8) | Yes | Replication key | No |
| Table Name : | |
| Comment : | Quick Code Header table. This table stores mandatory falg for all the Quick code types |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| setopthdr_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | OU Instance for which options are set. | No |
| setopthdr_timestamp | udd_timestamp | int(4) | Yes | Time stamp | No |
| setopthdr_createdby | udd_ctxt_user | varchar(30) | Yes | Created user name. | No |
| setopthdr_createddate | _datetime_8 | datetime(8) | Yes | Set options created date. | No |
| setopthdr_modiifedby | udd_ctxt_user | varchar(30) | Yes | Modified user name. | No |
| setopthdr_modifieddate | _datetime_8 | datetime(8) | Yes | Modified date. | No |
| replication_key | _BIGINT_8 | Bigint(8) | Yes | Replication key | No |
| Table Name : | |
| Comment : | Standard Distribution List. List the Std. Distribution List Name, No of members for the list, Remarks. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| SetOpt_OptKeyCode | udd_documentno | varchar(40) | No | Unique key word to identify the set option parameter. | No |
| SetOpt_Metadata_type | udd_paramcode | varchar(30) | Yes | Classification of set option parameters. | No |
| SetOpt_paramcode | udd_paramcode | varchar(30) | Yes | Parameter code. | No |
| SetOpt_paramDesc | udd_txt150 | varchar(150) | Yes | Parameter description | No |
| SetOpt_permittedvalue | udd_txt150 | varchar(150) | Yes | Permitted values description. This is a text field by concatenating all the permitted values. | No |
| SetOpt_Mandatory_Check | udd_flag1 | varchar(25) | Yes | Flag to check if the parameter is mandatory. | No |
| SetOpt_Sotrby | udd_seqno | int(4) | Yes | Sort by flag. | No |
| Setopt_createdDate | _datetime_8 | datetime(8) | Yes | Created date. | No |
| replication_key | _bigint_8 | Bigint(8) | Yes | Replication Key | No |