Technology Adjacent

I have a query I am trying to write against a custom table within PeopleSoft.  This custom table has some character columns that are free form, but in this case storing dates, so the user can type something like "03/14/2017" for March 14, 2017.  The query needs to evaluate these entries as date criteria, determining whether the date in the column is less than the current date. This is a little challenging because the field could be populate or it could be empty, although in PeopleSoft empty actually means a single space character.  We are also assuming that if it is populated it is always in the format MM/DD/YYYY. A couple different approaches are below, but obviously there are huge issues with this type of implementation... what happens is someone enters something that doesn't even look like a date?  Probably an error. At least in my case the data entry is somewhat controlled.  In both examples I do want to return rows where the date column is blank or th...

Personalize links as displayed on a PeopleSoft grid. PeopleSoft provides individual users the ability to customize the display of various pages and grids using the "Personalize" links.  This can be useful for power users who want to streamline their pages and filter out unnecessary details.  It can, however, present some challenges for administrators. While testing a recent PeopleTools and HCM Image update an issue was reported in which three columns of a grid were not displaying.  The component was HRS_JO_360, part of the Recruitment/Talent Acquisition module.  Of the two columns not displaying one was custom and two delivered.  In the place of two of these columns was a checkbox with the column heading "Select". After some troubleshooting we found that the columns displayed correctly for some users, then that all three displayed correctly for a user with the same security roles as the user with the original issue.  We spent some time looking at ot...