Assignment Category and Worker Category Table in Oracle Fusion HCM
- Post author: Oracle Cloud Hub
- Post last modified: 26 February 2024
Below Query will help us fetch the Assignment Category and Worker Category for a given assignment.
Above code will return the below output
Navigate to the assignment details screen to view data from UI
You Might Also Like
Oracle Fusion HCM Technical Consultant Skills
Fast Formula Types based on modules in Oracle Fusion HCM Cloud
Query to Fetch the Payroll Assigned to a Person in Oracle Fusion HCM
- Tables and Views for HCM
HCM Tables and Views
This guide contains the information about tables within Oracle HCM Cloud and their columns, primary keys, and indexes. The guide also includes the information about views within Oracle HCM Cloud along with the columns and queries associated with each view. For your reference:
Tables are the basic unit of data storage in Oracle HCM Cloud, where data is stored in rows and columns. For example, the PER_ASG_RESPONSIBILITIES table stores general information about a person's areas of responsibility defined by reference to existing workforce structures. This table stores attributes such as start and end date of responsibility, type of responsibility, status, organization, location, and assignment category.
A view is a logical representation of a table or combination of tables. A view is a stored query that derives its data from the tables on which it is based. For example, the PER_DISPLAY_PHONES_V view shows attributes such as phone type, phone number, speed dial number, extension, country code, and person identifier.
IMAGES