Test Definitions
Test Number
01.0
Test Description
Asset Number Tests
Definition of Test
All tests in the 01 series have to do specifically with asset number.
Test Number
01.1
Test Description
Check for MOD137
Definition of Test
The asset number is tested to see if it complies with the MOD137 checksum scheme. If MOD137 checksum asset tags were used, this test should be invoked to ensure all asset numbers are valid.
Test Number
01.2
Test Description
Check for duplicates
Definition of Test
The database is scanned for duplicate asset numbers. The sources may range from using generic placeholders such as "No data" to wholly duplicated records. The report will show the serial numbers of the two offending records. This allows tracking back to the data to find out why duplicates have been reported. There should be no duplicate asset numbers in an asset tracking system. The test for duplicates is not performed on records that have blank asset numbers, as they must first be fixed with a value.
01.3 Check for blanks
Definition of Test
All records are tested for blank asset numbers. There should be no blank asset numbers in an asset tracking system. The detailed report lists every record that was found to have a blank asset number.
Test Number
01.4
Test Description
Check for acceptable length
Definition of Test
All records are tested to ensure the length of the asset number falls within an acceptable range. Ideally, only one uniform length should be used - 8 digits with the 8th digit being a MOD137 checksum digit. All records that fail to comply are shown in the detailed report along with the actual length found. Length tests are not performed on those records that have blank asset numbers.
Test Number
02.0
Test Description
Serial Number Tests
Definition of Test
All tests in the 02 series have to do specifically with serial number.
Test Number
02.1
Test Description
Check for duplicates
Definition of Test
The database is scanned for dulicate serial numbers. The causes are similar to duplicate asset numbers. The detailed report will show the asset numbers of the offending records, allowing tracking back to the data for further investigation. Duplicate tests are not performed on records that have blank serial numbers.
02.2 Check for blanks
Definition of Test
All records are tested for blank serial numbers. The detailed report lists every record that was found to have a blank serial number.
Test Number
02.3
Test Description
Check against specs
Definition of Test
All records that have a non-blank serial number are tested against serial number templates previously defined. For instance, a template for Compaq serial numbers may have been defined as "XXXXXXXXXXXX", which specifies a 12-digit long serial number composed of alphanumeric characters. The test is conducted by first attempting to look-up the specific asset type and manufacturer in the templates table. Failing that look-up, just the manufacturer is used to see if a generic template has been defined for that manufacturer. If so, the template is used. If no template has been defined, or if the manufacturer cannot be found in the templates table, the test is skipped. The detailed report shows the reason for failing the specification test for each record that failed.
Test Number
03.0
Test Description
Check for blank model
Definition of Test
All records are tested for blank models. The detailed report lists every record that was found to have a blank model.
Test Number
04.0
Test Description
Check for blank prod desc
Definition of Test
All records are tested for blank product descriptions. The detailed report lists every record that was found to have a blank product description.
05.0 Check for blank cost center
Definition of Test
All records are tested for blank cost centers. The detailed report lists every record that was found to have a blank cost center.
Test Number
06.0
Test Description
Check for blank assignee
Definition of Test
All records are tested for blank assignees. The detailed report lists every record that was found to have a blank assignee.
Test Number
07.0
Test Description
Check for blank site
Definition of Test
All records are tested for blank sites. The detailed report lists every record that was found to have a blank site.
Test Number
08.0
Test Description
Check for blank type
Definition of Test
All records are tested for blank asset types. The detailed report lists every record that was found to have a blank asset type. There should be no records with blank asset type in an asset tracking system.
09.0 Check for blank manufacturer
Definition of Test
All records are tested for blank manufacturers. The detailed report lists every record that was found to have a blank manufacturer.
Test Number
10.0
Test Description
Different mfr for same prod
Definition of Test
The database is scanned looking for records that show different manufacturers for the same product description. For instance, a product description of "Laserjet 600MP" may show manufacturers of "DELL, COMPAQ, HP". Also, it may show manufacturers of "HP" and "HEWLETT PACKARD". This test can show assets which were miscoded as well as
standardization issues with manufacturer naming. The detailed report shows each occurrence found, but not each record that participated. To correct, a query on the specific product description should be used to narrow the record scope, the each record in that scope should be checked for correctness.
Test Number
11.0
Test Description
Different type for same prod
Definition of Test
The database is scanned looking for records that show different asset types for the same product description. For example, a product description may show "SMARTUPS 1200", yet the asset types may show "UPS, EXTERNAL MODEM", which usually indicates improper asset coding for asset type. The detailed report shows each occurrence and not each record that participated in the occurrence. To correct these issues, a query must be used on the reported offending product description in order to narrow the scope to just those records. Then each record in that scope must be scanned for correctness.
