Joining To The Pay Scales File

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:

 

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