|
|
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 |
|
The TABT format creates a hold file that is tab delimited and provides column headings in the first row of the hold file. Column headings can be specified using the AS option on the print/sum etc. statement. We recommend using this format for files that will be imported into Excel.
Format:
ON TABLE HOLD AS hold file name FORMAT TABT
Example:
EX EH
TABLE FILE EH
PRINT EH:EFFDATE AS 'EFF DATE'
EH:TRANCODE AS 'TRAN,CODE'
EH:POSIT16 AS 'POSITION NUMBER'
EH:SEPCODE AS 'SEP CODE'
EH:RANGE AS 'RANGE'
EH:EMPIDX AS 'EMP ID'
EH:TIMEBASE AS 'TIMEBASE'
ON TABLE HOLD AS PERMLRG FORMAT TABT
END