Att K - Reports.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Hunting and Fishing Electronic Licensing System
- Solicitation number
- 24-00006
- Issued by
- Adams County, Asotin County, Benton County, Chelan County, Clallam County, Clark County, Columbia County, Cowlitz County, Douglas County, Ferry County, Franklin County, Garfield County, Grant County, Grays Harbor County, Island County, Jefferson County, King County, Kitsap County, Kittitas County, Klickitat County, Lewis County, Lincoln County, Mason County, Okanogan County, Pacific County, Pend Oreille County, Pierce County, San Juan County, Skagit County, Skamania County, Snohomish County, Spokane County, Stevens County, Thurston County, Wahkiakum County, Walla Walla County, Whatcom County, Whitman County, Yakima County, Asotin City, Clarkston City, Clarkston Heights-Vineland CDP, West Clarkston-Highland CDP, Benton City, Chelan City, Chelan Falls CDP, Clallam Bay CDP, Lewisville CDP, Rock Island City, Pacific Beach CDP, Whidbey Island Station CDP, Mercer Island City, Pacific City, Bainbridge Island City, Kingston CDP, Kitsap Lake CDP, Kittitas City, Klickitat CDP, Okanogan City, Anderson Island CDP, Fort Lewis CDP, Fox Island CDP, Herron Island CDP, Ketron Island CDP, North Fort Lewis CDP, Raft Island CDP, Stevenson City, Hat Island CDP, Lake Stevens City, Snohomish City, Spokane City, Spokane Valley City, Puget Island CDP, Garfield Town, Yakima City, Washington
About this file
This file is a comprehensive report overview document detailing existing and new reporting requirements for the Washington Department of Fish and Wildlife's (WDFW) electronic licensing system. The document catalogs over 40 existing reports and 15 new reports that must be supported by the system, covering functions such as financial tracking, license sales, special hunt management, inventory control, and federal compliance reporting. Each report listing includes detailed specifications for search criteria, output formats, required data fields, and primary user groups.
The reports serve various business functions including ACH payment processing, dealer management, sales tracking, special hunt administration, and federal reporting requirements. Key stakeholders who utilize these reports include the Financial Unit, Customer Service Staff, Business Technical Unit, Wildlife Program staff, and license dealers. Notable requirements include federal certification reporting to US Fish and Wildlife Service, veteran donation program management, special hunt draw administration, and Discover Pass fulfillment tracking. The document emphasizes the importance of maintaining historical data according to retention schedules and supporting multiple output formats including PDF, CSV, and Excel.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| General Retention Schedule (Common Items).pdf | ||
| RFP 24-00006 Amd 4.pdf | ||
| RFP 24-00006 Amd 1.pdf | ||
| WDFW ELS RFP No. 24-00006 - Sample Contract.pdf | ||
| RFP 24-00006 Amd 2.pdf | ||
| WDFW ELS RFP No. 24-00006 - Sample Contract.pdf.crdownload | CRDOWNLOAD file | |
| RFP 24-00006 ATT A - I.docx | DOCX document | |
| RFP 24-00006 Amd 3.pdf | ||
| DFW Records Retention Schedule v.1.11.pdf | ||
| WDFW ELS RFP No. 24-00006.pdf | ||
| RFP 24-00006 Amd 5.pdf | ||
| Att J - Fit Gap Analysis.xlsx | XLSX spreadsheet |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Reports Overview WDFW Reports
In accordance with analytics requirement ANA 2.5, the system shall deliver several out-of-the-box reports tailored to WDFW’s needs and industry standards.
Existing Reports: This section provides an inventory of the current reports that WDFW relies on to support daily business operations.
New Reports: This section serves as a preliminary guide for identifying the requirements for new reports.
Neither list should be considered exhaustive but rather a foundation for further discussion and the elicitation of additional reporting requirements.
Existing Reports
| Name | Search Criteria | Report Results | Primary User(s) | Purpose |
| ACH Aging and Resubmitted Report | Optional fields: |
•Location •Start Date •End Date •Account Status •Location Type •Business Type •City •Managing Location •Corporation •Dealer Rep •Output Type (defaults to PDF) •Invoice ID •Location ID •Location Name •Billing Invoice Period •Invoice Date •Amount •Return Code •Return Code Date
| •Sweep Date | •Financial Unit | This report allows Financial Unit staff to know which license dealers have had ACH rejections and when those ACH issues were resubmitted for payment. |
| Active Dealer Report | Optional fields: |
•Location •Account Status •Location Type •Business Type •City •County •Managing Location •Corporation •Dealer Rep •Output Type (defaults to PDF) •Location ID •Account Status •Location Name •Location Type •Primary Address •City •State •Zip •County •Account Rep •Phone Number •Email Address •Account Reps •Financial Unit •Customer Service Manager
| •Business Technical Unit | This report allows the user to pull a list of all active or inactive license dealer locations. | |
| Adjustments Report | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer ID •Adjustment Type •Credit/Debit •Output Type (defaults to PDF) •Dealer ID •Transaction Number (of adjustment) •Credit/Debit Type •Adjustment Type •Adjustment Amount •Adjustment Dates
| •Created By | •Financial Unit | |
| •Account Reps | This report allows the user to pull all adjustments (Debits/Credits) for all locations for a specific timeframe or for one specific location and timeframe. | |
| Cancellations Report | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer ID •Dealer Rep •Status (Dealer Cancel or State Cancel) •Output type (defaults to PDF) •Location ID •Name •Dealer Rep •Transaction Code (of cancellation, not original), •Document Number (when applicable) •Item Name •State Fee Amount •Transaction Fee Amount •Dealer Fee Amount •Cancel Date •Clerk Name (user doing the cancellation or void) •Customer Type •Type of Cancellation (state or dealer cancel) •Total Dealer State Fee •Total Dealer Transaction Fee •Dealer Fee •Number of Cancellations •Total Cancellation Amount •Total Transaction Fee Amount •Total Dealer Fee Amount •Total Cancellations •Cancellation Reason •Financial unit •Customer Service Staff
| •Account Reps | This report provides a list of all cancelled and voided license items. | |
| Cash Journal Detail Report | Required fields: |
•ACH Generation Date (must be Tuesday)
Optional fields:
•Output type (defaults to PDF) •Effective Date •Total Sales Amount •Document Number •Fund Code
| •Sales Amount | •Financial Unit | This is a mandatory financial report. |
| Cash Journal Summary Report | Required fields: |
•ACH Generation Date
Optional fields:
•Output type defaults to PDF) •ACH Generation Date •Fiscal Month •Biennium •Total Sales Amount •Major Group •Major Source •Sub Source •Description
| •Sales | Financial Unit | This is a mandatory financial report. |
| Change History Report | Required fields: |
•History Type (Dealer, Customer, or Product) •Start Date •End Date
Optional fields:
•Output type defaults to PDF) •Entity ID (database id) •Entity Name •Entity Change •Date of Change
| •Username | •Business Technical Unit | This report provides a list of all changes made in the system during a specific time period. |
| Customer Purchase History Report | Required fields: |
•WILD ID
Optional fields:
•Season •Output type (defaults to PDF) •Purchase Date •Transaction Number •Status (of transaction) •License Year •Customer Type •Location (dealer number and name) •Product Name •Document # •Status (of document) •Effective Dates •Other Information (CRC species, game species, weapon type, and hunt areas) •Customer Service Staff •Enforcement
| •Business Technical Unit | This report allows users to view all license purchases made for one or more license years. | |
| Daily Clerk Report | Required fields: |
•Dealer ID •Start Date
Optional fields:
•Clerk ID •Output type (defaults to PDF)
Note: Dealer Admins and Dealer Clerks are not required to enter Dealer ID. •Clerk Name •Product Name •Status •Discount Type •Quantity •Price •Clerk Total •License Dealer Adminstrators •License Dealer Clerks •Financial Report Users •Offices •Financial Unit
| •Dealer Reps | This report is used by license dealers to view sales executed by each authorized user associated with their dealer location. This report can be printed from the POS terminal. | |
| Dealer Holds Not Cleared Report | All fields are optional: |
•Location •Account Status •Start Date •End Date •Output Type defaults to PDF) •Account Status •Start Date •End Date •Invoice ID •Invoice Date •Billing Invoice Period •Invoice Amount •Location ID •Location Name •ACH Status •ACH Hold User •Payment Method
| •Payment Type User | •Financial Unit | This report provides a list of all dealer locations that have an ACH hold on their account. |
| Dealers with No Sales Report | All fields are optional: |
•Dealer ID •Start Date •End Date •Account Status •Dealer Rep •Output Type (defaults to PDF) •Location ID •Location Name •Last Transaction Date •Dealer Rep •Financial Unit •Dealer Reps
| •Customer Service Manager | This report provides a list of all dealer locations that haven't made a sale during a specified timeframe. | |
| Duplicates Issued Report | All fields are optional: |
•WILD ID
•Season •Sales Start Date •Sales End Date •Product Type •Product Code •Product Category •Dealer County •Output Type (defaults to PDF) •WILD ID •Customer Name •Customer Address •Dealer County •Season •Product Category •Product Code •Product Type •Survey Answer
| •Duplication Time | •Enforcement | This report enables enforcement officers to identify and review customers who have duplicated a license product. |
| Fund Distributions Report | All fields are optional: |
•Product Code •Product Name •Customer Type •Distribution Name •Fund Number •Fund Source •Amount •Season •Output type (limited to XLSX) •Product Code Number •Product •Type •Year •Date of Change •Distribution Name •Distribution of Fund Number (51 columns) •Fund Number •Distribution Amount •Name •Address •Document Number
| •Document Type | •Financial Unit | This report gives financial unit staff a comprehensive overview of how fund distributions are linked to products. |
| Fund Source Listing Report | Only 1 field: | |
| •Output type (defaults to PDF) | •Fund Name |
•Fund •Major Group •Major Source •Fund Number •Status •Created Date UTC •Last Modified Date UTC
| •Last Modified By | •Financial Unit | This report provides financial unit staff the full list of the fund sources. |
| HIP Survey Results Data (txt) | Required fields: |
•Start Date •End Date
Optional fields:
•Output type (limited to TXT) First Name •Middle Initial •Last Name •Address •City State •Zip Code •Date of Birth •Survey Date •Survey Answers
| •Email Address | •Science Division | This report is required by the U.S. Fish and Wildlife Service. |
| Inventory Order Report | All fields are optional: |
•Inventory Order Number •Output Type •Dealer Number •Business Name •Order Number •Order Date •Shipping Address •Product •Total Quantity •Fee •Total Fee
| •Inventory Range | •Warehouse | This report is used by warehouse staff to process inventory orders. |
| Licensed Dealer Rollup Report | Required fields: |
•Dealer ID •Start Date •End Date
Optional fields:
•Output Type (defaults to PDF) •Processed on Date and Time Dealer ID •Dealer Name •Dealer Address •Date Range •Quantity •Item •Season •Item Fees •Subtotal •Transaction Fees •Adjustments-State Fees •Adjustments - Transaction Fees •Total Dealer Fees •Dealers •Financial Unit •Customer Service Staff
| • Business Technical Unit | This report allows dealers to review the quantity of products sold for a specified timeframe. | |
| Multiple Licenses Issued Report | Required fields: |
•Season •Start Date •End Date
Optional Fields:
•Dealer ID •Output Type (defaults to PDF) •Start Date •End Date •Location ID •Location Name •Transaction Number •Date and Time of Sale
•WILD ID
•Customer Name •Item Name •Quantity •Season •State Fee •Transaction Fee
| •Dealer Fee | •Business Technical Unit | This report enables authorized users to determine if the system permitted a dealer or customer to violate the product configuration rules during the purchase process. |
| Puget Sound Crab Report | Required fields: |
•Season
Optional fields:
•Start Date •End Date •Report Season (Summer or Winter) •Delivery Method (email or post card), •Submission Status
•WILD ID
•Output type (limited to CSV) •Season
•WILD ID
•First Name •Middle Name •Last Name •Email Address •Mailing Address •City •State •Zip Code •Product Code •Product Name •Submission Status •Submission Date •Delivery Method •Marketing •Customer Service Staff
| •Business Technical Unit | This report generates a list of customers that have a Puget Sound crab summer or winter harvest reporting requirement and the status of their submission. | |
| Reprint Report | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer ID •Output type (defaults to PDF) •Dealer ID •Dealer Name •Transaction Number (original) •Reprinted Document Number •Item Type •Reprint Date •Reprint Reason •Clerk
| •Count | •Financial Unit | |
| •Dealer Reps | This report provides a list of items that were reprinted at a dealer location. | |
| Sales Detail Report | Required fields: |
•Start Date •End Date
Optional fields:
•Product Code •Dealer ID •Output Type (defaults to PDF) •Report Date •Sales Start Date •Sales End Date •Dealer ID •Dealer Name •Dealer Address •Item •Quantity •Item Status •Item Fee •Customer Name •Transaction Number •POS Date •Item Subtotal •Credit Item Total •Item Total •Transaction Fee Subtotal •Credited Transaction Fee •Transaction Fee •Application Fee •Subtotal •Dealer Fee Subtotal •Credit Dealer Fee •Dealer Fee •Total •Dealers •Financial Unit •Customer Service Staff
| •Business Technical Unit | This report provides a detailed accounting of all transactions. | |
| Sales Statistical Report | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer ID •Product Category •Product Type •Pricing Type •Season •Output Type (if output is not selected, the report will default to PDF) •Sales Start Date •Sales End Date •Product Code •Product Name •Status •Season •Discount Type •State Fee •Quantity •Total State Fee •Total Transaction Fee •WDFW Transaction Fee •Vendor Transaction Fee •Total Quantity •Total State Fee •Total Trans Fee •Total WDFW Fee •Total Vendor Transaction Fee •Dealer Fee •Total Dealer Fee •Financial Unit •Customer Service Manager
| •Business Technical Unit | This report provides the statistical and revenue generated from the sale of recreational licensing items. | |
| Sales Summary Report | Required fields: |
•Dealer ID •Sales Start Date •Sales End Date
Optional Fields:
•Output Type (defaults to PDF) •Sales Start Date •Sales End Date •Dealer Name •Dealer Address •Phone Number •Sales Date •State Fee •Adjustments •Transaction Fee •Dealer Fee •State Fee total •Total Adjustments •Transaction Fee Total •Total Dealer Fee Collected
| •Total Amount | •Financial Unit | |
| •Dealer Reps | This report provides a summary of sales fees collected dealers. | |
| Special Hunt - Post Draw Report | Required fields: |
•Season •Hunt Series Name
Optional fields:
•Hunt Number •Output type (defaults to PDF) •Hunt Series Name •Execution Date UTC •Hunt Selection Status •Date Status Changed •Selected Hunt Choice Number •Selected Hunt Choice Name •First Choice Hunt •Second Choice Hunt •Third Choice Hunt •Fourth Choice Hunt •Terra ID •Last Name •First Name •Middle Name •Email •Cell Phone •Home Phone •Work Phone •Address •City •Stat •Zip Code •Wildlife Program •Customer Service Staff
| •Business Technical Unit | This report provides a list of customers that withdrew (returned permit for restoration of points) from a special hunt opportunity, and those that were manually added winners for a specific hunt choice/hunt series. |
| Special Hunt Application Submissions | |
| Verification at Customer level | Required fields: |
•Start Date •End Date •Season •Only Customers with Violations?
Optional fields:
•WILD ID
•Output type (defaults to PDF) •Series Name
•WILD ID
•First Name •Last Name •Date of Birth •Email Address •Phone Number •Phone Type •Finalized Date UTC •Transaction Code •Dealer ID •Dealer Name •Has Executed Hunt Choice Max •Has Hunt Choice Duplicated Hunt •Has Skipped Hunt Choice •Has Invalid Weapon Type •Has Invalid Hun t Area •Has Both Hunt Choice and Points Saver •Business Technical Unit This report is used to ensure the system is preventing the following submittal scenarios:
•applications where the number of hunt choices is exceeded •applications with duplicate hunt choices •applications with missing/skipped hunt choices •applications with the wrong weapon or area •applications with both a hunt choice and points only option.
| Special Hunt Application Submissions | |
| Verification at Group level | Required fields: |
•Start Date •End Date •Season •Only Customers with Violations?
Optional fields:
•WILD ID
•Output type (defaults to PDF) •Hunt Series Name •Member WILD ID •Member First Name •Member Last Name •Date of Birth •Email Address •Phone Number •Phone Type •Finalized Date UTC •Transaction Code •Dealer ID •Dealer Name •Group Limit •Applicant Type •Leader First Name •Leader Last Name •Is Group Limited Exceeded
| •Is Group Has No Leader | •Business Technical Unit | This report shows all applications submitted as a group. It highlights any group that has exceeded the category limits (Hunt Series) and identifies groups without a leader. It is used by WDFW staff to used to ensure the business rules are being enforced correctly by the system during the application submission process. |
| Special Hunt Application Verification | Required fields: |
•Start Date •End Date •Seasons •Only Customers with Violations?
Optional fields:
•WILD ID
Output type (defaults to PDF) •Series Name
•WILD ID
•First Name •Last Name •Date of Birth •Age at Time of Purchase •Age at End of Purchase Season •Email Address •Phone Number •Phone Type •Finalized Date UTC •Transaction Code •Dealer ID •Has Duplicates •Has Disability Violations •Has Certificate Violations
| •Has Age Violations | •Business Technical Unit | This report is used to verify that the system enforces business rules at the time of purchase. It checks for duplicate application purchases, appropriate disability type in the customer profile, basic and master hunter certification, and age requirements for youth and those aged 65+. |
| Special Hunt Application Waiting Period | ||
| Verification Report | Required fields: |
•Start Date •End Date •Season •Only Customers with Violations?
Optional fields:
•WILD ID
•Output type (defaults to PDF) •Hunt Series Name
•WILD ID
•First Name •Last Name •Date of Birth •Email Address •Phone Number •Phone Type, •Finalized Date UTC •Transaction Code •Dealer ID •Dealer Name •Waiting Period Type
| •Last Special Hunt Submitted UTC | •Business Technical Unit | This report is used to ensure the system is appropriately restricting customers from purchasing a once-in-a-lifetime (OIL) application when they are no longer eligible. |
| Special Hunt Draw - Obtain Execution Date | Required fields: |
•Season
Optional fields:
•Hunt Series Name •Hunt Series Name •Hunt Series ID •Execution Date(s) •Wildlife Program •Customer Service Staff
| •Business Technical Unit | This report allows users who don't have access to the draw execution screens to pull the drawing dates by year for all drawings. | |
| Special Hunt Draw By Species | Required fields: |
•Season
Optional fields:
•Species Name •Output type (defaults to PDF) •Species •Permit Quota •Permits Issued •Total Applicants •Total Applications •Selected First Choice •Selected Second Choice •Selected Third Choice •Selected Fourth Choice •Not Selected •Wildlife Program •Customer Service Staff •Business Technical Unit
| •Public Records Staff | This is a static report used for the public-facing agency website. | |
| Special Hunt Draw Report by Customer | Required fields: |
•Hunt Series Name •Execution Date •Season
Optional fields:
•Hunt Number •Output type defaults to PDF) •Hunt Series Name •Hunt Selection Status •Selected Hunt Choice Number •Select Hunt Choice Name •First Choice Hunt •Second Choice Hunt •Third Choice Hunt •Fourth Choice Hunt •Points Used •Rank Number •Random Number
•WILD ID
•Last Name •First Name •Middle Name •Email •Cell Phone •Home Phone •Work Phone •Address •City •State •Zip Code •Wildlife Program •Customer Service Staff
| •Business Technical Unit | This report retrieves drawing results after they have been published. The report information has multiple uses depending on the authorized user group. The report presents the drawing outcomes for both selected and unselected applicants. The information is organized in selected rank order and unselected rank order. The report also includes customer contact information (email, phone number, address). | |
| Special Hunt Draw Report by Hunt Series | Required fields |
•Season •Hunt Series Name
Optional fields:
•Output type (defaults to PDF) •Species •Hunt Series Name •Hunt Choice Number •Hunt Choice Name •Permit Quota •Permit Issued •Total Applicants •Total Applications •Average Winner Points •Selected First Choice •Selected Second Choice •Selected Third Choice •Selected Fourth Choice •Not Selected •Wildlife Program •Customer Service Staff •Business Technical Unit
| •Public Records Staff | This is a static report used for the public-facing agency website. | |
| Special Hunt Permits - Manually Added Winners | Required fields: |
•Season
Optional fields:
•Hunt Series Name •Hunt Number •Output type (limited to PDF)
| PDF file: 8-1/2 x 11 permits for manually added winners. | •Wildlife Program | |
| •Customer Service Staff | This report produces the 8-1/2 x 11 system-generated permits for manually added special hunt winners by category and hunt choice/hunt series. | |
| Special Hunt Permits Report | Required fields: |
•Hunt Series •Season •Execution Date
Optional Fields:
| •Output Type (if output is not selected, the report will default to PDF) | PDF file: 8-1/2 x 11 permits for special hunt winners. | •Business Technical Unit | This report produces the 8-1/2 x 11 system-generated permits for special hunt winners by category and hunt choice/hunt series. |
| Special Hunt Summary Report | Required fields: |
•Hunt Series •Season •Execution Date
Optional Fields:
•Output Type defaults to PDF) •Special Hunt Category •Season •Hunt Choices 1-4 •Number of Permits Distributed •Hunt Number •Number of Permits Available •Number of Permits Distributed •Number of Permits Remaining
| •Totals | •Business Technical Unit | This report provides a summary of an executed special hunt drawing, displaying information about the permits allowed and permits distributed by hunt category. |
| Special Hunt Unselected Report | Required fields: |
•Hunt Series •Season •Execution Date
Optional Fields:
•Hunt Number •Output Type defaults to PDF) •Special Hunt Category •Rank Number •Random Assigned Number
•WILD ID
•Customer Name •Hunt Number
| •Points | •Business Technical Unit | This report provides a rank-order list of applicants that were not selected in the special hunt drawing. |
| Special Hunt Winners Report | Required fields: |
•Hunt Series •Season •Execution Date
Optional Fields:
•Hunt Number •Output Type (defaults to PDF) •Special Hunt Category •Rank Number •Random Assigned Number
•WILD ID
•Customer Name •Hunt Number
| •Points | •Business Technical Unit | This report is a condensed version of special hunt drawing data, used as a visual aid for the citizen witness process. |
| Weekly Invoice Corporate Report | Required fields: |
•Invoice ID
Optional fields:
•Output Type (defaults to PDF) •Individual corporate store roll up •Weekly sales by day
| •Grand Total (to be swept from account) | •Corporate Users | This report groups all dealer locations identified for a specific corporation into a single weekly billing invoice with a breakdown for each dealer location. This is specifically for corporate financial users. |
| Weekly Invoice Report | Required fields: |
•Invoice ID
Optional fields:
| •Output Type (defaults to PDF) | •Weekly sales by day | |
| •Total (to be swept from account) | •Dealers | This report is for non-corporate dealer locations. |
New Reports
| Name | Search Criteria | Report Results | Primary user groups | Purpose |
| ACH Hold Status | Optional fields: |
•Dealer Number •Dealer Name •ACH Status •Start Date •End Date •Output type (CSV, PDF, XLSX) •Dealer Number •Dealer Name •ACH Status •Username (last modified ACH status) •Date ACH Status Modified
| •Date ACH Status Released from Hold | •Financial Unit | This report will be used to monitor the number of dealers being placed on or removed from ACH hold status. |
| Annual Discover Pass Fulfillment Report | Required fields: |
•Start Date •End Date •Output type (CSV, PDF, XLSX) •Batch ID •Transaction Number •Document Number
•WILD ID
•Date & Time Printed •Printed by •Date Mailed
| •Mailed by | •Customer Service Staff | This report will be used to support the fulfillment of Annual Discover Passes. |
| Annual Federal Certification (DJ/PR) | ||
| 50 CFR 80 Subpart D | Required fields: |
•Fiscal Year Start Date •Fiscal Year End Date
Excel is the format (Data is currently entered directly into TRACS)
Part A includes:
A. Hunting License Holders: I certify that Washington State had Count of number of unique hunters , paid hunting license holders during the license year ending June 30, 20XXX.
B. Sport Fishing License Holders: I certify that Washington State had Count of the count of number of unique anglers (fishers) paid fishing license holders during the license year ending June 30, 20XX.
Part B includes: (supporting documentation) License Type (fishing or hunting) Residency Product Code Name of Product Product Cost (unit price) Record Count Number Revenue Generated Summary of Hunting and Sport Fishing
| •Business Technical Unit | ||
| •US Fish and Wildlife Service | This report will be used to fulfill the agency’s requirement to report the total number of unique hunters and fishers, as well as the revenue generated from the sale of licenses to these individuals, to the US Fish and Wildlife Service. The system must store the results for each year in the database according to the retention schedule. | |
| Customer Contact Lists | Required fields: |
•Season •Harvest Report Type
Optional fields:
•Start Date •End Date •Delivery Method •Submission Status
•WILD ID
•First Name •Last Name •Output type (defaults to PDF) •Season
•WILD ID
•First Name •Middle Name •Last Name •Email Address •Mailing Address •City •State •Zip Code •Product Code •Product Name •Submission Status •Submission Date •Delivery Method •Customer Service Manager •Marketing
| •Business Technical Unit | This report will be used to identify customers by harvest report type grouping for notification of outstanding reporting requirements. | |
| Customer Harvest and Checkout Survey Report | Required fields: |
•WILD ID
•Season(s)
Optional fields:
•Start Date •End Date Sales:
•WILD ID
•First Name •Middle Name •Last Name •Sales Date •Transaction Number •Product Code •Product Name •Season Checkout Survey Responses:
•WILD ID
•First Name •Middle Name •Last Name •Transaction Date •Product Code •Product Name •Survey Question •Survey Response Harvest Reports:
•WILD ID
•First Name •Middle Name •Last Name •Transaction Date •Transaction Number •Product Code •Product Name •Harvest Report Question •Harvest Report Response •Public Records Office •Dealer Reps
| •Business Technical Unit | This report will be use to respond to public records requests. It should allow the user to request results for more than one season in the same report. | |
| Discover Pass Report | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer Number •Dealer Name •Inventory Type •Printed Date •Mailed Date •Dealer Number •Dealer Name •Date Ordered •Code •Transaction Number •Document Number •Inventory Type •Status •Quantity •State Fee •Transaction Fee •Dealer Fee
| •Total | •Customer Service Staff | This report will be used to manage and document the fulfillment of Annual Discover Passes. |
| Discover Pass Mailing Label Report | Required fields: |
•Batch ID •Output type (CSV, PDF, XLSX) •First Name •Last Name •Mailing Address •City •State
| •Zip | •Customer Service Staff | This report will be used to print mailing labels for Annual Discover Pass fulfillment. |
| Discover Pass Orders Report | Required fields: |
•Batch ID •Output type (CSV, PDF, XLSX) •WILD ID •First Name •Last Name •Mailing Address •City •State •Zip Code •Transaction Number •Document Number •Date & Time Printed •Printed by
| •Batch ID | •Customer Service Staff | This report will be used for verification purposes, as well as employee accountability and workload tracking. | |||
| Federal Duck Stamp Fulfillment Report | TBD | TBD | TBD | Enrollment in the E-Stamp Program is currently suspended; however, WDFW intends to enroll in the program when it becomes available. |
https://www.fws.gov/service/apply-join-e-stamp-program-state-wildlife-agencies-only Inventory Detail Report Optional fields:
•Dealer Number •Dealer Name •Status •Inventory Type •Date Range •Tracking Number •Dealer Number •Dealer Name •Shipping Address •Ordered Date •Order Number •Inventory Type •Quantity •Amount •Serial Numbers Issued •Shipped Date •Approved by •Status
| •Tracking Number | •Financial Unit | This report will be used to identify serial numbered inventory issued to limited dealers. |
| Inventory Order Summary report | Optional fields: |
•Inventory Type •Dealer Number •Dealer Name •Shipped Date •Ordered Date •Shipped Date •Dealer Number •Dealer Name •Inventory Type •Quantity per Box •Quantity Ordered •Shipping Address
| •Tracking Number | *Dealer Account Reps | This report will be used as the initial shipping manifest for hunting and fishing regulations book shipments. |
| Next Invoice Date | Optional fields: |
•Dealer Number •Dealer Name •Corporation •Dealer Status •Invoice Date Range Start Date •Invoice Date Range End Date •Output type (CSV, PDF, XLSX) •Next Invoice Date •Dealer Number •Dealer Name •Corporation •Dealer Status •Payment Method
| •Bank Name | •Financial Unit | This report will be used to verify all active dealers have the appropriate next invoice date in their dealer profile. |
| Sales Statistical Report - Detail | Required fields: |
•Start Date •End Date
Optional fields:
•Dealer Number •Dealer Name •Product Category •Inventory Type •Discount Type •Season •Output type (CSV, PDF, XLSX) •Product Code •Product Name •Status •Season •Discount Type •State Fee •Quantity •Total State Fee •Total Transaction Fee •WDFW Transaction Fee •Vendor Transaction Fee
| •Sales Date | •Licensing Economic Analyst | |
| •Licensing Division Manager | This report will be used to provide a daily sales summary for the Licensing Division Manager | |
| Special Use Permits | Optional fields: |
•Start Date •End Dates
•WILD ID
•Disability/Special Use Permit (SUP) Type •Output Type (PDF, CSV, XLSX) •Disability Type •SUP Type •Effective Date •Expiration Date
•WILD ID
•First Name •Last Name •Email Address •Mailing Address •City •State
| •Zip Code | •Licensing | This report will be used to track and manage the issuance of special use permits (SUP). |
| Veteran Donation Credits and Debits | Required fields: |
•Start Date •End Date •Date •First Name •Last Name •Mailing Address •Transaction •Season •Financial Unit This report will be used to manage the veteran donation fund program.
https://www.ecfr.gov/current/title-50/chapter-I/subchapter-F/part-80/subpart-Dhttps://www.fws.gov/service/apply-join-e-stamp-program-state-wildlife-agencies-only
File details come from the government source that posted it. Updated .