Sample Focexecs: Alternate File Views

S A M P L E F O C E X E C S

Alternate File Views

Certain subsets of the file are available by using a variation of the table file command. If you need access to only a subset of thje file, you should use the alternate file view commands. Subsets are available for each collective bargaining unit, each appointment type - title code (personnel program type), and each personnel appointment type - pps.

xx-tuc    where "xx" is the title unit code (tuc). To select, for
          example,  all  records  with  a  title unit code of "99" (no unit),
          type:  99-tuc.

taca    appointment type - title code =   a (Academic)
texec                                     e (Executive)
tmap                                      m (MAP)
tstafp                                    s (Staff Personnel)
taps                                      p (A&PS)
tstaps                                    s and p (Staff Personnel and A&PS)


1-apttyp  appointment type - pps  1  (Contract)
2-apttyp                          2  (Reatilar/Career)
3-apttyp                          3  (Casual)
4-apttyp                          4  (Casual/Restricted)
5-apttyp                          5  (Academic)
6-apttyp                          6  (Per Diem)

(Effective with January, 1988 population)


To use the alternate file view, substitute the commands listed
above for the table file command. See the following examples:

taca                         cx-tuc
print empname                sum mongrs
end                          end

Note: If you do counts using alternate file views, your counts will be duplicated. See instructions on unduplicated counts.

Back to Sample Focexecs