Sql quires and pulling data
- or -
Post a project like this$$
- Posted:
- Proposals: 6
- Remote
- #1525073
- Expired
⭐ ⭐ ⭐ ⭐ ⭐ Top Rated in Plymouth UK, 17+ Years Professional Experience, A+ Communications
Metuchen
Web asp..net, php, JavaScript,c#, sql server and Mobile development Android,IOS
Bangalore
27426314631511501577153257216056351626906
Description
Experience Level: Intermediate
The logic for the No Contact Report is as follows:
Filter by Status 2-Active Offenders
From the Active Status “2” Pull their APSLevel (Both of which are in the APSFACC table). Program the required number of contact based on the APSLevel. (i.e. if the offender is level 3 then there should be 3 contacts per month)
Pull the number of contacts made per month from the supervision table labeled dbo.BULK_PSPV. For each SQ3_DATE_CCYYMM (month) there are 24 possible contacts labeled as SQ3_TYPE, SQ3_LITR and SQ3_DATE. As I mentioned yesterday, I am not interested in knowing what type of contact was missed, only that if they did not have the required number of contacts for that SQ3_DATE_CCYYMM month, then they should show up on our list. The ultimate goal is to be able to see a list of all active offenders, within a specified date range (in months) that did not meet the minimum required number of contacts. We should first develop this to pull for the entire state
Filter by Status 2-Active Offenders
From the Active Status “2” Pull their APSLevel (Both of which are in the APSFACC table). Program the required number of contact based on the APSLevel. (i.e. if the offender is level 3 then there should be 3 contacts per month)
Pull the number of contacts made per month from the supervision table labeled dbo.BULK_PSPV. For each SQ3_DATE_CCYYMM (month) there are 24 possible contacts labeled as SQ3_TYPE, SQ3_LITR and SQ3_DATE. As I mentioned yesterday, I am not interested in knowing what type of contact was missed, only that if they did not have the required number of contacts for that SQ3_DATE_CCYYMM month, then they should show up on our list. The ultimate goal is to be able to see a list of all active offenders, within a specified date range (in months) that did not meet the minimum required number of contacts. We should first develop this to pull for the entire state
Anand D.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
14 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
This is just one SQL query/procedure to be written?
382016
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies