Leave Balance Information Master File Description

If your campus participates in CLAS, this file contains detailed leave activity for your employees.  Employees will have one record per leave period, per benefit type. Data is available for the last 5 years. The range of data available for your campus will depend on when it began participation in CLAS.

 

  • File Name:  LB

  • Update Schedule:  Weekly. Data as of close of business on Friday, available on Monday.    

  • Files Automatically Joined:  None

  • Pre-programmed Joins:  JLBPS, JLVLB

  • Sample FOCUS Request:  FOC1070 - FOC1075

  • See Also: Leave Files Comparison

 


Segment Name = LBEN, Segment Type = S1

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

  •  

LB:SSA

A

11

Social Security Number

  •  

LB:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

LB:SSAMASK

A

11

Social Security Number, Masked

  •  

LB:CAMPUSCD

A

2

Campus Numeric Code

 

LB:CAMPSSA

A

11

Campus Numeric Code / SSA

 

LB:PSNSEQ

A

2

Position Sequence Number

 

LB:AGENCY

A

3

Agency Code

 

LB:UNIT

A

3

Reporting Unit

 

LB:CLASS

A

4

Class Code

 

LB:SERIAL

A

3

Serial Number

  •  

LB:POSIT16

A

16

Position Number

 

LB:AUDIT

A

19

Audit Information

  •  

LB:LT

A

2

Leave Benefit Type

  •  

LB:LN

A

8

Leave Benefit Name

  •  

LB:LCAT

A

7

Leave Benefit Category

 

LB:LVSORT

A

2

Leave Type Sort Sequence

 

LB:LVPSNSEQ

A

2

Position Sequence Number

 

LB:EMPID

A

3

Employer Identifier

  •  

LB:LP

A

6

Leave Period

 

LB:ACTIND

A

1

Activity Indicator

 

LB:BEGBAL

P

8.3

Begin Balance

 

LB:TOTUSED

P

8.3

Total Amount Used

 

LB:TOTMISC

P

8.3

Total Miscellaneous

 

LB:TOTCR

P

8.3

Total Credit Amount

 

LB:FLSACTO

P

8.3

FLSA CTO Amount

 

LB:REGLCTO

P

8.3

Regular CTO

 

LB:ENDBAL

P

8.3

Ending Balance, Leave

 

LB:USEIND

A

1

Use Indicator

 

LB:MISCIND

A

1

Miscellaneous Indicator , Leave

 

LB:CRIND

A

1

Credit Indicator

 

LB:CTORIND

A

1

CTO Regular Indicator

 

LB:CTOFIND

A

1

CTO FLSA Indicator

 

 

 

Last Updated: January 13, 2006