Creating a New Sample Type - Item Interface
This tutorial will go over the steps needed to be taken when setting up a new Sample Type in WinLIMS. This is usually requested through an MFD, or internal HelpDesk system. If the LIMS site does not have a live JDE Items Interface refer to tutorial: "Creating a New Sample Type - Manual."
1. Log-In Page
From Log-in page
- Enter your User Name
- Enter your Password
- Click "Log In"
2. Searching for the Sample Type
- Hold your cursor over "Administration" Menu, a drop down menu will appear
- Hold your cursor over "Sample Types" a side menu will appear
- Click on "Update"
Item Interface sends information form JDE system to LIMS anytime a new item is created in the JDE. Having this interface active ensures synchronization between systems on key product data.
2.1. JDE Item Interface
Key data includes:
- Bulk Code
- Class
- Product Name
- Product Description
- Owner or Site (this field will be assigned automatically based on the location of your facility)
- Shelf Life
3. Sampletype Manager View
This is the SampleType Manager View. All cells highlighted in yellow will require an input before saving the record.
- Bulk Code is a unique product identifier from JDE. Note: LIMS cannot keep multiple identical bulk codes, when a bulk code already exists you will get an error. The only way to keep identical bulk codes is when you have customer specific spec for a particular item number (additional training is required to set this up)
- Product Name Copied directly from JDE, should not be changed
- Product Description Copied directly from JDE, often identical as the product name, appears on the COA
- Class: depending on what type of a bulk code you are creating this will vary, click on blue text "Class" to see a pop-up of available options. (Examples: BK-JDE Bulk Product, RM-JDE Raw Material, FG-JDE Finished Good, SL-Shelf Life sample type created for data gathering for shelf life studies) Additional classes can be created per site request.
- Status of the Sample Type. (Automatically assigned by the system and means the following: N-New, H-Hold, A-Approved, O-Obsolete)
- Auto Approve if this check box is checked of, then a sample will automatically approve itself and create a CoA when all the results are within specification limits. This should not be checked off for samples which do not have specification limits.
- Comments This field is used to keep notes on revision history. Short description of why revision was made.
- Code Fields used for customized requests. (Example: categorize products into business/market segment such as IS, ES, AES. Categorize for importing JDE records into LIMS. QC-Required = Yes, QC-Not Required = No. When JDE records are sent they check this field and if it's set to "No" it will not import work order because QC testing is not required. This feature is active in Germany and DenBosch
- Owner is set up based on the data from JDE to LIMS interface. When creating a new item manually this matches what is chosen in Users "My Profile". If site is set to all in "My Profile" this field will be empty, if site is set to a specific location, that locations 3-digit site Acronym will appear in this field automatically. It's important to have a site set-up to make sure data is stored properly in the database.
- To access additional sections of the SampleType Manager View click on the double arrows (each section is reviewed in the below sub steps)
When entering classes other then BK and RM, the bulk code entered into sample type must have an appropriate extension. For example: Bulk code 205178 requires you to create a QA sampletype. In the Bulk Code text box enter 205178QA and in the Class text box enter QA. This is only applicable to sampletypes other then BK and RM those should only be a 6 digit JDE bulk code.
3.1. Customer Specific Details Section - Sampletype Manager view
- Click on the "COA" link
- From the list populated select the appropriate CoA template by clicking on Select
- You will see the selected CoA template on the Customer Specific Details section window
3.2. Saving Sample Type
Press "Save" button to capture changes
3.3. Version Control Section - Sampletype Manager view
NOTE: This section is for information only and gets populated automatically, no data will need to be added in this section.
- Section will contain information when the record was entered by Item Interface
- When the sample type is approved this section will contain information on whom approved it and when automatically
3.4. Quality Management Module Section - Sampletype Manager view
Fill out this section with any available information.
Shelf Life field is populated by Item Interface
3.5. Market Synonyms Section - Sampletype Manager view
- Market Synonyms are sent form JDE to LIMS
3.6. Clone Product Section - Sampletype Manger view
This sections is not regularly used.
- Clone Products section is similar to "Market Synonyms"
3.7. Mailing List Section - Sampletype Manager view
This sections is not regularly used, however can be used to have emails about the sample entered with this sample type to be emailed out to a necessary contact.
- Auto email can be set up by clicking New
- To find appropriate contact either scroll through the list, or type in the user name in the search text box
- Click the find button (binoculars)
- Click on the check box to select the contact
- Click the select button
- The Mailing List will be updated with user name and email of the contact.
4. Methods Section - Sampletype Manager view
This section will contain all the methods needed for data collection on the parameters for this sample type.
- To add new method click on the new button.
- Enter Method name
- Click on the search button (binoculars).
- Select appropriate method from the list by checking the check box on the left side.
- Click "Select" button to add method.
- The method will appear in the "Method" Section
- Save changes before moving on to the next step.
- Additional methods can be added by following steps 1-7 again.
Very often multiple methods will appear which differ slightly from each other. To make sure you are selecting the correct method verify the parameters in that method by going into the Method Menu. This process is described in a different tutorial titled: "Revising a Method"
5. Parameters and Limits Section - Sampletype Manager view
5.1. Remove Unnecessary Parameters
Often a method contains multiple parameters that are specific to testing conditions, or required dilution of a sample. Not all parameters within a method might be applicable to this item and need to be removed. Screenshot below shows method "Specific Gravity MEIC" contains 3 different parameters. The name of the parameters shows that first one is to measure Specific Gravity in general. Second parameter is specifically measuring Specific Gravity at 25 Deg C, and third parameter is specifically measuring Specific Gravity at 20 Deg C. Only keep the parameter that is necessary for your item.
- Select parameters to delete by clicking on the checkbox next to the parameter
- Click the "X" button
Screen will update and show that parameters have been removed.
5.2. Configure Parameters
Parameters which are part of the methods will be added in this section.
- Click on graph icon to select SPC rules which need to be monitored for this parameter. (this feature requires additional set-up, for detailed instructions and training discuss this with LIMS administrator)
- Click next to optional parameter
- Enter Customer Specs if available
- Enter Internal Specs if available
- Enter Control Specs if available
- Enter Target Value is available
- Enter number of values after the decimal point for result
- Enter number of values after the decimal point for results as shown on the CoA. (Most sites use the "Decimals" column for this, because it's harder to manage two sets of data.)
- Enter C-Pro Method Control Number
- Enter units
- Enter "Print Flag" value. For print flag value of "1" the parameter will appear on the CoA. For print flag value of "0" the parameter will not appear on the CoA and will only be internal.
- Put in C-Pro document link, so that a link shows next to the parameter and user can quickly access the method.
- Enter Demand condition if the parameter is not quantitative. This is a spec for quantitative condition. The user will have to enter this exact verbiage in order to pass specification validation. When entering a value, sites usually put in specification vlaue first and use a tilde symbol (~) to seperate the spec from acceptable result. For example a descriptive spec for Color parameter is Clear Blue Liquid. Acceptable result is PASS. The value to put into the demand section should be: Clear Blue Liquid~Pass
- Enter what needs to appear on the CoA for the quantitative condition.
- Default is set at "1" for every parameter, it's best to leave it as auto-validation to be on.
5.2.1. Associated Formulas Section - Sampletype Manager view
This sections is not regularly used
6. Saving and Approving newly created Sample Type
- Save all the settings on this main section page by clicking the save button. Note that the status is "N"
- Click on the "Approve" button (thumbs up) to approve the sample
- After the sample is approved you will see that the status is changed to "A"
- Instead of the "thumbs up" approve button you will see the "x" button which is used to take away the approval and put the sample on Hold.



0 Comments
Add your comment