Core Criteria
Staff Members (SAStaff_RecordCode_DataGrid)
The Instructors DataGrid displays all Instructor Codes in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual Instructor Codes, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Staff Code Range option.
THEN
Input the range of Staff Codes you wish to include.
Make selections in the DataGrid or use a Staff Code Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO STAFF CODES being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Staff Code Range (SAStaff_RecordCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Staff Members.
THEN
Enter the range of Staff Codes.
OR
Leave this option de-selected to skip the Staff Code 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 de-selected skips this filter and results in ALL Codes being included.
Status (SAStaff_RecordStatus_ComboBox)
Select the Status(es) by which you wish to filter. Multiple selection is allowed. Only Records that are linked to the Status(es) you select will be included on the output.
OR
Leave this field at its default setting, (0) Selected, to skip this check and include all statuses.
- Active
- Inactive
- Pending
- Quit
- Fired
Begin Instructor Code (SAStaff_RecordCode_Begin)
This field is applicable only if you opt to Use Staff Code Range.
Select the Beginning and Ending Staff Codes for their respective fields. Staff Codes within the range entered will be included in the process.
DeleteEnd Instructor Code (SAStaff_RecordCode_End)
This field is applicable only if you opt to Use Staff Code Range.
Select the Beginning and Ending Staff Codes for their respective fields. Staff Codes within the range entered will be included in the process.
DeleteStaff Code WildCard (SAStaff_RecordCode_Equals)
Select a Staff Record to use as a base for your Wildcard search
OR
Enter letters in this field to use as a base for your Wildcard search, if desired.
THEN
Select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required. Only those Sections to which an instructor who meets your Wildcard Criteria will appear on your output.
WildCard Option (SAStaff_RecordCode_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.
League Criteria
Leagues (LSLeague_LeagueCode_DataGrid)
Specify the league or leagues to include. You can select leagues using one or a combination of the following options (DataGrid, League Range, Wildcard, and League Begin/End Dates). When multiple selection options are used, it is additive. For example, you might use a range to select consecutive league codes (SoftballCoedA, SoftballCoedB, and SoftballCoedC), and then the DataGrid to select a league with a non-consecutive code.
The Leagues DataGrid lists all the leagues currently established in your system that you have Permissions to view.
Highlight/select the individual leagues you want to include in your Tournament. Multiple selection is allowed.
DataGrid column sort options allow you to customize the view as desired. Click here for a full description of RecTrac DataGrids.
DeleteUse League Range (LSLeague_LeagueCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to use limit your selection to a range of leagues.
THEN
Enter the range.
OR
Leave this option deselected to skip this 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 don't have a DataGrid a selection here is not required. Leaving this option deselected skips this filter and results in all codes being included.
Begin League (LSLeague_LeagueCode_Begin)
This field is applicable only if you opt to Use League Range.
Select the beginning and ending league codes for their respective fields.
DeleteEnd League (LSLeague_LeagueCode_End)
This field is applicable only if you opt to Use League Range.
Select the beginning and ending league codes for their respective fields.
DeleteLeague (LSLeague_LeagueCode_Equals)
Select the league code you wish to use a base for your wildcard.
THEN
Choose your wildcard equals option, if applicable.
See also: RecTrac Wildcarding.
DeleteWildCard Option (LSLeague_LeagueCode_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.
League Category (LSLeague_Category_ComboBox)
Select the category code(s) by which you want to filter. Multiple selection is allowed.
DeleteUse League Date Range (LSLeague_IncludeDateRange_UseRange)
Enable League Range to specify a range of leagues to include, if desired.
DeleteBegin League Date (LSLeague_IncludeDateRange_Begin)
Enter the league begin and end dates. This field includes records based on the dates during which the league plays. Any league with play dates anywhere within your date range will be included.
For example, your Date Range is 01 May 20xx - 30 June 20xx.
A league beginning on 29 June would be included because the league takes place within your date range.
A league ending on 02 May would be included because the league takes place within the date range.
A league beginning on/after 01 July would NOT be included because the league starts after your date range.
DeleteEnd League Date (LSLeague_IncludeDateRange_End)
Enter the league begin and end dates. This field includes records based on the dates during which the league plays. Any league with play dates anywhere within your date range will be included.
For example, your Date Range is 01 May 20xx - 30 June 20xx.
A league beginning on 29 June would be included because the league takes place within your date range.
A league ending on 02 May would be included because the league takes place within the date range.
A league beginning on/after 01 July would NOT be included because the league starts after your date range.
DeleteAdditional Criteria
Site Code (SAStaff_SiteCode_Picklist)
Select the Site Code(s) by which you want to filter the report. Multiple selection is allowed.
OR
Leave this field blank to skip this filter.
Site Area (SAStaff_SiteArea_Picklist)
Select the Site Area(s) by which you want to filter the report. Multiple selection is allowed.
OR
Leave this field blank to skip this filter.
Site Category (SAStaff_SiteCategory_Picklist)
Select the Site Category/Categories by which you want to filter the report. Multiple selection is allowed.
OR
Leave this field blank to skip this filter.
Site Group (SASite_SiteGroup_PickList)
Select the Site Group(s) by which you want to filter the report. Multiple selection is allowed.
OR
Leave this field blank to skip this filter.
Site Type (SASite_SiteType_PickList)
Select the Site Type(s) by which you want to filter the report. Multiple selection is allowed.
OR
Leave this field blank to skip this filter.