There is increasing interest in wastewater-based epidemiology (WBE) of SARS-CoV-2 RNA to serve as an early warning system for a community. Despite successful detection of SARS-CoV-2 RNA in wastewaters sampled from multiple locations, there is still no clear idea on the minimal number of cases in a community that are associated with a positive detection of the virus in wastewater. To address this knowledge gap, we sampled wastewaters from a septic tank (n = 57) and biological activated sludge tank (n = 52) located on-site of a hospital. The hospital is providing treatment for SARS-CoV-2 infected patients, with the number of hospitalized patients per day known. It was observed that depending on which nucleocapsid gene is targeted by means of RT-qPCR, a range of 253-409 positive cases out of 10,000 persons are required prior to detecting RNA SARS-CoV-2 in wastewater. There was a weak correlation between N1 and N2 gene abundances in wastewater with the number of hospitalized cases. This correlation was however not observed for N3 gene. The frequency of detecting N1 and N2 gene in wastewater was also higher than that for N3 gene. Furthermore, nucleocapsid genes of SARS-CoV-2 were detected at lower frequency in the partially treated wastewater than in the septic tank. In particular, N1 gene abundance was associated with water quality parameters such as total organic carbon and pH. In instances of positive detection, the average abundance of N1 and N3 genes in the activated sludge tank were reduced by 50 and 70% of the levels detected in septic tank, suggesting degradation of the SARS-CoV-2 gene fragments already occurring in the early stages of the wastewater treatment process.