In-line SQL Conversion

Changes made to convert in-line SQL to stored procedures, and the areas of the SPIRIT application impacted, are documented in the table below.

File

In-line SQL Method Converted to Stored Procedure

Main Functional Area(s) Impacted

Specific Screen(s) Impacted

ParticipantManager.vb

DeleteIncompleteCert

Certification Guided Script

Called when the Remove Incomplete Certification menu option is selected on the Certification menu within the Participant Folder in the Clinic application module.

ParticipantManager.vb

GetHighRiskParticipants

Generate Reports

Called when generating the following system outputs on the following screens:

  • Participant High Risk Report CLN030 (Output) / Generate Participant High Risk Report screen (Clinic)

  • Participant High Risk Report CLN030 (Output) on the Generate Participant High Risk Report screen (State Office)

ParticipantManager.vb

SaveIncomeContact

Participant Folder

Certification Guided Script

Called when saving income data on the Income Calculator screen in the Clinic application module.

ParticipantManager.vb

CreateChildOrWoman

Certification Guided Script

Called when saving woman or child data during the certification process on the following screens from within the Certification Guided Script:

  • Demographic Information

  • Demographics

  • AdditionalInfo1

  • AdditionalInfo2

  • Initial Contact

  • Race/Ethnicity

  • Income Calculator

  • Income Line Item

  • Health Information

  • Child Health Information

  • Pregnancy Information

  • Postpartum Information

  • Linked Participant

  • Infants Born from This Pregnancy

  • Height/Weight and Blood Work Information

  • Height/Weight

  • Height/Weight Measurement

  • Blood

  • Blood Measurement

  • Immunizations

  • Select Appointment to Schedule

  • Add Immunization(s)

  • Edit Immunization

  • Nutrition Assessment

  • Nutrition Assessment Contact

  • Assign Certification Risk Factors

  • Referrals and Other Programs

  • Referral Contact Information

  • Nutrition Education Contact

  • Individual Material Contact

  • Individual Nutrition Education Contact

  • Goal Setting Contact

  • Group Education Contact

  • Breastfeeding Peer Counselor Referral

  • Food Prescriptions

  • Select Formula

  • Food Prescription

  • Add Food Item

  • Edit Food Item

  • Add General Note

  • Add SOAP Note

  • CPA-determined Follow-up

ParticipantManager.vb

GetCertEffectiveDateForPsuedoCert

Participant List

Called when a pseudo certification exists, the value of the CERTDATEINLIST business rule equals "START", and the Show Details button is clicked on the following screens:

  • Participant List (Central Administrative Site)

  • Participant List (Clinic)

  • Participant List (State Office)

ParticipantManager.vb

GetOriginalScreenDate

Income Calculator

Called when the Copy Items to Current Income button is clicked on the Income Calculator screen in the Clinic application module.

ParticipantManager.vb

SaveIncomeContactForMember

The functional area associated with this in-line SQL method is currently ambiguous.

This method was converted to a stored procedure; however, since the functional areas associated with this in-line SQL method are not easily identifiable within SPIRIT, the references to this stored procedure were flagged within the code as an XML "TODO:", stating that further research is required (which is outside of scope for this release). The code surrounding the functional areas associated with this method will be researched further during the Research PAQ to identify how and where the stored procedure is referenced.

Therefore, nothing should be tested at this time.

ParticipantManager.vb

UpdateApplicant

Applicant Prescreening

Called when updating applicant data on the Applicant Prescreening screen in the Clinic application module.

ParticipantManager.vb

DoesPregnantOrInfantHasMedicaid

Certification menu

Called when the Remove Incomplete Certification menu option is selected on the Certification menu within the Participant Folder in the Clinic application module.

ParticipantManager.vb

GetFoodInstrumentItemDetails

Food Prescriptions

Called whenever food prescriptions are accessed on the following screens:

  • Food Prescriptions (Central Administrative Site)

  • Food Prescriptions (Clinic)

  • Food Prescriptions (State Office)

  • Food Prescription (Issue Benefits) (Clinic)

ParticipantManager.vb

GetIneligibleMembers

Generate Reports

Called when generating the following system outputs on the following screens:

  • Ineligibility Summary Report CAS005/OPR024 (Output) on the Generate Ineligibility Summary Report screen (Central Administrative Site)

  • Ineligibility Summary Report CAS005/OPR024 (Output) on the Generate Ineligibility Summary Report screen (State Office)

ParticipantManager.vb

GetMaximumPriorityCode

Manage Waiting List

Called when populating the Manage Waiting List screen and when performing a VOC Certification in the Clinic application module.

ParticipantManager.vb

GetMotherOfChild

Risk Factors

Called when assigning new risk factors on the Assign Certification Risk Factors screen and when performing a check for low birth weight on the Child Health Information screen in the Clinic application module.

ParticipantManager.vb

GetPostpartum

Woman Health Information

Called when updating a postpartum woman's health information on the following screens in the Clinic application module:

  • Postpartum Information

  • Linked Participant

ParticipantManager.vb

GetPostpartumId

The functional area associated with this in-line SQL method is currently ambiguous.

This method was converted to a stored procedure; however, since the functional areas associated with this in-line SQL method are not easily identifiable within SPIRIT, the references to this stored procedure were flagged within the code as an XML "TODO:", stating that further research is required (which is outside of scope for this release). The code surrounding the functional areas associated with this method will be researched further during the Research PAQ to identify how and where the stored procedure is referenced.

Therefore, nothing should be tested at this time.

ParticipantManager.vb

SaveParticipant

Applicant Prescreening

Participant Folder

Certification Guided Script

Called when saving participant data from any of the following screens:

  • Applicant Prescreening

  • Demographic Information

  • Demographics

  • AdditionalInfo1

  • AdditionalInfo2

  • Initial Contact

  • Race/Ethnicity

  • Income Calculator

  • Income Line Item

  • Health Information

  • Child Health Information

  • Pregnancy Information

  • Postpartum Information

  • Linked Participant

  • Infants Born from This Pregnancy

  • Height/Weight and Blood Work Information

  • Height/Weight

  • Height/Weight Measurement

  • Blood

  • Blood Measurement

  • Immunizations

  • Select Appointment to Schedule

  • Add Immunization(s)

  • Edit Immunization

  • Nutrition Assessment

  • Nutrition Assessment Contact

  • Assign Certification Risk Factors

  • Referrals and Other Programs

  • Referral Contact Information

  • Nutrition Education Contact

  • Individual Material Contact

  • Individual Nutrition Education Contact

  • Goal Setting Contact

  • Group Education Contact

  • Breastfeeding Peer Counselor Referral

  • Food Prescriptions

  • Select Formula

  • Food Prescription

  • Add Food Item

  • Edit Food Item

  • Add General Note

  • Add SOAP Note

  • CPA-determined Follow-up

ParticipantManager.vb

IsMotherOfInfantReceiving

MoreThanMaximumAmountOfFormula

Issue Benefits

Called when an infant is being issued more than the maximum allowable amount of formula on the Benefits (Issue Benefits) screen in the Clinic application module.

ParticipantManager.vb

AssignRiskFactors

Risk Factors

Called when assigning new risk factors on the Assign Certification Risk Factors screen from within the Participant Folder in the Clinic application module.

ParticipantManager.vb

GetBloodWorkListItems

Produce Participant Summary

Called when generating the following system outputs on the following screens:

  • Participant Summary (Output) / Produce Participant Summary screen (Central Administrative Site)

  • Participant Summary (Output) / Produce Participant Summary screen (Clinic)

  • Participant Summary (Output) / Produce Participant Summary screen (State Office)

ParticipantManager.vb

GetHeightWeightListItems

Produce Participant Summary

Called when generating the following system outputs on the following screens:

  • Participant Summary (Output) / Produce Participant Summary screen (Central Administrative Site)

  • Participant Summary (Output) / Produce Participant Summary screen (Clinic)

  • Participant Summary (Output) / Produce Participant Summary screen (State Office)

ParticipantManager.vb

GetLowestUnservedPriority

Manage Waiting List

Called when populating the Manage Waiting List screen in the Clinic application module.

ParticipantManager.vb

GetMoreParticipantInfo

Clinic Participant List

Called when the External Data radio button is selected in the Where to Search radio button group and the Search button is clicked on the Participant List screen in the Clinic application module.

ParticipantManager.vb

SaveMembers

Participant Folder

Certification Guided Script

Called when updating participant data from any of the following screens:

  • Demographic Information

  • Demographics

  • AdditionalInfo1

  • AdditionalInfo2

  • Initial Contact

  • Race/Ethnicity

  • Income Calculator

  • Income Line Item

  • Health Information

  • Child Health Information

  • Pregnancy Information

  • Postpartum Information

  • Linked Participant

  • Infants Born from This Pregnancy

  • Height/Weight and Blood Work Information

  • Height/Weight

  • Height/Weight Measurement

  • Blood

  • Blood Measurement

  • Immunizations

  • Select Appointment to Schedule

  • Add Immunization(s)

  • Edit Immunization

  • Nutrition Assessment

  • Nutrition Assessment Contact

  • Assign Certification Risk Factors

  • Referrals and Other Programs

  • Referral Contact Information

  • Nutrition Education Contact

  • Individual Material Contact

  • Individual Nutrition Education Contact

  • Goal Setting Contact

  • Group Education Contact

  • Breastfeeding Peer Counselor Referral

  • Food Prescriptions

  • Select Formula

  • Food Prescription

  • Add Food Item

  • Edit Food Item

  • Add General Note

  • Add SOAP Note

  • CPA-determined Follow-up

ParticipantManager.vb

SavePostPartumInfant

Child Health Information

Called when saving postpartum infant data on the Child Health Information screen in the Clinic application module.

ParticipantManager.vb

SaveRiskFactorThreshold

Risk Factors

Called when updating the threshold value for a risk factor on the Edit Threshold Field Value screen in the Reference Utility application module.

ParticipantManager.vb

XferParticipant

Change Clinic of Operation

Called when a participant is transferred to a new clinic on the following screens:

  • Change Clinic of Operation (Clinic)

  • Change Clinic of Operation (WIC Outreach Loaner Program)

ParticipantManager.vb

GetPrtFoodPackageListItems

Produce Participant Summary

Called when generating the following system outputs on the following screens:

  • Participant Summary (Output) / Produce Participant Summary screen (Central Administrative Site)

  • Participant Summary (Output) / Produce Participant Summary screen (Clinic)

  • Participant Summary (Output) / Produce Participant Summary screen (State Office)

ParticipantManager.vb

HouseholdHasAnActiveCertification

The functional area associated with this in-line SQL method is currently ambiguous.

This method was converted to a stored procedure; however, since the functional areas associated with this in-line SQL method are not easily identifiable within SPIRIT, the references to this stored procedure were flagged within the code as an XML "TODO:", stating that further research is required (which is outside of scope for this release). The code surrounding the functional areas associated with this method will be researched further during the Research PAQ to identify how and where the stored procedure is referenced.

Therefore, nothing should be tested at this time.

ParticipantManager.vb

SaveResidencyProofforHousehold

Demographics

Called when saving Residency Proof data on the Demographics sub-tab on the Demographic Information screen in the Clinic application module.

ParticipantManager.vb

EditProgram

Participant Folder

Certification Guided Script

Called when updating referral contact data on the Referral Contact Information screen in the Clinic application module.

Household.vb

Insert

Applicant Prescreening

Called when creating a new household using the Applicant Prescreening screen in the Clinic application module.

Household.vb

Update

The functional area associated with this in-line SQL method is currently ambiguous.

This method was converted to a stored procedure; however, since the functional areas associated with this in-line SQL method are not easily identifiable within SPIRIT, the references to this stored procedure were flagged within the code as an XML "TODO:", stating that further research is required (which is outside of scope for this release). The code surrounding the functional areas associated with this method will be researched further during the Research PAQ to identify how and where the stored procedure is referenced.

Therefore, nothing should be tested at this time.

Member.vb

Insert

Applicant Prescreening

Called when adding a new member to an existing household using the Applicant Prescreening screen in the Clinic application module.