Business Intelligence

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 ReportsPublic 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