Set Up Activity Tables
Copyright © 2019 EarthSoft, Inc • Modified: 05 Mar 2019
Activities in Sample Planning Module are synonymous with inspections. In general, an Activity is something that should be done and record that doesn't directly relate to the collection of a sample. This article describes setting up SPM so that you may plan Purging, Water Level collection and other activities.
To be able to add Purge and/or Water Levels to Planned Tasks:
1.Add one or both of the following records to the RT_SPM_ACTIVITY table:
2.Go to the Planned Task window and click Activities. The ACTIVITY_DESC is used to create the label on the Add button in the Activities tab:
3.The Purge activity requires the additional step of ensuring that a "Purge" activity type exists in RT_GROUP, with GROUP_CODE="purge" and GROUP_TYPE="spm_activity". A simple way to do this is to use the Add Activity Type feature of the SPM Activity Manager (see steps below for more details).
The following steps provide a convenient way to set up Activities for use in SPM and EDGE. See Create Groups for Custom Activity List for details on which fields in Professional are populated through this process.
1.Click Manage Activities to open the Activities Manager screen. This is accessed either:
a.On the Plan tab of the SPM Menu Ribbon:
b.Or on the SPM Activities screen:
2.Click Add Activity Type to display the Activity Code(s) of that type.
3.Click Add Activity to create a new ACTIVITY_CODE
4.Add Activity Code, Activity Description and Field Type. Field Type is used to specify the expected data type and/or constrain the Activity to an enumeration list when entering the Activity's data in EDGE. The following are examples of valid entries for Field Type:
•Blank or "EDGE_TEXT" = EDGE will expect text entries (up to 255 characters)
•"EDGE_Integer" = EDGE will expect integer values (e.g. 1,2,3,4,5)
•"EDGE_Decimal" = EDGE will expect decimal values (e.g. 1, 1.1, 1.22)
•"EDGE_Date" = EDGE will expect Date values
•"EDGE_Time" = EDGE will expect time values in 24 hr format
•"EDGE_DateTime"=EDGE will expect DateTime values
•"EDGE_Label"=EDGE_Label can be used for a header no values are expected. To make it a white space (blank line) you need to enter a "space" in the description
•The List Name from the format enumeration (…-enum.xml) file - e.g., enter “Colors” if you have an enumeration list entitled "Colors"
Note: To specify both a data type and an enumeration, separate the entries with a comma (e.g. "EDGE_TEXT, Colors").
5.Click OK to complete the data entry and to return to the Home or Activities screen.
6.To delete activity records, highlight the Activity Type Code or Activity Code, and click Remove Activity Type or Remove Activity.