Agenda

As Of When? Understanding Date, Time, and Effective Date in HCM & Queries

Track: Technical and Reporting

Session Number: 10584
Date: Tue, Mar 5th, 2024
Time: 10:00 AM - 11:00 AM

Description:

As of when? It’s the most important question you can ask. Databases are like rivers. They’re always moving and changing, and their relevant data changes from minute to minute. Understanding how database software platforms use Date, Time, Effective Date, and Effective Sequence is critical to obtaining valid, accurate, and relevant information, both in functional operations and in queries and decision making. The primary focus of this course is Oracle HCM, PS Query, and SQL. However, the basic concepts directly relate to Oracle SIS. In this session, you will learn:

• How computers and HCM / SIS platforms “understand” and use Date & Time (what the computer is thinking)
• How that relates to you and your concept of date and time (what your bosses & customers are thinking)
• What “Effective Date” really is and why it’s absolutely critical to everything
• Effective Sequence and how/where it is used
• How all of the above are critical to data queries in both PS Query and SQL
• Common SQL operators that are used for manipulating date, time and Effective_Date/Sequence
• A few of my most useful query expressions (including the really sneaky ones!)
Sub-Categorization: Best Practices, Automation, Dev Ops
Session Type: Presentation

Focus Area: Data to Decisions
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1734, trk-1741, trk-1796, trk-1732
ERP Systems: Oracle, Other
Knowledge Level: Intermediate
Field of Study: Computer Software and Applications
CPE: Yes
Sub-Categorization: Best Practices, Automation, Dev Ops
Session Type: Presentation

Focus Area: Data to Decisions
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1734, trk-1741, trk-1796, trk-1732
ERP Systems: Oracle, Other
Knowledge Level: Intermediate
Field of Study: Computer Software and Applications
CPE: Yes