Employee salary fact table (Redshift)

Stores employee salary and payroll details including commission, tenure bonus, redo penalties, and deductions per pay period.

Field	Field type	Description	Primary Key	Mapped Dimension table	Mapped Dimension field
empsalwid	BIGINT IDENTITY	Surrogate key and primary key for the employee salary record.	PK
factemployeesalaryid	BIGINT	Source system identifier for the employee salary fact.
factemployeesalarywid	BIGINT IDENTITY	Surrogate primary key (auto-generated)
centerwid	BIGINT	Foreign key to the center dimension
employeewid	BIGINT	Foreign key to the employee dimension		Bi_DimUser	userwid
payrollcenterwid	BIGINT	Foreign key to the center where payroll is processed (Bi_DimCenter.centerwid).		Bi_DimCenter	centerwid
payperiodname	VARCHAR(1000)	Name of the pay period.
payrollstartdate	TIMESTAMP	Start date of the payroll period.
payrollenddate	TIMESTAMP	End date of the payroll period.
salary	DOUBLE PRECISION	Base salary amount for the pay period.
effectivedatestart	TIMESTAMP	Effective start date of the salary record.
effectivedateend	TIMESTAMP	Effective end date of the salary record.
centercommission	DOUBLE PRECISION	Commission amount earned at the center level.
tenurebonus	DOUBLE PRECISION	Bonus amount based on employee tenure.
redopenalty	DOUBLE PRECISION	Penalty amount deducted for service redos.
emptotaldeductions	DOUBLE PRECISION	Total deductions applied to the employee salary.
podid	INTEGER	Identifier for the pod (database partition).
void	BOOLEAN	Soft-delete flag indicating the record is logically deleted.
groupid	BIGINT	Identifier for the organizational group.

In this section:

Search results