Difference between revisions of "Activity Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{New_6.0 | Ammunition storage, are new in 6.0.<br/>
+
{{New_6.0 | Ammunition storage, Cancelled Area, Cleared Area, Community involved in handover, Criteria for Cancellation, Criteria for Reduction, Deployed Asset, External Visual Ordnance Condition, Handover carried out, Number of boys involved from community in handover, Number of girl involved from community in handover, Number of men involved from community in handover, Number of women involved from community in handover, Reduced Area with technical asset, Reduced Area without technical asset, Status Changed Comment, Status Changed Date, Status Changed Reason, Technical Survey Type and Type of Minefield are new in 6.0.}}
−
}}
+
{{Note | The main table is called ''hazreduc'', the entity type is called ''Hazard Reduction'', the target is called ''Hazreducversion'' and the main maXML artifact is [[Activity Artifact| HazardReductionActivity]]. }}
−
 
 
 
{|
 
{|
 
|- valign="top"
 
|- valign="top"
Line 16: Line 15:
 
| Reduction Method || Multi-select || - || Clearance Operation || HazreducMethods
 
| Reduction Method || Multi-select || - || Clearance Operation || HazreducMethods
 
|-
 
|-
−
| Marking Method || Multi-select ||   || Marking Method || Markings
+
| Marking Method || Multi-select || -  || Marking Method || Markings
 
|-
 
|-
−
| Recommendations || Multi-select ||   || RecommendationType || Recommendations
+
| Recommendations || Multi-select || -  || RecommendationType || Recommendations
 
|-
 
|-
 
| Ammunition Storage || Place ||  ammunition_storage ||  || AmmunitionStorage
 
| Ammunition Storage || Place ||  ammunition_storage ||  || AmmunitionStorage
Line 28: Line 27:
 
| Area Officer || String ||  areaofficer ||  || AreaOfficer
 
| Area Officer || String ||  areaofficer ||  || AreaOfficer
 
|-
 
|-
−
| Size of Area (old) || Numeric ||  AreaSize ||  || AreaSize
+
| Size of Area (old) || Numeric ||  areasize||  || AreaSize
 
|-
 
|-
 
| Area Supervisor || String ||  areasupervisor ||  || AreaSupervisor
 
| Area Supervisor || String ||  areasupervisor ||  || AreaSupervisor
Line 38: Line 37:
 
| Booby Trapped || Single-select ||  boobytrap_guid || Yes No Answer || BoobyTrapped
 
| Booby Trapped || Single-select ||  boobytrap_guid || Yes No Answer || BoobyTrapped
 
|-
 
|-
−
| Inactive || - ||  calculatedareasize ||  || CalculatedAreaSize
+
| ''Inactive'' || - ||  calculatedareasize ||  || CalculatedAreaSize
 
|-
 
|-
 
| Cancelled Area || Numeric ||  cancelled_area ||  || CancelledArea
 
| Cancelled Area || Numeric ||  cancelled_area ||  || CancelledArea
Line 50: Line 49:
 
| Community Leader || String ||  communityleader ||  || CommunityLeader
 
| Community Leader || String ||  communityleader ||  || CommunityLeader
 
|-
 
|-
−
| Inactive || - ||  communityleaderposition ||  || CommunityLeadershipPosition
+
| ''Inactive'' || - ||  communityleaderposition ||  || CommunityLeadershipPosition
 
|-
 
|-
 
| Cost per Meter || Numeric ||  costsquaremeter ||  || CostSquareMeter
 
| Cost per Meter || Numeric ||  costsquaremeter ||  || CostSquareMeter
Line 58: Line 57:
 
| Deployed Asset || Single-select ||  deployed_asset || Deployed Asset || DeployedAsset
 
| Deployed Asset || Single-select ||  deployed_asset || Deployed Asset || DeployedAsset
 
|-
 
|-
−
| Depth || Numeric ||  Depth ||  || Depth
+
| Depth || Numeric ||  depth ||  || Depth
 
|-
 
|-
−
| Destruction Method || ''Text''' ||  destructionmethod ||  || DestructionMethod
+
| Destruction Method || '''Text''' ||  destructionmethod ||  || DestructionMethod
 
|-
 
|-
 
| Distance from Nearest Town || Numeric ||  distancefromnearesttown ||  || DistanceFromNearestTown
 
| Distance from Nearest Town || Numeric ||  distancefromnearesttown ||  || DistanceFromNearestTown
 
|-
 
|-
−
| End Date || Date ||  EndDate ||  || EndDate
+
| End Date || Date ||  enddate||  || EndDate
 
|-
 
|-
 
| End Period || String ||  endperiod ||  || EndPeriod
 
| End Period || String ||  endperiod ||  || EndPeriod
 
|-
 
|-
−
| Estimated Workday || ''String''' ||  estimatedworkday ||  || EstimatedWorkday
+
| Estimated Workday || '''String''' ||  estimatedworkday ||  || EstimatedWorkday
 
|-
 
|-
 
| External Visual Ordnance Condition || Single-select ||  external_visual_ordnance_condition || External Visual Ordnance Condition || ExternalVisualOrdnanceCondition
 
| External Visual Ordnance Condition || Single-select ||  external_visual_ordnance_condition || External Visual Ordnance Condition || ExternalVisualOrdnanceCondition
Line 76: Line 75:
 
| Handover Carried Out || Single-select ||  handover_carried_out || Yes No Answer || HandoverCarriedOut
 
| Handover Carried Out || Single-select ||  handover_carried_out || Yes No Answer || HandoverCarriedOut
 
|-
 
|-
−
| Activity ID || String ||  HazReduc_LocalID ||  || LocalId
+
| Activity ID || String ||  hazreduc_localid||  || LocalId
 
|-
 
|-
−
| Activity Name || String ||  HazReducName ||  || Name
+
| Activity Name || String ||  hazreducname||  || Name
 
|-
 
|-
−
| Type of Activity || Single-select ||  HazReducTypeEnum_GUID || Mine Action Activity || Type
+
| Type of Activity || Single-select ||  hazreductypeenum_guid|| Mine Action Activity || Type
 
|-
 
|-
 
| Hours Spent || Numeric ||  hoursspent ||  || HoursSpent
 
| Hours Spent || Numeric ||  hoursspent ||  || HoursSpent
 
|-
 
|-
−
| Intended Land Use || ''Text''' ||  IntendedLandUse ||  || IntendedLandUse
+
| Intended Land Use || '''Text''' ||  intendedlanduse||  || IntendedLandUse
 
|-
 
|-
 
| Interviewer || String ||  interviewer ||  || Interviewer
 
| Interviewer || String ||  interviewer ||  || Interviewer
Line 90: Line 89:
 
| Length || Numeric ||  length ||  || Length
 
| Length || Numeric ||  length ||  || Length
 
|-
 
|-
−
| Inactive || - ||  macid ||  || MacId
+
| ''Inactive'' || - ||  macid ||  || MacId
 
|-
 
|-
 
| Marking || Single-select ||  marking_guid || Yes No Answer || Marking
 
| Marking || Single-select ||  marking_guid || Yes No Answer || Marking
 
|-
 
|-
−
| Inactive || - ||  mechanicaldemining_guid || Yes No Answer || MechanicalDemining
+
| ''Inactive'' || - ||  mechanicaldemining_guid || Yes No Answer || MechanicalDemining
 
|-
 
|-
−
| Inactive || - ||  minefieldref_guid ||  || MineFieldId
+
| ''Inactive'' || - ||  minefieldref_guid ||  || MineFieldId
 
|-
 
|-
 
| Mines/UXO Condition || Single-select ||  mineuxocondition_guid || MineCondition || MinesUxoConditionId
 
| Mines/UXO Condition || Single-select ||  mineuxocondition_guid || MineCondition || MinesUxoConditionId
Line 104: Line 103:
 
| Municipality || String ||  municipality ||  || Municipality
 
| Municipality || String ||  municipality ||  || Municipality
 
|-
 
|-
−
| Number of Boys Involved from Community in Handover || Integer ||  number_of_boys_involved_from_community_in_handover ||  || NumberOfBoysInvolvedFromCommunityInHandover
+
| Number of Boys Involved from Community in Handover || Integer ||  number_of_boys_involved_from_ community_in_handover ||  || NumberOfBoysInvolvedFromCommunity InHandover
 
|-
 
|-
−
| Number of Girls Involved from Community in Handover || Integer ||  number_of_girls_involved_from_community_in_handover ||  || NumberOfGirlsInvolvedFromCommunityInHandover
+
| Number of Girls Involved from Community in Handover || Integer ||  number_of_girls_involved_from_ community_in_handover ||  || NumberOfGirlsInvolvedFromCommunity InHandover
 
|-
 
|-
−
| Number of Men Involved from Community in Handover || Integer ||  number_of_men_involved_from_community_in_handover ||  || NumberOfMenInvolvedFromCommunityInHandover
+
| Number of Men Involved from Community in Handover || Integer ||  number_of_men_involved_from_ community_in_handover ||  || NumberOfMenInvolvedFromCommunity InHandover
 
|-
 
|-
−
| Number of Women Involved from Community in Handover || Integer ||  number_of_women_involved_from_community_in_handover ||  || NumberOfWomenInvolvedFromCommunityInHandover
+
| Number of Women Involved from Community in Handover || Integer ||  number_of_women_involved_from_ community_in_handover ||  || NumberOfWomenInvolvedFromCommunity InHandover
 
|-
 
|-
 
| Number of Teams || Integer ||  numberofteams ||  || NumberOfTeams
 
| Number of Teams || Integer ||  numberofteams ||  || NumberOfTeams
Line 116: Line 115:
 
| Number of Vehicles || Integer ||  numberofvehicles_herd ||  || NumberOfVehicles
 
| Number of Vehicles || Integer ||  numberofvehicles_herd ||  || NumberOfVehicles
 
|-
 
|-
−
| Operational Notes || Text ||  OperationalNotes ||  || OperationalNotes
+
| Operational Notes || Text ||  operationalnotes||  || OperationalNotes
 
|-
 
|-
−
| Organisation || Organisation ||  Org_GUID ||  || Organisation
+
| Organisation || Organisation ||  org_guid||  || Organisation
 
|-
 
|-
 
| Planned End Date || Date ||  plannedenddate ||  || PlannedEndDate
 
| Planned End Date || Date ||  plannedenddate ||  || PlannedEndDate
Line 126: Line 125:
 
| QM Comments || Text ||  qacomments ||  || QaComments
 
| QM Comments || Text ||  qacomments ||  || QaComments
 
|-
 
|-
−
| Quality Assurance || String ||  qualityassurance_guid || Yes No Answer || QualityAssurance
+
| Quality Assurance || Single-select ||  qualityassurance_guid || Yes No Answer || QualityAssurance
 
|-
 
|-
 
| Reduced Area With Technical Asset || Numeric ||  reduced_area_with_technical_asset ||  || ReducedAreaWithTechnicalAsset
 
| Reduced Area With Technical Asset || Numeric ||  reduced_area_with_technical_asset ||  || ReducedAreaWithTechnicalAsset
Line 144: Line 143:
 
| SOP Metal Detector || Text ||  sopmetaldector ||  || SopMetalDetector
 
| SOP Metal Detector || Text ||  sopmetaldector ||  || SopMetalDetector
 
|-
 
|-
−
| Start Date || Date ||  StartDate ||  || StartDate
+
| Start Date || Date ||  startdate||  || StartDate
 
|-
 
|-
 
| Start Period || String ||  startperiod ||  || StartPeriod
 
| Start Period || String ||  startperiod ||  || StartPeriod
Line 156: Line 155:
 
| Status || Single-select ||  status_guid || HazReducStatus || Status
 
| Status || Single-select ||  status_guid || HazReducStatus || Status
 
|-
 
|-
−
| Inactive || - ||  surveyref_guid ||  || SurveyId
+
| ''Inactive'' || - ||  surveyref_guid ||  || SurveyId
 
|-
 
|-
 
| Task Dossier || String ||  taskdossier ||  || Taskdossier
 
| Task Dossier || String ||  taskdossier ||  || Taskdossier
Line 162: Line 161:
 
| Tasked By || String ||  taskedby ||  || TaskedBy
 
| Tasked By || String ||  taskedby ||  || TaskedBy
 
|-
 
|-
−
| Inactive || - ||  taskref_guid ||  || TaskId
+
| ''Inactive'' || - ||  taskref_guid ||  || TaskId
 
|-
 
|-
 
| Team ID || String ||  teamid ||  || TeamId
 
| Team ID || String ||  teamid ||  || TeamId
Line 172: Line 171:
 
| Technical Survey Type || Single-select ||  technical_survey_type || Technical Survey Type || TechnicalSurveyType
 
| Technical Survey Type || Single-select ||  technical_survey_type || Technical Survey Type || TechnicalSurveyType
 
|-
 
|-
−
| Type of Minefield || String ||  type_of_minefield || Type Of Minefield || TypeOfMinefield
+
| Type of Minefield || Single-select||  type_of_minefield || Type Of Minefield || TypeOfMinefield
 
|-
 
|-
−
| Inactive || - ||  unclearedareasize ||  || UnclearedAreaSize
+
| Uncleared Area Size || Numeric  ||  unclearedareasize ||  || UnclearedAreaSize
 
|-
 
|-
−
| Inactive || - ||  vegetationremovedby_guid || VegetationRemovalMethod || VegetationRemovedBy
+
| ''Inactive'' || - ||  vegetationremovedby_guid || VegetationRemovalMethod || VegetationRemovedBy
 
|-
 
|-
−
| Verification Notes || ''String''' ||  verificationnotes ||  || VerificationNotes
+
| Verification Notes || '''String''' ||  verificationnotes ||  || VerificationNotes
 
|-
 
|-
 
| Visitor || Text ||  visitor ||  || Visitor
 
| Visitor || Text ||  visitor ||  || Visitor

Latest revision as of 10:21, 1 November 2018

New 6.0.png Ammunition storage, Cancelled Area, Cleared Area, Community involved in handover, Criteria for Cancellation, Criteria for Reduction, Deployed Asset, External Visual Ordnance Condition, Handover carried out, Number of boys involved from community in handover, Number of girl involved from community in handover, Number of men involved from community in handover, Number of women involved from community in handover, Reduced Area with technical asset, Reduced Area without technical asset, Status Changed Comment, Status Changed Date, Status Changed Reason, Technical Survey Type and Type of Minefield are new in 6.0.
Note.jpg The main table is called hazreduc, the entity type is called Hazard Reduction, the target is called Hazreducversion and the main maXML artifact is HazardReductionActivity.

Uncategorised.png

DIM Label Data type Database column name Enumcategory Pojo name
Criteria for Cancellation Multi-select - Criteria For Cancellation CriterionForCancellation
Criteria for Reduction Multi-select - Criteria For Reduction CriterionForReduction
Reduction Method Multi-select - Clearance Operation HazreducMethods
Marking Method Multi-select - Marking Method Markings
Recommendations Multi-select - RecommendationType Recommendations
Ammunition Storage Place ammunition_storage AmmunitionStorage
Anti-lift Fitted Single-select antilift_guid Yes No Answer AntiLiftFitted
Area Description Text areadescription AreaDescription
Area Officer String areaofficer AreaOfficer
Size of Area (old) Numeric areasize AreaSize
Area Supervisor String areasupervisor AreaSupervisor
Assumption Prior To Visit Single-select assumptionpriortovisit_guid Assumption AssumptionPriorToVisit
Best Route to Site Text bestroutetosite BestRouteToSite
Booby Trapped Single-select boobytrap_guid Yes No Answer BoobyTrapped
Inactive - calculatedareasize CalculatedAreaSize
Cancelled Area Numeric cancelled_area CancelledArea
Cleared Area Numeric cleared_area ClearedArea
Comment Text comments Comments
Community Involved in Handover Single-select community_involved_in_handover Yes No Answer CommunityInvolvedInHandover
Community Leader String communityleader CommunityLeader
Inactive - communityleaderposition CommunityLeadershipPosition
Cost per Meter Numeric costsquaremeter CostSquareMeter
Dangerous Area Type Single-select dangerousarea_guid DangerAreaType DangerousArea
Deployed Asset Single-select deployed_asset Deployed Asset DeployedAsset
Depth Numeric depth Depth
Destruction Method Text destructionmethod DestructionMethod
Distance from Nearest Town Numeric distancefromnearesttown DistanceFromNearestTown
End Date Date enddate EndDate
End Period String endperiod EndPeriod
Estimated Workday String estimatedworkday EstimatedWorkday
External Visual Ordnance Condition Single-select external_visual_ordnance_condition External Visual Ordnance Condition ExternalVisualOrdnanceCondition
Fighting in Area Single-select fightinginarea_guid Yes No Answer FightingInArea
Handover Carried Out Single-select handover_carried_out Yes No Answer HandoverCarriedOut
Activity ID String hazreduc_localid LocalId
Activity Name String hazreducname Name
Type of Activity Single-select hazreductypeenum_guid Mine Action Activity Type
Hours Spent Numeric hoursspent HoursSpent
Intended Land Use Text intendedlanduse IntendedLandUse
Interviewer String interviewer Interviewer
Length Numeric length Length
Inactive - macid MacId
Marking Single-select marking_guid Yes No Answer Marking
Inactive - mechanicaldemining_guid Yes No Answer MechanicalDemining
Inactive - minefieldref_guid MineFieldId
Mines/UXO Condition Single-select mineuxocondition_guid MineCondition MinesUxoConditionId
Monitor Single-select monitor_guid Yes No Answer Monitor
Municipality String municipality Municipality
Number of Boys Involved from Community in Handover Integer number_of_boys_involved_from_ community_in_handover NumberOfBoysInvolvedFromCommunity InHandover
Number of Girls Involved from Community in Handover Integer number_of_girls_involved_from_ community_in_handover NumberOfGirlsInvolvedFromCommunity InHandover
Number of Men Involved from Community in Handover Integer number_of_men_involved_from_ community_in_handover NumberOfMenInvolvedFromCommunity InHandover
Number of Women Involved from Community in Handover Integer number_of_women_involved_from_ community_in_handover NumberOfWomenInvolvedFromCommunity InHandover
Number of Teams Integer numberofteams NumberOfTeams
Number of Vehicles Integer numberofvehicles_herd NumberOfVehicles
Operational Notes Text operationalnotes OperationalNotes
Organisation Organisation org_guid Organisation
Planned End Date Date plannedenddate PlannedEndDate
Planned Start Date Date plannedstartdate PlannedStartDate
QM Comments Text qacomments QaComments
Quality Assurance Single-select qualityassurance_guid Yes No Answer QualityAssurance
Reduced Area With Technical Asset Numeric reduced_area_with_technical_asset ReducedAreaWithTechnicalAsset
Reduced Area Without Technical Asset Numeric reduced_area_without_technical_asset ReducedAreaWithoutTechnicalAsset
Road Usable For Single-select roadusablefor_guid RoadUsableFor RoadUsableFor
SOP Combination Text sopcombination SopCombination
SOP Animal Text sopdog SopDog
SOP Manual Text sopmanual SopManual
SOP Mechanical Text sopmechanical SopMechanical
SOP Metal Detector Text sopmetaldector SopMetalDetector
Start Date Date startdate StartDate
Start Period String startperiod StartPeriod
Status Changed Comment Text status_changed_comment StatusChangedComment
Status Changed Date Date status_changed_date StatusChangedDate
Status Changed Reason Single-select status_changed_reason Hazard Reduction Status Changed Reason StatusChangedReason
Status Single-select status_guid HazReducStatus Status
Inactive - surveyref_guid SurveyId
Task Dossier String taskdossier Taskdossier
Tasked By String taskedby TaskedBy
Inactive - taskref_guid TaskId
Team ID String teamid TeamId
Team Leader String teamleader TeamLeader
Team Location String teamlocation TeamLocation
Technical Survey Type Single-select technical_survey_type Technical Survey Type TechnicalSurveyType
Type of Minefield Single-select type_of_minefield Type Of Minefield TypeOfMinefield
Uncleared Area Size Numeric unclearedareasize UnclearedAreaSize
Inactive - vegetationremovedby_guid VegetationRemovalMethod VegetationRemovedBy
Verification Notes String verificationnotes VerificationNotes
Visitor Text visitor Visitor
Item Data
DEFs
Geo data
Task
Auxiliary Data
Other
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Activity_Uncategorised&oldid=24127"