User Entities for Extracting Rate-Based Salary Components
You can extract rates-based component details on a particular date or for a particular date range for payroll processing and interfacing with tools such as HCM Extracts. The user entities to use are ORA_CMP_ASSIGNMENT_SALARY_RATES_UE and ORA_CMP_ASSIGNMENT_SALARY_RATES_RGE_UE.
To get the rate amount for a specific assignment base rate, use the GET_SALARY_RATE_DATA function.
ORA_CMP_ASSIGNMENT_SALARY_RATES_UE
Use the Assignment Salary Rates Data user entity to extract this information on a particular date:
- Assignment Salary Rate Salary Identifier
- Assignment Salary Rate Assignment Identifier
- Assignment Salary Rate Salary Date From
- Assignment Salary Rate Salary Date To
- Assignment Salary Rate Base Name
- Assignment Salary Rate Factor
- Assignment Salary Rate Amount
- Assignment Salary Rate Annual Amount
- Assignment Salary Rate Annual Full-time Amount
- Assignment Salary Rate Frequency Code
- Assignment Salary Rate Currency Code
- Assignment Salary Rate Overall Salary Indicator
- Assignment Salary Rate Full-time Indicator
- Assignment Salary Rate Pay Component Identifier
- Assignment Salary Rate Salary Basis Identifier
- Assignment Salary Rate Display Sequence
- Assignment Salary Rate Base Salary Indicator
- Assignment Salary Rate Definition Identifier
ORA_CMP_ASSIGNMENT_SALARY_RATES_RGE_UE
Use the Assignment Salary Rates Data user entity to extract this information for a date range:
- Assignment Salary Rate Salary Identifier Array
- Assignment Salary Rate Assignment Identifier Array
- Assignment Salary Rate Salary Date From Array
- Assignment Salary Rate Salary Date To Array
- Assignment Salary Rate Base Name Array
- Assignment Salary Rate Factor Array
- Assignment Salary Rate Amount Array
- Assignment Salary Rate Annual Amount Array
- Assignment Salary Rate Annual Full-time Amount Array
- Assignment Salary Rate Frequency Code Array
- Assignment Salary Rate Currency Code Array
- Assignment Salary Rate Overall Salary Indicator Array
- Assignment Salary Rate Full-time Indicator Array
- Assignment Salary Rate Pay Component Identifier Array
- Assignment Salary Rate Salary Basis Identifier Array
- Assignment Salary Rate Display Sequence Array
- Assignment Salary Rate Base Salary Indicator Array
- Assignment Salary Rate Definition Identifier Array