Finding the system codes in our online help might be faster than looking them up in SQL server with this query:
Select type, [Parent SysCodeID], [Parent SysCodeDesc], [Child SysCodeID], [Child SysCodeDesc] from
(
SELECT 'Parent' AS Type, SysCodesID AS [Parent SysCodeID], SysCodeDesc AS [Parent SysCodeDesc], NULL AS [Child SysCodeID], NULL AS [Child SysCodeDesc],
Parent.SysCodesID AS [Sort1], 0 AS [Sort2]
FROM HQMS_SysCodes AS Parent
WHere Parent.SysCodeType = 0
UNION ALL
SELECT 'Child' as type, NULL AS [Parent SysCodeID],NULL AS [Parent SysCodeDesc],
ChildSysCodes.SysCodesID AS [Child SysCodeID], ChildSysCodes.SysCodeDesc AS [Child SysCodeDesc],
Parent.SysCodesID AS [Sort1], ChildSysCodes.SysCodesID AS [Sort2]
FROM HQMS_SysCodes AS Parent LEFT OUTER JOIN
HQMS_SysCodes AS ChildSysCodes ON Parent.SysCodesID = ChildSysCodes.SysCodeType
Where ChildSysCodes.SysCodeType is not null
) as Results
order by Sort1, Sort2
| Type | Parent SysCodeID | Parent SysCodeDesc | Child SysCodeID | Child SysCodeDesc |
| Parent | 1 | ApplyToSID | ||
| Child | 1000 | In Process | ||
| Child | 1001 | In Place | ||
| Parent | 2 | DataTypeSID | ||
| Child | 2001 | Number | ||
| Child | 2002 | Boolean | ||
| Child | 2004 | System Code List | ||
| Child | 2005 | Free Text | ||
| Child | 2006 | Date Only | ||
| Child | 2007 | Time Only | ||
| Child | 2008 | Date and Time | ||
| Child | 2009 | Document Path | ||
| Parent | 3 | SampleSizeID | ||
| Child | 3001 | Batch Amt P/F | ||
| Child | 3002 | Batch Amt Values | ||
| Child | 3003 | Percent Amt P/F | ||
| Child | 3004 | Percent Amt Values | ||
| Child | 3005 | Specific Amt P/F | ||
| Child | 3006 | Specific Amt Values | ||
| Parent | 4 | Unit of Measure | ||
| Parent | 5 | Document Status | ||
| Child | 5001 | History | ||
| Child | 5002 | Void | ||
| Child | 5003 | New | ||
| Child | 5004 | Hold | ||
| Child | 5005 | Testing | ||
| Parent | 6 | Test Categories | ||
| Child | 60001 | Analytical | ||
| Child | 60002 | Physical | ||
| Child | 60003 | Identity | ||
| Child | 60004 | Verification | ||
| Child | 60005 | Particle Size | ||
| Parent | 7 | Inspection Categories | ||
| Child | 70001 | Polymer | ||
| Child | 70002 | Monomer | ||
| Child | 70003 | Gel | ||
| Child | 70004 | Raw Material | ||
| Parent | 8 | Inspectors | ||
| Parent | 9 | Disposition Codes | ||
| Child | 90001 | test | ||
| Parent | 10 | Status Codes | ||
| Parent | 11 | Item Type | ||
| Child | 11001 | None | ||
| Child | 11002 | Serial | ||
| Child | 11003 | Lot | ||
| Parent | 12 | ReportBaseTypes | ||
| Child | 12004 | Results Entry | ||
| Child | 12005 | Tolerance Plot | ||
| Child | 12007 | Item Details | ||
| Child | 12008 | COA Print | ||
| Child | 12009 | Action Details | ||
| Child | 12010 | Action Non-Conformance | ||
| Child | 12011 | Event Details | ||
| Child | 12012 | Action | ||
| Child | 12013 | COA Print Avg | ||
| Child | 12014 | COA Print AvgMinMax | ||
| Child | 12016 | COA Print LotSeperated | ||
| Child | 12017 | Item Specification | ||
| Child | 12018 | COA Print Pivot | ||
| Child | 12019 | COA Print Secondary | ||
| Child | 12030 | Action Costs | ||
| Parent | 13 | Process Codes | ||
| Child | 13001 | HZS Manufacturing | ||
| Child | 13002 | GP Manufacturing | ||
| Child | 13003 | POP receiving | ||
| Child | 13004 | SOP returns | ||
| Child | 13005 | INV transfer | ||
| Child | 13006 | INV adjustemnt | ||
| Child | 13007 | QES Hold | ||
| Parent | 14 | Reason Codes | ||
| Parent | 15 | Transaction Types | ||
| Child | 15001 | User Defined | ||
| Child | 15002 | Purchase Order | ||
| Child | 15003 | Work Order | ||
| Child | 15004 | Sales Order | ||
| Parent | 16 | Action Types | ||
| Child | 16001 | Non-Conformance | ||
| Child | 16002 | Corrective Action | ||
| Child | 16003 | Root Cause Analysis | ||
| Child | 16004 | Event | ||
| Parent | 18 | Item Sources | ||
| Parent | 19 | Action Outcomes | ||
| Parent | 20 | Location of Detection | ||
| Parent | 21 | Sub-Location of Detection | ||
| Parent | 22 | Item Sources | ||
| Parent | 23 | QA Source | ||
| Parent | 24 | CostCodeType | ||
| Child | 2401 | Labor | ||
| Child | 2402 | Material | ||
| Child | 2403 | Overhead | ||
| Child | 2404 | ROI | ||
| Parent | 25 | Operational Source | ||
| Parent | 26 | Inspection Group | ||
| Parent | 27 | In Place Group | ||
| Parent | 28 | Test Group | ||
| Parent | 29 | Sales Order Type | ||
| Child | 2901 | Quote | ||
| Child | 2902 | Order | ||
| Child | 2903 | Invoice | ||
| Child | 2904 | Return | ||
| Parent | 30 | Use Criteria Type | ||
| Child | 1101 | Original Criteria | ||
| Child | 1102 | Customer Item Criteria | ||
| Parent | 31 | Grade Logic | ||
| Child | 4000 | Acceptable - To be used | ||
| Child | 4001 | Acceptable - Not to be used | ||
| Child | 4002 | Not Acceptable - To be used | ||
| Child | 4003 | Not Acceptable - Not to be used | ||
| Parent | 32 | Item Spec Category | ||
| Parent | 33 | Frequency | ||
| Child | 4100 | Monthly | ||
| Child | 4101 | First Article | ||
| Parent | 34 | Dashboard Analysis | ||
| Parent | 35 | Base Calc Type | ||
| Child | 5500 | Sum | ||
| Child | 5501 | Average | ||
| Child | 5502 | Median | ||
| Child | 5503 | Mode | ||
| Child | 5504 | STD Deviation | ||
| Child | 5505 | Min | ||
| Child | 5506 | Max | ||
| Parent | 36 | Test Plan Status | ||
| Child | 4200 | New | ||
| Child | 4201 | In Process | ||
| Child | 4202 | Complete | ||
| Child | 4203 | Void | ||
| Parent | 37 | Email Event | ||
| Child | 3700 | COA Finalize | ||
| Child | 3701 | Failed Result Test | ||
| Child | 3702 | Result Header Change | ||
| Parent | 20002 | Bubble Viscosity | ||
| Child | 20003 | A | ||
| Child | 20004 | B | ||
| Parent | 200010 | Analysis Values | ||
| Child | 200011 | N/D | ||
| Child | 200012 | OK | ||
| Child | 200013 | Fails | ||
| Child | 200014 | Matches Standard |