Exported Data Schema Reference

Exported Data Schema Reference

This reference guide outlines the structure of the CSV files available for export, detailing the contents of each file to aid in comprehensive analysis and reporting.

CalibrationTestData.csv

Description: Table of all calibration test data recorded in calibration records.

• ID
• Serial No
• Record No
• Test No
• Attribute
• Nominal | Minimum | Maximum
• Reference Standard ID
• Reference Standard Serial No
• As Found
• As Left
• Result

ListOfCalibrations.csv

Description: Table of all calibration records and related metadata.

• ID
• Serial No
• Record No
• Asset No
• Status (Test Equipment As Found)
• Date of Last Calibration
• Calibration Due Date
• Reference Standard
• Type
• Manufacturer
• Model
• Measurement Types
• Units Of Measure
• Range/Size
• Accuracy
• Location
• Assignee
• Condition Received
• Interval
• Years
• Months
• Days
• Uncertainty
• Instructions
• Template available
• Adjustments Required
• Repairs Required
• Record Location (e.g., File, Network Drive, Link, URL, etc.)
• Appropriate individuals notified
• Out of Tolerance condition and product nonconformance
• Product recall or customer notification
• Action taken in detail
• Additional Comments
• Calibration Date
• Next Calibration Due
• Update Equipment Status
• Time
• Cost
• Updated By

ListOfGages.csv

Description: Table of all gage (equipment) records and related metadata.

• ID
• Serial No
• Control No
• Asset No
• Status
• Last Calibration
• Next Calibration Due
• Reference Standard
• Type
• Manufacturer
• Website
• Model
• Measurement Types
• Units Of Measure
• Range/Size
• Accuracy
• BSI/ISO Reference
• Date Acquired
• Source/Vendor
• Gage Cost
• Condition Acquired
• Location
• Area
• Assignee
• Notification List
• Interval
• Environment
• Instructions
• Other Information
• Custom Fields (e.g., Test 2, Text Area, Checkbox Group, Dropdown, Radio Group, Date Picker, Number, Link, Calib Instr, Counter)

ListOfManufacturers.csv

Description: Table of all manufacturers and related metadata.

• Name
• Address
• Phone
• Fax
• Website

Settings.csv

Description: Table of all account settings and configuration options.

• Name
• Setting Value

TestTemplates.csv

Description: Table of all calibration test templates recorded in gage records.

• ID
• Serial No
• Test No
• Attribute
• Nominal | Minimum | Maximum
• Reference Standard ID
• Reference Standard Serial No

GageAttachments.csv

Description: List of all attachments stored in gage records.

• Gage ID
• Attachment

CalibrationAttachments.csv

Description: List of all attachments stored in calibration records.

• Record No
• Attachment

Please note that the actual data contained within these tables will vary based on the specific records and configurations of your GageList account.