1	Hospital Systems Library (HSL) Introduction to the System Data and Related Tables
2	TRENDSTAR Decision Support Data + Toolset = Information Provides Tools for the Manipulation of Data for Modeling Purposes Gathers Information for Easy Manipulation and to Support Management Decisions Allows for Both Short Term and Long Term Assessment and Planning
3	TRENDSTAR Top Screen
4	TRENDSTAR Decision Support Main Modules Clinical Data Driven Applications: Clinical Cost Accounting (CCA)/Resource Utilization Analyst (RUA) Contract Payment Advisor (CPA) Financial Data Driven Applications: Hospital Systems Library (HSL) Management Cost Accounting (MCA) These modules feed other important tools for end user access: ds.Pathfinder, WebTREND and Outcomes Advisor.
5	HSL Applications Standard and Flexible Reporting Zero-based, Volume-based, and Flexible Budgeting Applications Modeling and Simulation Overhead Allocation for Management Reporting and for Case Mix Cost Accounting
6	HSL Budget Applications Fill in remainder of year Average, combine with budget, variance Flexible budget Project values, create rules, apply rules Spread values Across accounts, across periods Reporting
7	Hospital Systems Library (HSL) Department Level Data: G/L, Statistics, and Payroll Information in One Place Matches Health System Organization Multiple Databases Organized by Month or by Period Provides Tools to Easily Access Tremendous Amounts of Data
8	The HSL Data Tables Department Level Database File name ends in extension .DBH Based on fiscal year Many different versions possible (prior years, actual, budget 1, budget 2, etc.) Database Control Tables Provide organization to the data Provide information or titles to the data Application Developed Tables
9	HSL Department Level Database General Ledger Data Revenues Expenses Assets, Liabilities, Equities Statistical Data Procedures, Patient Days, Discharges, etc. Payroll Data Dollars and Hours by Job Code and Pay Type
10	HSL Department Level Database Data Organization Entity (if this field has been activated) Cost Center: G/L department Data Type: Revenue, Expense, Unit, Manhour, (optional: Asset, Liability, Equities) Account: usually matches G/L subaccount Classifier: account categorization for ease of access. Qualifier: further categorization of classifiers 12 Months or 13 Periods of data
11	HSL Departmental Database Access Data Via Account Specification Entity Code (Entity) Divisions (GRP1, GRP2) Cost Center (CCN) Data Type (DTY) Account (ACT) Classifier (CLS) Qualifier (QUA)
12	HSL Database Control Tables Chart of Accounts Control Table (.CHA) Classifier Control Table (.CLA) Optional: HSLedger Interface Mapping Table (*.HMP)
13	HSL Chart of Accounts Table Always Named with the Extension *.CHA Contains Titles for Entities, Cost Centers, Accounts, and Classifiers Contains Groupings of Cost Centers into Department and Division Structures (Group 1 and Group 2) Edited with Own Chart of Accounts Editor Text File Import to Build/Update
14	Classifier Control Table Always Named with the Extension *.CLA Maps accounts by data type into User-defined Classifiers and HBOC Defined Qualifiers Classifiers are three character or digit codes assigned to one or more account numbers (INP, OUT, SAL, FEE) Qualifiers are a one character code assigned to classifiers (O, N, D) Maps User-defined Classifiers into Standards Edited with Own Classifier Table Editor
15	HSLedger Mapping Table Maps Entity G/L, Statistical, or Payroll Account into HSL Account Structure Mapping rules defined by data type Cost center and account definitions by general rule Processes input G/L, Statistical, or Payroll file and outputs an HSL Transaction Table (*.TRH) used to create or update an HSL database
16	HSL Application Developed Tables Report Tables (.RPH) Model Tables (.MOD) Remap Tables (.REM) Transaction Tables (.TRH) Allocation Control Tables (.ALH) Report Log Tables (.LOG) ds.Pathfinder/WebTREND Reports (*.ERS)
17	Expense Database Example
18	Payroll Database Example