QM Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "{{Note | The table is called ''qa'' and the entity type is called ''QC''. }} {| |- valign="top" | 100px | {| class="wikitable sortable" ! DIM Lab..."
 
No edit summary
Line 8: Line 8:
{| class="wikitable sortable"
{| class="wikitable sortable"
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
| Clearance Equipment Inspected || Multi-select ||  || ClearanceEquipmentInspected || ClearanceEquipmentInspected
|-
| Facilities Inspected || Multi-select ||  || FacilitiesInspected || FacilitiesInspected
|-
| Method Used || Multi-select ||  || QA Method || QaMethods
|-
| Support Equipment Inspected || Multi-select ||  || SupportEquipmentInspected || SupportEquipmentInspected
|-
| Worksite || Multi-select ||  || Worksite || Worksite
|-
| Acceptance Date || Date ||  accpetance_date ||  || AcceptanceDate
|-
| Accredited by UNMAO || Single-select ||  accreditedbyunmao_guid || Yes No Answer || AccreditedByUnmao
|-
| Activity Type || Single-select ||  activitytype_guid || QAActivityType || ActivityType
|-
| Additional Info || Text ||  additionalinformation ||  || AdditionalInformation
|-
| Adequate Supervision || Single-select ||  adequatesupervision_guid || Yes No Answer || AdequateSupervision
|-
| Area Size || Numeric ||  areasize ||  || AreaSize
|-
| Clearance Area Description || '''String''' ||  clearanceareadescription ||  || ClearedAreaDesc
|-
| Clearance Depth || Numeric ||  clearancedepth ||  || ClearanceDepth
|-
| Cleared Area Size || Numeric ||  clearedareasize ||  || ClearedAreaSize
|-
| Compliant with NMAS / NTSG || Single-select ||  compliantwithntsg_guid || Yes No Answer || CompliantWithNtsg
|-
| Compliant with Org SOP || Single-select ||  compliantwithorgsop_guid || Yes No Answer || CompliantWithOrgsop
|-
| Inactive || - ||  contact_guid ||  || Contacts
|-
| Copy To || Text ||  copyto ||  || CopyTo
|-
| Debrief Accepted || Single-select ||  debriefedaccepted_guid || Yes No Answer || DebriefedAccepted
|-
| Debrief Provided || Single-select ||  debriefedprovided_guid || Yes No Answer || DebriefedProvided
|-
| Delivery Date || Date ||  delivery_date ||  || DeliveryDate
|-
| Documentation || Single-select ||  documentation_guid || Documentation || Documentation
|-
| End Date || Date ||  enddate ||  || EndDate
|-
| Equipment Stored Properly || Single-select ||  equipmentstoredproperly_guid || Yes No Answer || EquipStoredProperly
|-
| Equipment Suitable || Single-select ||  equipmentsuitable_guid || Yes No Answer || EquipSuitable
|-
| Evidence of Testing and Evaluation || Single-select ||  evidenceoftande_guid || Yes No Answer || EvidenceOfTandE
|-
| Facilities Suitable || Single-select ||  facilitiessuitable_guid || Yes No Answer || FacilitiesSuitable
|-
| Inactive || - ||  hazreducref_guid ||  || HazreducRef
|-
| Hours Spent || Numeric ||  hourspent ||  || HoursSpent
|-
| Inspector Name || String ||  InspectorName ||  || InspectorName
|-
| Internal QM Logs Current || Single-select ||  internalqalogscurrent_guid || Yes No Answer || InternalLogsCurrent
|-
| Inactive || - ||  macid ||  || MacId
|-
| MAC Rep Name || String ||  macrepname ||  || MacRepName
|-
| MAC Rep Position || String ||  macrepposition ||  || MacRepPosition
|-
| MAC Rep Sign Date || Date ||  macrepsigndate ||  || MacRepSignDate
|-
| Maintenance Log Current || Single-select ||  maintenancelogscurrent_guid || Yes No Answer || MaintenanceLogsCurrent
|-
| Major Non-Conformity || Single-select ||  major_non_conformity || Yes No Answer || MajorNonConformity
|-
| Marking || Single-select ||  marking_guid || Yes No Answer || Marking
|-
| Minor Non-Conformity || Single-select ||  minor_non_conformity || Yes No Answer || MinorNonConformity
|-
| Municipality || String ||  municipality ||  || Municipality
|-
| Noncompliance Corrected || Single-select ||  noncompliancecorrected_guid || Yes No Answer || NoncomplianceCorrected
|-
| Object Type || Single-select ||  objecttype_guid || ObjectType || ObjectType
|-
| Observation || Single-select ||  observation || Yes No Answer || Observation
|-
| Onsite Inspection Purpose || String ||  onsite_inspection_purpose ||  || OnsiteInspectionPurpose
|-
| Operations Suspended Reason || String ||  operations_suspended_reason ||  || OperationsSuspendedReason
|-
| Operations Suspended || Single-select ||  operationssuspended_guid || Yes No Answer || OperationsSuspended
|-
| Organisation || Organisation ||  Org_GUID ||  || Organisation
|-
| Original To || Text ||  originalto ||  || OriginalTo
|-
| Personnel Qualified || Single-select ||  personnelqualified_guid || Yes No Answer || PersonnelQualified
|-
| Planned End Date || Date ||  plannedenddate ||  || PlannedEndDate
|-
| Planned Start Date || Date ||  plannedstartdate ||  || PlannedStartDate
|-
| QM ID || String ||  qa_localid ||  || LocalId
|-
| Date of Activity || Date ||  QADate ||  || Date
|-
| Results || Text ||  QAResult ||  || Result
|-
| QM Result Status || Single-select ||  qaresultstatus_guid || QAResultStatus || QaResultStatus
|-
| Qualified Medic Available || Single-select ||  qualifiedmedicavailable_guid || Yes No Answer || QualifiedMedicAvail
|-
| Quality Assurance By || Text ||  qualityassuranceby ||  || QualityAssuranceBy
|-
| Inactive || - ||  referencetype_guid || MineActionAreaType || ReferenceType
|-
| Responsible Authority || String ||  respauthname ||  || RespAuthName
|-
| Responsible Authority || Organisation ||  respauthorg_guid ||  || RespAuthOrg
|-
| Responsible Authority Sign Date || Date ||  respauthsigndate ||  || RespAuthSignDate
|-
| Special Monitoring Reason || String ||  special_monitoring_reason ||  || SpecialMonitoringReason
|-
| Special Monitoring || Single-select ||  specialmonitoring_guid || Yes No Answer || SpecialMonitoring
|-
| Start Date || Date ||  startdate ||  || StartDate
|-
| Status || Single-select ||  status_guid || QAStatus || Status
|-
| Task Dossier || String ||  taskdossier ||  || Taskdossier
|-
| Uncleared Area Description || Text ||  unclearedareadescription ||  || UnclearedAreaDescription
|-
| Uncleared Area Size || Numeric ||  unclearedareasize ||  || UnclearedAreaSize
|-
| Visitor Logs Current || Single-select ||  visitorlogscurrent_guid || Yes No Answer || VisitorLogsCurrent
|-
| Warning Delivered || Single-select ||  warningdelivered_guid || Yes No Answer || WarningDelivered
|-
| Warning Explained || Single-select ||  warningexplained_guid || Yes No Answer || WarningExplained
|-
| Warning Received || Single-select ||  warningreceived_guid || Yes No Answer || WarningReceived
|}


|}
|}
{{NavBox Data Dictionary}}
{{NavBox Data Dictionary}}
[[Category:NAA]]
[[Category:NAA]]

Revision as of 17:26, 15 March 2016

The table is called qa and the entity type is called QC.

DIM Label Data type Database column name Enumcategory Pojo name
Clearance Equipment Inspected Multi-select ClearanceEquipmentInspected ClearanceEquipmentInspected
Facilities Inspected Multi-select FacilitiesInspected FacilitiesInspected
Method Used Multi-select QA Method QaMethods
Support Equipment Inspected Multi-select SupportEquipmentInspected SupportEquipmentInspected
Worksite Multi-select Worksite Worksite
Acceptance Date Date accpetance_date AcceptanceDate
Accredited by UNMAO Single-select accreditedbyunmao_guid Yes No Answer AccreditedByUnmao
Activity Type Single-select activitytype_guid QAActivityType ActivityType
Additional Info Text additionalinformation AdditionalInformation
Adequate Supervision Single-select adequatesupervision_guid Yes No Answer AdequateSupervision
Area Size Numeric areasize AreaSize
Clearance Area Description String clearanceareadescription ClearedAreaDesc
Clearance Depth Numeric clearancedepth ClearanceDepth
Cleared Area Size Numeric clearedareasize ClearedAreaSize
Compliant with NMAS / NTSG Single-select compliantwithntsg_guid Yes No Answer CompliantWithNtsg
Compliant with Org SOP Single-select compliantwithorgsop_guid Yes No Answer CompliantWithOrgsop
Inactive - contact_guid Contacts
Copy To Text copyto CopyTo
Debrief Accepted Single-select debriefedaccepted_guid Yes No Answer DebriefedAccepted
Debrief Provided Single-select debriefedprovided_guid Yes No Answer DebriefedProvided
Delivery Date Date delivery_date DeliveryDate
Documentation Single-select documentation_guid Documentation Documentation
End Date Date enddate EndDate
Equipment Stored Properly Single-select equipmentstoredproperly_guid Yes No Answer EquipStoredProperly
Equipment Suitable Single-select equipmentsuitable_guid Yes No Answer EquipSuitable
Evidence of Testing and Evaluation Single-select evidenceoftande_guid Yes No Answer EvidenceOfTandE
Facilities Suitable Single-select facilitiessuitable_guid Yes No Answer FacilitiesSuitable
Inactive - hazreducref_guid HazreducRef
Hours Spent Numeric hourspent HoursSpent
Inspector Name String InspectorName InspectorName
Internal QM Logs Current Single-select internalqalogscurrent_guid Yes No Answer InternalLogsCurrent
Inactive - macid MacId
MAC Rep Name String macrepname MacRepName
MAC Rep Position String macrepposition MacRepPosition
MAC Rep Sign Date Date macrepsigndate MacRepSignDate
Maintenance Log Current Single-select maintenancelogscurrent_guid Yes No Answer MaintenanceLogsCurrent
Major Non-Conformity Single-select major_non_conformity Yes No Answer MajorNonConformity
Marking Single-select marking_guid Yes No Answer Marking
Minor Non-Conformity Single-select minor_non_conformity Yes No Answer MinorNonConformity
Municipality String municipality Municipality
Noncompliance Corrected Single-select noncompliancecorrected_guid Yes No Answer NoncomplianceCorrected
Object Type Single-select objecttype_guid ObjectType ObjectType
Observation Single-select observation Yes No Answer Observation
Onsite Inspection Purpose String onsite_inspection_purpose OnsiteInspectionPurpose
Operations Suspended Reason String operations_suspended_reason OperationsSuspendedReason
Operations Suspended Single-select operationssuspended_guid Yes No Answer OperationsSuspended
Organisation Organisation Org_GUID Organisation
Original To Text originalto OriginalTo
Personnel Qualified Single-select personnelqualified_guid Yes No Answer PersonnelQualified
Planned End Date Date plannedenddate PlannedEndDate
Planned Start Date Date plannedstartdate PlannedStartDate
QM ID String qa_localid LocalId
Date of Activity Date QADate Date
Results Text QAResult Result
QM Result Status Single-select qaresultstatus_guid QAResultStatus QaResultStatus
Qualified Medic Available Single-select qualifiedmedicavailable_guid Yes No Answer QualifiedMedicAvail
Quality Assurance By Text qualityassuranceby QualityAssuranceBy
Inactive - referencetype_guid MineActionAreaType ReferenceType
Responsible Authority String respauthname RespAuthName
Responsible Authority Organisation respauthorg_guid RespAuthOrg
Responsible Authority Sign Date Date respauthsigndate RespAuthSignDate
Special Monitoring Reason String special_monitoring_reason SpecialMonitoringReason
Special Monitoring Single-select specialmonitoring_guid Yes No Answer SpecialMonitoring
Start Date Date startdate StartDate
Status Single-select status_guid QAStatus Status
Task Dossier String taskdossier Taskdossier
Uncleared Area Description Text unclearedareadescription UnclearedAreaDescription
Uncleared Area Size Numeric unclearedareasize UnclearedAreaSize
Visitor Logs Current Single-select visitorlogscurrent_guid Yes No Answer VisitorLogsCurrent
Warning Delivered Single-select warningdelivered_guid Yes No Answer WarningDelivered
Warning Explained Single-select warningexplained_guid Yes No Answer WarningExplained
Warning Received Single-select warningreceived_guid Yes No Answer WarningReceived

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|<td class="navbox-image " style="width:0%;padding:0px 2px 0px 0px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{imageleft}}}
}}{{#if:Item Data|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|<td class="navbox-image " style="width:0%;padding:0px 0px 0px 2px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{image}}}
}}}}{{#if: Overview DEF
Data Entry Form  · Attachments|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:qm uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if: DEFs| DEFs<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Overview DEF

Data Entry Form  · Attachments

}}{{#if:Point Types
Geospatial  · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:qm uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF

Data Entry Form  · Attachments|}}{{#if: Geo data| Geo data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Point Types

Geospatial  · Geopoint

}}{{#if:Task  · Work item  · Task Child Tables|{{#if: Task | Task <td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Task  · Work item  · Task Child Tables

}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|{{#if:Auxiliary Data|Auxiliary Data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places

}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|{{#if:Other|Other<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:qm uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF
Data Entry Form  · AttachmentsPoint Types

Geospatial  · Geopoint|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:qm uncategorised
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}