All of the major files in CIRS have a pre-programmed join to the Pay Scales file. Most of the joins to the PS file are based on class code (XX:CLASS) and range code (XX:RANGE). However some of the joins retrieve records from the PS file only at the range 0 level to get a common abbreviated title regardless of range.
Things to note:
The PS file has all current information pertaining to active and abolished classes. No historical information is available.
If a join to the PS file at range 0 is used, DO NOT retrieve data elements from the lower segments in the PS file, otherwise you may get erroneous data (see example 3 below).
When a join to an external file (EH, TR, PH, PHS, PY) is used, your report request must include the following statements IF XX:CLASS GT 0 and IF XX:RANGE GE 0 to retrieve data from the PS file.
Records from the PS file are retrieved at the class and range level.
TABLE FILE AC
IF RECORDLIMIT EQ 5
AC:WNAME CLS RNG PS:TITLEA
-------- --- --- ---------
BEAR, JIM 2358 1 LECTURER L, AY
COUGAR, JAN 2358 5 LECTURER D, AY
FROG, STAN 1170 2 CONF OS-12MOB
GECKO, MIKE 3312 1 ADMIN IIA
LLAMA, AMY 2360 5 PROFESSOR AY
Records from the PS file are retrieved at the range 0 level.
BEAR, JIM 2358 1 LECTURER AY
COUGAR, JAN 2358 5 LECTURER AY
FROG, STAN 1170 2 CONF OS-12MO
LLAMA, AMY 2360 5 INS FACULTY AY
Records are retrieved only for record type 'F' and range 0 values. Minimum Rate (PS:MIN) resides in the lower segment of the PS file and is only available for those class codes where compensation is a variable rate (min-max).
AC:WNAME CLS RNG PS:TITLEA ps:min
-------- --- --- --------- ------
fox, john 1800 0 casual wkr $6.75
horse, beth 1150 0 isa $8.00
newt, ann 1970 0 ec mstr tchr $2,053.00
lion, MIKE 7172 0 reader $6.75
whale, bob 0101 0 helper/aid $1,170.00
For more information on joins, refer to the CIRS Data Element Dictionary.
See also: Using Joins
Last Updated: February 6, 2006