1. Implementing Global Human Resources
  2. Retained Grade Context of the Assignment Extensible Flexfield

Retained Grade Context of the Assignment Extensible Flexfield

This table describes the lookup and SQL information for the different grade-related fields in the Retained Grade context of the Assignment extensible flexfield (EFF).

Grade Field

Related Lookup and Usage

SQL Clause

Start Date and End Date

The start and end date of the retained grade entered by the user.

Note: The start and end date fields are different from the effective start and end date fields. The start and end date fields contain user entered values whereas effective start and end date fields contain application maintained values for the retained grade records.

Not applicable.

Pay Table ID

The ORA_PER_RETGRD_GRADE_LADDER_VS lookup controls the Pay Table ID field. By default, the field displays all active grade ladders between the selected start and end date of the retained grade.

These are the SQL code clauses used by the Pay Table ID field:

FROM Clause : PER_GRADE_LADDERS_F_VL GradeLadder, FND_SETID_SETS_VL SetId

Value Column Name: SUBSTR(NAME,1,100)

WHERE Clause : GradeLadder.GRADE_SET_ID = SetId.SET_ID(+) AND :{SEGMENT.ORA_PER_RETGRD_START_DATE_S} <= EFFECTIVE_END_DATE and :{SEGMENT.ORA_PER_RETGRD_END_DATE_S} >= EFFECTIVE_START_DATE

Grade

The ORA_PER_RETGRD_GRADE_VS lookup controls the Grade field. By default, the field displays all active grades that belong to the selected grade ladder.

Note: If the grade ladder isn't selected, the Grade field displays all active grades in the application that are valid between the selected start and end date of the retained grade.

These are the SQL code clauses used by the Grade field:

FROM Clause : per_grades_f_vl grades left outer join PER_GRADES_IN_LADDERS_F gradeinladder ON grades.grade_id = gradeinladder.grade_id

Value Column Name: SUBSTR(grades.NAME,1,100)

WHERE Clause : {SEGMENT.ORA_PER_RETGRD_START_DATE_S} <= grades.EFFECTIVE_END_DATE and :{SEGMENT.ORA_PER_RETGRD_END_DATE_S} >= grades.EFFECTIVE_START_DATE and grades.ACTIVE_STATUS = 'A' and (1= (CASE WHEN (:{SEGMENT.ORA_PER_RETGRD_GRADE_LADDER_S} is NULL) THEN 1 ELSE 2 END) OR gradeinladder.GRADE_LADDER_ID = to_number(:{SEGMENT.ORA_PER_RETGRD_GRADE_LADDER_S}))

Step

The ORA_PER_RETGRD_GRADE_STEP_VS lookup controls the Step field. By default, the field displays all grade steps that belong to the selected grade, and are active between the selected start and end date of the retained grade.

Note: If the grade isn't selected, the Step field doesn't display any value.

These are the SQL code clauses used by the Step field:

FROM Clause : per_grade_steps_f_vl

Value Column Name: SUBSTR(NAME,1,100)

WHERE Clause : GRADE_ID = to_number(:{SEGMENT.ORA_PER_RETGRD_GRADE_S}) and :{SEGMENT.ORA_PER_RETGRD_START_DATE_S} <= EFFECTIVE_END_DATE and :{SEGMENT.ORA_PER_RETGRD_END_DATE_S} >= EFFECTIVE_START_DATE
Pay Basis The ORA_PER_RETGRD_PAY_BASIS_VS lookup controls the Pay Basis field. The lookup is SQL query-based and displays the existing retained grade data entered by the user in the Pay Basis field from the PER_ASSIGNMENT_EXTRA_INFO_M table.

These are the SQL code clauses used by the Pay Basis field:

FROM Clause : (SELECT DISTINCT AEI_ATTRIBUTE6 FROM PER_ASSIGNMENT_EXTRA_INFO_M_V)

Value Column Name: SUBSTR(AEI_ATTRIBUTE6,1,100)

WHERE Clause : AEI_ATTRIBUTE6 IS NOT NULL
Pay Plan The ORA_PER_RETGRD_PAY_PLAN_VS lookup controls the Pay Plan field. The lookup is SQL query-based and displays the existing retained grade data entered by the user in the Pay Plan field from the PER_ASSIGNMENT_EXTRA_INFO_M table.

These are the SQL code clauses used by the Pay Plan field:

FROM Clause : ( SELECT DISTINCT AEI_ATTRIBUTE7 FROM PER_ASSIGNMENT_EXTRA_INFO_M_V )

Value Column Name: SUBSTR(AEI_ATTRIBUTE7,1,100)

WHERE Clause : AEI_ATTRIBUTE7 IS NOT NULL