| 
						
					 | 
					
						
						
							
						
						09d1e93404
					 | 
					
						
						
							
							Cleaned up fomat plant list
						
						
						
						
						
						
					 | 
					
						2023-12-08 14:42:42 -05:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Chris Glavan
							
						 
					 | 
					
						
						
							
						
						f320c8a865
					 | 
					
						
						
							
							~Fixed ALTER TABLE statement that adds the ApplicablePlant column to the Formats table so that it checks if the column exists
						
						
						
						
						
						
					 | 
					
						2023-10-18 09:06:08 -04:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Chris Glavan
							
						 
					 | 
					
						
						
							
						
						8f17b49287
					 | 
					
						
						
							
							~Modified PROMSFixes.sql to update ApplicablePlant formats that are Generic before updating plant-specific due to potential for a plant-specific format description to have the word generic in it.
						
						
						
						
						
						
					 | 
					
						2023-10-05 15:29:50 -04:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Chris Glavan
							
						 
					 | 
					
						
						
							
						
						cbcf7c845d
					 | 
					
						
						
							
							~Restructured PROMSFixes.sql to add updates above section that lists RevDate and RevDescription
						
						
						
						
						
						
					 | 
					
						2023-10-03 11:09:47 -04:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Chris Glavan
							
						 
					 | 
					
						
						
							
						
						4be7cdc6c7
					 | 
					
						
						
							
							~Added database changes to PROMSFixes.sql
						
						
						
						
						
						
					 | 
					
						2023-10-03 09:18:53 -04:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						6712671d04
					 | 
					
						
						
							
							B2022-124: [JPR] Blank RO Values (All Spaces) printing as "?"
						
						
						
						
						
						
					 | 
					
						2022-10-03 17:56:12 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						7c9a722eba
					 | 
					
						
						
							
							B2022-121: RO values containing curly braces around values that are NOT multi return values do not resolved in Word Sections.
						
						
						
						
						
						
					 | 
					
						2022-09-21 21:05:41 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						a858733052
					 | 
					
						
						
							
							B2022-104: SearchReferenced Objects in PROMS is not finding any results
						
						
						
						
						
						
					 | 
					
						2022-08-23 11:28:11 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						c2351ce363
					 | 
					
						
						
							
							
						
						
						
						
						
						
					 | 
					
						2022-08-16 16:04:11 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						ac8e8432b7
					 | 
					
						
						
							
							B2022-098: ROs not being resolved in Word Sections
						
						
						
						
						
						
					 | 
					
						2022-08-16 15:02:30 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						b6d69fbd4c
					 | 
					
						
						
							
							B2022-049: Copy/paste of enhanced procedure and bad links between source and enhanced
						
						
						
						
						
						
					 | 
					
						2022-08-03 15:03:40 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						78bd41dc56
					 | 
					
						
						
							
							B2022-082: Search for THEN STOP not finding occurrences in RNOs
						
						
						
						
						
						
					 | 
					
						2022-07-29 13:32:16 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						6dff9463ad
					 | 
					
						
						
							
							B2022-083: Support Conditional RO Values (v2.1) [Part-2]
						
						
						
						
						
						
					 | 
					
						2022-07-28 10:03:07 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						7ad89759de
					 | 
					
						
						
							
							B2022-074 needed to move the drop/creation of vwRofstDat_RofstHeaderStatuses to before the drop/creation of vwRofstData_Rofstheaders
						
						
						
						
						
						
					 | 
					
						2022-07-12 15:22:55 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						e40872a3ed
					 | 
					
						
						
							
							B2022-026: RO Memory Reduction Coding
						
						
						
						
						
						
					 | 
					
						2022-06-24 20:19:18 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						fa5d78f844
					 | 
					
						
						
							
							B2022-047: Tables search – refresh data to allow search to find text in tables
						
						
						
						
						
						
					 | 
					
						2022-06-02 13:12:58 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						0acedd7e7a
					 | 
					
						
						
							
							B2022-010 stored procedure getAssociationsByVersionID was loading RO FST information that was not needed.
						
						
						
						
						
						
					 | 
					
						2022-01-17 17:50:01 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						ea93a6030a
					 | 
					
						
						
							
							B2021-110 Remove the un-used and un-maintained BNPPclk format file from PROMS.
						
						
						
						
						
						
					 | 
					
						2022-01-07 15:43:59 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						4b9234a70e
					 | 
					
						
						
							
							F2021-069 – Make sure the customers do not have the “BNPP Single Column Format (draft)” format (BNPPgop).
						
						
						
						
						
						
					 | 
					
						2021-11-23 15:25:29 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						79c5aa0c4d
					 | 
					
						
						
							
							
						
						
						
						
						
						
					 | 
					
						2021-08-26 19:03:56 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Jake
							
						 
					 | 
					
						
						
							
						
						ae108efde1
					 | 
					
						
						
							
							B2021-098 – Modified the existing functions and stored procedure for the search.  Added new indexes to increase performance. Created new views / stored procedure to check and rebuild indexes if need. Added a statement to automatically run the Index rebuild utility when the PROMSFixes.sql file is executed
						
						
						
						
						
						
					 | 
					
						2021-08-26 16:27:33 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						4a70a927be
					 | 
					
						
						
							
							C2021-031 added vesp_RemoveUnUsedFormat stored procedure which will remove the given format and point any uses of that format (including history records) to the PROMS Base format.
						
						
						
						
						
						
					 | 
					
						2021-07-06 18:14:57 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						aa9c2574bf
					 | 
					
						
						
							
							
						
						
						
						
						
						
					 | 
					
						2021-06-25 18:29:32 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						b190deb8c7
					 | 
					
						
						
							
							B2021-037: Approval Inconsistencies Report was listing transition items that should not be in report
						
						
						
						
						
						
					 | 
					
						2021-04-07 12:37:24 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						7c92953eeb
					 | 
					
						
						
							
							B2021-031: Grouping/ordering of items in the Chronology Report is not always correct
						
						
						
						
						
						
						
						B2020-156: When a procedure title is changed, it does not appear in Summary or Chronology of Changes reports 
						
						
					 | 
					
						2021-03-22 14:28:05 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						2868362fe2
					 | 
					
						
						
							
							B2021-025: Limit RO items in Approved Procedures Inconsistencies Report
						
						
						
						
						
						
					 | 
					
						2021-03-17 11:35:50 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						780e8d1503
					 | 
					
						
						
							
							B2020-094: Saving of Folder properties crashed
						
						
						
						
						
						
					 | 
					
						2020-07-30 10:10:51 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						b8d46d3768
					 | 
					
						
						
							
							B2020-091: Section deletes even if transition point to it
						
						
						
						
						
						
					 | 
					
						2020-07-15 12:45:30 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						6f42f911f7
					 | 
					
						
						
							
							C2020-009 Search By Word
						
						
						
						
						
						
					 | 
					
						2020-05-04 14:09:48 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						de58331ffb
					 | 
					
						
						
							
							C2017-003: Support SQL Server for storing of Referenced Object data
						
						
						
						
						
						
					 | 
					
						2020-01-09 15:39:17 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						beed3319ca
					 | 
					
						
						
							
							C2019-045: Fix length of procedure number for CCR to work
						
						
						
						
						
						
						
						C2019-045: For enhanced procedures, allow modification of number & title 
						
						
					 | 
					
						2019-12-13 11:51:15 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						ed0b1d2b74
					 | 
					
						
						
							
							B2019-180 Fixes a duplicate key error when searching more than one procedure set.
						
						
						
						
						
						
					 | 
					
						2019-12-11 19:42:03 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						44011a3672
					 | 
					
						
						
							
							B2019-081 Improved performance for Global Search of text
						
						
						
						
						
						
					 | 
					
						2019-12-10 20:44:56 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						550200acf6
					 | 
					
						
						
							
							B2019-023 Fixed case sensitive search in Word attachments
						
						
						
						
						
						
						
						B2019-016 include RNO step type in the searchable list 
						
						
					 | 
					
						2019-04-23 19:11:44 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					
						
							
							
								 
								Kathy
							
						 
					 | 
					
						
						
							
						
						e2392f5fec
					 | 
					
						
						
							
							C2018-039: Upgrade – User Control of Format
						
						
						
						
						
						
					 | 
					
						2018-12-12 15:25:53 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 | 
				
			
				
					| 
						
					 | 
					
						
						
							
						
						d5514caf4c
					 | 
					
						
						
							
							
						
						
						
						
						
						
					 | 
					
						2018-09-27 18:12:36 +00:00 | 
					
					
						
						
						
							
							
							
							
							
							
							
							
						
					 |