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.
TABLE FILE Lv
if lb:lp eq 200207
IF RECORDLIMIT EQ 5
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
Last Updated: July 2, 2003