Data overview

Data in a database is organized by file. (According to custom, these files are called "tables." We will avoid this terminology.) In a human resources system, most database information is linked to employees. Other information serves to define the company, its policies and its rules. There are also system control files. For a better understanding, check out our conceptual data model.

About employees and candidates

• PERS – the employee's "master" record, specifying name, address, etc.
• JOBHIST– Employee job history, movements and status
• PRPAR – Information for net pay and statutory deductions
• CAREER – Previous career, CAND – candidates and DCAREER – and their careers
• CAND - Candidates
• APPLNT – Applicants. connects a PERS or CAND to a STAFRQ
• EDUC – Education
• EVENT – Various events concerning the employee
• ACCID – Accidents
• TIMEDT – Attendance and gross pay transactions. Archived in OTIMEDT)
• PAYDT – Net pay details and TEMPPAY (unfinalized). Archived in OPAYDT
• PLANDT - Daily schedule overrides (work planner)
• TIMSUM – Employee time banks
• BENEFIT – Benefit enrollments
• DEPEND – employee dependants
• ROE - Record of employment (DBF format for)
• TOGLDET - Detail GL transactions generated by period

About the company (Reference tables)

• TBL – Various validation code tables
• JOB – Jobs and POS – Positions
• ENTITY – Administrative entities (services or departments)
• RATE – Rates and dated expressions table
• APLAN – Attendance plans (Time banks)
• BPLAN – Benefits plans
• RPLAN – Remuneration plans
• PAYNO – Pay calendar and EMPRNO – Employer information for payroll
• SCHED – Standard schedules
• COURSE – Training courses and TRNGRP – training groups
• LOG – System access log
• ALARM – Definition of alarms, DALARM – future actions and SALARM – kept messages
• TOGL - G/L Summary by pay period
• STAFRQ - Staffing Request

About the application

• NCONFIG – Configuration options
• REPOLIST – Maintenance tools
• ERRLIST - Error log (DBF format)