Definition of Terms

Worked department:  department where hours are actually worked (and expensed)

Home department:  department where an employee is officially assigned in the payroll master file; employee may not work all of his/her hours in this department

Labor type:  there are three labor types, as designated by the first digit in the account number:

1 -  Normal labor:  hours which are worked (and expensed) by an employee in his/her home department (i.e., worked department and home department are the same)

2 -  Borrowed labor:  from the perspective of the worked department, these are hours which are worked (and expensed) by an employee from a different home department (i.e., worked department and home department are not the same)

3 -  Lost labor:  from the perspective of the home department, these are hours which are worked (and expensed) in another department, thereby reducing worked hours in the home department; note that these hours are redundant to borrowed hours stored in the worked department

      Employee status: groupings from the payroll system, this data element differentiates the various classifications of full-time, part-time, and temporary employees; see accompanying Employee Status Description for details

      Job class:  alternately referred to as position code, this data element describes the different skill levels and operational functions within the hospital

      Pay type:  corresponding to Time Codes on the payroll system, this data element differentiates the various pay categories such as regular, overtime, vacation, jury duty, etc.(about 35 in all); this element is used to distinguish productive and non-productive hours and expense; see accompanying Time Code Description for details.

      Isolating data classifications:

        Total paid hours and salary:                                  Account     -   1???????????, 2???????????

                                                                              Classifier  -   ALL

                                                                              Qualifier    -   ALL

        Productive hours and salary:                                 Account     -   1???????????, 2???????????

                                                                              Classifier  -   ALL

                                                                              Qualifier    -   P

        Nonproductive hours and salary:                          Account     -   1???????????, 2???????????

                                                                              Classifier  -   ALL

                                                                              Qualifier    -   N

        Full-time hours and salary:           Regular            Account     -   1????????????, 2????????????

                                                                              Classifier  -   FT?

                                                                              Qualifier    -   ALL

                                                                                and/or

                                                      Premium          Account     -   1????????????, 2????????????

                                                                              Classifier  -   F0X

                                                                              Qualifier    -   ALL

        Non-full-time hours and salary:    Regular            Account     -   1????????????, 2????????????

                                                                              Classifier  -   PT?, TM?, OT?

                                                                              Qualifier    -   ALL

                                                                                and/or

                                                      Premium          Account     -   1????????????, 2????????????

                                                                              Classifier  -   P?X, T?X, O?X

                                                                              Qualifier    -   ALL

        Note:   Any account beginning with "3" is Lost Labor which is redundant to Borrowed Labor and should therefore be eliminated from most analyses.

Account Structure

Example:        Cost Center  6010                               Intensive Care Unit

                                    Expenses/Manhours

                                         110001000023

Structure:          1         100        0100        002        3

                           A           B            C            D         E

A = Labor Type:            1 =    Normal labor

                                       2 =    Borrowed labor

                                       3 =    Lost labor

B = Employee Status:     Employee                            

                                       Status Code              Description                                        

                                               0                       Full-time                                                                   

                                               1                       Part-time Weekend Baylor w/Benefits                     

                                               2                       Part-time (20-32 Hrs/Wk w/Benefits)                      

                                               3                       PRN                                                                          

                                               4                       Leave of Absence w/no Benefits        

                                               5                       Leave of Absence w/Accrued Benefits

                                              05                      VSP

                                              06                      Part-time less than 20 Hrs/Wk           

                                              07                      Per Diem              

                                              08                      Temporary            

                                               9                       Terminated           

                                             10                      Seasonal Employee (20-80 Hrs/Wk w/ Benefits)     

C = Job Class:  Values range from 1 to 9999 and define detailed position codes.

D = Pay Type:  Values are mapped from Payroll system time codes - 

                          (regular, PDO, over-time, etc.).

E = G/L Type:  Values are 1-7 corresponding to Labor Types - (management, RN, etc.).