Core Criteria
Passes (SADetail_FileLinkCode1PM_DataGrid)
Select individual Pass Types or a range of Pass Types from the DataGrid, if desired. The passes you select will be included in the process you are running.
OR
Make no selections in the browser and opt to Use Pass Range to select a range of passes to include in this process, if desired.
Note: You must make a selection either in the DataGrid or in this Range (or both). Leaving the Use Pass Range option de-selected and making no selections in the DataGrid will result in NO PASS TYPES being selected.
Use Pass Range (SADetail_FileLinkCode1PM_UseRange)
Select this option to include only those Passes in the Begin and End Code range in this process.
THEN
Input the range of Passes you wish to include.
OR
Leave this option de-selected to skip this filter.
Note: You must make a selection either in the DataGrid or in this Range (or both). Leaving this option de-selected and making no selections in the DataGrid will result in NO PASS TYPES being selected.
Record Status (PMPass_RecordStatus_ComboBox)
Click the Combo Box icon to select the Pass Code Status(es) you wish to include in your output. Multiple selection is allowed.
OR
Leave this field at its default (0) Selected to skip this field and include all statuses.
- Active
- Inactive
Begin Pass Code (SADetail_FileLinkCode1PM_Begin)
If opting to Use Pass Range, accept the default entries (<blank> to ZZZZZZ)
OR
Click the Picklist icons and select your Begin and End Pass Codes.
OR
Enter a Pass Code Wildcard.
Note: You must make a selection either in the DataGrid or in this Range (or both). Leaving the Use Pass Range option de-selected and making no selections in the DataGrid will result in NO PASS TYPES being selected.
End Pass (SADetail_FileLinkCode1PM_End)
If opting to Use Pass Range, accept the default entries (<blank> to ZZZZZZ)
OR
Click the Picklist icons and select your Begin and End Pass Codes.
OR
Enter a Pass Code Wildcard.
Note: You must make a selection either in the DataGrid or in this Range (or both). Leaving the Use Pass Range option de-selected and making no selections in the DataGrid will result in NO PASS TYPES being selected.
Pass Code Wildcard (SADetail_FileLinkCode1PM_Equals)
Expand the Picklist icon to select the Pass Code Type you wish to use a base for your Wildcard.
THEN
Choose your Wildcard Equals Option.
See also: RecTrac Wildcarding.
DeleteWildCard Option (SADetail_FileLinkCode1PM_Equals_Option)
This field is applicable only if you opt to use a Wildcard.
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.
Site Code (SADetail_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 (SADetail_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 (SADetail_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.
Use Begin Date Range (SADetail_BeginDate_UseRange)
Select this option to filter the report output by Begin Date Range, if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending Begin Date range.
OR
Leave this option de-selected to skip the Begin Date Range check.
This field is used to filter SADetail Records by the date they started/begin as opposed to the date of the Transaction (For Example: Pass Membership Begin Dates, Visit Begin (Swipe-in) Dates, Activity Begin Dates, Rental Begin Dates, etc…).
DeleteEnrollment Status (SADetail_RecordStatus_ComboBox)
Select the Status(es) which you want included on the report or in your process. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
Note: The statuses in this field are module-specific. The table provides all status options. The list you're seeing is dependent upon the report or process you're running.
|
|
Classes That Begin Between: (SADetail_BeginDate_Begin)
This field is applicable only if you opt to Use Begin Date Range.
Select your Begin/End Begin Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Anything with a Begin Date in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteAnd: (SADetail_BeginDate_End)
This field is applicable only if you opt to Use Begin Date Range.
Select your Begin/End Begin Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Anything with a Begin Date in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Include Date Range (SADetail_IncludeDateRange_UseRange)
Select this option to filter the report output by the Date Range on the label, if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending Date range.
OR
Leave this option de-selected to skip the Use Date Range check.
This field is used to filter SADetail Records by the date they took place or were valid as opposed to the date of the Transaction (For Example: Visit Dates, Membership Dates, Daycare Meeting Dates (i.e. Activities designated as Child Care Activities), Facility Reservation Dates, Rental Dates, etc…).
DeleteUse Most Current Pass Only? (SADetail_MostRecentPass_ComboBox)
Expand the Drop-down list and select your Current Pass Only option.
- Yes - The report output will include only the most recent pass by number, by expiration date, by status. For Example: Pass 401 has been renewed three (3) times, so there are four (4) SADetailRecords for this pass (1 Active" record and 3 "Expired" records). If your Member Status includes 'Active' and 'Expired' then the report output will include one (1) record only for Pass 401: the most recent one which is likely 'Active' status.
- No - The report output will include every instance of a pass by number by expiration date by status. For Example: Pass 401 has been renewed three (3) times so there are four (4) SADetailRecords for this pass (1 "Active" record and 3 "Expired" records). If your Member Status includes 'Active' and 'Expired' then the report output will include all four records for Pass 401.
Begin Include Date (SADetail_IncludeDateRange_Begin)
This field is applicable only if you opt to Use Date Range and it is mandatory in that event.
Expand the Drop-down list and select your Begin/End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Include Date (SADetail_IncludeDateRange_End)
This field is applicable only if you opt to Use Date Range and it is mandatory in that event.
Expand the Drop-down list and select your Begin/End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse End Date Range (SADetail_EndDate_UseRange)
Select this option to filter the report output by End Date Range, if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending End Date range.
OR
Leave this option de-selected to skip the End Date Range check.
This field is used to filter SADetail Records by the date they end/expire as opposed to the date of the Transaction (For Example: Pass Membership Expiration Dates, Locker Expiration Dates, Activity End Dates, Facility Rental End Dates, etc…).
DeleteExclude Passes with a Future Renewal? (SADetail_HasFutureRenewal_ComboBox)
Expand the Drop-down list and select your Has Future Renewal option.
- Yes - The report output will include Active Pass Codes with a most recent renewal Date in the future. For Example: Today" is May 05. Pass 401 is 'Active' and the most recent renewal date in 01 June which has not yet arrived. This Pass will be included on the report.
- No - The report output will include Active Pass Codes with a most recent renewal Date in the past only. For Example: "Today" is May 05. Pass 401 is 'Active' and the most recent renewal date in 01 June which has not yet arrived. This Pass will NOT be included on the report.
Begin End Date (SADetail_EndDate_Begin)
This field is applicable only if you opt to Use End Date Range.
Select your Begin/End End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Anything with an End Date in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd End Date (SADetail_EndDate_End)
This field is applicable only if you opt to Use End Date Range.
Select your Begin/End End Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Anything with an End Date in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeletePass Report Tag (PMPass_ReportTag_ComboBox)
Select the Report Tags by which you wish to filter. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
Report Tags are maintained in System Code Maintenance Code Type = Report Tag. They are linked in File Management for the module you are working with. For example Section Report Tags are linked in Section Management Facility Report Tags are linked in Facility Management etc.
DeleteDaily Pass (PMPass_DailyPass_ComboBox)
Click the Combo Box icon to select the Daily Pass Status(es) on which you wish to report. Only those Codes with a Status matching your selection(s) will be included.
- Yes - Yes. Include Daily Passes.
- No - No. Do not include Daily Passes.
Note: This option keys off your selection in the Daily Pass Code field in Pass Code Update. On the Standard VSI Design this is the Core Settings group on the Core tab.
Leave this field at its default value (0) to skip the Daily Pass check.
DeletePass Category (PMPass_Category_ComboBox)
Select the Category Code(s) by which you wish to filter. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
Category Codes are maintained in System Code Management Code Type = Category. They are linked in File Management for the module you are working with. For Example: Activity Categories are linked in Activity Management Facility Categories are linked in Facility Management etc.
DeletePunch Pass Option (PMPass_PunchPassOption_ComboBox)
Click the Combo Box icon to select the Punch Pass Option(s) on which you wish to report. Only those Punch Pass Codes with a type matching your selection(s) will be included.
- Not a Punch Pass - Include Pass Codes that are NOT Punch Passes
- per Day - Include per Day Punch Pass Codes.
- per Day - Include per Visit Punch Pass Codes.
Note: The options in this field key off your selections in the Punch Pass Option field in Pass Code Update. On the Standard VSI Design this is the Punch Pass Settings group on the Core tab.
Leave this field at its default value (0) to skip the Punch Pass check.
DeletePass Type (PMPass_TypeCode_ComboBox)
Select the Type Code(s) by which you wish to filter. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
Type Codes are maintained in System Code Management Code Type = Type. They are linked in File Management for the module you are working with. For Example: Activity Types are linked in Activity Management Facility Types are linked in Facility Management etc.
DeleteSpecial Option (PMPass_SpecialOption_ComboBox)
Click the Combo Box icon to select the Special Option(s) on which you wish to report. Only those Pass Codes with an Option matching your selection(s) will be included.
- Normal - Include 'Normal' passes. These are regular Pass Codes
- CYMS - Include Child Youth Management System (CYMS) Pass Codes.
- Secondary - Include Secondary Pass Codes. These are Family Pssses."
Note: The options in this field key off your selections in the Pass Classification field in Pass Code Update. On the Standard VSI Design this is the Family Pass Settings group on the Core Continued tab.
Leave this field at its default value (0) to skip the Special Option check.
DeletePass SubType (PMPass_SubType_ComboBox)
Select the SubType Code(s) by which you wish to filter. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
SubType Codes are maintained in System Code Management Code Type = Type • SubTypes. They are linked in File Management for the module you are working with. For Example: Activity SubTypes are linked in Activity Management Facility SubTypes are linked in Facility Management etc.
DeleteVisit Option (PMPass_VisitOption_ComboBox)
Click the Combo Box icon to select the Punch Pass Option(s) on which you wish to report. Only those Punch Pass Codes with a type matching your selection(s) will be included.
- Full Only - Include Pass Codes set up for Full Visits.
- Half Only - Include Pass Codes set up for Half Visits.
- Both - Include Pass Codes set up for both Full and Half Visits.
Note: The options in this field key off your selections in the Visit Option field in Pass Code Update. On the Standard VSI Design this is the Visit Options group on the Core Continued tab.
Leave this field at its default value (0) to skip the Visit Option check.
DeleteDetail Criteria
Use Original Member Date Range (SADetail_OriginalMemberDate_UseRange)
Select this option to filter your report by Original Member Date Range, if desired.
THEN
Enter your Beginning and Ending Original Membership Date Range in their respective fields.
Note: Original Membership Date refers to the date on which a patron purchased his or her Membership. Renewals do not count so a Pass purchased on 16 April 2013 and subsequently renewed year after year would have an "Original Membership Date" of April 16 2013.
Begin Original Member Date (SADetail_OriginalMemberDate_Begin)
This field is applicable only if you are opting to Use Original Member Date Range
Expand the Drop-down list and select the date range you want to use.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
If you are running this program manually it is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Original Member Date (SADetail_OriginalMemberDate_End)
This field is applicable only if you are opting to Use Original Member Date Range
Expand the Drop-down list and select the date range you want to use.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
If you are running this program manually it is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Suspension Start Date Range (SADetail_BeginSuspension_UseRange)
Select this option to filter your report by Suspension Start Date Range, if desired.
THEN
Enter your Beginning and Ending Suspension Start Date Range in their respective fields.
Begin Suspension Start Date (SADetail_BeginSuspension_Begin)
This field is applicable only if you are opting to Use Suspension Start Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Suspension Start Date (SADetail_BeginSuspension_End)
This field is applicable only if you are opting to Use Suspension Start Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Suspension Finish Date Range (SADetail_EndSuspension_UseRange)
Select this option to filter your report by Suspension End Date Range, if desired.
THEN
Enter your Beginning and Ending Suspension Start Date Range in their respective fields.
Begin Suspension Finish Date (SADetail_EndSuspension_Begin)
This field is applicable only if you are opting to Use Suspension End Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Suspension Finish Date (SADetail_EndSuspension_End)
This field is applicable only if you are opting to Use Suspension End Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Pass Number Range (SADetail_PassNumber_UseRange)
Select this option to filter your report by Pass Number, if desired.
THEN
Enter your Beginning and Ending Pass Number Range in their respective fields.
Begin Pass Number (SADetail_PassNumber_Begin)
This field is applicable only if you are opting to Use Pass Number Range
Enter the Beginning and Ending Pass Numbers by which you wish to filter in their respective fields.
DeleteEnd Pass Number (SADetail_PassNumber_End)
This field is applicable only if you are opting to Use Pass Number Range
Enter the Beginning and Ending Pass Numbers by which you wish to filter in their respective fields.
DeleteUse Lost Card Count Range (SADetail_LostCardCount_UseRange)
Select this option to filter your report by Lost Card Count, if desired.
THEN
Enter your Beginning and Ending Lost Card Count Range in their respective fields.
Begin Lost Card Count (SADetail_LostCardCount_Begin)
This field is applicable only if you are opting to Use Lost Card Count Range
Enter the Beginning and Ending Lost Card Count by which you wish to filter in their respective fields.
DeleteEnd Lost Card Count (SADetail_LostCardCount_End)
This field is applicable only if you are opting to Use Lost Card Count Range
Enter the Beginning and Ending Lost Card Count by which you wish to filter in their respective fields.
DeleteUse Punches Left Range (SADetail_PunchesLeft_UseRange)
This field is applicable for Punch Pass Codes only.
Select this option to filter your report by the number of Punches remaining on Punch Passes if desired.
THEN
Enter your beginning and ending range of remaining punches in their respective fields.
Begin Punches Left (SADetail_PunchesLeft_Begin)
This field is applicable only if you are opting to Use Punches Left Range
Enter the Beginning and Ending Punches Left count by which you wish to filter in their respective fields.
DeleteEnd Punches Left (SADetail_PunchesLeft_End)
This field is applicable only if you are opting to Use Punches Left Range
Enter the Beginning and Ending Punches Left count by which you wish to filter in their respective fields.
DeleteUse Last Visit Date Range (SADetail_LastVisitDate_UseRange)
Select this option to filter your report by Last Visit Date Range, if desired.
THEN
Enter your Beginning and Ending Visit Date Range in their respective fields.
Begin Last Visit Date (SADetail_LastVisitDate_Begin)
This field is applicable only if you are opting to Use Last Visit Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Last Visit Date (SADetail_LastVisitDate_End)
This field is applicable only if you are opting to Use Last Visit Date Range
Expand the Drop-down list and select the date range you want to use
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
It is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteHas Installment Bill Linked (SADetail_HasInstallmentBill_ComboBox)
Click the Combo Box icon to select your Installment Billing option(s), if desired.
- Yes - The report will list only those Members that are being installment billed for their pass.
- No - The report will list only those Members who are not being installment billed for their pass.
- Both or Neither - The report will list all Members regardless of whether they're being installment billed.
Use Visit Count Total Filters (SADetail_VisitCountTotals_UseRange)
Select this option to use Visit Count filters on your report selection.
THEN
Fill out all applicable fields that appear in the group
Begin Visit Count Total (SADetail_VisitCountTotals_Begin)
Enter a Beginning and Ending Visit Count range, if desired. Only those Members with a total number of visits that fall within your range will be included.
Leave these fields at their default value of 0" to skip the visit count check if desired.
Examples:
- Range = 1 - 50: Will include all Members with at least one (1) visit and up to 50 visits. Members with 0 visits and Members with 51 or more visits will be excluded.
- Range = 0 - 50: Will include all Members with up to 50. Members with 0 visits will be included. Members with 51 or more visits will be excluded.
- Range = 0 - 0: The system will skip the Visit Count Range check.
End Visit Count Total (SADetail_VisitCountTotals_End)
Enter a Beginning and Ending Visit Count range, if desired. Only those Members with a total number of visits that fall within your range will be included.
Leave these fields at their default value of 0" to skip the visit count check if desired.
Examples:
- Range = 1 - 50: Will include all Members with at least one (1) visit and up to 50 visits. Members with 0 visits and Members with 51 or more visits will be excluded.
- Range = 0 - 50: Will include all Members with up to 50. Members with 0 visits will be included. Members with 51 or more visits will be excluded.
- Range = 0 - 0: The system will skip the Visit Count Range check.
Visit Count Total Begin Date (SADetail_VisitCountTotals_BeginDate)
Expand the Drop-down list and select the date range over which you want to have visits listed.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
If you are running this program manually, it is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteVisit Count Total End Date (SADetail_VisitCountTotals_EndDate)
Expand the Drop-down list and select the date range over which you want to have visits listed.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select.
If you are running this program manually, it is always safe to use Actual Date for this field and your date range will be whatever you enter.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteBegin Visit Location (SADetail_VisitCountTotals_BeginLocationCode)
Click the Picklist icons to select a Location range, if desired. Only Members with visits recorded somewhere within the range of Locations selected will be included.
Leave these fields at their default value of <blank> to skip this check and include visit from all Locations.
DeleteEnd Visit Location (SADetail_VisitCountTotals_EndLocationCode)
Click the Picklist icons to select a Location range, if desired. Only Members with visits recorded somewhere within the range of Locations selected will be included.
Leave these fields at their default value of <blank> to skip this check and include visit from all Locations.
DeleteUnique Visits By Day (SADetail_VisitCountTotals_UniqueVisits)
Select this option to have the report filter by unique visits by member by day. When this option is enabled, a Member with multiple visits on the same day will be listed once only for that day, so a Member with three (3) visits in one day would be listed once only for that day.
When this option is de-selected, then a Member with multiple visits on the same day will be on the report as many times as the member had visits, so a Member with three (3) visits in one day would be listed three (3) times for that day.
DeleteHH / FM Criteria
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.
Household Category (SAHousehold_Category_ComboBox)
Expand the Combo Box icon to select the Household Categories you wish to include in your output.
OR
Leave this field at its default (0) Selected to include all Household Categories in your output.
Household Categories are maintained in System Code Management; Type = Category (Household/Family Member/Team).
DeleteCreation Product (SAHousehold_CreationProduct_ComboBox)
Select the Household Creation Products you wish to include in your output.
OR
Leave this field at its default (0) Selected to skip this filter. The Creation Product is the method by which the household's initial entry was generated in the database.For example, Selecting RecTrac only from the Combo Box will yield RecConnect results only for those Households that were created by a member of your staff using RecTrac. Households created by patrons using WebTrac would NOT be included.
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.
Use HH Last Name Range (SAHousehold_LastName_UseRange)
The functionality of this field differs depending on whether you are running a Report or a Process.
-
If running a Report - Select this option to include only those Households in the Begin and End Household Last Name range in your output.
THEN
Input the range of Households you wish to include. By default the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all households).- If the report you are running also contains a Household/Family Member DataGrid then DO NOT make any selections the DataGrid when running reports AND using Last Name Range. The report will yield 0 results because the two fields work separately.
- If the report you are running contains a non-Household/Family Member DataGrid then you can make selections in the DataGrid. For Example: If running the Question Statistics Report you can make selections in the Question Text DataGrid AND filter the report by Household/Family Member Range if desired.
-
If running a Process - Select this option to include only those Households in the Begin and End Household Last Name range in your process as well as any households selected in the DataGrid if applicable.
THEN
Input the range of Households you wish to include. By default the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all households).
OR
Leave this option de-selected to include only those Households selected in the DataGrid (if applicable for this process) in your process.
OR
Leave this option de-selected and do not select any Households in the DataGrid to include ALL households in the process.
Note: Begin and End Household Last Name fields appear only if this check box is selected.
Begin HH Last Name (SAHousehold_LastName_Begin)
If opting to Use HH Last Name Range, enter the Beginning and Ending range of Households you wish to include on your output. By default, the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all households).
The system wildcards automatically, so entering partial names will include all names that begin with the same letters. For Example: Entering 'A' in the Begin field and 'MZZZZ' in the End field will yield all last names starting with 'A' through 'M' in your output.
DeleteEnd HH Last Name (SAHousehold_LastName_End)
If opting to Use HH Last Name Range, enter the Beginning and Ending range of Households you wish to include on your output. By default, the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all households).
The system wildcards automatically, so entering partial names will include all names that begin with the same letters. For Example: Entering 'A' in the Begin field and 'MZZZZ' in the End field will yield all last names starting with 'A' through 'M' in your output.
DeleteUse Creation Date Range (SAHousehold_CreationDate_UseRange)
Select this option to filter the report output by Creation Date Range (the date on which households were entered into the database), if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending Creation Date range.
OR
Leave this option de-selected to skip the Creation Date Range check.
Begin Creation Date (SAHousehold_CreationDate_Begin)
This field is applicable only if you opt to Use Creation Date Range.
Select your Begin/End Creation Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Households added to your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Creation Date (SAHousehold_CreationDate_End)
This field is applicable only if you opt to Use Creation Date Range.
Select your Begin/End Creation Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Households added to your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Last Active Date Range (SAHousehold_LastActiveDate_UseRange)
Select this option to filter the report output by Last Active Date Range, if desired.
THEN
Use the Date Select fields to identify your Beginning and Ending Last Active Date range.
OR
Leave this option de-selected to skip the Last Active Date Range check.
The Last Active Date field can be found in Household Update. The system maintains this value and updates it any time a household is linked to a transaction such as an Activity Registration Facility Reservation Pass Visit etc. and whenever billing is run if the household is linked to an Installment Billing and/or Auto-debit record.
DeleteBegin Last Active Date (SAHousehold_LastActiveDate_Begin)
This field is applicable only if you opt to Use Last Active Date Range.
Select your Begin/End Last Active Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Households with activity in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Last Active Date (SAHousehold_LastActiveDate_End)
This field is applicable only if you opt to Use Last Active Date Range.
Select your Begin/End Last Active Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Households with activity in your database within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Reward Points Range (SAHousehold_RewardPoints_UseRange)
Select this option to filter the report output by Rewards Points Range, if desired.
THEN
Enter your Beginning and Ending Rewards Points range.
OR
Leave this option de-selected to skip Rewards Point Range check.
See Also: Topic Doc - RecTrac Reward Points.
DeleteBegin Reward Points (SAHousehold_RewardPoints_Begin)
This field is applicable only if you opt to Use Rewards Point Range.
Enter your Begin/End Rewards Points range. Households with a Rewards Point balance that falls within the range entered will be included in your output.
See Also: Topic Doc - RecTrac Reward Points.
DeleteEnd Reward Points (SAHousehold_RewardPoints_End)
This field is applicable only if you opt to Use Rewards Point Range.
Enter your Begin/End Rewards Points range. Households with a Rewards Point balance that falls within the range entered will be included in your output.
See Also: Topic Doc - RecTrac Reward Points.
DeleteFamily Member Status (SAPerson_RecordStatus_ComboBox)
Select the family member statuses you want to include in your output.
OR
Leave this field at its default to skip this filter.
Family Member Category (SAPerson_Category_ComboBox)
Select the Family Member Categories you wish to include in your output.
OR
Leave this field at its default (0) Selected to skip this filter.
Family Member Categories are maintained in System Code Management; Type = Category (Household/Family Member/Team).
DeleteGender (SAPerson_Gender_Equals)
Select the Genders you wish to include in your output.
OR
Leave this field at its default (0) Selected to skip this filter.
Gender Codes are maintained in System Code Management; Type = Gender.
DeleteBirthday Month (SAPerson_BirthdayMonth_ComboBox)
Click the Combo Box icon and select the months of the year you wish to include in your report output. Multiple selection is allowed. When you process the report, it will filter results to show only those members with a birthday in the month(s) selected.
Make no selections in this field to include all 12 months.
DeleteMember Has Special Needs (SAPerson_MemberHasSpecialNeeds_ComboBox)
Select whether you wish to filter your output by Family Members who have Special Needs.
OR
Leave this field at its default (0) Selected to skip this filter.
- Yes - Filter the report by those who DO have Special Needs.
- No - Filter the output by those who DO NOT have Special Needs.
Member Has Photo (SAPerson_HasPhoto_ComboBox)
Select your Has Photo" filter option.
- Yes - The report will filter by members who have a photo file attached. Only those members who have a photo will be included.
- No - The report will filter by members who do not have a photo file attached. Only those members without a photo (other than your "No Photo" image) will be included.
- Both - The report will include both members with a photo file and members without a photo file.
Use FM Last Name Range (SAPerson_LastName_UseRange)
The functionality of this field differs depending on whether you are running a Report or a Process.
-
If running a Report - Select this option to include only those Family Members in the Begin and End Family Member Last Name range in your report output as well as any family members selected in the DataGrid if applicable.
THEN
Input the range of Family Members you wish to include. By default the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all family members).- DO NOT make selections from the DataGrid when running reports and using Last Name Range. The report will yield 0 results as the two fields work separately.
-
If running a Process - Select this option to include only those Family Members in the Begin and End Family Member Last Name range in your process as well as any family members selected in the DataGrid if applicable.
THEN
Input the range of Family Members you wish to include. By default the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all family members).
OR
Leave this option de-selected to include only those Family Members selected in the DataGrid (if applicable for this process) in your process.
OR
Leave this option de-selected and do not select any Family Members in the DataGrid to include ALL family members in the process.
Note: Begin and End Family Member Last Name fields appear only if this check box is selected.
Begin FM Last Name (SAPerson_LastName_Begin)
If opting to Use FM Last Name Range, enter the Beginning and Ending range of Family Members you wish to include on your output. By default, the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all family members).
The system wildcards automatically, so entering partial names will include all names that begin with the same letters. For Example: Entering 'A' in the Begin field and 'MZZZZ' in the End field will yield all last names starting with 'A' through 'M' in your output.
DeleteEnd FM Last Name (SAPerson_LastName_End)
If opting to Use FM Last Name Range, enter the Beginning and Ending range of Family Members you wish to include on your output. By default, the Begin/End range is <Blank> to 'ZZZZZ' (i.e. all family members).
The system wildcards automatically, so entering partial names will include all names that begin with the same letters. For Example: Entering 'A' in the Begin field and 'MZZZZ' in the End field will yield all last names starting with 'A' through 'M' in your output.
DeleteUse Birthday Range (SAPerson_Birthday_UseRange)
Select this option to filter the report output by Birth Date Range, if desired.
THEN
Use the Date Select fields to identify your Beginning and Birthday Date range.
OR
Leave this option de-selected to skip the Birthday Date Range check.
Begin Birthday (SAPerson_Birthday_Begin)
This field is applicable only if you opt to Use Birthday Date Range.
Select your Begin/End Birthday Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Family Members born within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Birthday (SAPerson_Birthday_End)
This field is applicable only if you opt to Use Birthday Date Range.
Select your Begin/End Birthday Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Family Members born within the Date Range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Age Range (SAPerson_Age_UseRange)
Select this option to filter the report output by Age Range, if desired.
THEN
Enter your range of Ages in the applicable fields.
Begin Age (SAPerson_Age_Begin)
This field is applicable only if you opt to Use Age Range.
Enter your Begin/End Age range. Family Members an age that falls within the range entered will be included in your output.
DeleteEnd Age (SAPerson_Age_End)
This field is applicable only if you opt to Use Age Range.
Enter your Begin/End Age range. Family Members an age that falls within the range entered will be included in your output.
DeleteUse School Grade Range (SAPerson_SchoolGrade_UseRange)
Select this option to filter the report output by School Grade Range, if desired.
THEN
Enter your range of School Grades in the applicable fields.
OR
Leave this field de-selected to skip this filter.
Begin School Grade (SAPerson_SchoolGrade_Begin)
This field is applicable only if you opt to Use School Grade Range.
Enter your Begin/End School Grade range. Family Members in a school grade that falls within the range entered will be included in your output.
DeleteEnd School Grade (SAPerson_SchoolGrade_End)
This field is applicable only if you opt to Use School Grade Range.
Enter your Begin/End School Grade range. Family Members in a school grade that falls within the range entered will be included in your output.
DeleteHH Fee Code (SAHousehold_FeeCode_ComboBox)
Select this option to filter the output by Household Fee Codes
THEN
Select the corresponding Match Option.
OR
Leave this field at its default (0) Selected to skip the HH Fee Code check.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Fee Codes are maintained in System Code Management. Type = Fee.
DeleteHH Fee Code Match Option (SAHousehold_FeeCode_ComboBox_MatchOption)
This field is applicable only if you are including HH Fee Codes.
Expand the Drop-down list and select the corresponding Match Option.
Note: Code and Match option fields appear on numerous reports and processes in RecTrac. Depending on the report or process you are running some Match Options listed below may not appear in the Drop-down list. However the Match Options described here work the same way regardless of the field name. 'Fee Code' is being used in the following as an example only.
- Match Any - If there are options selected at least one (1) match is needed though multiple matches would be acceptable. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Resident Non-Profit Senior and Student. In order to appear on the report or process a Household would need to be linked to at least one of those Fee Codes though it could be linked to more than one such as Resident and Senior.
- Match All - If there are options selected ALL options must be linked to appear on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to all of those Fee Codes though it could be linked to more such as Resident Senior and Non-Profit.
- Match Exact - If there are options selected an EXACT MATCH is required for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. In order to appear on the report or process a Household would need to be linked to only those Fee Codes. It has to be an exact match. A Household linked to Senior and Non-Profit would not appear nor would a household linked to Resident Non-Profit Senior and Veteran.
- Match 1 (and up) - If there are options selected the Match number threshold must be met in order for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. Your Match Option is "2." In order to appear on the report or process a Household would need to be linked to two (2) of the three (3) Fee Codes though it could be linked to more.
- Match None - If there are options selected no matches must be found in order to be included on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to no Fee Codes or to Fee Codes that are NOT Resident and Senior such as Non-Resident and Student.
HH Features (SAHousehold_Features_ComboBox)
Select this option to filter the output by Household Feature Codes
THEN
Select the corresponding Match Option.
OR
Leave this field at its default (0) Selected to skip the HH Feature Code check.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Feature Codes are maintained in System Code Management. Type = Household Feature.
DeleteHH Features Match Option (SAHousehold_Features_ComboBox_MatchOption)
This field is applicable only if you are including HH Features.
Expand the Drop-down list and select the corresponding Match Option.
Note: Code and Match option fields appear on numerous reports and processes in RecTrac. Depending on the report or process you are running some Match Options listed below may not appear in the Drop-down list. However the Match Options described here work the same way regardless of the field name. 'Fee Code' is being used in the following as an example only.
- Match Any - If there are options selected at least one (1) match is needed though multiple matches would be acceptable. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Resident Non-Profit Senior and Student. In order to appear on the report or process a Household would need to be linked to at least one of those Fee Codes though it could be linked to more than one such as Resident and Senior.
- Match All - If there are options selected ALL options must be linked to appear on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to all of those Fee Codes though it could be linked to more such as Resident Senior and Non-Profit.
- Match Exact - If there are options selected an EXACT MATCH is required for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. In order to appear on the report or process a Household would need to be linked to only those Fee Codes. It has to be an exact match. A Household linked to Senior and Non-Profit would not appear nor would a household linked to Resident Non-Profit Senior and Veteran.
- Match 1 (and up) - If there are options selected the Match number threshold must be met in order for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. Your Match Option is "2." In order to appear on the report or process a Household would need to be linked to two (2) of the three (3) Fee Codes though it could be linked to more.
- Match None - If there are options selected no matches must be found in order to be included on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to no Fee Codes or to Fee Codes that are NOT Resident and Senior such as Non-Resident and Student.
Fee Code (SAPerson_FeeCode_ComboBox)
Select this option to filter the output by Family Member Fee Codes
THEN
Select the corresponding Match Option.
OR
Leave this field at its default (0) Selected to skip this filter.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Fee Codes are maintained in System Code Management. Type = Fee.
DeleteFee Code Match Option (SAPerson_FeeCode_ComboBox_MatchOption)
This field is applicable only if you are including HH Fee Codes.
Expand the Drop-down list and select the corresponding Match Option.
Note: Code and Match option fields appear on numerous reports and processes in RecTrac. Depending on the report or process you are running some Match Options listed below may not appear in the Drop-down list. However the Match Options described here work the same way regardless of the field name. 'Fee Code' is being used in the following as an example only.
- Match Any - If there are options selected at least one (1) match is needed though multiple matches would be acceptable. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Resident Non-Profit Senior and Student. In order to appear on the report or process a Household would need to be linked to at least one of those Fee Codes though it could be linked to more than one such as Resident and Senior.
- Match All - If there are options selected ALL options must be linked to appear on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to all of those Fee Codes though it could be linked to more such as Resident Senior and Non-Profit.
- Match Exact - If there are options selected an EXACT MATCH is required for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. In order to appear on the report or process a Household would need to be linked to only those Fee Codes. It has to be an exact match. A Household linked to Senior and Non-Profit would not appear nor would a household linked to Resident Non-Profit Senior and Veteran.
- Match 1 (and up) - If there are options selected the Match number threshold must be met in order for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. Your Match Option is "2." In order to appear on the report or process a Household would need to be linked to two (2) of the three (3) Fee Codes though it could be linked to more.
- Match None - If there are options selected no matches must be found in order to be included on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to no Fee Codes or to Fee Codes that are NOT Resident and Senior such as Non-Resident and Student.
FM Features (SAPerson_Features_ComboBox)
Select this option to filter the output by Family Member Feature Codes
THEN
Select the corresponding Match Option.
OR
Leave this field at its default (0) Selected to skip this filter.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Feature Codes are maintained in System Code Management. Type = Household Feature.
DeleteFM Features Match Option (SAPerson_Features_ComboBox_MatchOption)
This field is applicable only if you are including FM Features.
Expand the Drop-down list and select the corresponding Match Option.
Note: Code and Match option fields appear on numerous reports and processes in RecTrac. Depending on the report or process you are running some Match Options listed below may not appear in the Drop-down list. However the Match Options described here work the same way regardless of the field name. 'Fee Code' is being used in the following as an example only.
- Match Any - If there are options selected at least one (1) match is needed though multiple matches would be acceptable. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Resident Non-Profit Senior and Student. In order to appear on the report or process a Household would need to be linked to at least one of those Fee Codes though it could be linked to more than one such as Resident and Senior.
- Match All - If there are options selected ALL options must be linked to appear on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to all of those Fee Codes though it could be linked to more such as Resident Senior and Non-Profit.
- Match Exact - If there are options selected an EXACT MATCH is required for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. In order to appear on the report or process a Household would need to be linked to only those Fee Codes. It has to be an exact match. A Household linked to Senior and Non-Profit would not appear nor would a household linked to Resident Non-Profit Senior and Veteran.
- Match 1 (and up) - If there are options selected the Match number threshold must be met in order for inclusion on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident Non-Profit and Senior. Your Match Option is "2." In order to appear on the report or process a Household would need to be linked to two (2) of the three (3) Fee Codes though it could be linked to more.
- Match None - If there are options selected no matches must be found in order to be included on the report or process. For Example: This field might be for Fee Code and the Fee Codes you selected might be Resident and Senior. In order to appear on the report or process a Household would need to be linked to no Fee Codes or to Fee Codes that are NOT Resident and Senior such as Non-Resident and Student.
Transaction Criteria
Use Item Original Transaction Date Range (SADetail_TransactionDate_UseRange)
Select this option to filter the report output by transaction date range (the date on which the transaction was processed), if desired.
THEN
Select your date range.
OR
Leave this option deselected to skip this filter.
Transaction Type (SADetail_TransactionType_ComboBox)
Click the Combo Box icon to select the Transaction Type(s) by which you wish to filter when generating the output
OR
Make no selections in this field to include all Transaction Types.
|
|
Begin Transaction Date (SADetail_TransactionDate_Begin)
This field is applicable only if you opt to Use Transaction Date Range.
Select your transaction options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Transaction Date (SADetail_TransactionDate_End)
This field is applicable only if you opt to Use Transaction Date Range.
Select your transaction options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Item Original Transaction Time Range (SADetail_TransactionTime_UseRange)
Select this option to filter the report output by time range (the time on which the transaction was processed within the date range entered, if any), if desired.
THEN
Select your time range.
OR
Leave this option deselected to skip this filter.
Note: When opting to use a date and time range times are fixed across the dates in the range. For example your date range is 04/01/20xx - 04/07/20xx and your time range is 0700am - 0400pm. The report will list transactions that took place daily between 7:00am and 4:00pm for each date in the range.
To run a report using continuous time enter a date range and leave the Use Posting Time Range option deselected.
Begin Transaction Time (SADetail_TransactionTime_Begin)
This field is applicable only if you opt to Use Transaction Time Range.
Select your transaction time option.
THEN
Take appropriate action in the right-hand column to specify the actual time you wish to select. Transactions processed within the time range selected will be included on your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Transaction Time (SADetail_TransactionTime_End)
This field is applicable only if you opt to Use Transaction Time Range.
Select your transaction time option.
THEN
Take appropriate action in the right-hand column to specify the actual time you wish to select. Transactions processed within the time range selected will be included on your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Item Original Transaction Location Range (SADetail_TransactionLocationCode_UseRange)
Select this option to filter the report output by location range (the location at which the transaction was processed as determined by the user's Location profile), if desired.
THEN
Select your location range.
OR
Leave this option deselected to skip this filter.
Begin Transaction Location (SADetail_TransactionLocationCode_Begin)
This field is applicable only if you opt to Use Transaction Location Range.
Select your location range for this report.
DeleteEnd Transaction Location (SADetail_TransactionLocationCode_End)
This field is applicable only if you opt to Use Transaction Location Range.
Select your location range for this report.
DeleteUse UserName Range (SADetail_UserName_UseRange)
Select this option to filter the report output by User ID Range, if desired.
THEN
Enter a User ID range.
OR
Leave this option deselected to skip this filter.
Begin User Name (SADetail_UserName_Begin)
This field is applicable only if you opt to Use User ID Range.
Select your user ID range for this report.
DeleteEnd User Name (SADetail_UserName_End)
This field is applicable only if you opt to Use User ID Range.
Select your user ID range for this report.
DeleteUse Current Cash Drawer Range (SADetail_CurrentCashDrawer_UseRange)
Select this option to filter the report output by cash drawer range.
THEN
Enter a range of cash drawers in the applicable fields. The report will filter results by the most recent cash drawer used within your date/time range. For example, you enter 100-199 in this range. When you run the report, the output will include only results where the LAST cash drawer used for a transaction was within the range of drawers you enter.
Optionally, you can leave this option deselected and enter a single cash drawer in the Cash Drawer List Lookup field. That option will list transactions that occurred on that drawer at any time within your date/time range.
Optionally, you can leave this option deselected and leave the Cash Drawer Listing Lookup field at '0' to skip this filter.
DeleteCash Drawer List Lookup (SADetail_CashDrawerList_Equals)
Enter a single cash drawer number in this field, if desired, to run the report for transactions linked to that single drawer. This option will list transactions that occurred on this drawer at any time during your date/time range.
Optionally, you can select the Use Current Cash Drawer Range option to filter the report output by cash drawer range. The report will filter results by the most recent cash drawer used within your date/time range. For example, you enter 100-199 in this range. When you run the report, the output will include only results where the LAST cash drawer used for a transaction was within the range of drawers you enter.
Optionally, you can leave this field at '0' and deselect the range option to skip this filter.
DeleteBegin Cash Drawer (SADetail_CurrentCashDrawer_Begin)
This field is applicable only if you opt to Use Current Cash Drawer Range.
Enter a range of cash drawers in the applicable fields.
DeleteEnd Cash Drawer (SADetail_CurrentCashDrawer_End)
This field is applicable only if you opt to Use Current Cash Drawer Range.
Enter a range of cash drawers in the applicable fields.
DeleteUse Cancellation Date Range (SADetail_CancelDateTime_UseRange)
Select this option to filter the report output by Cancellation date range (the date or effective date on which the item was cancelled/will be cancelled, if any), if desired.
THEN
Use the Date Select fields to identify your beginning and ending cancellation Date range.
OR
Leave this option de-selected to skip this filter.
Begin Cancellation Date (SADetail_CancelDateTime_Begin)
This field is applicable only if you opt to Use Cancellation Date Range.
Select your Begin/End Cancellation Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Items cancelled in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Cancellation Date (SADetail_CancelDateTime_End)
This field is applicable only if you opt to Use Cancellation Date Range.
Select your Begin/End Cancellation Date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Items cancelled in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Total Amount Range (SADetail_TotalAmount_UseRange)
Select this option to filter the report output by total amount range, if desired.
THEN
Enter your range of amounts in the applicable fields.
OR
Leave this option deselected to skip this filter.
Begin Total Amount (SADetail_TotalAmount_Begin)
This field is applicable only if you opt to Use Total Amount Range.
Enter your total amount range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteEnd Total Amount (SADetail_TotalAmount_End)
This field is applicable only if you opt to Use Total Amount Range.
Enter your total amount range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteUse Discount Amount Range (SADetail_FeeDiscountAmount_UseRange)
Select this option to filter the report output by discount amount range, if desired.
THEN
Enter your range of amounts in the applicable fields.
Begin Discount Amount (SADetail_FeeDiscountAmount_Begin)
This field is applicable only if you opt to Use Discount Amount Range.
Enter your Begin/End Discount Amount range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteEnd Discount Amount (SADetail_FeeDiscountAmount_End)
This field is applicable only if you opt to Use Discount Amount Range.
Enter your Begin/End Discount Amount range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteUse Total Paid Range (SADetail_TotalPaid_UseRange)
Select this option to filter the report output by total paid amount range, if desired.
THEN
Enter your range of amounts in the applicable fields.
OR
Leave this option deselected to skip this filter.
Begin Total Paid (SADetail_TotalPaid_Begin)
This field is applicable only if you opt to Use Total Paid Amount Range.
Enter your total amount paid range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteRecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
From the bottom of the screen…
iv class="f-accordion-panel" data-controller="accordion">
End Total Paid (SADetail_TotalPaid_End)
This field is applicable only if you opt to Use Total Paid Amount Range.
Enter your total amount paid range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteUse Total Due Range (SADetail_TotalDue_UseRange)
Select this option to filter the report output by total due amount range, if desired.
THEN
Enter your range of amounts in the applicable fields.
OR
Leave this option deselected to skip this filter.
Begin Total Due (SADetail_TotalDue_Begin)
This field is applicable only if you opt to Use Total Due Amount Range.
Enter your total amount due range. Transactions for amounts that fall within the range entered will be included in your output.
DeleteEnd Total Due (SADetail_TotalDue_End)
This field is applicable only if you opt to Use Total Due Amount Range.
Enter your total amount due range. Transactions for amounts that fall within the range entered will be included in your output.
Delete