Report Developer Access Request SNOW Form Example

Required Form Questions

Submitted by:

Requested For:

Job Title:

Manager:

Department:

Do you need on-going access or one-time access for a project?

Please explain your need for access:

How often do you work with the data?

Are you willing to share your reports with the entire campus, if appropriate?

• Submitted by: auto-populate and lock to user name of person filling out the form
• Requested For:  Auto-populated with user name, can be changed to another user. (required)  Limit to UCSD employees only.
• Job Title: Auto-populated based on 'Requested For' (required)
• Department: Auto-populated based on 'Requested For' (required)
• Manager: Auto-populated based on 'Requested For' (required)
• Do you need on-going access or one-time access for a project? (required)
  
  • Single select from 'One-time project access' or' Persistent access as part of my job'
• Please explain your need for access: Free form text
• How often do you work with student financial aid data? 
  • Single select from 'Daily', 'Weekly', 'Monthly', or 'Less frequently than once a month'
• Are you willing to share your reports with the entire campus, if appropriate?
  • Single select from 'Yes', 'No'.

Form Specific Questions

What Students do you work with?

What Financial departments do you need access for?

Do you need ...?

Form Specific Requirement or Training

SNOW can look up AD group member

SNOW can look up UC Learning training status

• SNOW can look up AD group member
  • Provide Active Directory group name
  • Refreshed nightly, will not reflect membership changes until the next day
• SNOW will look up Privacy 101 Workshop
  • Official name = Privacy 101 Workshop
  • Code = SD-VCAA-1914
  • Link = https://uc.sumtotal.host/Core/pillarRedirect?relyingParty=LM&url=core%2Factivitydetails%2FViewActivityDetails%3FActivityId%3D357110%26UserMode%3D0
  • Refreshed nightly, will not reflect the training completion until the next day

Note:  SNOW will ping UC Learning to verify training certification but will not save any of that information to SNOW.

Report Developer Required Training

Has user completed FERPA training?

Has user completed Privacy 101 training?

For more information see FERPA - Confidentiality of Student Records and Privacy Rights. and Privacy 101 Workshop and Financial Aid Data Sharing Laws and Regulations.

• SNOW will look up FERPA training
  • Official name = FERPA - Confidentiality of Student Records and Privacy Rights
  • Code = 06SEDFERPA
  • Link = https://uc.sumtotal.host/Core/pillarRedirect?relyingParty=LM&url=core%2Factivitydetails%2FViewActivityDetails%3FActivityId%3D287667%26UserMode%3D0
  • If no record in UC Learning then ask customer to (1) check box that they have taken the training, (2) add the date of the training and (3) attach certificate.
• SNOW will look up Privacy 101 Workshop
  • Official name = Privacy 101 Workshop
  • Code = SD-VCAA-1914
  • Link = https://uc.sumtotal.host/Core/pillarRedirect?relyingParty=LM&url=core%2Factivitydetails%2FViewActivityDetails%3FActivityId%3D357110%26UserMode%3D0
  • If no record in UC Learning then ask customer to (1) check box that they have taken the training, (2) add the date of the training and (3) attach certificate.

User cannot submit request without UC Learning confirmation or attached certificates.

Note:  SNOW will ping UC Learning to verify training certification but will not save any of that information to SNOW.

Report Acknowledgment

Upon clicking 'Submit' an approval request will be sent via email to your manager. After your manager approves, your request will be sent to the Data Steward for approval.

Submit.

System default notification - cannot be changed:

Your request has been received and entered into the system. You will receive an update as it is reviewed and processed. Here is a ticket number for your records:

APPROVAL request sent to Manager.

APPROVAL Notification1:  Notification to manager

Reminder ping sent at 1 week, every week until addressed.

System default notification - cannot be changed:

Click here to approve or reject this request.

Custom Text:

Your request for Developer access to the % Activity Hub Data has been approved by your manager.  This access requires both your manager's and the Data Steward's approval.

The request has been forwarded to Data Steward for their approval.

APPROVAL request sent to Data Steward.

https://blink.ucsd.edu/technology/bi/governance/council.html

APPROVAL Notification3: Notification to Data Steward

Reminder ping sent at 1 week, every week until addressed.

System default notification - cannot be changed:

Click here to approve or reject this request.

Custom Text:

Your request for Developer access to the % Activity Hub Data has been approved by the Data Steward.  In receiving access to the % Activity Hub both you and your manager are certifying that the access is necessary to an employment responsibility or that it is a properly assigned subject matter.  Both you and your manager will be accountable for the appropriate use and distribution of data, analytics and reports by the Report Developer.

ITS will now provision you access.

ITS location of AD group:  will depend on the data steward and activity hub

Managed by ITS-WorkStationLifecycle

Created ticket for ITS-WorkStationLifecycle to request all of these AD groups are created =

Custom Text:

Your Developer access to the % Activity Hub Data has been provisioned.  Please keep in mind that in receiving access to the % Activity Hub Data, both you and your manager are certifying that the access is necessary to an employment responsibility or that it is a properly assigned subject matter. If your role changes such that this is no longer the case, your access should be revoked.

Request rejected notification to Requestor (Rejected by manager)

Custom Text:

Your Developer request for access to the % Activity Hub Data has been been rejected by your manager.  Please follow up with your manager for further information.

Rejection Notes: <from rejection notes in SNOW form>

Custom Text:

Your Developer request for access to the % Activity Hub Data has been been rejected by the Data Steward.  Please follow up with your manager for further information.

Rejection Notes: <from rejection notes in SNOW form>