The Chartfield Mapping Report lists both active and inactive department, position and appointment levels that are mapped to funding chartfields. The departments use this report to verify that the assigned levels are mapped correctly to funding chartfields, and make correction(s) as needed.

This report was developed using the following dataset:

• LCD_DeptChartfield_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Campus
• Fiscal Year
• Funding Effective Date Between
• Funding Status
• Funding Level
• DeptID
• Fund
• Program
• Class
• Project
• EmplID
• Employee Name
• Hierarchy Name
• Level1
• Level2
• Level3
• Level4

This report contains the following report fields:

• Campus
• Organization
• Dept ID
• Department Description
• Fiscal Year
• Funding Effective Date
• Dept. Budget Earning Status
• Funding Level
• Charged DeptID
• Fund
• Program
• Class
• Project
• % of Distrib.
• Position Pool ID
• Pool ID Description
• Position Number
• Position Title
• Appointment Empl ID
• Appointment Empl Rcd
• Appointment Employee Name
• Job Code
• Job Code Position Title
• Combo Code
• Account

The Employee Data and Funding Report lists both active and inactive employees who are mapped to their position and funding chartfields. The departments use this report to verfiy that employees are mapped correctly to their position and funding chartfields, and make correction(s) as needed.

This report was developed using the following dataset:

• LCD_EmployeeData_FundingReport_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Hierarchy Name
• Campus
• Fiscal Year
• Organization Unit
• DeptID
• EmplID
• Employee Name
• Position Number
• CSU Unit
• Employee Status
• Reports to Position Number
• Level1
• Level2
• Level3
• Level4

This report contains the following report fields:

• Campus
• Organization Unit
• Department
• EmplID
• Empl Rcd
• Employee Name
• Position Number
• Position Title
• Position Status
• Employee Effective Date
• Job Code Description
• Reports To Position Number
• Grade
• FTE
• CSU Unit
• Pool ID
• Fund
• % Distrib.

The Position Report lists both active and inactive positions that are linked to employees, and mapped to funding chartfields. The departments use this report to verify position data and its funding chartfields, and make correction(s) as needed.

This report was developed using the following dataset:

• LCD_Position_Snowflake

This report contains the following Control Prompts to allow users to filter data:

• Campus
• Department
• Organization Unit
• Position Effective Status
• Position Number
• Job Code
• Reports To
• Pool ID
• CSU Unit
• Fund
• Program
• Filled Count
• Effective Date Between
• Hierarchy Name

This report contains the following report fields:

• Campus
• Department
• Position Number
• Position Title
• Job Code Description
• Grade
• Reports To
• FTE
• CSU Unit
• Pool ID
• Fund
• % Distrib.

End of Article