LA Update Years Experience - File Layout and Data Mapping

The default file names for the LA Update Years Experience report are:

Excel: updservrpt<XXXX_XXXXX>.xlsx
PDF: updserv_<XXXXX>.pdf
RPT: updserv.rpt

The following table shows the columns, column names, descriptions, and data sources or valid values for the LA Update Years Experience report.

Column	Column Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The employee’s identification (ID) number.	The field value is retrieved from the Employee Number field on the Employee Information page.
B	EMPLOYEE NAME	The employee’s first name. The format is Last name, First name Middle initial	Retrieved from the Last Name, First Name, and Middle Name fields on the Employee Information page.
C	YEARS IN DISTRICT	The number of years the employee worked for your organization.	Retrieved from the Years Employed field on the Employment tab of the Employee Information page.
D	YEARS IN STATE	The number of years the employee worked in your state.	Retrieved from the Years in State field on the Employment tab of the Employee Information page.
E	YEARS IN TOTAL	The employee's total years of experience.	Retrieved from the Years in Total field on the Employment tab of the Employee Information page.