Payroll Detail Table

Data Elements in the Stf_Payroll_by_Account Table

Data Element Name Long Name Size

Account Account Number
6

Account Title Account Title
35

Annual_Amount Annual Amount
17

Annual_Rate Annual Rate
17

Distribution_No Distribution Number
2

Eff_Date Effective Date
7

Employee_Initials Employee Initials
2

Employee_Last_Name Employee's last name
16

Employee_Number Employee Number
9

FTE_Employee FTE Employee
12

Location_1 UC Location Code 1 2

Location_1_Title UC Location Code 1 Title 13

Location_2 UC Location Code 2 1

SAU Systemwide Administrative Unit Code 1

SAU_Description Systemwide Administrative Unit Description 35

Sub_Account Sub Account Number 2

Sub_Campus_ID Sub Campus ID 1

Title_Code Title Code 4

Title_Name Title Name 30

10/11/2007
By Office of the President

Data Element Name	Long Name	Size
Account	Account Number	6
Account Title	Account Title	35
Annual_Amount	Annual Amount	17
Annual_Rate	Annual Rate	17
Distribution_No	Distribution Number	2
Eff_Date	Effective Date	7
Employee_Initials	Employee Initials	2
Employee_Last_Name	Employee's last name	16
Employee_Number	Employee Number	9
FTE_Employee	FTE Employee	12
Location_1	UC Location Code 1	2
Location_1_Title	UC Location Code 1 Title	13
Location_2	UC Location Code 2	1
SAU	Systemwide Administrative Unit Code	1
SAU_Description	Systemwide Administrative Unit Description	35
Sub_Account	Sub Account Number	2
Sub_Campus_ID	Sub Campus ID	1
Title_Code	Title Code	4
Title_Name	Title Name	30