STR - Sample Report

The following common library program: FOC1000 counts the number of systemwide appointment transactions that have been posted since 1976.

 

EX JSTRPSAG
TABLE FILE STR

HEADING CENTER

"THE CALIFORNIA STATE UNIVERSITY"

"APPOINTMENT TRANSACTION COUNT"

"BY TRANSACTION CODE AND CAMPUS"

"COMMON FOCEXEC: FOC1000"
"  "

COUNT STR:PSNSEQ

BY CAMPUS   

ACROSS STR:TRANCODE AS ''

WHERE STR:TRANTYPE EQ 'APPOINTMENT'

WHERE RECORDLIMIT EQ 1000

END

 

The following is only an excerpt from the actual report.

 

THE CALIFORNIA STATE UNIVERSITY

 APPOINTMENT TRANSACTION COUNT

BY TRANSACTION CODE AND CAMPUS

   COMMON FOCEXEC:  FOC1000

 

CAMPUS         A50    A52   A56   

-------------------------------

CHANNEL IS       1     27     0

BAKERSFLD        5     27     0

CHANCLR OFF      1      3     9

CHICO            2     14     8

DOMINGUEZ        1     34     0

east bay         1     11     5

FRESNO           2     34     1

FULLERTON        2     39     3

HUMBOLDT         1     57     9

LA               3     39     0

LONG BEACH       3      1     7

MARITIME         2      1     0

NORTHRIDGE       3     44     7

POMONA           2    109     7

SACRAMENTO       2     46     2

SAN BERN         1     23     1

SAN DIEGO       10    143     8

SAN FRAN         3     72     5

SAN JOSE        14     74     8

SAN MARCOS       3      7     0

SLO              3     30     0

SONOMA           1     13     0

STANISLAUS       8      2     0