"I would double check the user's personalization options, specifically related to date formatting, just to ensure that they haven't tweaked this for any reason. I've seen this cause confusion with dates before..."
"Michael,
Here is the SQL I use to get the Parent Node, Node, Detail Value (Leaf), and Level from trees in PeopleSoft via SQL:
SELECT PSTREENODE.SETID, PSTREENODE.TREE_NAME, PSTREENODE.EFFDT, PARENT_NODE_NAME AS PARENTNODE, TREE_NODE AS…"
"A Prompt Table validates various data fields. For instance, when you are entering a Business Unit, the field is typically validated against a Prompt Table which lists the valid values for that field. When entering a Business Unit online, if the BU…"