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
|
Last Updated: February 27, 2024