PER_RATES_F

HCMUsed in 0 subject areas23 reporting columnsBICC incremental-ready

Person / Worker (PER).

Likely primary key: RATE_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.
ANNUALIZATION_FACTOR		●	Annualization factor.
BUSINESS_GROUP_ID		●	Identifier for the business group.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
CURRENCY_CODE		●	Code identifying the currency.
EFFECTIVE_END_DATE		●	End date of the effective-dated record.
EFFECTIVE_START_DATE	PK?	●	Start date of the effective-dated record.
GRADE_LADDER_ID		●	Identifier for the grade ladder.
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.
LEGISLATION_CODE		●	Code identifying the legislation.
LEGISLATIVE_DATA_GROUP_ID		●	Identifier for the legislative data group.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PAY_SCALE_ID		●	Identifier for the pay scale.
PROGRESSION_RATE_FLAG		●	Indicator (Y/N) for the progression rate.
RATE_FREQUENCY		●	Rate frequency.
RATE_ID	PK?	●	Identifier for the rate.
RATE_OBJECT_TYPE		●	Type of rate object.
RATE_TYPE		●	Type of rate.
RATE_UOM		●	Rate unit of measure.

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_RATES_F?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us