Difference between revisions of "QM Uncategorised"
From IMSMA Wiki
(Created page with "{{Note | The table is called ''qa'' and the entity type is called ''QC''. }} {| |- valign="top" | 100px | {| class="wikitable sortable" ! DIM Lab...") |
|||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | {{Note | The table is called ''qa'' | + | {{New_6.0 |''Major Non-conformity'', ''Minor Non-conformity'' and ''Observation'' were added in 6.0.}} |
+ | {{Note | The main table is called ''qa'', the entity type is called ''QC'', the target is called ''Qainfoversion'' and the main maXML artifact is [[QM Artifact|QAActivity]]. }} | ||
{| | {| | ||
Line 8: | Line 9: | ||
{| 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]] |
Latest revision as of 10:34, 1 November 2018
Major Non-conformity, Minor Non-conformity and Observation were added in 6.0. |
The main table is called qa, the entity type is called QC, the target is called Qainfoversion and the main maXML artifact is QAActivity. |
|