Note: Leave data is only available for campuses participating in the SCO's Leave Accounting System.
If you need to report on current leave balances for your employees, that information is available in the Leave Accounting Summary (LX) file. However, if you need leave balances as of a certain period, you'll need to use the Leave Balance Information (LB) file which contains up to 5 years of detailed leave activity.
The sample report request below uses the LB file to report on beginning and ending balances by employee name and leave type for the July 2002 leave period. Because the LB file doesn't have employee name. a join is used to get that field from the Employee Specific Information (LV) file.
Report Request:
EX JLVLB
TABLE FILE Lv
PRINT LB:BEGBAL
LB:ENDBAL
by LV:wname
BY LB:SSA
by lb:lt
if lb:lp eq 200207
IF RECORDLIMIT EQ 5
END
Report Generated:
lv:wname lb:ssa LB:LT beg bal end bal
-------- ------ ----- ------- -------
DOG, AM 999-99-9999 SL 48.000 40.000
VA 116.000 76.000
hawk, rm 555-55-5555 ph 1.000 .000
sl 720.000 720.000
va 424.000 384.000