Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Modified the uspToggleHouseholdOnsite procedure in the following ways:
Updated the OnSiteClnId field value in the member table with the agency ID and Clinic ID that marked the member on-site. The format for the field is agencyid-clinicid.
Changed the toggle member on-site or off-site regardless of the participant's certification status.
Added the following column to the member table. The column stores the Agency and Clinic IDs of the clinic that marked the member on-site.
Column Name |
Format |
ONSITECLNID |
agencyid-clinicid |
The following four views were updated:
View Name |
Returns |
V_ONSITE_ALLMEMBERS |
ONSITECLNID from member table Only returns on-site members, regardless of certification status |
V_ONSITE_OLDESTMEMBERS |
ONSITECLNID from member table Only returns on-site members, regardless of certification status |
V_PARTICIPANT_LIST |
ONSITECLNID from member table |
V_EBTPARTICIPANT_LIST |
ONSITECLNID from member table |