Sage HRMS Train database file list

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

Database files for Sage HRMS Train

 

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