|
|
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 |
|
If you have lengthy defines, or share defines with others, they can be stored separately to simplify maintenance and then be incorporated into report requests using the -INCLUDE command. The -INCLUDE command calls in procedures when the report is executed.
For example, the define below creates a new field named EEGROUP. Assume the procedure containing the define is named GROUPS and is stored in the common library. Note that only the commands required for beginning and ending the defined field are stored.
|
-* REPORT REQUEST: GROUPS DEFINE FILE AC ADD EEGROUP/A10 = IF AC:CBID EQ 'R03' THEN 'FACULTY' ELSE IF AC:CBID EQ 'MPP' THEN 'MANAGEMENT' ELSE 'STAFF'; END |
To use the field EEGROUP in a report request (e.g. as a sort field, verb field or part of a screening statement), use the -INCLUDE command after executing the standard defines or the join. Note the procedure GROUPS defines can only be called into requests using the AC file. In the example below, the EEGROUP is used as a sort field.
|
-* REPORT REQUEST: EESTATS EX AC -INCLUDE GROUPS TABLE FILE AC count AC:POSITION ACROSS AC:SEX BY EEGROUP END |
For more information on the -INCLUDE command, refer to your FOCUS documentation.