HR Labor Allocation Model (LAM) Standard Reports

To run the report, simply click the name.
- You must have COGNOS Access to run these reports. (How to Request Access)
- For information on downloading to Excel, Click Here

Report Name/Description Intended Audience Last Modified Type Notes/Comments Prompt Points
HR LAM Reports
Public Folders > 1-UD HR LAM Reporting
HR LAM Data
Report provides detail information on rows in the HR Labor Allocation Module (LAM).

sample prompt page 		Campus Community 7/1/2012 HTM;XLS
  • Report can be viewed and downloaded into Excel.
  • When using Effective Dated rows prompt you must select a start and end date.
  • Use the Optional prompts to further refine your selection.
  • Click the Finish button to submit the report.
 Required Prompts:
  • Date Range
    • Current rows = Most recent effective date LAM rows less than equal to today
    • All Future rows = LAM effective date rows greater then today
    • All History rows = LAM Effective date rows less than or equal to today
    • Effective Dated rows = LAM effective date between two dates.
Optional Prompts:
  • Department
  • Employee ID
  • Purpose
  • Fiscal Year
HR LAM Data Excel Format
Report provides detail information on rows in the HR Labor Allocation Module (LAM).

sample prompt page 		Campus Community 7/1/2012 XLS
  • Report will be downloaded into Excel.
  • When using Effective Dated rows prompt you must select a start and end date.
  • Use the Optional prompts to further refine your selection.
  • Click the Finish button to submit the report.
 Required Prompts:
  • Date Range
    • Current rows = Most recent effective date LAM rows less than equal to today
    • All Future rows = LAM effective date rows greater then today
    • All History rows = LAM Effective date rows less than or equal to today
    • Effective Dated rows = LAM effective date between two dates.
Optional Prompts:
  • Department
  • Employee ID
  • Purpose
  • Fiscal Year
HR LAM with Job Data
Report provides detail information on rows in the HR Labor Allocation Module (LAM).

sample prompt page 		Campus Community 7/1/2012 HTM;XLS
  • Report can be viewed and downloaded into Excel.
  • When using Effective Dated rows prompt you must select a start and end date.
  • Use the Optional prompts to further refine your selection.
  • Click the Finish button to submit the report.
 Required Prompts:
  • Date Range
    • Current rows = Most recent effective date LAM rows less than equal to today
    • All Future rows = LAM effective date rows greater then today
    • All History rows = LAM Effective date rows less than or equal to today
    • Effective Dated rows = LAM effective date between two dates.
Optional Prompts:
  • Department
  • Employee Status
  • Salary Admin Plan
  • Employee ID
  • Purpose
  • Fiscal Year
HR LAM with Job Data Excel Format
Report provides detail information on rows in the HR Labor Allocation Module (LAM).

sample prompt page 		Campus Community 7/1/2012 XLS
  • Report will be downloaded into Excel.
  • When using Effective Dated rows prompt you must select a start and end date.
  • Use the Optional prompts to further refine your selection.
  • Click the Finish button to submit the report.
 Required Prompts:
  • Date Range
    • Current rows = Most recent effective date LAM rows less than equal to today
    • All Future rows = LAM effective date rows greater then today
    • All History rows = LAM Effective date rows less than or equal to today
    • Effective Dated rows = LAM effective date between two dates.
Optional Prompts:
  • Department
  • Employee Status
  • Salary Admin Plan
  • Employee ID
  • Purpose
  • Fiscal Year
  • UD Office of Institutional Research  •   325 Hullihen Hall  •   Newark, DE 19716  •   USA
    Phone: 302-831-2021  •   E-mail: ir-udew-it@udel.edu  •  © 2013