Skip to main content

Annual Security Access Recertification

Each year, Northwestern University conducts a review of user access for the NUFinancials and Cognos systems as part of the University’s larger effort to comply with industry standards for information security. Approvers review active users for their department/unit and provide feedback for any updates to the Financial Operations IT Security team.

Instructions for Performing the Recertification Review

Background and resources

The 2021 Annual Security Access Recertification includes three categories in the worksheet for review. 

Recertification Worksheet Categories

Categories

Approver

Cognos Reports

Employee Self Service
(Basic Roles Only)

Description

Approval for assigned Tree Nodes, Departments and or Project IDs

Assigned chartstrings, including Tree Nodes, DeptIDs and/or Project IDs

Access to create expense reports, shop in ACQUIIRE, enter journals, as well as look up assets, Chartfield attributes, expenses, and journals

GE007 Report Reference

Review PeopleSoft Roles section

Review Workflow Approvals section

Review Data Security Access (RLS) section

 

N/A – Review of the GE007 for these users is NOT required

You still must indicate whether user should remain active or be inactivated. 

Review steps

For each user on the Recertification form (as applicable), verify that the following sections in GE007 report are correct: 

  1. PeopleSoft Roles – roles that dictate the functions a user can perform in NUFinancials
  2. Workflow Approvals - level(s) of approval assigned to a user for Tree Nodes and chart string values
  3. Data Security Access (RLS)
    • Nodes and chart string values limit the data viewable online and in Cognos reports
    • Note the extra column “Access Managed By” at the end of the Department Values section.  If field lists “Chartfield Manager Module” then access was granted because the individual is identified as the ChartField Manager for the DeptID value.  If field is empty, then access was granted by submission of a FFRA security form.  

Your review should be performed effective as of June 7, 2021, when the data was extracted from NUFinancials. The review is performed on an annual basis, and additional staff hired after June 7th will be on the subsequent year’s review. Users who have been locked-out but have not had their access removed yet will still produce results in the GE007.  Instructions for running the GE007 Report to perform your review are available in the next section of this webpage. 

Finalization and submission of User Access Recertification

  1. For each user, the reviewer must indicate their status. Mark an X in the column under Status that matches the user’s current employment standing within your department/unit. All users must have at least one Status column marked. 
    • Active – Mark an X in this column under Status if the user’s access is correct and no change is needed.
    • Active but Incorrect Access – Mark an X in this column under To correct the user’s access, use a new Security Form and submit via email to Financial Operations IT Security.
    • Not in Unit / School – Mark an X in this column under Status if the user is does not belong to your department/unit.
    • No longer @ NU – Mark an X in this column under FOIT Security will remove all FFRA Systems access for the user with the exception of the Basic Expense and Shopper roles.
    • Terminate Date – Indicate the Date the user was (or will be) terminated from the department/unit. FOIT Security will remove all FFRA Systems access with the exception of the Basic Expense and Shopper roles for the user according to the date provided.
    • Transfer Date – Indicate the Date the user moved to another department/unit. FOIT Security will remove all FFRA Systems access to your department/unit with the exception of the Basic Expense and Shopper roles according to the date provided.
    • On Leave or Emeritus – Mark an X in this column under User’s NUFinancials profile will remain active unless otherwise noted by reviewer.
  2. After access for each user is verified, the reviewer must type their name and date of review at the top of the spreadsheet: reviewby.jpg
  3. Submit the completed and signed (by typing name and date of review as described above) spreadsheet via email to FOIT Security.

Instructions for Running the GE007 Report

Browser considerations

The GE007 report is best supported in the Mozilla Firefox browser.  If you prefer Internet Explorer, refer to additional steps in the Running the GE007 Report section below.

Navigation to the GE007 Report

  • Login to Cognos Reporting
  • Click Team content on the left menu
  • Click Finance Facilities and Research Administration
  • Click School
  • Click either Budget/COA or Monthly Financial (either selection works)
  • Click GE007 – User Security Profile

Running the GE007 Report

The GE007 Report can run reports for multiple users or departments. The report for users will be used to review individual information. The report for departments will be used to identify any new additions or unexpected users who do not belong to your department.

 To look-up multiple users:
  1. Select the entire column of NetIDs from your departmental excel spreadsheet.
  2. Click “copy”
  3. Under Report Run Control select “NetID – Name”
  4. Under the “Keywords” field, right click and select “paste”
  5. Click “Search”
  6. Click “Select All” to highlight all the NetIDs in the Results field and click “Insert”
  7. Click “Finish”  
Additional look-up steps for Internet Explorer method:
  1. Select the list of NetIDs and right click copy
  2. Use an empty excel cell and right click “Paste Special”
  3. Choose the “Transpose” option
  4. Copy the row of NetIDs and paste into the GE007 search box.

 To look-up a Department: 
  1. Under Report Run Control select “FASIS Department Search & Select”
  2. Type in the name of the department (if you do not know the exact name of the DeptID, under “Options” click “Contains any of these keywords”)
  3. Click “Search”
  4. Click on the DeptID and click “Insert”
  5. Click “Finish”