PIMS 7.0Notes

Changes to PIMS in version 7.0.11 Release (1/17/14)

Changes to PIMS in version 7.0.10 Release (9/23/13)

Changes to PIMS in version 7.0.9 Release (9/7/13)

Changes to PIMS in version 7.0.8 Release (8/18/13)

Changes to PIMS in version 7.0.7 Release (8/1/13)

Changes to PIMS in version 7.0.6 Release (7/30/13)

Changes to PIMS in version 7.0.5 Release (7/25/13)

Changes to PIMS in version 7.0.4 Release (7/21/13)

Changes to PIMS in version 7.0.3 Release (7/17/13)

Changes to PIMS in version 7.0.2 Release (6/18/13)

Changes to PIMS in version 7.0.1 Release (4/7/13)

Changes to PIMS in version 7.0.0 Release (2/13/13)

Technical Notes on Upgrading Between Versions

Upgrading to PIMS 7.0.3 release

Upgrading to PIMS 7.0.2 release

Upgrading to PIMS 7.0.0 release

Changes to PIMS in version 7.0.11 Release (1/17/14)

New Reports

  • QA08: Service Start and End Dates By Participant

Bugs Fixed in this version (Forms)

  • Child Outcome-ASQ-SE now flags if score is ABOVE cutoff, and disables referral button if it’s below cutoff
  • Child Outcome- HOME and Child Outcome- HOME EC “Reason not completed” field is always enabled, subject to staff interpretion
  • Monthly Contact Log Form- for sites defining service start as date of first home visit AND calculating home visits from Monthly Contact Log, the estimated service start date is determined by the first month in which a home visit was completed

Bugs Fixed in this version (Reports)

  • PIMS16B: Monthly Case Status Summary- list of New Enrollments excludes participants with no children
  • PIMS31A: Well Baby Visit Summary- Report header indicates count of “target children with immunizations due" and should count “target children with well baby visits due"

Changes to PIMS in version 7.0.10 Release (9/23/13)

Minor Bugs Fixed in this version

  • Child Outcomes- HOME and Child Outcomes- HOME EC“Reason not completed” field should only be enabled when no scores are entered or total score is zero
  • Home Form- re-enroll button triggered Site_ID parameter prompt when opening Reports Menu

Changes to PIMS in version 7.0.9 Release (9/7/13)

Minor Bugs Fixed in this version

  • Referral- child selection didn’t list all children
  • Staff level logins could not see Referral History, though they could add new referrals
  • Home Visit Form- didn’t list participant’s name at top of form

Changes to PIMS in version 7.0.8 Release (8/18/13)

This version fixes one critical bug which affects only user-based logins.When logged in as a staff member with no admin access, a user would get an error:

“Record(s) cannot be read; no read permission on ‘tservice_level_history’. in UpdateServiceDatesForIndiv.”

when trying to update service level history in Intake or Service Level History. This prevented updating the person’s Current FSW used in some Child Outcome reports.

Minor Bugs Fixed in this version

  • Home Visit Form- IFSP button in middle of form didn’t work
  • PIMS16A: Weighted Caseload and PIMS16E: Adjusted Expected Home Visits-count of Total Participants included “ghost” participants, i.e. participants who once had an Intake record entered which was later deleted.
  • User-Based Login- error “Record(s) cannot be read; no read permission on ‘tservice_level_history’. in UpdateServiceDatesForIndiv.” when trying to update service level history in Intake or Service Level History. This prevented updating the person’s Current FSW used in some Child Outcome reports.

Changes to PIMS in version 7.0.7 Release (8/1/13)

  • Form updates
  • Baseline/Followup- “Type of Housing” field is now reachable on the form
  • Medical Visits Formnow has record selector allowing deletion
  • Site/Program Search Menu now can be used to create a new site
  • Creating new data table
  • “Invalid Use of Null” error now prevented (only occurred in 7.0.6)

Changes to PIMS in version 7.0.6 Release (7/30/13)

  • Report Updates
  • PIMS02: Screening Info Summary- in Screen Outcome section, added categories:
  • “Positive, Not Referred for Assessment” to count positive screens with “was referral made for assessment” checkbox not checked and no assessment available. These cases were previously counted with “Positive, Pending Assessment”
  • “Negative, But Referred and Pending” to count negative screens with “was referral made for assessment” checkbox checked and no assessment available. These cases were previously counted with “Negative, Pending Assessment”
  • PIMS31A: Well Baby Visits Summary
  • This will now refresh without having to first run the individual-level report, PIMS31: Well Baby Visits
  • Report Menu
  • Minimum HVs Before Birth parameter now works immediately after linking database for sites which count HVs from Monthly Contact Log

Changes to PIMS in version 7.0.5 Release (7/25/13)

  • Enhancements and Bug Fixes
  • Baseline/Followup
  • Target Followup Date (display only) now displays termination date for termination followup timepoint
  • Tickler now displays correct followup due date
  • Baseline due date is now based on service start rather than first followup
  • Report Updates
  • PIMS02: Screening Info Summary
  • now displays correct counts for cases newly entered in PIMS 7
  • PIMS15: Home Visit Activities
  • Reports now sort correctly without extra section grouping
  • PIMS43: Life Course Outcomes
  • Now avoids “too complex to be evaluated” error caused by null “income level” data
  • PIMS57: Child Outcome Scores within Normal Limits
  • Cutoff scores can now be configured in Reports Menu
  • Show ID display option now works
  • PIMS58: ASQ Referrals
  • now sorts by whether children have one or more selected delays
  • Show ID display option now works
  • Upgrade Routine - Instrument schedule is retained on upgrade

Changes to PIMS in version 7.0.4 Release (7/21/13)

  • Report Menu
  • Participant Filter and Individual Staff Filter now available for:
  • PIMS20a: Birth Weight Categories
  • PIMS31: Well Baby Visits
  • Updated Reports
  • PIMS20B: Birth Weight Categories and PIMS20B: Gestational Age
  • Added fields Months Enrolled Prior to Birth and # HVs Prior to Birth
  • Now successfully filter for target children
  • PIMS58: ASQ Referrals now includes quality assurance check for valid referrals
  • New Reports
  • PIMS19F: Immunization Summary
  • replaces summary at end of PIMS19A: Immunizations
  • Added separate category for 100% completed immunizations
  • PIMS19F: Immunization Summary- Reflecting Medical Advice
  • replaces summary at end of PIMS19C: Immunizations (medical advice considered)
  • PIMS31A: Well Baby Visit Summary
  • replaces summary at end of PIMS31: Well Baby Visits
  • Added separate category for 100% completed well baby visits
  • PIMS57: Child Outcome Scores within Normal Limits
  • PIMS57: Child Outcome Scores within Normal Limits - Summary
  • PIMS58A: ASQ Referrals Summary

Changes to PIMS in version 7.0.3 Release (7/17/13)

  • New Fields(related to North Carolina and North Dakota MIECHV tracking)
  • Baseline/Followup Form
  • income amount (dollar figure)
  • type of insurance- added “SCHIP” option (for children only)
  • CPS form
  • Whether there are reports of suspected maltreatment
  • Date of suspected maltreatment report
  • Home Visit
  • Training on Safety and Prevention of Child Injuries (8 checkboxes)
  • Medical Visit
  • new fields
  • Check if this visit satisfies a post-partum checkup
  • Check if this visit satisfies a well woman visit
  • Did this visit result in medical treatment for a child injury? (yes/no/unknown)
  • type of visit- added “prenatal care” option
  • Outcome- ASQ
  • Date ASQ results discussed with participant
  • Outcome- ASQ_SE
  • Date ASQ results discussed with participant
  • Outcome- HFPI
  • Date ASQ results discussed with participant
  • Enhancements and Bug Fixes
  • Custom Queries
  • Clear All Output button allows you to reset report output
  • Database Administration
  • Quality Assurance- Missing Birthweights form added
  • Forms
  • ASQ-SE
  • now correctly enables referrals if score is *below* cutoff
  • Training Events List
  • now lists training events in chronological order
  • Renamed Forms
  • Instrument Admin renamed to Parent Outcomes
  • Instrument List renamed to Outcome Instrument
  • Instrument Form renamed to Outcome Instrument Definition
  • Ticklers
  • Baseline/Followup Tickler
  • date of followup field added
  • Child, Partner, and Household info placeholders are added even if no child or partner baseline info entered
  • Outcome- ASQ, Outcome- ASQ-SE, and Outcome- HFPI
  • Ticklers cleaned up for better clarity
  • Well Baby Tickler
  • Tickler now prints for non-target children
  • Upgrade Routine
  • now retains HOME-early childhood data
  • rewrote version upgrade mechanism for improved reliability
  • New Reports
  • PIMS58: ASQ Referrals
  • Updated Reports
  • All
  • Data Cutoff can now be set to the end of the current month
  • Individual Staff filter no longer activated when not visible
  • “months, years” display is now listed just as “months”
  • SortBy parameter now works correctly
  • PIMS01: Screening Info by Individual
  • now displays correct assessment status for cases newly entered in PIMS 7
  • PIMS20A: Birth Weight Categories and PIMS20B: Gestational Age Categories now allow 3 more parameters- Target vs. All Children, Prenatal Enrollment period, minimum HVs before birth
  • PIMS21: Referral Information by Individual
  • now lists referrals for people without intakes
  • now correctly sorts PIMS 6 & PIMS 7 entries
  • PIMS31: Well-Baby Visits
  • now displays each child’s FSW and service end date
  • now lists only well baby visits due before last home visit
  • PIMS56: Child Outcome Checkpoints
  • all reports distinguish between screens completed on time vs. screens completed to date
  • Data Aggregation
  • Service Level History
  • form now tracks Site ID in addition to service level
  • Reports- the following reports previously showed duplicate counts for any reports on aggregated data. This has been fixed.
  • Case History category
  • PIMS14C: Summary of Intensive Services for New Families
  • PIMS26: Service Termination History
  • PIMS28: Enrollment History
  • PIMS39A: Service Level History
  • PIMS39B: Service Level History for Creative Outreach Recipients
  • PIMS39C: Service Level History – Individual
  • Case Management category
  • PIMS16A: Monthly Caseload Management: Weighted Caseload
  • PIMS16B: Monthly Case Status Summary
  • PIMS16E: Monthly Caseload Management: Adjusted Expected Home Visits
  • PIMS16F: Current Weighted Caseload
  • Contact/Home Visit category
  • PIMS14: Monthly Contact Log by Month
  • PIMS14A: Monthly Contact Log by Partcipant
  • PIMS35A: Home Visit Completion by Individual
  • PIMS35B: Home Visit Completion by Site
  • PIMS35C: Home Visit Completion by FSW

Changes to PIMS in version 7.0.2 Release (6/18/13)

  • Bug Fixes and Other Improvements
  • Forms
  • Birth Form- calculate birthweight button now works
  • OutcomeForms(KIPS, HOME, etc.) now allow deletions
  • Site Definitions
  • Instrument Checkpoints – can now delete
  • Report Menu
  • Participant Filter
  • added “Service Start Between” option
  • Individual Staff Filter
  • added, now available for:
  • PIMS13: Participant Info Sheet
  • PIMS19: Immunizations
  • PIMS33: Mailing Labels
  • PIMS52: Outcome Instruments
  • PIMS56: Child Outcome Checkpoints To Date
  • Reports- Revised
  • All new reports labeled “Beta”
  • PIMS02A: Screening Information- Pending Assessments now correctly displays only participants with no assessments
  • PIMS16E: Monthly Caseload Adjusted HV
  • no longer double-counts a participant who switches levels mid-month
  • report header now correctly states whether home visits were tabulated from Monthly Contact Log or Home Visit forms
  • PIMS16F: Current Weighted Caseload “sort by” parameter now works
  • PIMS28: Enrollment History now displays past first page
  • PIMS52: Outcome Instruments now sorts alphabetically by last name
  • PIMS53: Child Outcome Checkpoints from Birth – by birth cohort now incorporates PIMS53A: Child Outcome Checkpoints from Birth – Summary
  • PIMS54: Child Outcome Checkpoints from Enrollment now incorporates PIMS54A: Child Outcome Checkpoints from Enrollment - Summary
  • Reports- New
  • PIMS56: Child Outcome Checkpoints To Date
  • PIMS56A: Child Outcome Checkpoints To Date Summary

Changes to PIMS in version 7.0.1 Release (4/7/13)

  • Bug Fixes and Other Improvements
  • Aggregation tool now works (no longer get error, “cannot find the input table or query ‘tassessment_data_DB1’”)
  • Forms
  • Birth form
  • removed link to Followup form (was triggering an error)
  • reorganized form to reduce clutter
  • Child Development Screens- renamed as Child Outcomes
  • Child Development Screens- non-admin staff can now see child screenings (list previously appeared blank unless logged in as pims admin)
  • Child Development Screens- non-admin staff can now print the tickler (previously triggered a permissions error)
  • Home Form corrected tab order
  • Outcome_ASQ- non-admin staff can now print
  • Reports
  • PIMS17: Child Outcomes- “too complex to be evaluated” error no longer occurs when an instrument definition for “Home- Early Childhood” hasn’t been created
  • PIMS31: Well Baby Visits
  • Children who changed pregnancy ID from target (‘A’) in PIMS 6 to non-target (‘B’, ‘C’, etc.) in PIMS 7would still be listed as target children in PIMS 7. This problem has been corrected.

Changes to PIMS in version 7.0.0Release (2/13/13)

  • Bug Fixes and Other Improvements
  • *All
  • No longer forces application to quit when suspected that it’s being opened by more than one user; just suggests that the user close PIMS
  • New Forms
  • Outcome- Home- Early Childhood added, along with a corresponding tickler report
  • Forms
  • Child Development Screens
  • for non-target children, timelines correctly reflect birth and due dates
  • generic score field now tracks decimal scores
  • Home
  • Re-enroll button works correctly (deleting existing termination first)
  • Instrument Admin
  • generic score field now tracks decimal scores
  • Instrument Definition
  • All cutoff scores can be defined at each timepoint for ASQ
  • One cutoff score can be defined at each timepoint for all other instruments
  • Warning message appears when a user tries to close this form without selecting a baseline, target, or data tracking form
  • Outcome- ASQ
  • looks up cutoff scores for each timepoint based on Instrument Definition form for ASQ
  • Outcome- ASQ-SE
  • looks up cutoff score for each timepoint based on Instrument Definition form for ASQ-SE
  • Score field now tracks decimal scores
  • Outcome- KIPS
  • displays revised subscale names, and now displays child name (not parent’s name)
  • Participant History
  • no longer prohibits second entry of email address
  • Partner History
  • no longer prohibits second entry of email address
  • Custom Queries
  • Add Current Participants wizard now works
  • Added Fields
  • Outcome- Other Instruments - Score
  • Outcome- Other Child Development Screens - Score
  • Report Menu
  • Cutoff date- when updated, this will now immediately update monthly contact calculations
  • Reports will not open if month/year parameter is later than cutoff date
  • New Reports
  • PIMS53: Child Development Screen Checkpoints from Birth Date(replaces PIMS51A: Child Development Screen Checkpoints)
  • PIMS53A: Child Development Screen Checkpoint from Birth Date- Summary
  • PIMS54: Child Development Screen Checkpoints from Enrollment Date
  • PIMS54A: Child Development Screen Checkpoint from Enrollment Date - Summary
  • PIMS55: Instrument Checkpoints from Birth Date
  • PIMS55A: Instrument Checkpoints from Birth Date - Summary
  • Reports
  • Baseline/Followup Tickler
  • now displays date due for currently selected followup period
  • Health Care Tickler
  • combined Measures Completed to Date into Child Development Screens, now displays timelines for all screens due up to the current month, including tools added in PIMS 7
  • PIMS16A: Monthly Caseload Management: Weighted Caseload
  • “1st Service Level Assigned” column (which has always been used in the calculation of the number of home visits expected) now displays the correct data and not the enrollment date
  • PIMS16E:Monthly Caseload Management: Adjusted Expected Home Visits
  • “Enrollment date” column replaced by“1st Service Level Assigned” date, which has always been used in the calculation of the number of home visits expected
  • Correctly flags for incomplete Monthly Contact Logs, even for logs entered afterdata set is update to PIMS 7
  • PIMS17: Child Development Screenings
  • now displays min due date, max due date, referral date
  • now displays all child dev screens, including HOME, HOME-EC, ASQ, ASQ-SE
  • reformatted for consistency with PIMS 52
  • PIMS21: Referral Info by Individual
  • can now be opened by staff-level accounts
  • PIMS25: Child Corresponding Parent Listing
  • now counts total # of active/terminated families
  • PIMS 52: Outcome Instruments (renamed from Instrument Administration Tickler)
  • now displays min and max due dates
  • reformatted for consistency with PIMS 17

Technical Notes on Upgrading Between Versions

Upgrading to PIMS 7.0.3 release

  • tbirth_data
  • added qa_weightfix_timepoint
  • tfollowup_participant_data
  • added hours working per week
  • tchildprotectiveservices_data
  • added suspected_reports_flag
  • added suspected_date
  • tintake_lkup_insurance
  • 30 = SCHIP (for children only)
  • tmedical_visit_data
  • added satisfy_postpartum_checkup_flag
  • tmedical_visit_lkup
  • 40 = prenatal care
  • toutcome_asq
  • added participant_discuss_date
  • toutcome_asq_se
  • added participant_discuss_date
  • toutcome_hfpi
  • added participant_discuss_date

Upgrading to PIMS 7.0.2 release

  • tassessment_lkup_instrument_score_type
  • tInstrumentsToTimepoints
  • added more cutoff scores (cutoff_score6, cutoff_score7, cutoff_score8, cutoff_score9, cutoff_score10) to allow score tracking for more complex scales such as HOME and HFPI
  • tpeople_data
  • added current_fsw_id (a calculated field)

Upgrading to PIMS 7.0.0 release

  • tInstrumentsToTimepoints
  • added cutoff scores (cutoff_score, cutoff_score2, cutoff_score3, cutoff_score4, cutoff_score5) to allow different cutoffs at different timepoints; 5 scores for ASQ, 1 score for all other tools
  • toutcome_HOME_EC added
  • tparticipant_history
  • participant_email_text allows duplicates
  • emergency_email_text allows duplicates
  • tpartner_history
  • partner_email_text allows duplicates

Page 1 of 14