ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Please follow this guide! Computers are not inherently smart, so we have to set the language as clearly as possible. Please just message VGT for any questions re; filling out the form
2
For the SURGICAL PATHOLOGY tests: for now, please just double check & update the current test list, but do NOT input it into this sheet yet.
3
The old version of the test asterlist is on the rightmost tab - please feel free to use it as a base for your specific section
4
5
What to PutLonger Remarks
6
HIS Test Codeleave blank for nowfor intetrfacing with HIS/EMR later on
7
Test Codesame as short name for now
8
Test NameFull test nameBaseline, we can use what is already in the current system (see old masterlist linked at top of this sheet), but feel free to "improve" the names as you see fit. Remember to add tests that aren't included yet!
9
Short Nameshorthand name for test, up to 6 charactersINTERNAL shorthand for the test name - mainly used by the LIS system. Up to 6 characters only
10
Test Groupsection nameLeave this as the section name for now, then we will decide later on if we need to include the machine number or other later on.
11
CategoryProfile OR SingleProfile - used for if the test is comprised of multiple single tests (ex, lipid profile), or if the test has multiple variants/machines/names/abbreviations (eg. PAX5 & BSAP IHCs)
12
Unitpreferred unit on result
13
Order ItemY OR NDefines whether or not this can be ordered by the clinician. Generally just set to N if they are part of a profile-only test (eg. "neutrophils" in the context of a CBC), or if they are a "reflex" test that only the labs should be doing (
14
Sample TypeBLOOD, PLASMA, CSF, etc. etc.Specimen used. Please check if there is a different spelling/close enough specimen type.
15
Data TypeNumeric, Free text, textvalue, no valueWhat kind of data comes out in the result.
- Numeric (ie. numbers/decimals),
- textvalue (text result, often qualitative from a list such as colors or +/-),
- Free text (longer form results, such as in "remarks"),
- No Value (as in "profile" tests, when the test does not put out a singular data result for that specific request. Ex. Lipid Profile is no value, since its results are HDL, LDL, etc. etc.)
16
Output Mask8 character number comprised of 9's, 0's and decimal places, INCLUDING the decimal in the countBasically setting the format of numerical outpus (ie. number of decimal places). The 0 should occupy the LAST non-decimal digit. All other numbers are 9.

Again, the decimal point is part of the 8 characters (9990.999 is 8 characters - 7 numbers and one punctuation) Numbers without decimal points (or non-number values) should be input as 99999990
17
SexM, F or AMale, Female or All. To help define reference values since minsan nag-iiba
18
Age To### - ###Age range, same as above
19
< Normal Range >LowernumbersNormal reference range value, lower
20
UppernumbersNormal reference range value, upper
21
< Panic Range >LowernumbersAbnormal reference value where the lab should IMMEDIATELY call the clinician, lower
22
UppernumbersAbnormal reference value where the lab should IMMEDIATELY call the clinician, upper
23
Reference Range
#### - #####Normal reference range, written as # - #
24
25
26
27
FAQ goes below if people ask questions
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100