SQL Query to identify person relationship with Organization
Do you know how to get the Person's relationship with the organization? Candidate, Employee, Ex-Employee, Pending Worker, etc. Read on to know more details.
All posts on Sample SQL Queries
How to Mask Work Email Address in Dev or Test instance post P2T Refresh
Do you know how to mask the work email address for employees in Dev/Test POD post P2T refresh? Read on to know more details.
How to Reverse Terminate employees using HDL?
Do you know how to reverse terminate employees using HDL? Can you use SQL Query to generate the HDL file for reverse termination? Read on to know more details.
SQL Query to fetch ORC Candidate Job Application Status
Do you know how to fetch the Candidate Job Application Status in ORC? What are the different Phases/States for a candidate Job Application? Read on to know more details
How to Export Jobs from one POD to another using HDL?
Do you know how to export the Job Business object into HDL which can be used to import Jobs into target POD? Read on to know more details.
SQL Query to get Unique and Active Line Managers Names
Do you know how to fetch the unique and active line managers? Can we have that as a list of values for a DFF? Read on to know more details.
Sample Table Valuesets for ready reference
Do you know the table valuesets and their usage in the HCM application? Check out the sample valuesets to get the absence count within date range, phone number, expat employee check, costing segments for an organization.
Personal Payment Method, its importance and query for Active Employees
Do you know what is personal payment method and how to query the personal payment method details for active employees? Read on to know more details.
SQL Query to pull the Payroll Balance Feeds
Do you know how to extract the Payroll Balance Feed details for a balance? Read on to know more details.
SQL Query to get the Payroll Name, Time Card Required Flag from Payroll Relationship Screen
Do you know how to get the Payroll Relationship, Payroll Name and Time Card Required Flag from Payroll Relationship Screen? Read on to know more details.