Section Filters
Sections (ARSection_ComboKey_DataGrid)
The Activity Section DataGrid displays all sections in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Sections, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Activity Section Range option.
THEN
Input the range of sections you want to include.
Make selections in the DataGrid or use an Activity Section Range or both. Leaving the DataGrid blank and the Use Range option de-selected will result in no sections being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Activity Section Range (ARSection_ComboKey_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of activity sections.
THEN
Enter the range of section codes.
OR
Leave this option de-selected to skip the activity section range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the range yields a blank report or process.
- If there is not a DataGrid for this program - In instances where you do not have a DataGrid a selection here is not required. Leaving this option deselected skips this filter and results in all codes being included.
Begin Activity Section (ARSection_ComboKey_Begin)
This field is applicable only if you opt to Use Activity Section Range.
Select the beginning and ending activity section codes for their respective fields. Activity sections within the range entered will be included in the process.
DeleteEnd Activity Section (ARSection_ComboKey_End)
This field is applicable only if you opt to Use Activity Section Range.
Select the beginning and ending activity section codes for their respective fields. Activity sections within the range entered will be included in the process.
DeleteLocation Code (CYAbsence_SectionLocation_Equals)
Select a Facility Location to use as a base for a Wildcard
OR
Enter all or part of a Facility Location code in this field.
THEN
Select your WildCard Option for matching the data entered. Wildcarding is allowed in this field.
Core
Households (SAHousehold_HouseholdNumber_DataGrid)
The Household DataGrid displays all households in your database based on the DataGrid filters being used.
Highlight/select individual Households, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Household Number Range option.
THEN
Input the range of Household Numbers you wish to include.
Make selections in the DataGrid or use a Household Number Range or Both. Leaving the DataGrid blank and this option de-selected will result in NO HOUSEHOLDS being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Household # Range (CYAbsence_HouseholdNumber_UseRange)
The functionality of this field differs depending on whether you are running a Household Report/Process or a Family Member Report/Process.
-
Household Report/Process - Select this option to include only those Households in the Begin and End Household Number range in your output as well as any households selected in the DataGrid if applicable.
THEN
Input the range of Household Numbers you wish to include. By default the Begin/End range is <Blank> to '999999999' (i.e. all households).
OR
Leave this option de-selected to include onlythose Households selected in the DataGrid in your output.- Make selections in the DataGrid or use a Household Number Range or Both. Leaving the DataGrid blank and this option de-selected will result in NO HOUSEHOLDS being selected.
-
Family Member Report/Process - Select this option to include only those Households in the Begin and End Household Numberrange in your output.
- DO NOT make selections from the DataGrid when running Family Member reports/processes and using Household Number Range. The report will yield 0 results as the two fields work separately.
Note: Begin and End Household Number fields appear only if this check box is selected.
Household Status (SAHousehold_RecordStatus_ComboBox)
Select the Statuses you wish to include in your output.
OR
Leave this field at its default to skip this filter.
Begin Household # (SAHousehold_HouseholdNumber_Begin)
If opting to Use Household Number Range, enter the Beginning and Ending range of Household Numbers you wish to include on your output. By default, the Begin/End range is <Blank> to '999999999' (i.e. all households).
OR
Select your Beginning and Ending Household Number range.
End Household # (SAHousehold_HouseholdNumber_End)
If opting to Use Household Number Range, enter the Beginning and Ending range of Household Numbers you wish to include on your output. By default, the Begin/End range is <Blank> to '999999999' (i.e. all households).
OR
Select your Beginning and Ending Household Number range.
Household # (SAHousehold_HouseholdNumber_Equals)
The functionality of this field differs depending on whether you are running a Report or a Process.
- If Running a Report - Click the Picklist icon to select a single household if desired. The report will yield results for that single household only.
-
If Running a Process - Enter a Wildcard value if desired.
THEN
Select a Wildcard Option. Depending on your selection wildcard asterisks/periods may be required.
WildCard Option (SAHousehold_HouseholdNumber_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr ' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by ' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Begin Absence Date (CYAbsence_AbsenceDate_Begin)
This field is applicable only if you are opting to Use Posting Date Range
Select your posting date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Absence Date (CYAbsence_AbsenceDate_End)
This field is applicable only if you are opting to Use Posting Date Range
Select your posting date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteBegin Posting Date (CYAbsence_PostingDate_Begin)
This field is applicable only if you are opting to Use Posting Date Range
Select your posting date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Posting Date (CYAbsence_PostingDate_End)
This field is applicable only if you are opting to Use Posting Date Range
Select your posting date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeletePosting Method (CYAbsence_PostingMethod_ComboBox)
Select the Posting Methods you wish to include in your output.
OR
Leave this field at its default to skip this filter.
Reason For Absence (CYAbsence_ReasonForAbsence_ComboBox)
Select the most applicable reason code for the absence. This is a Mandatory field for the default Vermont Systems design. Your design and setup may vary.
Reason for Absence Codes are maintained in System Code Management. Type = Reason for Absence.
Delete