Using Data Dictionaries > Training Data Dictionary

Sage HRMS Train 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
DDFIELD	Data Dictionary Fields	FLD
DDFILE	Data Dictionary File Names	FIL
DDINDEX	Data Dictionary Index Keys	IND
HRPERSNL	Employee Personnel	PE
HRTABLES	HR and Payroll Code Tables	TA
NCATCOUR	Course Catalog	NCC
NCATINST	Instructor Catalog	NIN
NCATLOCA	Training Location Catalog	NLO
NCATPROG	Training Program Catalog	NPR
NCLAINFO	Class Information	NCI
NCLALETT	Class Correspondence Letters	NLT
NEMPCERT	Employee Certifications	NEC
NEMPHIST	Courses Taken	NEH
NEMPINFO	Employee Miscellaneous Training Information	NEI
NEMPLOY	Training Employer Setup	NTS
NEMPPROG	Employee Training Programs	NEP
NEMPREQU	Required Courses	NER
NJOBREQU	Job Requirements	NJR
NPREREQU	Course Prerequisites	NCQ
NPROCURR	Training Program Curriculum	NPC
NSKILLS	Associated Skills	NSK
SYAUDIT	Audit Trail	AU
SYBACKUP	Backup Transaction Log	BKP
SYEMPLOY	Employer Setup	ER
SYENTER	Enterprise Setup	ENT
SYFILTER	Product Group Filters	FILTERS
SYSFIELD	Security Group Field Access	FLDSEC
SYSRPT	Security Report Writer Field Access	RWSEC
SYSCHED	Schedule	SCHEDULE
SYSTEP	Security Steps	STEPS
SYTASK	Security Task	TASKS
SYUSER	Security User	USERS