Team Coherence History Report
Criteria: All Revisions
Created by blawes - 1/8/2007 12:33:36 PM

FileName: PhoneNumbers.dll
Comments
update primarily to stored proc to handle modifications to existing phone numbers. Current behavior is: On update, if phone number already exists, update the linkage of the selected row. If the modified phone number does NOT exist, insert a new phone number and add a new linkage to it.
removed auto-insert of new linkage record when changing phone type, added right-click option to copy the existing phone number and use with a new type.
On new set Phone Number tab active. Otherwise use got a "cannot focus on disabled or invisible window" error.
sort so primary is on top of grid
moved from 44 down to 43 for earlier release. Uses master_phone_numbers and phone_number_linkages tables.
Moved the Date Update/User Updated before Date/User Inserted so users could see this field first. This should help a little with Tracker # CMS012251
surfaced user/date inserted/updated columns in grid
Default icon didn't exist. Changed to notepad
Helps if you remove the cms.PhoneNumberFormat from the dataset.
Changed QueryPhoneNumberFormatPhoneNumber to a calculated field rather than using the PhoneNumberFormat function in the database due to an issue with Wyandotte's 9.1.0.7 version of Oracle DB.
Added new formatted phone number field to the query so the number is readable.
Added a warning when users try to add a duplicate phone number type.
new


 

FileName: Events.dll
Comments
Tracker # ID26012429
Events Report - Steve is reporting that the Modified time is showing as 12 hour time rather thatn the 24 hour time like all other info for this screen.  

1/02/07 -Fixed -Brian Lawes
reversed completed by/entered by on the report, had been backwards
All of the Event time was not showing in the Event Report. Fixed
Tracker # MI94012134
Unit Number added but not required When adding an event.
fixed enddate after startdate check bug when enddate is typed in.
SET G_EVENT_SECURITY TO UPPERCASE
added test for g_event_security to see if select security checking should be enabled
added parameter of faciilty to the events query. It uses the preferences setting for which facility to use by default. Changing the facility pulldown refreshes the query with the selected facility.
added parameter of faciilty to the events query. It uses the preferences setting for which facility to use by default. Changing the facility pulldown refreshes the query with the selected facility.
Tracker # MI10011119
Behavior_Incident_Template Global Setting can be used to auto populate a template to the notes field on NEW.
Tracker # ID 26010716
Added report based on date range. Date range Start date must be before the enddate. Copied this into the Events and FacInc date range report too.
02/03/06-bl
Tracker # MI10011099 -Added the ability to select the number of events to view in the event history.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Images.dll
Comments
made the mug shot report images bigger so that it did less truncating of the image in the mugshot report. Nothing else we can do about it unless we redesign the report for even larger images which would force it to span multiple pages which was exactly what we didn't want to do initially.
updated to 4.3 to support new phone_numbers table. Print current image report now uses the new table.
moved the new mug shot lineup generation report from reports into the images dll so that people who don't have access to reports can generate lineups
new build to set unique base addresses
Latest change when cancelling an image made it so you couldn't add an image at all.
Cancelling the file type/file date screen will now stop the image install process.
first 'production' build of 4.3, ready for testing


 

FileName: CMS.exe
Comments
1. Display latest image on desc check box is visible again
2. Added default System preference.
commented out line that enables/disables the system pulldown when entering/exiting workflows for testing
Testing - now using combo box for systems to determine system access
Testing - try adding system to another place the error gets raised
Testing - added system name to error message when a user doesn't have access to the selected name
Testing - commented out line that enables/disables the system pulldown when entering/exiting workflows for testing
Testing - added test for system access in the canacccess function in cms (as opposed to the stored procedure). Error is raised if the user doesn't have access to the system or if their agency doesn't have access.
Testing - TEST version of cms.exe, NOT for client distribution
User was able to Cancel changing the password when PasswordNotPassword was enabled by the administrator. If cancelled the user will be forced to exit or restart CMS to start the cycle over.
Tracker # CMS011980
06/13/2006 - added the users' name to the hint in the status bar and to the about screen.
fixed query in preference dm
Trying to get rid of the QueryDoWorkflowsExist:Field'Tablecount' not found. Added a sleep, processmessages, sleep. And added a static TableCount field
added code to keep all sockets alive on the keepAliveTimer fire event, not just compsec sockets. Attempt to resolve an AV Bonner is getting at exit. Tested by letting it sit for 2 minutes then exiting with several screens open, no errors.
Added Unit to preferences. Refreshes the pulldown list when facility is changed, and initially populates based upon units defined for the currently selected facility. If no default facility has been selected, unit cannot be set.
allow close on cancel password change, added test for g_min_password_length
Use of Alert socket by QueryAgency caused "Client socket not active" errors if Reminders were turned off. It's now using the CMS socket.
added creation/population of user.current_agency table when ever a user logs in or changes the selected agency. For use by referential validation triggers in a future release.
another test version that saves the currently selected agency into a table it dynamically creates named 'current_agency'
Test version prototyping saving the currently selected agency at start time as well as if it changes.
Added DB version info to the about screen. So we can see the DB and App versions at the same time.
new build to set unique base addresses
Removed e-mail preferences tab from user preferences, added logic so that the default agency isn't saved when saving preferences unless it's actually been changed. It will still require that the user set an agency, however.
first 'production' build of 4.3, ready for testing


 

FileName: Reports.dll
Comments
Restitution balance was not excluding Voided payments.
Juvenile Hisotry - matched field names to column name definitions in querycustodian
HDEM report changed to use cms.getphonenumbers function
Reports updated to use cms.getphonenumbers function.
unmailed UA's report was AV'ing on exit. Caused by illegal reference to another form. Used variable being passed to the form at create, fixed.
several changes related to phone numbers and adding minutes to an arapahoe report
Phone was overlapping School. Fixed
Tracker # ID26012307
Caseload by PO now show home, cell, or business if the previous is not there. Using the cms.getphonenumber function.
updated to use master_phone_numbers and phone_number_linkages tables
fixed reporting by type so that the correct report header was used when filtered.
Added LEO time (from the Non-secure report) at Kira's request
changed juv hist to a 2 pass report so page numbers are displayed correctly on preview and print without preview of each page
moved the new mug shot lineup generation report from reports into the images dll so that people who don't have access to reports can generate lineups
bottom row of mni's is a duplicate of the top mni's in the lineup report, can't get them to go away
fixed AV when select criteria form cancelled for mug shot lineup report
added abiliity to select which images appear on the mugshot lineup report. A maximum of 6 will be displayed with only the MNI identifying the image on the report. Out-sized images will not display correctly, that's a problem of the image taker, not the software.
Changed to a Report Builder report
Helps if you change the alias for the column when you add cms.PhoneNumberFormat to the query.
using cms.getphonenumber for relationships query.
Address info is taken from the Address_2 field (Full Address on the CMS screen)
Relationship phone number were all pointing at QueryHomePhone dataset.
Tracker # MI904011777
Added Food Services report (Head Count) that includes Unit, Room Number, Name, DOB, Age, Diet info, & Allergy Info based upon the users default facility in preferences. We may need to make it look at the Default unit too in the future.
NOTE: Old Head Count report query wasn't looking for the housing.date_out_room so kids were counted multiple times. Fixed the query and also hid the old report as not to confuse the users.
Tracker # ND32011762
Juvenile History - If available it now shows the Probation End rather than than the Anticipated End.
added educational status report under detention pulldown
DO NOT DEPLOY without 4.3k update...
updated face sheet and juvenile history to pull phone numbers from the new phone_numbers table
Tracker # ND32011569
05/12/06 - bl
Juvenile History - Added a sort_date column to sort hearings
added actual_program_end to the caseload by PO report as per ND
Detention reports modified to use unit_name rather than only room_number. Project moved to 4.3 directory as it's based on the updated data model.
added mailing address to the juvenile history as a single column below the physical address data, for ND
added new reportbuilder based court pass report
Tracker # ID26011151
Now the Photo Line-Up report looks for the most recent Image type specified by the users. Previously it was just looking for the most recent image causing the person not to appear in the report.
courtpass report rolled back to original as per Ronya
02/03/06 - bl
Tracker # ND32011106 Added the Program Actual end Date to the Juvenile History.
Juvenile History - Moved the Address Unit info around a little so it was easier to see.
Tracker ID26011033
01/28/06-bl
Added an indicator to show which Holding Cases are also cases for the Hearing.
Tracker # ND32011020
Added Deceased status after the relationship name on the Juvenile History.
Balance for Restitution Paymens report now shows correct balance at the end of the report period.
Tracker # ID26010856
Restitution Payments report now only shows the offender payments made during the time the offender was assigned to the PO
new build to set unique base addresses
On the detention aging report, added a try/except block around the formatFloat call in the onCalcField event for the Duration column. In the demo instance, the durations were too long, and it was crashing. Now sets the duration to '' on error. Shouldn't be a problem in a real-world database. (Tests fine at Canyon)
Added holding authority to the Arapahoe Secure report.
first 'production' build of 4.3, ready for testing


 

FileName: Hearing.dll
Comments
1. Added "unique" to queries.
2. Added "none" instead of ' ' for no po or hearing officer.
removed the loadlibrary call in the save event if called from schedule, for some reason that I was unable to identify, it was causing an AV
new build to set unique base addresses
Tracker # CMS010588
Hearing.Date_Updated changed to a date field.
first 'production' build of 4.3, ready for testing


 

FileName: CMSEmploymentHist.dll
Comments
"Current Employment" check on save.
Issue 12318 - Now assumes new record if recordcount is zero on save
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Schools.dll
Comments
Tracker # ID26012392
Fixed -Schools - Error adding new school entry.  Changing the district reset the ISNew and caused the an update of the first entry in the schools screen.
detail screen migrated to stand-alone dll
new build to set unique base addresses
Tracker # CMS010453
added filter by district
first 'production' build of 4.3, ready for testing


 

FileName: DriversLicense.dll
Comments
Tracker # CMS012350
1. Assume New suspensions when there are no Suspensions and when adding a new drivers license #.
2. Checks on Save to make sure a Drivers license number is specified before entering a suspension.
3. New Supspension cannot be clicked if there is no drivers license on file.
days_suspended now cleared on New
added auto-calculation of suspension end date based upon entry of days suspended. Days suspended not stored, is calculated based upon saved dates on screen refresh.
updated DL table structure, added subordinate suspensions
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Probatio.dll
Comments
Tracker # CMS012358 & CMS012369
1. Won't allow instances until the probation entry is saved
2. Associate Referrals automatically pops up when saving a new entry.
3. Automatically saved probation entry when the associate referral grid is double-clicked.
Bug # 12334 and 12323. Probation instance PO lookup modified to act like main probation screen. AssRefer can't work on the probation instance since the table has no MID column. Assrefer removed since it is subordinate to the probation table that has both MID and it's own Assrefer.
added CR handling to the staff pulldown, so it on CR selects the currently highlighted entry and tabs to the next column, just like if you'd hit the tab key. Also fixed the need to double-click the pull-down button if the staff field was highlighted.
staff selector maybe a little more well behaved?
PO queries now 'distinct'
added filter to PO list using socket.agency
changed tab order based upon user selection from supervised by pulldown. Now displays/hides pulldown
Updated new pulldown for EDIT_PROBATION_SUPERVISED_BY
ready for testing after changing supervised by to a pulldown rather than free text only.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: PTerms.dll
Comments
Issue 12387 - AssRefer wasn't refreshing after save. The Assrefer.Reopen wasn't working, so I added the full close, set the parameters and then open code block. Also added a popup menu to delete from the bottom grid.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Contacts.dll
Comments
Tracker # ID26012309-
Printing calendar cut off the Follow-up on the right side of the page. Change the Printmargin=2 for the HTMLViewer.
set global variable to uppercase
made the contacted by field act a little more like probation, but because it populates the login field, they can't be identical.
PO queries now 'distinct'
added filter to PO list using socket.agency
added lookup for contacted by. Does auto-complete of the pulldown for login name if it can find the right name, otherwise it forces the user to select by setting tab position on login by pulldown.
turned on autoschema on queryloginnames
removed the loadlibrary call in the save event if called from schedule, for some reason that I was unable to identify, it was causing an AV
QueryLoginNames was populating the stringlist with staff's MNI rather than staff_key. Fixed.
new build to set unique base addresses
Long contact was not Emailing at Canyon. Change max length of email comment to 2000
fixed querycontacts to get staff_key from jcms.staff_linkage
first 'production' build of 4.3, ready for testing


 

FileName: Description.dll
Comments
updated query for phone numbers to use the new master_phone_numbers and phone_number_linkages tables. Also added abillity to click directly to the phone numbers screen by clicking on the displayed phone number on the main description screen.
Removed call to phonenumberformat function so that description will work in kansas.
Updated for the new phone numbers table.
Updated DescQuery to work with both New and Old data model for addresses.
Tracker # CMS011911
DOB must be in the past
Is Offender flag was getting set when using NewRelationship action. Found that the GlobalVars BypassOffender was not being seen on save. Changed it to a local variable and removed all the references to the old GlobalVar.
moved the system access display label up from behind the moved relationship grid
moved the relationship grid to the bottom of the screen and onto a panel so as you make the screen bigger you can see more of the relationship grid.
new build to set unique base addresses
Tracker # MI10010710
On Save, use NewMNI for comment save vs. CurrentMNI, since the NewMNI should be set in every instance and CurrentMNI may not be from a workflow.
changed prompt message when removing a supervisor with existing employees
added test for employees and warn user if when unchecking is_supervisor there are any employee records out there. Stored proc updated to do a cascade delete of employees on delete.
first 'production' build of 4.3, ready for testing


 

FileName: Detentio.dll
Comments
updated to use master_phone_numbers and phone_number_linkages tables
fixed bugs where date out of a room was getting set when it wasn't supposed to be.
removed AND facility_type_2 = 'DETENTION' from the room list report
SMT on FPC back updated so multiple lines show and it indicates if what type of SMT.
Bookin (Admission) report relationships of Guardian, %FATHER%, %MOTHER% now show.
fixed null times on housing
added times to placement rooms, time in and out.
Hid classificaiton level from the Washtenaw door tag.
probably fixed a bug in the bookin report related to phone number, but I don't remember
schema-qualified call to formatphonenumber in the bookin report
fixed book-in report to use new phone number table
removed the 'facility_type='DETENTION'' from the in custody report
fix applied to housing room query with the new table structure for property
fixed housing rooms query
added taken by and returned by to the property report
added reason moved to housing
Filxed Housing on release error.
Added Rooms Available count to the housing screen
On New select the users default facility (if available)
List of Bins is now limited by the Bins for GlobalVars.SelectedFacility.
widened the visitors.name_6 to 200 bytes
Housing - Date moved can now be filled in during an update
Tracker # MI10011531 - visitors list report added
Added facility_name_2 parameter for stored proc
added unit to housing, updated reports that report what room to include unit
added mni to the querychargeonfile query on the charges screen to make sure that we're only checking for the current person and the case number, not the case number in general.
Tracker # ID26011053
Error when Rebooking option has been fixed.
Washtenaw has hidden the Holding Petiiton combo box on the charges screen. When they click NEW is gives them a "Cannot focus..." error. Fixed.
Tracker # ID26010762
Test for Charges now uses Global Setting MANDATORY_HOLDING_CHARGE_ENDDATE to determine if enddates are mandatory.
Tracker # ID26010763
Bookin report now only shows charges where end_date is null
Added test for charges with null end_date on release, take them to the charges screen if count > 0
See Tracker #CMS010742
new build to set unique base addresses
There's a large space between the headers and the property list. Removed the extra space.
door tag report added for Washtenaw
changed query populating holding petitions on main detention screen to only show those petitions with a holding charge with an end date of null or an end date <= sysdate
Released_to field was allowing more than the 25 characters for the database field.
Released_to field was allowing more than the 25 characters for the database field.
Added start_date, end_date, user_modified, date_modified columns to holding_charge, renamed existing date/user columns to user_inserted, date_inserted.
Tracker # MI10010237
10/11/05 -bl
Added a label showing the Code Description for the Holding Charge
Made middle names visible in approved and no contact visitors lists
first 'production' build of 4.3, ready for testing


 

FileName: CommServ.dll
Comments
added date ordered
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Staff.dll
Comments
several usability changes...check to see if dataset is already set before changing, change dataset on inactive checkbox click instead of on agency change events, don't set currentmni when the form is opened, only when a name is selected.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Address.dll
Comments
made address_1 field match the database column length, updated the 'use physical as mailing' button to only use the first 35 bytes of the physical address so it won't exceed column length.
hid phone number fields, added phone number button that links to dll
unit is now showing in grid and is included in the full address
new build to set unique base addresses
On New click, check global_settings for value in 'g_default_state', if set, use value in both physical and mailing state fields.
Tracker ID26010531
added country to the table, auto-populates based upon 'default_country' set in maint/global_settings, sets zip mask based upon countries lookup table
first 'production' build of 4.3, ready for testing


 

FileName: Email.dll
Comments
Default icon didn't exist. Changed to notepad
new


 

FileName: Document.dll
Comments
clear comment on new doc from template
Commented out a file rename right before template save on open office templates that was causing an AV. In stepping through it the file had already been named, and was probably AV'ing because the file was locked. Seems to work fine without the redundant file rename.
NotDocRTF files can now be saved if modified after doubleclicking them.
new build to set unique base addresses
same fix, ootemplates
Petition number was getting set to -1 all the time. Moved an else into the begin...end block.
added file_size, file_type and comments to the table. Added code to extract the data, and if a user makes a change after saved in the database, handle the ioexception raised by using existing file name, size, type stored in the database on save
removed double .. from file name on save external from template
fixed save to external file from template to not use export code, can't assume the object is in the database, only save from the oleobject
Added error handling on file double-click open so it will display an appropriate message based upon the error condition
1. Changed "New Document" to "New File"
2. Changed "Save As" to "Export"
3. Added right click to export
4. "Open with..." popup will now show when double-clicking on a file that does not have file association.
Working on Tracker # CMS010275
Non DOC / RTF files can be saved to the database and will open in their associated program.
don't remember what I changed
Added code to force the user to select a document saved in the database before double-clicking on it so that we have time to get the doc out of the database and saved locally so that it can be opened by OO or Word.
first 'production' build of 4.3, ready for testing


 

FileName: Behavior.dll
Comments
added test for G_BEHAVIOR_INJURY_SOURCE, it true, requires injury source pulldown to be completed if the Offender Injured? checkbox has been checked.
realigned fields
reason force used, staff injured, offender injured, injury caused by columns added
fixed enddate after startdate check bug when enddate is typed in.
Tracker # MI10011119
Behavior_Incident_Template Global Setting can be used to auto populate a template to the notes field on NEW.
Tracker # ID 26010716
Added report based on date range. Date range Start date must be before the enddate. Copied this into the Events and FacInc date range report too.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: MainPlc.dll
Comments
added set of assrefer.mid := currentmni onFormRefresh
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: InterviewPlans.dll
Comments
Added to the length of underlying database columns.
new


 

FileName: Medcon.dll
Comments
Tracker # ID26012242
Added abitlity to Copy selected observation items and notes. Cleaned up some old unused code.
Screen caption updated to Medical Observations. Also updated the default module manager name and hint. This has been done to distinguish information added by medical and non-medical staff.
new build to set unique base addresses
Tracker #MI10010354 - Changed True column to T/F and added a True or False listing for the results.
Also fixed it so the Name, DOB, and MID would show always. The query for this info was linked directly to the most recent placement which did not make sense.
first 'production' build of 4.3, ready for testing


 

FileName: TribalAffiliations.dll
Comments
new


 

FileName: JoltsInterface.dll
Comments
helps when you build the right version
43 update
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ACESInterface.dll
Comments
Parameters for Search proc updated
43 update
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Tests.dll
Comments
Added label when comments fields are created.
new build to set unique base addresses
On Generate Case Plan, if 0 plan types are defined, don't continue, if 1 is defined, use it, if more than one, ask user to select which plan type to use.
first 'production' build of 4.3, ready for testing


 

FileName: ClassAttendance.dll
Comments
Added scrollbars for comment fields
Added message to warn a users that have been given limited acces that they can only view classes where they are the instructor
added popup menu delete on enrollment grid
brian lawes fixed some things
will not allow saving attendance or outcomes if no attendee is selected.
Now precludes saving unless there is a class available to save against.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ExtNumb.dll
Comments
Added check for a number value
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ClassEnrollment.dll
Comments
old version was raising stored proc errors, this one isn't...dunno why
brian lawes fixed some things
precludes enrollment in a class if no class is available.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ClassCreation.dll
Comments
brian lawes fixed some things
Sets numeric values to null if the text fields are blank on save rather than raise errors, since not all fields are mandatory.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Commit.dll
Comments
Fixed new County query to only occur when there is a record on file.
Added a grid to display county_name from associated referrals. Grid used in case multiple referrals from multiple counties are associated via AssRefer.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CommunityServiceResources.dll
Comments
deleted extra close button
new


 

FileName: ProgramResources.dll
Comments
new


 

FileName: Allergies.dll
Comments
Fixed typo
tab order fix
new


 

FileName: EducationalTests.dll
Comments
added test_result_types
added calculation of difference as Pre-Test - Post-test = difference. Displayed in Red if negative, black if positive
fixed size of memo field, set maxlength to 4000, added verticle scroll bars
new


 

FileName: TransitionalPlacements.dll
Comments
changed label caption just to keep brian happy :)
new


 

FileName: FacInc.dll
Comments
Unit Name - Added new field and updated reports for new field
Facility query refreshes when facitility name is changed and on form refresh.
added facility access checking from events. Changed facility query to return all facilities and then use the new function rather than attempt to filter appropriate facilties in the query.
fixed enddate after startdate check bug when enddate is typed in.
Tracker # MI10011119
Behavior_Incident_Template Global Setting can be used to auto populate a template to the notes field on NEW.
Tracker # ID 26010716
Added report based on date range. Date range Start date must be before the enddate. Copied this into the Events and FacInc date range report too.
CMS011006 - Added "Print by Date Range" report
MI10010992 - Made the History grid a little larger and added a splitter so it can be adjusted.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: MassHousing.dll
Comments
added reason moved
1. Uses the facility selected on the placement screen.
2. Allows the user to change units
3. Selects the unit if only one is listed.
4. Save correctly after addition of facility name to the housing table.
"Wrong number or types of arguments" reported by Shawn Brown. Shoudl be fixed.
added support for unit_name, moved to 4.3 project folder
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: GrievHearing.dll
Comments
Tracker #MI94012132, added popup option to filter staff selection by user's agency or all agencies
TC Issue 11954, now cannot associate grievances or hearing officers without first adding a hearing. Also added test for subordinate records before allowing deletes.
labels fixed
new


 

FileName: Disciplinary.dll
Comments
added popup option to filter by default agency or by any agency for selecting hearing officers, TC issue#MI94012132
Tracker # MI94012133
Done - Label Changed
TC #11954, now disables add linkage to behavior and hearing officers if hearing recordcount is 0
Tracker # ID26011489
1.  Hearing history now listed Newest to Oldest
2. report print 2 copies by default
added outcome type and date to comments
added button on followup screen to append comments to main hearing. Also added a panel under the followup comments and made the comments a client of the panel for screen sizing issues for 'some' people.
another test build for testing
test build for forcing followup comments to be mandatory
moved the behavioral incident data items further apart on the report and set a max length on the incident type so it won't overwrite the date of incident.
Fixed spelling of 'disciplinary' on the report
I created a new query that only uses the selected hearing.  Also added a right-click menu option on the hearings grid to access the report.
window resized
added test for presence of an outcome when saving a followup
fixed IsNew bug, added a new boolean IsNewFU for followups
added automatic insert of outcomes if recordcount = 0
new


 

FileName: Drugass.dll
Comments
added time and person giving assessment
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: EdDetail.dll
Comments
Tracker # MI94011936
Added ESL column and update/added user/date columns
fixed size of memo field, set maxlength to 4000, added verticle scroll bars
new


 

FileName: MedicalIncidents.dll
Comments
1. Tracker # MI94011765 - Time has been added to Medical Incidents
2. Added checks for db mandatory fields (type & date)
added incident report, fixed width of memo fields.
new


 

FileName: Grievances.dll
Comments
Tracker # MI94012131
Staff grid anchored properly for resize and maximize.
new


 

FileName: MedicalImages.dll
Comments
new


 

FileName: ReligiousPrefs.dll
Comments
IsNew set if first record entered.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: MedicalConditions.dll
Comments
Tracker # MI94011776
Added Time for medical conditions- secure
Added "Secure" to Screen Name
new


 

FileName: Relationships.dll
Comments
Tracker # CMS011945
Save button will not be visible unless the "Add as Relationship" button is clicked on the Search screen.
Fixed misspelled 'Referrals' in delete of relationship
"Same Address" button fixed for new Address Country field
new build to set unique base addresses
added add new approved visitor and new relationship to current person on the right-click popup menu
first 'production' build of 4.3, ready for testing


 

FileName: Search.dll
Comments
hide relationship pulldwon on add new relationship search
GetAge in new Extended search is now schema qualified.
Changed SHOW_WAIVED to G_SHOW_WAIVED
1. With SHOW_WAIVED global setting, displays adult waiver date with hot link click to open waiver screen
2. Added new dynamic search tab
Now displays gang associations on the warning tab of the main CMS framework
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CaseLoad.dll
Comments
Test Ranking could cause error if 2 tests were given on the same day.
clear itemindex on unit when agency selected
clear cbUnits whenever populated
has unit as a filtering pulldown. Uses new createcaseloadview stored procedure.
build with only brian l's changes?
added close before opening flags query
Changed SHOW_WAIVED to G_SHOW_WAIVED
1. With SHOW_WAIVED global setting, displays adult waiver date with hot link click to open waiver screen
Now displays gang associations on the warning tab of the main CMS framework
added date of test to the getcaseloaddetails proc by appending it to the score, changing the v_score parameter to varchar from number.
Flags screen only shows if there are flags for the current agency. Otherwise user is warned that there are no flags for that agency. Also changed the querycaseload.open to gobutton.click.
Caseload flags weren't displaying correctly when you changed agencies. Moved the color stringlist population to refreshview, and fixed bug where agency_name wasn't being passed to the color query. Also added Socket.Agency to call to delete current flags when adding a new flag, and updated stored procedure to only delete flags for the current agency when function = 'D'
new build to set unique base addresses
Added agency to createcaseloadview stored procedure parameters, which is then passed to getcaseloadflags so that the currently selected agency is always used, regardless of preference settings.
added test for default_agency being set at form ready
11/09/05  -bl
Caseload need to use the new default agency set by the user when showing "My Caseload" and "My Agency"
Couldn't duplicate, but I added code to force use of GlobalPrefs['default_agency'] when clicking on the My Caseload and My Agency buttons
Tracker # MI10010276
Added LOS (Length of Stay) to the Caseload list for the individual selected for a facility.
first 'production' build of 4.3, ready for testing


 

FileName: MedicalReports.dll
Comments
new


 

FileName: EdLevels.dll
Comments
new


 

FileName: EdReferrals.dll
Comments
tab order
new


 

FileName: Diets.dll
Comments
tab order fix
new


 

FileName: HearingScreen.dll
Comments
new


 

FileName: Prescriptions.dll
Comments
fixed record positioning after save, replaced filteredits with plain TEdits since the filter edits were set to ftNoFilter and still wouldn't allow embedded spaces.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: FemaleMedCon.dll
Comments
new


 

FileName: SubstanceUse.dll
Comments
new


 

FileName: Hospitalizations.dll
Comments
new


 

FileName: FamilyHistory.dll
Comments
new


 

FileName: Vision.dll
Comments
removed vision_locations, coded for vision_levels to link to 3 columns, one for each eye and a both.
new


 

FileName: MedicalAppointments.dll
Comments
new


 

FileName: Vitals.dll
Comments
new


 

FileName: Assign.dll
Comments
Wrong # or type of arguements in call to "Createcaseloadview" after 4.3e upgrade. ( Housing Units )
Updated to support v_agency in the caseload view
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Interviews.dll
Comments
new


 

FileName: Urinalys.dll
Comments
Added report for all UAs on selected Person
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Waived.dll
Comments
now uses assrefer to track case associations instead of case number column
new


 

FileName: CMSGangs.dll
Comments
made selection of gang on the membership tab a separate event, not driven by the gang name selected on the edit tab.
gang membership tab now automatically uses gang name selected in edit tab. Not sure if users will like that, but brian does :)
Changed buttons to tabs, moved associated gangs grid to the data entry page, added reports for all gangs and selected gang membership.
changed the pagestyle from button to tabbed, makes it more self-explanitory visually as to what's going on.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Chrono.dll
Comments
1. Go button must be pressed to get records
2. Shows user # of rows that will be returned & prompts to get all the records.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Audit.dll
Comments
1. Go button must be pressed to get results
2. Dialog displays the number of filtered records and asks to show results (default to no)
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Restitution.dll
Comments
QueryPayment field Amount_Paid not found error fixed.
02/08/06-bl
Tracker # ND32011108 Added payment type
new build to set unique base addresses
In the event that a victim has multiple entries in the amounts_owed table for the same restitution order I added "Distinct" to the IndividualBalanceProcedure query. Multiple entries in the amounts_owed table should now be fixed in the proc also.
first 'production' build of 4.3, ready for testing


 

FileName: Analysis.dll
Comments
updated for ND. This version must be deployed with the updated CreateAnalysisViews and CreateAnalysisViewFirstOffenders.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Schedules.dll
Comments
it 'should' work now


 

FileName: Payment.dll
Comments
datasources on the payment plan data grids had somehow gotten cleared, restored.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Payplan.dll
Comments
added caveat to delete and regenerate payment plan dialog, since it will error out if payments from the plan have been disbursed, and asta won't let me trap the error.
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ViewReminders.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: VictimContacts.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Vehicles.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Updater.exe
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Transports.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: SuspensionHistory.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: SupervisorApprovals.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: SQLPlug.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Smts.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: SchoolAccess.exe
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ResourceSchedule.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Referrals.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ReferralLinkage.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ProgPlacHistory.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: ProbationViolations.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: POHist.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Plans.dll
Comments
new build to set unique base addresses
fixed task datagrid labels
lengthened the task type from 30 to 50 bytes
don't remember what I changed
Standardized grid hints when clicking between goal and task completion notes
first 'production' build of 4.3, ready for testing


 

FileName: PlacementReview.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: PalmSetup.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Otherinc.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Orientation.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: OraRoleUpdater.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: OfficerSafety.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: NorthPointe.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Monikers.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Merge.exe
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: MedicalContacts.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Levels.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Interstate.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: IJOSInterface.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: History.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: FosterCarePlacement.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Fine.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Fees.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: FacBeds.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: DocBatch.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: DNATracking.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: DllLoader.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Detorder.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: DataEntry.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CriminalHistory.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CourtOrders.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Confidential.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Commisary.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CMSMedIns.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CMSIMServer.exe
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: CMSIMClient.exe
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Benefits.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: BarCode.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Alias.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: AFCARSMedical.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: AdHoc.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Activities.dll
Comments
new build to set unique base addresses
first 'production' build of 4.3, ready for testing


 

FileName: Pivot_doug.csv
Comments
first 'production' build of 4.3, ready for testing


 

FileName: Pivot.csv
Comments
first 'production' build of 4.3, ready for testing


 

FileName: DATAMODELER.INI
Comments
first 'production' build of 4.3, ready for testing


 

FileName: CRIMINAL_ACTIVITIES_T.xls
Comments
first 'production' build of 4.3, ready for testing


 

FileName: CRIMINAL_ACTIVITIES.xls
Comments
first 'production' build of 4.3, ready for testing


 

FileName: Analysis_nd.xls
Comments
first 'production' build of 4.3, ready for testing


 

FileName: Analysis_doug.xls
Comments
first 'production' build of 4.3, ready for testing


 

FileName: ANALYSIS.XLS
Comments
first 'production' build of 4.3, ready for testing


 

FileName: American.dct
Comments
first 'production' build of 4.3, ready for testing


 

FileName: ADDICT.CFG
Comments
first 'production' build of 4.3, ready for testing