The sample request below identifies employees who do not have all deductions for health (flex cash or otherwise), and dental and vision deductions. The report could be used to research employees who may be entitled to additional benefits. The report request uses the PH - prior business month file and is available in the CIRS common library as FOC5001.
EMPLOYEES WHO DO NOT HAVE ALL DEDUCTIONS
FOR HEALTH AND DENTAL AND VISION
REPORT RUN: 99/99/9999
FLEX FLEX
EMPLOYEE SSA CASH HLTH HEALTH VISION DENTAL
-------- --- ---- ---- ------ ------ ------
ANT, SARA 123-45-6789 -128.00 .00 .00 .00 .00
CAMEL, BOB 987-65-4321 .00 65.08 .00 .00 .00
EAGLE, JIM 345-67-8910 .00 31.06 .00 .00 .00
Step 1:
Gather deduction information for each employee and use the sort command ACROSS to get one line of data per employee. Place the results in a hold file for further processing.
EX PH
TABLE FILE PH
SUM PH:DEDAMT
BY PH:SSA
BY PH:WNAME
ACROSS PH:DEDTYPE
IF PH:CAMPX EQ X
IF PH:PAYPERIOD EQ 2004/12
IF PH:DEDTYPE EQ FC OR FH OR HB OR HD OR HV
ON TABLE HOLD AS PERMRPT
END
-
When the report is executed in the online or batch environment, select the option for the PH - prior business month.
-
The PH file contains all payments and deductions for your employees, including those generated by another campus. To select only those deductions issued by your campus, include a screening statement (e.g., IF PH:CAMPX EQ X, where X is your alpha campus code).
Step 2:
Evaluate the data in the hold file and generate the final report.
TABLE FILE PERMRPT
HEADING CENTER
"EMPLOYEES WHO DO NOT HAVE ALL DEDUCTIONS"
"FOR HEALTH AND DENTAL AND VISION"
"REPORT RUN &DATE"
" "
PRINT PH:SSA AS 'SSA'
PH:FC AS 'FLEX,CASH'
PH:FH AS 'FLEX,HLTH'
PH:HB AS 'HEALTH'
PH:HD AS 'DENTAL'
PH:HV AS 'VISION'
BY PH:WNAME AS 'EMPLOYEE'
WHERE ((PH:FC + PH:FH + PH:HB) EQ 0))
OR (PH:HD EQ 0) OR (PH:HV EQ 0)
END
-
Refer to the hold file's Master File Description for the fieldnames and formats of the data held.
-
The parenthesis are required in the screening statement for each of the conditions.
Last Updated: March 1, 2024