Upload Documentation. File Structure.
- CLASSIFIERS
- INSPECTION CLASSIFIER (Root_Inspection_Class_Model)
| Sheet name |
Inspection Class Model |
The table for uploading the Inspection Classifier has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Class Code |
Code (full code). Created from the parent row code and current short code |
| Class Name |
Name |
| Class Name Code |
Name code (short code) |
| Class Short Name |
Short name |
| Class Desc |
Description |
| Class Parent Code |
Parent row code |
| Locale |
Locale identifier |
| Id |
Row identifier (External ID) |
| Parent Id |
Parent row identifier (External ID) |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- OBJECT CLASSIFIER (Root_Object_Class_Model)
| Sheet name |
Object Class Model |
The table for uploading the Object Classifier has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Class Code |
Code (full code). Created from the parent row code and current short code |
| Class Name |
Name |
| Class Name Code |
Code |
| Class Short Name |
Name code (short code) |
| Class Desc |
Description |
| Class Parent Code |
Parent row code |
| Locale |
Locale identifier |
| Id |
Row identifier (External ID) |
| Parent Id |
Parent row identifier (External ID) |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- DICTIONARIES
- List of Dictionaries
| Sheet name |
Description |
| Dic Boolean Reporting |
Boolean value Send/Do not send report |
| Dic Business Unit Class |
Business unit class |
| Dic Check List Item Type Check |
Type of checklist item |
| Dic Check List Type |
Checklist type |
| Dic Constraint Type |
Constraint type |
| Dic Inspection Operative Status |
Inspection operative status |
| Dic Inspection Schedule |
Schedule |
| Dic Inspection Schedule Type |
Schedule type |
| Dic Inspection Type |
Inspection type |
| Dic Measure Equipment type |
Measurement equipment type |
| Dic Measure Group |
Measurement group |
| Dic Measure Unit |
Measurement unit |
| Dic Object Form Factor |
Object form factor |
| Dic On Off |
Boolean value On/Off |
| Dic Quality Status |
Quality status |
| Dic Relevance |
Relevance |
| Dic Report |
List of reports |
| Dic Status Type |
Status type (object, business unit) |
| Dic User Type |
User type |
| Dic Validation Status |
Validation status |
| Dic Yes No |
Boolean value Yes/No |
- Basic columns set for dictionary tables
All tables for loading dictionaries have the following columns:
| Column name |
Description |
| Line_Id |
Row identifier |
| Id |
Row code. Row identifier within one locale |
| Name |
Name |
| Desc |
Description |
| Locale |
Locale identifier |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- Dictionary: SCHEDULE TYPE
| Sheet name |
Dic Inspection Schedule Type |
The dictionary table "Schedule Type" has additional columns:
| Column name |
Description |
| Line_Id |
Row identifier |
| Id |
Row code. Row identifier within one locale |
| Name |
Name |
| TTL |
Number of hours |
| Desc |
Description |
| Locale |
Locale identifier |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- Dictionary: SCHEDULE
| Sheet name |
Dic Inspection Schedule |
The dictionary table "Schedule" has additional columns:
| Column name |
Description |
| Line_Id |
Row identifier |
| Id |
Row code. Row identifier within one locale |
| Schedule_Type_Id |
Schedule type identifier |
| Name |
Name |
| Desc |
Description |
| Locale |
Locale identifier |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- Dictionary: MEASURE UNIT
| Sheet name |
Dic Measure Unit |
The dictionary table "Measure Unit" has additional columns:
| Column name |
Description |
| Line_Id |
Row identifier |
| Id |
Row code. Row identifier within one locale |
| Name |
Name |
| Group Id |
Measurement group identifier |
| Desc |
Description |
| Short |
Short name |
| Locale |
Locale identifier |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- Dictionary: MEASUREMENT EQUIPMENT TYPE
| Sheet name |
Dic Measure Equipment type |
The dictionary table "Measurement Equipment Type" has additional columns:
| Column name |
Description |
| Line_Id |
Row identifier |
| Id |
Row code. Row identifier within one locale |
| Name |
Name |
| Group Id |
Measurement group identifier |
| Desc |
Description |
| Short |
Short name |
| Locale |
Locale identifier |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- PROJECT DATA
- BUSINESS UNITS (01.BusinessUnits)
The table for uploading business units has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Code |
Business unit code. Created from parent row code and current row code name |
| Name |
Business unit name |
| Level |
Level |
| Name Code |
Business unit code name (short code) |
| Desc |
Description |
| External Code |
External code |
| Parent Code |
Parent business unit code |
| Id |
External business unit identifier (External ID) |
| Parent Id |
External identifier of the parent business unit (External ID) |
| Order |
Sort order |
| BU Class Id |
Business unit class code |
| Relevance Id |
Relevance code |
| Status Id |
Quality status code |
| Status Type Id |
Status type code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- USERS (02.Users)
The table for uploading users has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Id |
External user identifier (External ID) |
| First Name |
First name |
| Last Name |
Last name |
| Position |
Position |
| Responsibility |
Responsibility |
| External Code |
External code |
| email |
Email |
| Telephon |
Phone |
| Login |
Login |
| Password |
Password |
| Order |
Sort order |
| User Type id |
User type code |
| Reporting Type id |
Send / do not send report: 1 - yes, 0 - no. |
| BU id |
External business unit identifier (External ID) |
| Relevance id |
Relevance code |
| Display id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- CHECKLIST (03.CheckLists)
| Sheet name |
Description |
| CheckList |
Checklist |
| CheckList Items |
Checklist details |
The table for uploading checklists has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Code |
Checklist code |
| Id |
External checklist identifier (External ID) |
| Name |
Name |
| Name Code |
Name code (short code) |
| Desc |
Description |
| Class ID |
External object class identifier (External ID) |
| Version |
Release version |
| Provider |
Checklist provider |
| Data Rel |
Release date |
| External Code |
External code |
| Order |
Order |
| Type Id |
Checklist type code |
| Relevance Id |
Relevance code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
The table for uploading checklist details has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Number |
Sequence number |
| Item Group Id |
Group number |
| Item Group Name |
Group name |
| Id in Group |
Number in group |
| Name |
Checklist item name |
| Subcode |
Subcode. Used to identify object indicator by attribute "Subcode" |
| External Code |
External code / tags for additional calculations |
| Desc |
Description |
| Item List Values |
List item values |
| Type Interpretation |
Type interpretation |
| Valid Diapazon |
Valid range |
| Quality Range |
Quality range |
| Quality Interpretation |
Quality interpretation |
| Order |
Order |
| Type Id |
Checklist item type code |
| Relevance Id |
Relevance code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| Type Interpretation Ids |
Quality status codes for Type Interpretation |
| Quality Interpretation Ids |
Quality status codes for Quality Interpretation |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
| CheckList Id |
External checklist identifier (External ID) |
| Id |
External checklist item identifier |
- OBJECTS (04.Objects)
The table for uploading objects has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Code |
Object code. Created from parent object code and current object code name |
| Id |
External object identifier (External ID) |
| Name |
Object name |
| Full Name |
Full object name. Created from row code and name |
| Level |
Level |
| Name Code |
Object code name (short code) |
| Desc |
Description |
| Parent Code |
Parent object code |
| Parent Id |
External parent object identifier (External ID) |
| External Code |
External code |
| Order |
Sort order |
| Class ID |
External object class identifier (External ID) |
| Form factor Id |
Object form-factor code |
| Relevance Id |
Relevance code |
| Status Id |
Quality status code |
| Status type Id |
Status type code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| Business unit Id |
External business unit identifier (External ID) |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- INDICATORS (05.Indicators)
| Sheet name |
Description |
| Indicators |
Indicators |
| Indicator History |
Indicator value history |
The table for uploading indicators has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Code |
Indicator code |
| Id |
External indicator identifier |
| Name |
Indicator name |
| SubCode |
Indicator subcode |
| Desc |
Description |
| External Code |
External code / tags for additional calculations |
| Object Id |
External object identifier |
| Order |
Order |
| Group Id |
Measurement group code |
| Type Id |
Measurement equipment type code |
| Unit Id |
Measurement unit code |
| Relevance Id |
Relevance code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
The table for uploading indicator value history has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Last date |
Date of indicator value recording |
| Last Value |
Indicator value |
| Indicator Id |
External indicator identifier (External ID) |
| History Id |
External indicator history row identifier (External ID) |
| Note |
Comment |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- INSPECTION TEMPLATES (06.InspectionTemplates)
| Sheet name |
Description |
| InspTemplate |
Inspection templates |
| InspTemplateDetail |
Inspection template details |
The table for uploading inspection templates has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Code |
Inspection template code |
| Id |
External inspection template identifier (External ID) |
| Name |
Inspection template name |
| Name Code |
Name code (short code) of inspection template |
| Desc |
Description |
| Class ID |
External inspection class identifier (External ID) |
| External Code |
External code |
| Order |
Order |
| Schedule Type Id |
Schedule type code |
| Schedule Id |
Schedule code |
| Type Id |
Inspection type code |
| Relevance Id |
Relevance code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
The table for uploading inspection template details has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| ITDetail Id |
External inspection template detail identifier (External ID) |
| Insp Id |
External inspection template identifier (External ID) |
| Object Id |
External inspection object identifier (External ID) |
| CheckList Id |
External checklist identifier (External ID) |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |
- PREDEFINED MESSAGES TEMPLATES (08.PreDefinedText)
| Sheet name |
PreDefinedText |
The table for uploading predefined message templates has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Field of activity |
Field of activity |
| Content_Type |
Content type |
| Content_Value |
Template value |
| Field_Id |
Field of activity code |
| Type_Id |
Content type code |
| Content_Order |
Order |
- CONSTRAINTS (09.BaseConstraints)
| Sheet name |
Base_Constraints |
The table for uploading constraints has the following columns:
| Column name |
Description |
| Usage |
Usage flag: 1 – load, otherwise – do not load |
| Constraint Name |
Constraint name |
| Date from |
Date from |
| Date to |
Date to |
| Value from |
Value from |
| Value to |
Value to |
| TODO Description |
Task description |
| InspTemplate Id |
External inspection template identifier (External ID) |
| Remind before |
List of periods for reminders |
| Report Name Id |
Report code |
| Object Id |
External object identifier (External ID) |
| Indicator Id |
External indicator identifier (External ID) |
| Code |
Constraint code |
| Id |
External constraint identifier (External ID) |
| Order |
Order |
| Relevance Id |
Relevance code |
| Status Id |
Quality status code |
| Display Id |
Displayed: 1 - yes, 0 - no. |
| IsArchived |
Archive flag: 1 - yes, 0 - no. |