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_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_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_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 |