Frequently Asked Questions
Frequently Asked Questions
This page contains commonly received questions about data reporting, timing and transitioning to CCRS. Please see some of the most commonly asked questions below.
Quick Links:
- Data Elements
- Data Quality
- Data Reporting
- General
- Integrators
- Manifests
- Medical Products and Sales
- Public Records
- Rules
- Sales
- Tax
- Technical Details
Data Elements
-
Q: Will price data be included for wholesale and retail sales activity?
A: Sales data will be collected. Details can be found in the user guide on what content is required to be reported in the sales report fields. Please see the user guide located on the CCRS Resources page.
-
Q: Will there be a fixed list of inventory types? Or just broad 'equivalence' categories (eg, Clone/Seed, Plant, Bulk Material, Product)?
A: This information can be found in resources provided on reporting submittals and data field detail on the CCRS Resources page.
-
Q: What date should be entered for Harvest Date if the harvest date is not yet known?
A: If the harvest date is not yet known, leave a NULL or a blank entry in the Harvest Date. This is not a required field for data submission.
-
Q: How are infused Pre-Rolls categorized in CCRS?
A: Infused pre-rolls are to be categorized as Concentrates in CCRS and thus are subject to the serving/transaction limits of concentrates.
Data Quality
-
Q: How will an integrator access CCRS to send or review data?
A: Please refer to the Third Party Integrators section of the CCRS website.
-
Q: Is there a file size limit?
A: Files over 2GB will not be accepted by the system. If a file is too large, the system will generate an error message to the submitter.
-
Q: How do I fix the errors that I receive back from CCRS after submitting a .CSV file to report new or updated data, such as claiming new inventory, updating a plant tag, or noting a new sale?
A: Please review the Upload User Guide on the CCRS Resources page to learn more about how to make adjustments to the original file, based on the specific type of error received. If you are unable to resolve the errors, please email the LCB Examiners at examiner@lcb.wa.gov, and please email a copy of the .CSV file that was sent to CCRS, as well as forward the error email (along with any attachments) that was returned. The Examiners need to see both the file that was sent and what sort of errors were returned to the licensee in order to troubleshoot the situation.
Data Reporting
-
Q: What is the definition of "weekly reporting"?
A: Week is defined as Sunday - Saturday. After the transition period, all licensee weekly reporting will be expected by no later than Sunday for the previous week. Reporting more frequently than weekly is allowed.
-
Q: Are licensees expected to have data in CCRS from the start of Dec. 2021 when the system was launched?
A: Yes, if the license was active during that time then the data needs to be uploaded and reflected in CCRS.
-
Q: Are CBD materials are required to be entered into the system?
A: Yes. Imported CBD is required to have the necessary tests to allow it to be added to cannabis and the records and reporting requirements continue.
-
Q: Will the laboratory need to provide COA documents to the LCB?
A: Labs are required to provide the test results to LCB via the reports established for that purpose. Record maintenance and access remain the same for both the labs and licensees. No changes have been made on the requirement to produce the records if requested by LCB.
-
Q: For those that only grow during the summer, will they need to submit a .CSV file weekly during the winter months when there are no changes?
A: The Upload User Guide on the CCRS Resources page provides more detail on the required frequency of reporting. For seasonal growers, it is expected that reports are submitted when there are actions, updates and changes weekly (if those activities have occurred). It is not the expectation that reporting be submitted when there is no activity to report. A reminder that LCB will be monitoring reporting activity. If information does not support weekly report submissions, the LCB will also be reaching out to confirm the reason for lack of reporting, however keep in mind that there is no reporting required if there are no new data to provide (no updates to existing records, no new inventory lots, no changes to plant tags, no unreported sales, no outgoing manifests, etc. Simply put, if there is nothing new to report, there is no report to submit and no expectation to provide some form of “no change” report, which does not exist.
-
Q: Why does the Area specification mention that IsQuarantine is only for imported CBD? How is that related to Area data?
A: There are no quarantine requirements for cannabis products. You will have an entry as FALSE. For imported CBD: quarantine rules are required until passing tests results as outlined in WAC 314-55-109 are on hand. Imported CBD must be put into its own room/area and marked TRUE until passing results are received. This information is available in the Upload User Guide on the CCRS Resources page. Please be sure that Area is NOT set by default to “TRUE” for the answer to “IsQuarantine”, as this is typically not the case and would only apply in very select situations (such as when CBD has been received from a non I-502, such as from outside the state of Washington, and is awaiting testing results). All other cannabis products should NOT be listed as “IsQuarantine” by default, which will happen if the status for Area is set to TRUE (the system will treat inventory and products contained in that area as being in quarantine).
-
Q: What happens if an Update operation is performed prior to an Insert operation, will it default to inserting that case? If so, can we just always specify the operation to be Update even if it is an Insert?
A: The record doesn't exist, so an error message would be received.
-
Q: Can a Lab sub-contract out their testing? If they do, who is responsible for reporting the test result?
A: Labs may subcontract samples for a limited suite of tests and circumstances. The primary lab is responsible for reporting the test results directly to CCRS for the applicable product tested. WAC 314-55-102 (5) and WAC 314-55-102 (5) address referencing and subcontracting.
-
Q: For the inventory sheet, is ‘total cost’ the individual unit cost * quantity in stock, or the unit cost for each item in stock?
A: The Upload User Guide on the CCRS Resources page explains the following: TotalCost is the total cost associated with a licensee's inventory and stock.
-
Q: If a retailer incorrectly enters the ‘FromInventoryExternalIdentifier’ when they are receiving new products, how will they correct this?
A: They would perform an "Update" operation. That would update the record and correct the error. The receiving license should only be providing the new (if any) “ToInventoryExternalIdentifier”, as the “From” ID is assigned as the original ID by the producer or processor. If the license is going to use a new ID, it is important they submit an Inventory Transfer file, to provide both the old and new IDs for inventory items.
-
Q: What is the correct way to enter a product's weight in .CSV submissions?
A: UnitWeightGrams is the weight of the sellable product unit (not including packaging). Any one sellable product may never exceed the individual carry limit allowed for a consumer.
Unit Examples:
Sellable product = 2 grams of flower - UnitWeightGrams = 2 grams
Sellable product = 1 pre roll - UnitWeightGrams = 1 gram
Sellable product = 1 package of edibles - UnitWeightGrams = 10 grams
Sellable product = 1 concentrate for inhalation cartridge - UnitWeightGrams = 2 grams
General
-
Q: What is the expectation of licensees using CCRS?
A: Please see the Upload User Guide located on the CCRS Resources page.
-
Q: Does CCRS apply to all licensees, including retailers?
A: Yes. This applies to all cannabis license types and to certified labs.
-
Q: How do we do a plant ID in CCRS?
A: The plant ID will not be generated by the state software system. Licensees will need to establish/choose an inventory numbering system and then assign ID's to plants. A reminder that requirements to tag plants has not changed; plants must still be tagged. The plant tag will now be the ID a licensee assigns to that plant and has recorded in the appropriate .CSV file.
-
Q: What time zone should dates/times be documented in?
A: For reporting purposes, the file name should be referenced in PST.
-
Q: How should a licensee create a Sample to send to the Labs?
A: The sample sent to the lab should be the same external identifier for the lot that was created original. This way the Lab results are attached to the larger batch. Keep IDs from original external ID, do not break them out as this will cause issues with required testing of all your products.
-
Q: If a license changes physical locations, do they keep the same original six-digit license number?
A: No, the six-digit license number is associated with a physical address, so the license holder will receive a new six-digit license number.
-
Q: Can any approved user associated with the license make changes to who the integrator is? For example, an entity that has permissions to upload data to CCRS on behalf of the licensee?
A: No, only the active administrator of the license can assign or remove an integrator.
-
Q: I would like to change the email account currently associated with my license as the active administrator, how do I do that?
A: You must request a change to your license information by emailing licensingchanges@lcb.wa.gov from the current administrator email account of the license requesting a change of email address for your license.
-
Q: I am a licensee and my integrator has not been reporting my data to CCRS. Who is held responsible for making sure my data is reported?
A: The licensee is ultimately responsible to meet data reporting obligations, and may need to make a business decision with regard to which integrator they use if their data is not being reported.
Integrators
-
Q: Does CCRS provide an integration sandbox for integrators to develop against?
A: The LCB provides all cannabis licensees, labs and integrators access to the PREproduction CCRS environment for training and testing.
-
Q: How will an integrator gain access to CCRS to report on behalf of licensees?
A: Once an integrator is approved through the Cannabis Examiners Unit, licensees will have the option to assign themselves that integrator through CCRS. Integrators do not have the ability to adjust licensee assignment. It is critically important that licensees who opt to use an integrator go into CCRS and assign that integrator to their license, otherwise the integrator cannot upload any data on behalf of that licensee. Licensees must “unlock the door” to allow an integrator access to CCRS, and if a licensee holds multiple licenses, they must assign the integrator to every license they hold individually. Assigning an integrator to one licensee will not automatically provide access to CCRS for any other licenses they own.
-
Q: How will licensee software vendors authenticate on behalf of licensees?
A: Integrators will be assigned a specific ID and will need to use the SecureAccess Washington (SAW) to authenticate and report on behalf of a licensee.
-
Q: Does the integrator need to be preliminarily approved or validated by LCB before it is added to the system by the licensee to enable the integrator to upload reports on the licensee’s behalf?
A: Yes. Integrators providing reporting services for licensees will need to be added to the approved integrator list in order for licensees to assign them reporting permissions. The steps for approval are listed on the CCRS Third Party Integrator Approval Process page.
-
Q: If any licensees were to add an integrator within the PREproduction environment, do they need to do so again on the live site?
A: Yes. These environments are autonomous and do not share administration or reporting data.
-
Q: Can only one user be associated with our CCRS integrator account?
A: Two users can be associated with your integrator account, meaning the integrator can have up to two emails associated with the license and thus with access to submit data to CCRS on behalf of the licensee (their client).
-
Q: What filename format does an integrator use when uploading on behalf of a lab?
A: Integrators uploading files on a Lab's behalf would use the same Lab .CSV file that the labs would use. The CCRS specification file has the naming conventions.
-
Q: If an integrator is submitting .CSV reports on behalf of a licensee, should we expect that only the integrator will be notified of errors via email, or does the licensee receive an email notification as well?
A: Yes, the individual (integrator) uploading the .CSV file would be notified of any errors, but the licensee will not receive an email. However, many integrators have set up a method to automatically send a copy of any errors to the licensee. Please ask your integrator to confirm if they will automatically be sending you the licensee a copy of any errors generated when data is submitted to CCRS. If so, please be sure to check any spam filters that might initially block these error emails or look in junk folder to see if the error emails were sent there.
Medical Products and Sales
-
Q: As a cannabis producer/processor licensee, how do I comply with medically compliant product requirements?
A: To start, we recommend reviewing the information on Department of Health (DOH) Cannabis Program page. When reporting Medically Compliant products in CCRS, on the Inventory.csv, the Inventory External Identifier category must be marked as “Medically Compliant.”
-
Q: As a cannabis retail licensee, I want to register patients with a Cannabis Medical Card in the Medical Cannabis Authorization Database. What are the requirements?
A: The DOH website provides these requirements.
-
Q: As a cannabis retail licensee, how do I give Cannabis Medical Card holders the new excise tax exemption?
A: For a retailer to give the excise tax (begins June 6, 2024) exemption to qualified medical patients, all of these requirements must be met:- The retail store has a Medical Endorsement from DOH.
- The Medical Card holder is registered in the Medical Cannabis Authorization Database.
-
The product(s) are Medically Compliant products.
-
Q: What does the cannabis retail licensee need to report in CCRS for sales that meet these conditions?
A: All of the conditions below must be met:- The retail licensee must have a medical endorsement.
- The product must be marked in the retailer’s inventory upload to CCRS as “Medically Compliant.”
- The sale must be RecreationalMedical when reporting to CCRS.
If all these conditions are met, the two tax columns can be reported as $0.00 to show the tax exemption. All sales that do not meet these conditions must have taxes reported following current reporting requirements.
For information on tax reporting requirements related to the exemption, please visit the Cannabis Taxes and Fees resource page.
Manifests
-
Q: Can licensees use Manifests generated by their integrator or Point of Sale (POS) systems?
A: No, the only accepted Manifests are the PDF generated by submitting the CCRS Manifest.CSV or the Contingency Manifest per WAC 314-55-085. Please note that any use of a Contingency Manifest requires that a standard manifest still be submitted ASAP, as the use of a Contingency Manifest only meets one of two applicable WACs. A contingency manifest is to only be used if there is an issue with CCRS producing the manifest, such as not providing an email reply with attachment after waiting for one hour, and not just for when errors are received back by the creator of the standard manifest when attempting to upload.
Public Records
-
Q: Will licensees be able to access analytics from CCRS?
A: A license can request their data from the examiner unit for CCRS. An Integrator can request a copy of the licensee they are working with data (license must be included on the request). For all other requests, please contact Public Records.
-
Q: Can the LCB make a copy of the entire Leaf database available once it is turned off, similar to FOIA public records requests, but with full export?
A: Information on public records requests are available here. Full publishing of the entire backup is not available.
-
Q: Can we get access to all the CCRS data including products sold (in order to assess trends)? Or will the data at least be public for sales figures by license, similar to what we can access currently?
A: This information is not available on our public website, but information on public records requests are available here.
-
Q: What is the process for seeing what has previously been reported to CCRS for this given license so that we can align our future .csv imports to use the same external identifiers?
A: Licensees would request CCRS records through a Public Records request if seeking licensee specific information. There is no direct access to the data that has already been reported. The original licensee records still fall under the archive requirements found in WAC 314-55.
Rules
-
Q: Will there be explicit rules on what can be transported between licensees?
A: There are no changes to licensee permissions by licensee type and no changes in the types of products that can be transported between licensees.
-
Q: Will there be explicit rules on 'conversions' from one type to another? How will these be enforced? Leaf allowed anything to be ‘re-typed’ into anything.
A: Rules on valid conversions have not changed per RCW or WAC. CCRS will not “enforce” conversions by the system architecture. The enforcement of conversions will be based on the detail reported to WSLCB and follow up conversations between licensees and their Enforcement Officer/Compliance Consultant.
-
Q: WAC 314-55-083H still makes reference to "unique identifier generated by the traceability system." Will we be returning to that requirement?
A: The CCRS reports and the LCB will not be generating the IDs. Licensees will need to use reliable inventory tracking methodologies to assign IDs to their inventory and provide the ID (called external identifiers) when reporting via the CCRS reports. It is recommended that where possible to continue to use the existing ID structures. The WAC requirement going forward will be for IDs, not for IDs generated by the State.
-
Q: Will there be a redefinition of the concept of “failure to maintain traceability” or what it means to maintain compliance given the significant change?
A: No. The change in systems for reporting does not change the underlying concept that reporting is required and that accurate reporting and records maintenance is expected.
Sales
-
Q: When entering the discount and tax information in the Sales.CSV does the detail apply to the individual unit or the whole transaction?
A: For the Sale.CSV in a row entry in which QTY is more than 1, the discount and taxes are reflective of the entire transaction. Unit Price is the price of one unit before discount or taxes. A reminder that other tax is Excise tax and is required for retail sales.
Example:
QTY = 3
Unit Price = $5.00
Discount = $3.00
Sales Tax (10%) = $1.20
Other Tax (37%) = $4.44
-
Q: How are Medical Tax Exemptions applied?
A: The Sale.CSV will record the transaction as a RecreationalMedical sale. The tax for which the qualifying individual is exempt will not be charged and not collected from the individual and is therefore $0.00. A reminder that a tax exemption is not a "discount." The exemption for a valid medical sale applies to both sales and excise taxes, and is not optional. A patient should not pay either sales or excise tax. For more information on this topic, please visit the Washington State Department of Health's website and FAQ page.
-
Q: How do I report Waste in CCRS?
A: Producers can report the sales of designated waste in the following manner:
Sale: 3606641600
Sale Type: Wholesale
Product Category: Harvest Material
Product Type: Waste
The External Identifier must already exist in CCRS. For more information on what waste qualifies to be sold, please see the Cannabis Licensee Education page.
Tax
-
Q: How do I pay my cannabis excise tax in CCRS?
A: See the Cannabis Tax Reporting Guide for instructions on paying cannabis excise tax via CCRS.
-
Q: In the WAC (314-55-089) it states “the act of keeping data completely up-to-date in the state traceability system fulfills the monthly reporting requirement” - regarding taxes - will that still be the case or will there be a new process?
A: Cannabis retailers are still required to send monthly reports. Reporting requirements have not changed. The statements below are specific to producer/processors (reference 314-55-089(2) and 314-55-089(3).- Cannabis producer/processors do not have a tax obligation to the WSLCB and the Finance Tax and Fee group is not collecting reports from this group of licensees.
-
Producers and Processors should contact their Enforcement and Education Officer if they have questions regarding how to report their information. To be fully compliant with the LCB, licensed cannabis retailers (reference 314-55-089(4) are required to report using LCB form LIQ1295 (Retailers Sales and Excise Tax) and pay their monthly sales/tax information by the tax due date. Retail licensees are required to submit a report to the LCB each month even if they did not have sales completed. Per WAC 314-55-092(2) failure to report and/or pay will be sufficient grounds for the LCB to suspend or revoke a license.
Technical Details
-
Q: Does CCRS allow integrators to use an API?
A: No. There is no Application Programming Interface (API) for CCRS.
-
Q: Does the LCB provide any ‘cloud storage’ to facilitate digital transfer of data between licensees (such as manifests and lab results data)?
A: No, this is not a service available.
-
Q: How are lab results be tracked for retail products?
A: Records requirements have not changed. Licensees must continue to provide the supporting documentation for all products sold at retail. Reports are being built against the CCRS data submitted for LCB’s use in reviewing test results.