Below are several sample FOCUS reports that use the LX file.
|
FOC1095
|
Leave Summary File Report
|
|
FOC1096
|
Leave Balances For Active Employees (Intermittents Excluded)
|
|
FOC1097
|
Employee Leave Accrual And Usage By Type For the Last 6 Pay Periods
|
Report Request FOC1095:
The following program prints information from the employee data segment for current active employees.
EX LX
TABLE FILE LX
HEADING CENTER
"THE CALIFORNIA STATE UNIVERSITY"
"LEAVE SUMMARY FILE REPORT"
"REPORT RUN ON &DATE"
"COMMON FOCEXEC: FOC1095"
"</1"
PRINT LX:LASTNAME/A10 AS 'LASTNAME'
LX:SSMOBAL AS 'SS MO BAL'
LX:VACRATE/D7.2 AS 'VAC,RATE'
LX:SCKRATE/D7.2 AS 'SICK,RATE'
LX:VACMAX/D7.2 AS 'VACATION,MAX'
LX:CTOMAX/D7.2 AS 'CTO MAX'
BY LX:CBID
BY LX:SSA AS 'SSA'
WHERE LX:LSE EQ 'Y'
WHERE RECORDLIMIT EQ 50
END
The following is only an excerpt from the actual report.
THE CALIFORNIA STATE UNIVERSITY
LEAVE SUMMARY FILE REPORT
REPORT RUN ON 01/22/99
COMMON FOCEXEC: FOC1095
CB VAC SICK VACATION
ID SSA LASTNAME SS MO BAL RATE RATE MAX CTO MAX
-- --- -------- --------- ---- ---- ------- -------
C99 111-11-1111 SCHMITZ .0000 .00 .00 .00 120.00
222-22-2222 HEMPHILL 39.0000 16.00 8.00 384.00 120.00
M80 111-11-1111 KWIATKOWSK 72.0000 16.00 8.00 384.00 .00
222-22-2222 FORTIN 313.0000 16.00 8.00 440.00 .00
333-33-3333 HINES 104.0000 16.00 8.00 384.00 .00
Report Request FOC1096:
The following program prints Leave Benefit Balances from the second segment on all active employees who are not intermittent employees.
EX LX
TABLE FILE LX
HEADING CENTER
"THE CALIFORNIA STATE UNIVERSITY"
"LEAVE BALANCES FOR ACTIVE EMPLOYEES"
"(INTERMITENTS EXCLUDED)"
"COMMON FOCEXEC: FOC1096"
"REPORT RUN ON &DATE </1"
PRINT LX:LB/P8.2 AS 'LEAVE,BALANCE'
BY LX:SSA AS 'SOC SEC NUM'
BY LX:LASTNAME AS 'EMPLOYEE'
BY HIGHEST LX:LN AS 'LEAVE TYPE'
WHERE (LX:LSE EQ 'Y') AND (LX:TIMEBASE NE 'INT')
Where LX:LT NE ' '
WHERE RECORDLIMIT EQ 50
ON LX:SSA SKIP-LINE
END
The following is only an excerpt from the actual report.
THE CALIFORNIA STATE UNIVERSITY
LEAVE BALANCES FOR ACTIVE EMPLOYEES
(INTERMITENTS EXCLUDED)
COMMON FOCEXEC: FOC1096
REPORT RUN ON 99/99/99
LEAVE
SOC SEC NUM EMPLOYEE LEAVE TYPE BALANCE
----------- -------- ---------- -------
111-11-1111 Kangaroo VACATION 392.00
SICK LV 512.00
JURY DTY 24.00
PH .00
222-22-2222 Gorilla VACATION 58.67
SICK LV 9.00
ph 1.00
hol ito 4.00
333-33-3333 baboon VACATION 410.00
SICK LV 358.00
dock 63.00
ph 1.00
Report Request FOC1097:
The following program prints the hours earned and used for the leave types VA (Vacation), SL (Sick Leave), CT (Compensation Time Off), EH (Excess Hours), HT (Holiday CTO), HC (Holiday Credit) and PH (Personal Holiday) from the third segment for all active employees for the past three months. It must be run in the Online FOCUS Environment because it contains prompts for the pay periods.
EX LX
TABLE FILE LX
HEADING CENTER
"THE CALIFORNIA STATE UNIVERSITY"
"EMPLOYEE LEAVE ACCRUAL AND USAGE BY TYPE"
"DATA FOR THE LAST 3 PAY PERIODS"
"COMMON FOCEXEC: FOC1097"
"REPORT RUN ON &DATE </1"
SUM LX:LPERN/P8.2/L AS 'EARNED'
LX:LPUSE/P8.2/L AS 'USED'
BY LX:SSA AS 'SOC SEC NUM' skip-line
by lx:wname as 'employee'
BY HIGHEST LX:LN AS 'leave'
ACROSS LX:LP AS ''
WHERE LX:LSE EQ 'Y'
IF LX:LP FROM &LP1.ENTER THE PAY PERIOD 3 MONTHS AGO AS CCYYMM.
TO &LP2.ENTER THE PRIOR PAY PERIOD AS CCYYMM.
WHERE RECORDLIMIT EQ 50
END
The following is only an excerpt from the actual report.
THE CALIFORNIA STATE UNIVERSITY
EMPLOYEE LEAVE ACCRUAL AND USAGE BY TYPE
DATA FOR THE LAST 3 PAY PERIODS
COMMON FOCEXEC: FOC1097
REPORT RUN ON 01/22/99
200210 200211 200212
SOC SEC NUM Leave EARNED USED EARNED USED EARNED USED
-----------------------------------------------------------------------
111-11-1111 VACATION 16.00 -48.00 16.00 -40.00 16.00 .00
SICK LV 8.00 .00 8.00 .00 8.00 .00
ph . . . -1.00 .