This page provides instructions for scheduling reports in CMS, including creating a new request, copying a request, and defining and saving a report schedule.
New Request
Before You Start
- Enter ofweb.stanford.edu in the browser
- Click Login
- As prompted, log in using SUNet ID and password
- Click SU CMS USER
- Select Reports tab from the Reports screen
- Select View Previously Run Reports button
- Select Submit Request
- Search and select or enter Program Name: XXDL: SC Schedule CMS Reports
- Enter customized Request Name The Request Name can be used later to search for this request in Copy Request. Refer to the Copy Request tab on this page.
- Select Next
Select the favorite for which you want to submit the report
Select the PI/Task Owner for which you want to submit the report
Select the Task Org for which you want to submit the report
Select the Task Manager for which you want to submit the report
Select the Project for which you want to submit the report
Select the Task for which you want to submit the report. This option will be enabled only after selection of a Project (5)
Select the Award for which you want to submit the report
Select the PTA/PTA nickname for which you want to submit the report
You have to search and select either the PTA (if no nickname has been set up), or the PTA nickname, in order to activate the "PTA Period" parameter as described below.
Select other parameters, if desired:
• PTA Period: Select the PTA Period for which you want to submit the report. This option will be enabled only after selection of PTA Nickname/PTA (see above)
• Commitment Type (CMS or Hard)
• Budget Type (hard or soft) from the drop-down menu
Report will not be selected to run
- PDF – Report selected to run with "PDF" (see above: PTA Nickname/PTA) as output type
- XLS (Report format) – Report selected to run with "XLS (Report format)" as output type
- XLS (Data Only) – Report selected to run with "XLS (Data Only)" as output type
Required if 720: PTA Overview is selected with any
- 2 – SuperGroups Only: Direct vs Indirect
- 3 – Group Subtotals Only; no Exp Types
- 4 – Group and Subgroup Totals only; No Exp Types
- 5 – Expenditure Types w/ Group Subtotals
- 6 – Expenditure Types only; no Groups or Subtotals
Required if 720: PTA Overview is selected with any output option other than "None"
- Detail & Summary
- Detail Only
- Summary Only
Optional if 720: PTA Overview is selected with any output option other than "None"
- None
- Salary v/s Non-Salary
Select the Start period for the SC760, 770, 780, 790 reports. End Period will be automatically selected in the background
- None – Report will not be selected to run
- PDF, XLS (Report format) or XLS (Data Only) – Report selected to run with " Excel" as output
Required if 800: Month By Month Burn Rate: by PTA is selected with any output option other than "None"
- 2 – SuperGroups Only: Direct vs Indirect
- 3 – Group Subtotals Only; no Exp Types
- 4 – Group and Subgroup Totals only; No Exp Types
- 5 – Expenditure Types w/ Group Subtotals
- 6 – Expenditure Types only; no Groups or Subtotals
- 7 – People and G&S details, Group and Subgroup Totals; No Exp Types
Required if 800: Month By Month Burn Rate: by PTA is selected with any output option other than "None". Default option "Last 3 months"
- Last 3 months
- Last 6 months
- Last 9 months
- Last 12 months
Required if 820: PTA Notes is selected with any output option other than "None". Default option "1 – ALL"
- 1 – ALL
- 2 – P-T-A
- 3 – Soft Budget
- 4 – Custom Period
- 5 – Soft Commitment
- 6 – Employee
- 7 – Student
- 8 – Alerts
c. Select Next
- Select New Schedule, or Saved Schedule (refer to Define & Save a Report Schedule tab on this page) from the Schedule Request: Schedule screen
- Simple Schedule
- Enter Start Date
- Apply Interval and increment date for Recurring schedule
- Advanced Schedule
- Select Start date/time
- Select End date/time
- Specify recurring months/dates, and increment dates
- Select Next
- Enter email address for individual(s) to receive notifications of scheduled requests from the Schedule Request: Notifications screenReport originator automatically receives notification.
- Select Next
- Select all default parameters from the Schedule Request: Delivery screen
- Select Next
- Review report parameters and scheduling options from the Schedule Request: Review screen
- Select Submit
- Select Next
- An email will be generated when the scheduled requests begin, with Request IDs of reports selected to run.
- From the Requests Summary Table, select reports to view or save.
Copy Request
Before You Start
- Enter ofweb.stanford.edu in the browser
- Click Login
- As prompted, log in using SUNet ID and password
- Click SU CMS USER
- Select Reports tab from the Reports Screen
- Select View Previously Run Reports button
- Select Submit Request
- Select Copy Request radio button
- Search for and select existing (previously submitted) request
- Enter customized Request Name It is recommended to create Request name to facilitate future search.
- Select Next
- Retain or modify the accounts (PTAs) and report parameters from the Schedule Request: Parameters screen
- Save the request with a different name if you modify the previously submitted report parameters
- Retain or modify scheduling options from the Schedule Request: Schedule screen
- Select New Schedule, or Saved Schedule (Refer to the Define & Save a Report Schedule tab on this page)You may want to save the request with a different name if you modify the previously submitted schedule options.
- Enter email address for individual(s) to receive notifications of scheduled requests from the Schedule Request: Notifications screenReport originator automatically receives notification.
- Select Next
- Select all default parameters from the Schedule Request: Delivery screen
- Select Next
- An email will be generated when the scheduled requests begin, with Request IDs of reports selected to run.
- From the Requests Summary Table, select reports to view or save.
Define & Save a Report Schedule
Before You Start
- Enter ofweb.stanford.edu in the browser
- Click Login
- As prompted, log in using SUNet ID and password
- Click SU CMS USER
- Select Reports tab from the Reports screen
- Select View Previously Run Reports button
- Select Submit Request
- Select Manage Schedule
- Select Create
- Retain or modify the accounts (PTAs) and report parameters from the Schedule Request: Parameters screen
- Enter schedule name
- Enter schedule description (optional)
- Simple Schedule
- Specify Start date/time
- Specify End date/time
- Apply increment interval for recurring schedule
- Advanced Schedule
- Specify Months and Dates or Days of the month
- Select Apply
- Select OK
- Use this schedule by selecting the Saved schedule on Schedule Request screen.