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.