The League Registration reports allow you to report on SADetail records for Team Contacts linked to League Registrations in RecTrac.
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.
Note: Field Level Help for this report is under construction and will be completed soon!
See Also: Topic Doc - RecConnect Programs.
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.
From the bottom of the screen…
Core Criteria
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 League Date Range (LSLeague_IncludeDateRange_UseRange)
Enable League Range to specify a range of leagues to include, if desired.
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.
|
|
Begin 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.
DeleteReservation Archived (SADetail_Archived_ComboBox)
Select your archive filter. Multiple selection is allowed.
OR
Leave this field at 0 Selected to skip this filter
- Yes - Yes, you want to include records have been archived in your output.
- No - No, you don't want to include records that have been archived.
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.
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.
DeleteEnd 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