PAY_TIME_PERIODS

PayrollUsed in 0 subject areas32 reporting columnsBICC incremental-ready

Payroll (PAY) — accounting / calendar period reference.

Likely primary key: TIME_PERIOD_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Columns

Column	Key	In reports	Description (inferred)
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
CUT_OFF_DATE		●	Cut off date.
DEFAULT_PAYDATE		●	Default paydate.
DESCRIPTION		●	Description.
END_DATE		●	End date.
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.
PAYROLL_ID		●	Identifier for the payroll.
PAYSLIP_VIEW_DATE		●	Payslip view date.
PERIOD_CATEGORY		●	Period category.
PERIOD_NAME		●	Name of the period.
PERIOD_NUM		●	Period number.
PERIOD_SET_NAME		●	Name of the period set.
PERIOD_TYPE		●	Type of period.
PERIOD_YEAR		●	Period year.
PROCESS_SUB_DATE		●	Process sub date.
PROC_PERIOD_TYPE		●	Type of proc period.
QUARTER_NUM		●	Quarter number.
QUICKPAY_DISPLAY_NUMBER		●	Quickpay display number.
REGULAR_EARN_DATE		●	Regular earn date.
REGULAR_PROCESS_DATE		●	Regular process date.
RUN_DISPLAY_NUMBER		●	Run display number.
START_DATE		●	Start date.
STATUS		●	Status.
TIME_DEFINITION_ID		●	Identifier for the time definition.
TIME_PERIOD_ID	PK?	●	Identifier for the time period.
YEAR_NUMBER		●	Year number.

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

Need the extract + dbt staging for PAY_TIME_PERIODS?

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