Leave Accounting Summary Master File Description

If your campus participates in CLAS, this file provides a monthly snapshot of the leave accounting files after the monthly balances have been posted for employees who are currently active on CLAS, plus any employees who had leave activity within the past 12 months.  It includes intermittent employees, and employees who are on leave without pay.

 

This is a summary file that includes many of the most frequently used fields from the basic leave files for up to 26 leave benefit types. The first segment contains personal data, leave benefit rates and message flags.  The second segment has the current balance.  The third segment has earned/usage history for the last 12 months for the following leave types:  Vacation (VA), Sick Leave (SL), Compensated Time Off (CT), Excess Hours (EH), Holiday Compensated Time Off (HT), Holiday Credit (HC), CSU Furlough (FP) and Personal Holiday (PH)

 

  • File Name:  LX

 


Segment Name = ONE, Segment Type = S1

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

  •  

LX:SSA

A

11

Social Security Number

  •  

LX:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

LX:SSAMASK

A

11

Social Security Number, Masked

 

LX:CAMPUSCD

A

2

Campus Numeric Code

 

LX:CAMPSSA

A

11

Campus Code / SSA

  •  

LX:CAMPUS

A

10

Campus Name Abbreviated

 

LX:FRSTINT

A

1

Name, First Initial

 

LX:MDLEINT

A

1

Name, Middle Initial

 

LX:LASTNAME

A

21

Name, Last

  •  

LX:WNAME

A

25

Name, Whole

 

LX:PSNSEQ

A

2

Position Sequence Number

 

LX:AGENCY

A

3

Agency Code

 

LX:UNIT

A

3

Reporting Unit

 

LX:CLASS

A

4

Class Code

 

LX:SERIAL

A

3

Serial Number

  •  

LX:POSIT16

A

16

Position Number

  •  

LX:AGYUNIT

A

6

Agency and Unit Key

 

LX:CBID

A

3

Collective Bargaining Id, Code

 

LX:TIMEBASE

A

6

Time Base

 

LX:FTE

P

8.5

Full-Time Equivalent

 

LX:ACADMYR

A

1

Academic Year Class

 

LX:SEPCODE

A

1

Separation Code Leave

 

LX:OOSFLAG

A

1

Benefit Out-of-Service Flag

 

LX:CTOMAX

P

8.3

CTO Maximum Hours

 

LX:POOS

A

1

EH Position Out-Of-Service

 

LX:LSE

A

1

Eligibility Indicator

 

LX:OUTOFSVC

A

1

Out-Of-Service Indicator

 

LX:PHFLAG

A

1

Personal Holiday Flag

 

LX:SLEST

A

1

Sick Leave Benefit Established

 

LX:SCKRATE

P

8.3

Sick Leave Rate

 

LX:ENDFRAC

P

8.5

State Service End Fraction

 

LX:ENDHRS

P

6.2

State Service End Hours

 

LX:SSFLAG

A

1

State Service Flag

 

LX:SSMOBAL

P

8.3

State Service Monthly Balance

 

LX:NOLVFLAG

A

1

State Service No Information Flag

 

LX:SSOUTSVC

A

1

State Service Out-Of-Service

 

LX:VACEST

A

1

Vacation Benefit Established

 

LX:VACMAX

P

8.3

Vacation Max Hours

 

LX:NDETFLAG

A

1

Vacation Max Non-Determine Flag

 

LX:NCHGFLAG

A

1

Vacation No Change Flag

 

LX:NONSFLAG

A

1

Vacation Non-Standard Flag

 

LX:OVRFLAG

A

1

Vacation Over Max Flag

 

LX:VACRATE

P

8.3

Vacation Rate

 

LX:VACCHGDT

DT

MYY

Vacation Rate Change Date (MMYY)

 

LX:CHGFLAG

A

1

Vacation Rate Change Flag

 

LX:VACACCRU

A

1

Vacation Rate Code

 

LX:MAXFLAG

A

1

Vacation Rate Max Flag

 

LX:VACNXTRT

P

8.3

Vacation Rate Next

 

LX:NEXTMAX

P

8.3

Vacation Rate Next Max Hours

 

LX:LWOP

A

1

Leave Without Pay Indicator

 

Segment Name = TWO, Parent = ONE, Segment Type = S0

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

LX:LT

A

2

Leave Benefit Type

 

LX:LN

A

8

Leave Benefit Name

  •  

LX:LCAT

A

7

Leave Benefit Category

 

LX:LB

P

8.2

Leave Balance

 

LX:LM

A

4

Leave Measure

 

LX:LS

A

1

Leave Non-Standard Rate

 

LX:ESTDATE

A

6

Established Date, Leave

 

LX:ENDDATE

A

6

End Date, Leave

 

LX:THREECNT

P

4

Segment Count Level Three

 

Segment Name = THREE, Parent = TWO, Segment Type = S0

Note: This segment has data only for leave types VA, SL, CT, EH, HT, HC, FP and PH.

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

LX:LP

A

6

Leave Period (CCYYMM)

 

LX:LPERN

P

8.2

Leave Period Hours Earned

 

LX:LPUSE

P

8.2

Leave Period Hours Used

 

 

 

Last Updated: November 16, 2009