Data Source	Snowflake
Job/Process Source (Refresh Interval)	Daily Ingest
Report Domain	Contact information for students involved in the AAC program
Functional User(s)	Melony Henson, Lyndsi Litten, Maria Hamid
Constituent(s)
Report Owner	Melony Henson
Data Domain(s)	Demographic
Contains PII	Yes

What It’s Used For

Generates a contact list for AAC program students that have not followed the contact procedure for 3 terms in a row (Summer, Fall, Spring).

Options

Options	Description

Options	Description
Spring Term	Select the Spring term of interest. This also populates hidden fields that determine the prior two terms (Fall and Summer).

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
STUDENT_NAME	`SPRIDEN_LAST_NAME` and `SPRIDEN_FIRST_NAME`	Student’s name (Last, First)
BANNER_ID	`SPRIDEN_ID`	Banner ID
EMAIL	`GOREMAL_EMAIL_ADDRESS`	Student’s web-listed email address. Typically a @giant.cos.edu email address.
CONTACT_PHONE	`SPRTELE_PHONE_AREA` and `SPRTELE_PHONE_NUMBER`	Listed primary phone. May or may not be a mobile device.
MOBILE_PHONE	`SPRTELE_PHONE_AREA` and `SPRTELE_PHONE_NUMBER`	Listed mobile phone number.
SPRING_ENROLL_STATUS	`SFRSTCR_PIDM`	Flag for any positive count of `SFRSTCR_PIDM` for a given term. In this report, that term is the selected Spring term.
AAC	`SGRDISA_DISA_CODE`	Flag for AAC program students to determine AAC contact status.

Version	Date	Comment
Current Version (v. 1)	Sep 25, 2024 18:45	Michael Citi