QM Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 101: Line 101:
| Operations Suspended || Single-select ||  operationssuspended_guid || Yes No Answer || OperationsSuspended
| Operations Suspended || Single-select ||  operationssuspended_guid || Yes No Answer || OperationsSuspended
|-
|-
| Organisation || Organisation ||  Org_GUID ||  || Organisation
| Organisation || Organisation ||  org_guid||  || Organisation
|-
|-
| Original To || Text ||  originalto ||  || OriginalTo
| Original To || Text ||  originalto ||  || OriginalTo
Line 113: Line 113:
| QM ID || String ||  qa_localid ||  || LocalId
| QM ID || String ||  qa_localid ||  || LocalId
|-
|-
| Date of Activity || Date ||  QADate ||  || Date
| Date of Activity || Date ||  qadate||  || Date
|-
|-
| Results || Text ||  QAResult ||  || Result
| Results || Text ||  qaresult||  || Result
|-
|-
| QM Result Status || Single-select ||  qaresultstatus_guid || QAResultStatus || QaResultStatus
| QM Result Status || Single-select ||  qaresultstatus_guid || QAResultStatus || QaResultStatus

Revision as of 12:19, 15 October 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 = 
 }}
}}

}}}}}}