|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
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.
|
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
|
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
|
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