Finding the system codes in our online help might be faster than looking them up in SQL server with this query:

select * from HQMS_SysCodes


Results:

SysCodesIDSysCodeDescSysCodeType
1ApplyToSID0
2DataTypeSID0
3SampleSizeID0
4Unit of Measure0
5Document Status0
6Test Categories0
7Inspection Categories0
8Inspectors0
9Disposition Codes0
10Status Codes0
11Item Type0
12ReportBaseTypes0
13Process Codes0
14Reason Codes0
15Transaction Types0
16Action Types0
18Item Sources0
19Action Outcomes0
20Location of Detection0
21Sub-Location of Detection0
22Item Sources0
23QA Source0
24CostCodeType0
25Operational Source0
26Inspection Group0
27In Place Group0
28Test Group0
29Sales Order Type0
30Use Criteria Type0
31Grade Logic0
32Item Spec Category0
33Frequency0
34Dashboard Analysis0
35Base Calc Type0
36Test Plan Status0
1000In Process1
1001In Place1
1101Original Criteria30
1102Customer Item Criteria30
2001Number2
2002Boolean2
2004System Code List2
2005Free Text2
2006Date Only2
2007Time Only2
2008Date and Time2
2009Document Path2
2401Labor24
2402Material24
2403Overhead24
2404ROI24
2901Quote29
2902Order29
2903Invoice29
2904Return29
3001Batch Amt P/F3
3002Batch Amt Values3
3003Percent Amt P/F3
3004Percent Amt Values3
3005Specific Amt P/F3
3006Specific Amt Values3
4000Acceptable - To be used31
4001Acceptable - Not to be used31
4002Not Acceptable - To be used31
4003Not Acceptable - Not to be used31
4100Monthly33
4101First Article33
4200New36
4201In Process36
4202Complete36
4203Void36
5001History5
5002Void5
5003New5
5004Hold5
5005Testing5
5500Sum35
5501Average35
5502Median35
5503Mode35
5504STD Deviation35
5505Min35
5506Max35
11001None11
11002Serial11
11003Lot11
12004Results Entry12
12005Tolerance Plot12
12007Item Details12
12008COA Print12
12009Action Details12
12010Action Non-Conformance12
12011Event Details12
12012Action12
12013COA Print Avg12
12014COA Print AvgMinMax12
12016COA Print LotSeperated12
12017Item Specification12
12018COA Print Pivot12
12030Action Costs12
13001HZS Manufacturing13
13002GP Manufacturing13
13003POP receiving13
13004SOP returns13
13005INV transfer13
13006INV adjustemnt13
13007QES Hold13
15001User Defined15
15002Purchase Order15
15003Work Order15
15004Sales Order15
16001Non-Conformance16
16002Corrective Action16
16003Root Cause Analysis16
16004Event16