PAY_ELE_CLASSIFICATIONS

PayrollUsed in 0 subject areas26 reporting columnsBICC incremental-ready

Payroll (PAY).

Primary key: not yet catalogued for PAY_ELE_CLASSIFICATIONS — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

Column	Key	In reports	Description (inferred)
BASE_CLASSIFICATION_ID		●	Identifier for the base classification.
BASE_CLASSIFICATION_NAME		●	Name of the base classification.
CLASSIFICATION_ID		●	Identifier for the classification.
COSTABLE_FLAG		●	Indicator (Y/N) for the costable.
COSTING_DEBIT_OR_CREDIT		●	Costing debit or credit.
CREATED_BY		●	User who created the row.
CREATE_BY_DEFAULT_FLAG		●	Indicator (Y/N) for the create by default.
CREATION_DATE		●	Date and time the row was created.
DATE_FROM		●	Date from.
DATE_TO		●	Date to.
DEFAULT_HIGH_PRIORITY		●	Default high priority.
DEFAULT_LOW_PRIORITY		●	Default low priority.
DEFAULT_PRIORITY		●	Default priority.
DISTRIBUTABLE_OVER_FLAG		●	Indicator (Y/N) for the distributable over.
FREQ_RULE_ENABLED		●	Freq rule enabled.
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.
MODULE_ID		●	Identifier for the module.
NON_PAYMENTS_FLAG		●	Indicator (Y/N) for the non payments.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PARENT_CLASSIFICATION_ID		●	Identifier for the parent classification.
PROCESS_WHEN_EARNING		●	Process when earning.
SECONDARY_CLASSIFICATION_FLAG		●	Indicator (Y/N) for the secondary classification.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Need the extract + dbt staging for PAY_ELE_CLASSIFICATIONS?

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