Helm Downtime, Operation Manual

Page: 26 / 28

Portal Downtime System
PORTAL DATABASE STRUCTURE
Table: BADGE – Operator’s Name by Unit
Name Type Size
Badge Text 50
UnitName Text 50
Description Text 255
Table: DOWNTIME – Events recorded by Date & Time
Name Type Size
RecordDate Text 25
Downtime Long Integer
4
Description Text 255
Job Text 50
Unit Text 35
UnitType Text 50
Badge Text 35
Notes Text 255
Shift Integer
2
Tag Text 50
Heat Text 50
Table: DOWNTIMEREASONS – Maintenance table or uploading event reasons to a Unit
Name Type Size
Reason Integer 2
Description Text 255
Table: JOB – Tabled by Unit Name, this data is uploaded to each unit.
Name Type Size
Job Text 50
UnitName Text 50
PPH Long Integer
4
PartsToRun Long Integer 4
Table: JOBHISTORY – Recorded by date & time, contains records of each job change or
material change.
Name Type Size
RecordDate Text 50
Job Text 50
Badge Text 35
Unit Text 50
UnitType Text 50
Tag Text 50
Heat Text 50
Weight Single
4
Table: MESSAGE – Logs messages sent to the Units
Name Type Size
Message Text 255
Page 26 of 28