Difference between revisions of "QM Uncategorised"

From IMSMA Wiki
Jump to: navigation, 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...")
 
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 18:26, 15 March 2016

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

Uncategorised.png

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
Item Data
QM
DEFs
Geo data
Task
Auxiliary Data
Other
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=QM_Uncategorised&oldid=21130"