Database Items for Use in Salary Value by Criteria Rate Definitions
You can use these delivered database items in Value by Criteria rate definitions for salary bases. They let you detect proposed information in various flows, including Hire an Employee, and use the proposed attributes to calculate rate values.
| Attribute Name | Database Item Name | Comments |
|---|---|---|
| Business Unit | PER_ASG_BUSINESS_UNIT_ID | |
| PER_ASG_BUSINESS_UNIT_NAME | ||
| Location | PER_ASG_LOCATION_NAME | |
| Legal Employer | PER_ASG_ORG_LEGAL_EMPLOYER_NAME | |
| Department | PER_ASG_ORG_DEPARTMENT_NAME | |
| Worker Category | PER_ASG_EMPLOYEE_CATEGORY | |
| PER_ASG_EMPLOYEE_CATEGORY_MEANING | ||
| PER_ASG_EMPLOYMENT_CATEGORY | ||
| PER_ASG_EMPLOYMENT_CATEGORY_MEANING | ||
| Role | PER_EXT_PER_ROLE_ABSTRACT_ROLE | |
| PER_EXT_PER_ROLE_DATA_ROLE | ||
| PER_EXT_PER_ROLE_JOB_ROLE | ||
| PER_EXT_PER_ROLE_NAME | ||
| Period of Service (seniority) | PER_ASG_REL_LENGTH_OF_SERVICE | |
| PER_ASG_REL_ADJUSTED_SVC_DATE | ||
| Legal Employer Level Seniority Date | PER_ASG_REL_ADJUSTED_SVC_DATE. | Returns seniority date in a legal employer (relationship seniority date). |
| Enterprise Seniority Date | PAYROLL_INTERFACE_ORIGINAL_DATE_OF_HIRE | Returns first original date of hire regardless of legal employer. |
| Legal Employer Level Hire Date | PER_ASG_REL_ORIGINAL_DATE_OF_HIRE | Returns relationship original date of hire. |
| Enterprise Hire Date | PER_PERSON_ENTERPRISE_HIRE_DATE | Returns earliest relationship start date, which is the first hire date regardless of legal employer. |
| Number of Child Dependents | PER_PER_CONTACT_DEPEN_CHILD_COUNT | |
| PER_PER_CONTACT_DEPEN_CHILD_COUNT_LOC | ||
| Age of Children | PER_PER_DEPENDENT_UNDER_AGE. | Children younger than a certain age. A child is defined by the Child contact type and the selection of the Statutory dependent option. |
| PER_PER_DEPENDENT_AGE_BETWEEN. | Children between two defined ages. A child is defined by the Child contact type and the selection of the Statutory dependent option. | |
| Extract Contact Type | PER_EXT_CONT_CONTACT_TYPE | |
| Extract Contact Country Name | PER_EXT_CONT_COUNTRY_NAME | |
| Assignment Number | PER_ASG_ASSIGNMENT_NUMBER | |
| Assignment ID | PER_ASG_ASSIGNMENT_ID | |
| Assignment Start Date | PER_ASG_EFFECTIVE_START_DATE | |
| Hire Date | PER_PERSON_ENTERPRISE_HIRE_DATE | |
| Job | PER_ASG_JOB_ID | |
| PER_ASG_JOB_NAME | ||
| Job Code | PER_ASG_JOB_CODE | |
| Job Family | PER_JOB_FAMILY_ID | |
| PER_JOB_FAMILY_NAME | ||
| Business Unit | PER_ASG_BUSINESS_UNIT_ID | |
| PER_ASG_BUSINESS_UNIT_NAME | ||
| Location | PER_ASG_LOCATION_ID | |
| PER_ASG_LOCATION_NAME | ||
| Department | PER_ASG_DEPARTMENT_ID | |
| PER_ASG_ORG_DEPARTMENT_NAME | ||
| Legal Entity | PER_ASG_LEGAL_ENTITY_ID | |
| Legal Employer | PER_ASG_ORG_LEGAL_EMPLOYER_NAME | |
| Normal Hours | PER_ASG_NORMAL_HOURS | |
| Assignment Category | PER_ASG_EMPLOYEE_CATEGORY | |
| PER_ASG_EMPLOYMENT_CATEGORY | ||
| Legal Employer | PER_ASG_ORG_LEGAL_EMPLOYER_NAME | |
| Assignment Flex | PER_ASG_DF | Descriptive flexfield. |
| Grade Flex | PER_GRADES_DF | Descriptive flexfield. |
| Grade Code | PER_ASG_GRADE_CODE | |
| Grade | PER_ASG_GRADE_ID | |
| PER_ASG_GRADE_NAME | ||
| Grade Ladder | PER_ASG_GRADE_LADDER_PGM_ID | |
| Grade Step | PER_ASG_GRADE_STEP_ID | |
| PER_GRADE_STEP_NAME | ||
| Location Flex | PER_LOCATIONS_DF | Descriptive flexfield. |
| Grade | PER_ASG_GRADE_NAME | |
| Salary Basis | CMP_ASSIGNMENT_SALARY_BASIS_NAME | Works in only flows that have both employment and salary sections included. Won’t work in the standalone Change Salary flow |
| Action | PER_ASG_ACTION_CODE | |
| Reason | PER_ASG_ACTION_REASON_CODE |