What database items are supported for rates based salary calculations?
If you're defining values by criteria for salary rates, select one of the database items that are supported by HR flows such as new hire and promotion.
Here's the list of individual attribute database items to define values by criteria while using salary rates:
|
Database Item Name |
Display Name |
|---|---|
|
CMP_ASSIGNMENT_SALARY_BASIS_NAME |
Salary Basis |
|
CMP_ASSIGNMENT_SALARY_FTE_VALUE |
Salary FTE |
|
PER_ASG_ACTION_CODE |
Action Code |
|
PER_ASG_ACTION_REASON_CODE |
Action Reason |
|
PER_ASG_ADJUSTED_FTE |
Assignment Adjusted FTE |
|
PER_ASG_ASSIGNMENT_ID |
Assignment ID |
|
PER_ASG_ASSIGNMENT_NUMBER |
Assignment Number |
|
PER_ASG_ASSIGNMENT_STATUS_TYPE |
Assignment Status Type |
|
PER_ASG_BARGAINING_UNIT_CODE |
Bargaining Unit Code |
|
PER_ASG_BARGAINING_UNIT_CODE_NAME |
Bargaining Unit Name |
|
PER_ASG_BUSINESS_UNIT_ID |
Business Unit |
|
PER_ASG_BUSINESS_UNIT_NAME |
Business Unit |
| PER_ASG_COL_AGREEMENT_BARGAINING_UNIT_CODE | Assignment Collective Agreement Bargaining Unit Code |
|
PER_ASG_COLLECTIVE_AGREEMENT_ID |
Collective Agreement |
|
PER_ASG_DEPARTMENT_ID |
Department |
|
PER_ASG_EFFECTIVE_START_DATE |
Assignment Start Date |
|
PER_ASG_EMPLOYEE_CATEGORY |
Assignment Category |
|
PER_ASG_EMPLOYMENT_CATEGORY |
Assignment Category |
|
PER_ASG_ESTABLISHMENT_ID |
Establishment |
|
PER_ASG_FREQUENCY |
Frequency |
| PER_ASG_FTE_VALUE | Assignment FTE Value |
| PER_ASG_FULL_PART_TIME | Assignment Full Part Time |
|
PER_ASG_GRADE_CODE |
Grade Code |
|
PER_ASG_GRADE_ID |
Grade |
| PER_ASG_GRADE_LADDER_NAME | Assignment Grade Ladder Name |
|
PER_ASG_GRADE_LADDER_PGM_ID |
Grade Ladder |
|
PER_ASG_GRADE_NAME |
Grade |
|
PER_ASG_GRADE_STEP_ID |
Grade Step |
| PER_ASG_GSP_ELIGIBILITY_FLAG | Assignment Grade Step Progression Eligibility Indicator |
|
PER_ASG_JOB_CODE |
Job Code |
| PER_ASG_JOB_FUNCTION_CODE | Assignment Job Function Code |
|
PER_ASG_JOB_ID |
Job |
|
PER_ASG_JOB_MANAGER_LEVEL |
Job Manager Level |
|
PER_ASG_JOB_MANAGER_LEVEL_NAME |
Job Manager Level Name |
|
PER_ASG_JOB_NAME |
Job |
| PER_ASG_JOB_REGULAR_TEMPORARY | Assignment Job Regular or Temporary |
|
PER_ASG_LEGAL_ENTITY_ID |
Legal Entity |
| PER_ASG_LOCATION_CODE | Assignment Location Code |
|
PER_ASG_LOCATION_ID |
Location |
|
PER_ASG_LOCATION_NAME |
Location |
|
PER_ASG_NORMAL_HOURS |
Normal Hours |
|
PER_ASG_ORG_DEPARTMENT_NAME |
Department |
|
PER_ASG_ORG_LEGAL_EMPLOYER_NAME |
Legal Employer |
|
PER_ASG_ORG_LEGAL_EMPLOYER_NAME |
Legal Employer |
|
PER_ASG_POS_POS_CODE |
Position Code |
|
PER_ASG_POSITION_NAME |
Position Name |
| PER_ASG_PRIMARY_ASSIGNMENT_FLAG | Assignment Primary Assignment Indicator |
| PER_ASG_PRIMARY_ASSIGNMENT_FLAG_LOOKUP_MEANING | Assignment Primary Assignment Indicator - Lookup Meaning |
| PER_ASG_PRIMARY_FLAG | Assignment Primary Indicator |
| PER_ASG_PRIMARY_WORK_RELATION_FLAG | Assignment Primary Work Relationship Indicator |
|
PER_ASG_STANDARD_WORKING_HOURS |
Working Hours |
|
PER_ASG_STANDARD_WORKING_HOURS_FREQUENCY |
Working Hours Frequency |
|
PER_ASG_STANDARD_WORKING_HOURS_FREQUENCY_LOOKUP_MEANING |
Working Hours Frequency Meaning |
|
PER_ASG_UNION_ID |
Worker Union ID |
|
PER_ASG_UNION_NAME |
Worker Union Name |
|
PER_GRADE_STEP_NAME |
Grade Step |
|
PER_JOB_FAMILY_ID |
Job Family |
|
PER_JOB_FAMILY_NAME |
Job Family |
|
PER_PERSON_ENTERPRISE_HIRE_DATE |
Hire Date |
Here's the list of flexfield attribute database items to define values by criteria while using salary rates:
|
Flexfield Name |
Description |
Database Item Name |
|---|---|---|
|
PER_ASG_DFF |
Assignment Flexfield |
PER_ASG_ATTRIBUTE_CATEGORY |
|
PER_ASG_ATTRIBUTE1 … PER_ASG_ATTRIBUTE50 |
||
|
PER_ASG_ATTRIBUTE_DATE1 … PER_ASG_ATTRIBUTE_DATE15 |
||
|
PER_ASG_ATTRIBUTE_NUMBER1 … PER_ASG_ATTRIBUTE_NUMBER20 |
||
|
PER_GRADES_DFF |
Grade Flexfield |
PER_ASG_GRADE_ATTRIBUTE_CATEGORY |
|
PER_ASG_GRADE_ATTRIBUTE1 … PER_ASG_GRADE_ATTRIBUTE30 |
||
|
PER_ASG_GRADE_ATTRIBUTE_DATE1 … PER_ASG_GRADE_ATTRIBUTE_DATE15 |
||
|
PER_ASG_GRADE_ATTRIBUTE_NUMBER1 … PER_ASG_GRADE_ATTRIBUTE_NUMBER20 |
||
|
PER_JOBS_DFF |
Job Flexfield |
PER_ASG_JOB_ATTRIBUTE_CATEGORY |
|
PER_ASG_JOB_ATTRIBUTE1 … PER_ASG_JOB_ATTRIBUTE30 |
||
|
PER_ASG_JOB_ATTRIBUTE_DATE1 … PER_ASG_JOB_ATTRIBUTE_DATE15 |
||
|
PER_ASG_JOB_ATTRIBUTE_NUMBER1 … PER_ASG_JOB_ATTRIBUTE_NUMBER20 |
||
|
PER_LOCATIONS_DFF |
Location Flexfield |
PER_ASG_LOC_ATTRIBUTE_CATEGORY |
|
PER_ASG_LOC_ATTRIBUTE1 … PER_ASG_LOC_ATTRIBUTE30 |
||
|
PER_POSITIONS_DFF |
Position Flexfield |
PER_ASG_POS_ATTRIBUTE_CATEGORY |
|
PER_ASG_POS_ATTRIBUTE1 … PER_ASG_POS_ATTRIBUTE30 |
||
|
PER_ASG_POS_ATTRIBUTE_DATE1 … PER_ASG_POS_ATTRIBUTE_DATE15 |
||
|
PER_ASG_POS_ATTRIBUTE_NUMBER1 … PER_ASG_POS_ATTRIBUTE_NUMBER20 |