Salary Fields Comparison

Did you know there are 6 different data elements in CIRS that provide salary information?  Unless you're very familiar with personnel and payroll data, determining which field to use in reports can be confusing.  You should begin by identifying which type of data you need - employment or payroll data.  Remember that the employment data files have information on what an employee is scheduled to be paid and the payment data files have information on what was actually paid to an employee.

Employment Data  

The sample transaction records below show the various employee salary fields available in the employment data files. The fields containing data will vary based on the employee's salary record type.  Unless otherwise specified, all fields are in the Active Current Status (AC), Annual Current Status (AN), Employment History Extract (EH), Separated Current Status (SP) and Transaction Data (TR) files.  

  

                  effective         assigned  red                           salary

name        tran  date        cbid  salary    circle   base pay  timebase   total

----        ----  ---------   ----  --------  -------  --------  --------   ------     

bear, ann   SCR   06/08/2005  M80    5564.00    54.00   5618.00  FT        5618.00

camel, bob  a52   07/01/2005  r09    3332.00      .00   3332.00  int         19.22   

Dog, Jeff   A56   08/19/2004  R03    6645.00      .00   6645.00  001002    3322.50

Frog, aRI   430   08/01/2005  R08        .00      .00   5020.00  FT        5020.00  

Hippo, LEX  a52   07/01/2005  E99      12.50      .00     12.50  INT         12.50

 

 

 

 

Payment Data

The sample regular payment records below show the salary fields available in the payment files: Payment History Data (PH), Payment History Extract (PY) and the Payment History Summary (PHS).  

 

           pay   pay              salary               salary

name       type  period   cbid    full       timebase  rate

----       ----  ------   ----    -------    --------  -------    

bear, a    0     2005/08  M80     5618.00    000000    5618.00

camel, b   0     2005/07  R09     3332.00    000000      19.22

dog, j     0     2005/08  r03     6645.00    001002    3322.50  

from, a    0     2005/08  r08     5020.00    000000    5020.00

hippo, l   0     2005/08  E99       12.50    000000      12.50

 

The amount of money in dollars and cents that is paid by Salary Per. It includes Base Pay plus any Red Circle Rate amount. Note: For fractional employees, this is the amount an employee would receive if working full-time. For employees with an hourly rate based on a monthly salary rate, this is the total hourly rate.