Using Data Dictionaries > HRMS Data Dictionary

Sage HRMS Database File List

The following table lists the file name, description and alias for each database file. The files are listed alphabetically by file name.

File	Description	Alias
BPSPCDET	Check Detail for Employee Self Service	BPD
BPSPCMAS	Check Master for Employee Self Service	BPM
BPSW4	W4 Data for Employee Self Service	BPW4
DDFIELD	Data Dictionary Fields	FLD
DDFILE	Data Dictionary File Names	FIL
DDINDEX	Data Dictionary Index Keys	IND
GENEMAIL	Update Employee Email Addresses	GE
HBEDEF	Benefit Rate Setup	DF
HBENBEN	Beneficiary Enrollments	BB
HBENE	Employee Benefit	BE
HBEPLAN	Benefit Plan Table	BT
HBERES	Benefit Rate	RS
HDEPBEN	Dependent Benefits	DB
HDEPEND	Employee Dependent	DE
HEDU	Employee Education History	ED
HEMERG	Employee Emergency Contact	EM
HEVENTS	Employee Event	EV
HJOBHIS	Employee Job History	JH
HOSHA	Employee OSHA	OS
HPREV	Employee Previous Employment	PV
HREMPATT	Employee Attachments	EA
HRENOTES	Employee Notes	EN
HRLOA	Leave of Absence	LO
HRMAS90	Sage 100 Payroll Setup	MAS90
HRPERSNL	Employee Personnel	PE
HRPHOTO	Employee Photo	PIC
HRSECJOB	Employee Secondary Job	SJ
HRTABLES	HR and Payroll Code Table	TA
HSKILLS	Employee Skill	SK
HTERMJH	Terminated Employee Job	TERMJH
HTERMPE	Terminated Employee Personnel	TERMPE
HWELL	Employee Wellness	WE
OEBEPLAN	Benefit Plan Table for Open Enrollment	OEBT
OEBEDEF	Benefit Rate Setup for Open Enrollment	OEDF
OEBERES	Benefit Rate for Open Enrollment	OERS
SYAUDIT	Audit Trail	AU
SYBACKUP	Backup Transaction Log	BKP
SYCRIT	Criteria Table	CT
SYEMPLOY	Employer Setup	ER
SYENTER	Enterprise Setup	ENT
SYFILTER	Product Group Filters	FILTERS
SYSCHED	Schedule	SCHEDULE
SYSFIELD	Security Group Field Access	FLDSEC
SYSRPT	Security Report Writer Field Access	RWSEC
SYSTEP	Security Steps	STEPS
SYTASK	Security Task	TASKS
SYUSER	Security User	USERS