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 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_ASSIGNMENT_ID |
Assignment ID |
|
PER_ASG_ASSIGNMENT_NUMBER |
Assignment Number |
|
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_COLLECTIVE_AGREEMENT_ID |
Collective Agreement |
|
PER_ASG_DEPARTMENT_ID |
Department |
|
PER_ASG_DF |
Assignment Flexfield |
|
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_GRADE_CODE |
Grade Code |
|
PER_ASG_GRADE_ID |
Grade |
|
PER_ASG_GRADE_LADDER_PGM_ID |
Grade Ladder |
|
PER_ASG_GRADE_NAME |
Grade |
|
PER_ASG_GRADE_STEP_ID |
Grade Step |
|
PER_ASG_JOB_CODE |
Job 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_LEGAL_ENTITY_ID |
Legal Entity |
|
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_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_GRADES_DF |
Grade Flexfield |
|
PER_JOB_FAMILY_ID |
Job Family |
|
PER_JOB_FAMILY_NAME |
Job Family |
|
PER_JOBS_DFF |
Job Flexfield |
|
PER_LOCATIONS_DF |
Location Flexfield |
|
PER_PERSON_ENTERPRISE_HIRE_DATE |
Hire Date |
|
PER_POSITIONS_DFF |
Position Flexfield |