I-18
Demo Health System
HSL Database
Payroll data
Expenses, hours
PAYROLL04.DBH
Classifier Table
PAYCLASS.CLA
TRENDSTAR HSL
Database and Related Tables
General Ledger
Payroll
Copyright ©2004 Yardley Management Solutions, Inc.
215-321-9197
support@ymsolutions.com
Chart of Accounts Table
PAYCLASS.CHA
Payroll Data Account Specification
ENT = entity
CCN = G/L cost center
DTY = data type (Expenses, Manhours)
ACT = Job Code/Earning codes
CLS = classifier (JCEC groupings)
QUA = qualifier
Account code structure
                   5963054 =
   
           budget job code  earnings type
PAYACTyr.DBH = payroll data by month
PAYROLLyr.DBH = pay period data for fiscal yr
PAY04mon.DBH = pay period data for current pp
HSL Control Tables
Classifier table must be applied to appropriate HSL databases after modifications. Chart of accounts provides titles and cost center groupings.
Report Control Table
REPORT.RPH
Payroll Database Example