Oracle Fusion · Data dictionary
PER_GRADE_LADDERS_F
HCMUsed in 0 subject areas109 reporting columnsBICC incremental-ready
Person / Worker (PER).
Likely primary key: GRADE_LADDER_ID, EFFECTIVE_START_DATE (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_OCCURRENCE_ID | ● | Identifier for the action occurrence. | |
| ACTIVE_STATUS | ● | Status of the active. | |
| ALLOW_PROG_OVERRIDE_FLAG | ● | Indicator (Y/N) for the allow prog override. | |
| ALLOW_SALARY_OVERRIDE_FLAG | ● | Indicator (Y/N) for the allow salary override. | |
| ATTRIBUTE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE16 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE17 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE18 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE19 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE20 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE21 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE22 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE23 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE24 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE25 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE26 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE27 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE28 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE29 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE30 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_CATEGORY | ● | Descriptive flexfield context (structure definition). | |
| ATTRIBUTE_DATE1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_DATE9 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER1 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER10 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER11 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER12 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER13 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER14 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER15 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER16 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER17 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER18 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER19 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER2 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER20 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER3 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER4 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER5 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER6 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER7 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER8 | ● | Descriptive flexfield segment. | |
| ATTRIBUTE_NUMBER9 | ● | Descriptive flexfield segment. | |
| AUTO_PROGRESSION_CODE | ● | Code identifying the auto progression. | |
| AUTO_SAL_CHANGE_CODE | ● | Code identifying the auto sal change. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | PK? | ● | Start date of the effective-dated record. |
| GRADE_LADDER_GRP_CODE | ● | Code identifying the grade ladder grp. | |
| GRADE_LADDER_ID | PK? | ● | Identifier for the grade ladder. |
| GRADE_SET_ID | ● | Identifier for the grade set. | |
| GRADE_TYPE | ● | Type of grade. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGISLATIVE_DATA_GROUP_ID | ● | Identifier for the legislative data group. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PROGRESSION_DATE_CODE | ● | Code identifying the progression date. | |
| PROGRESSION_DATE_RULE_ID | ● | Identifier for the progression date rule. | |
| PROGRESSION_STYLE_CODE | ● | Code identifying the progression style. | |
| PROG_ACTION_ID | ● | Identifier for the prog action. | |
| PROG_ACTION_OCCURRENCE_ID | ● | Identifier for the prog action occurrence. | |
| PROG_ACTION_REASON_ID | ● | Identifier for the prog action reason. | |
| RATE_CHANGE_DATE_CODE | ● | Code identifying the rate change date. | |
| RATE_CHANGE_DATE_RULE_ID | ● | Identifier for the rate change date rule. | |
| RATE_SYNC_ACTION_ID | ● | Identifier for the rate sync action. | |
| RATE_SYNC_ACTION_REASON_ID | ● | Identifier for the rate sync action reason. | |
| SALARY_ACTION_ID | ● | Identifier for the salary action. | |
| SALARY_ACTION_OCCURRENCE_ID | ● | Identifier for the salary action occurrence. | |
| SALARY_ACTION_REASON_ID | ● | Identifier for the salary action reason. | |
| SALARY_ADJUSTMENT_TYPE_CODE | ● | Code identifying the salary adjustment type. | |
| SALARY_CALC_METHOD_CODE | ● | Code identifying the salary calc method. | |
| SALARY_CALC_RULE_ID | ● | Identifier for the salary calc rule. | |
| SALARY_CHANGE_DATE_CODE | ● | Code identifying the salary change date. | |
| SALARY_CHANGE_DATE_RULE_ID | ● | Identifier for the salary change date rule. | |
| SALARY_ELEMENT_TYPE_ID | ● | Identifier for the salary element type. | |
| SALARY_INPUT_VALUE_ID | ● | Identifier for the salary input value. | |
| SALARY_UPD_METHOD_CODE | ● | Code identifying the salary upd method. | |
| STEP_DETERMINATION_CODE | ● | Code identifying the step determination. | |
| UPDATE_SALARY_FLAG | ● | Indicator (Y/N) for the update salary. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Subject areas
- —
Need the extract + dbt staging for PER_GRADE_LADDERS_F?
We ship parameterized SQL, BICC config, and dbt models you own.