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.
-
Joins to PS at class & range level: JACPS, JANPS, JEHPSAG, JPHPSAG, JSACPS, JSANPS, JSPPS, JSTRPSAG, JTRPSAG
-
Joins to PS at range 0 level: ACPS1, JANPS1, JLBPS, JLXPS, JSACPS1, JSANPS1, JSPPS1
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.
Example #1 - JACPS
Records from the PS file are retrieved at the class and range level.
|
Commands
|
Output
|
|
EX JACPS
TABLE FILE AC
PRINT AC:CLASS
AC:RANGE
PS:TITLEA
BY AC:WNAME
IF RECORDLIMIT EQ 5
END
|
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
|
Example #2 - JACPS1
Records from the PS file are retrieved at the range 0 level.
|
Commands
|
Output
|
|
EX JACPS1
TABLE FILE AC
PRINT AC:CLASS
AC:RANGE
PS:TITLEA
BY AC:WNAME
IF RECORDLIMIT EQ 5
END
|
AC:WNAME CLS RNG PS:TITLEA
-------- --- --- ---------
BEAR, JIM 2358 1 LECTURER AY
COUGAR, JAN 2358 5 LECTURER AY
FROG, STAN 1170 2 CONF OS-12MO
GECKO, MIKE 3312 1 ADMIN IIA
LLAMA, AMY 2360 5 INS FACULTY AY
|
Example #3 - JACPS1
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).
|
Commands
|
Output
|
|
EX JACPS1
TABLE FILE AC
PRINT AC:CLASS
AC:RANGE
PS:TITLEA
PS:MIN
BY AC:WNAME
IF RECORDLIMIT EQ 5
END
|
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