Database Items That Can Detect Proposed Info in Salary Value by Criteria Rate Definitions
You can detect proposed information and calculate rate values in various flows, such as Hire an Employee, and Local and Global Transfer, when using these special database items in Value by Criteria rate definitions.
Other database items won’t detect the proposed information and will thus calculate rate values based on information in the database tables.
| Attribute Name | Database Item Name | Comments |
|---|---|---|
| Business Unit | PER_ASG_BUSINESS_UNIT_ID | |
| 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_MEANING | |
| PER_ASG_EMPLOYMENT_CATEGORY_MEANING | ||
| Period of Service (seniority) | PER_ASG_REL_LENGTH_OF_SERVICE | |
| 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 | ||
| Assignment Number | PER_ASG_ASSIGNMENT_NUMBER | |
| Assignment ID | PER_ASG_ASSIGNMENT_ID | |
| Assignment Start Date | PER_ASG_EFFECTIVE_START_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_NAME | |
| Location | PER_ASG_LOCATION_ID | |
| Department | PER_ASG_DEPARTMENT_ID | |
| Legal Entity | PER_ASG_LEGAL_ENTITY_ID | |
| 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 | |
| Grade Ladder | PER_ASG_GRADE_LADDER_PGM_ID | |
| Grade Step | 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 |