SC_Fiscal_Year (date)

For any date entered, this function will return the Smith College Fiscal Year in 4 digit character format.  The fiscal year for Smith starts Jul first of the previous year and ends on June 30th. You can return a two digit Fiscal Year value by using the substring function in your expression:

substring(SC_Fiscal_Year([ENTRY_DATE]),3,2)

SC_Fiscal_Year_Start (date)

For the date entered, this function will return the Smith Fiscal Year Start date in full date format.  The fiscal year for Smith starts on Jul 1st and ends on June 30th.  It is determined using the month and year of the date entered.  Use the Reportnet data item Format property to tailor the date display to your needs.

SC_Fiscal_Year_End (date)

For the date entered, this function will return the Smith Fiscal Year End date in full date format.  The fiscal year for Smith starts on Jul 1st and ends on June 30th.  It is determined using the month and year of the date entered.  Use the Reportnet data item Format property to tailor the date display to your needs.

SC_Phone (uid, Address_Code)

This function will return a formatted version of person_uid's active Address_Code phone number or null if it does not exist.  Basic format is (xxx) xxx-xxxx.

SC_ValidNumber (The_Number)

This function will return The_Number entered only if it is a valid number, or else it will return a null.  This allows statistical functions to be calculated that would otherwise fail due to bad numeric data.

(SC_Email (uid, ‘Email_Code’)

Pulls the email address for person with UID for the Emal_Code entered. The status must be 'A.' From Banner goremal table.

SC_Preferred_Email (uid)

Pulls the preferred email address for person with UID. The status must be 'A.' From Banner goremal table.

SC_Adm_Legacy (person_uid)

Admissions function which returns a horizontal list of mother, grandmother, and sister legacy values from ODS table Admission Comments SC, Banner table sprcmnt. If no values exist a null value is returned.

SC_Adm_SaMa_Phone (person_uid)

This Admissions function returns the formatted version of the SA or MA (if SA is not availble) phone number or null if neither exists. The hierarchy is pull from Banner table gtvsdax, internal group code ADDRESS, internal code ADMSADDR. Basic format is (xxx) xxx-xxxx.

SC_Adm_Attr_Exists (person_uid, attribute_code, academic_period)

This admissions function will return a 'Y' if the person_uid has an admissions attribute record for the attribute code and academic_period entered. If there is no record, a null is returned. Attribute records are found in ODS table ADMISSION ATTRIBUTE, Banner table saraatt.

SC_Adm_Interest_Exists (person_uid, interest_code)

This function will return a Y if person_uid has interest_code record in ODS Admissions table INTEREST, Banner table sorints. If not, it returns null.

SC_Adm_Music_Interests (person_uid)

For person_uid, this function returns a horizontal list of descriptions of music codes frp, ODS table INTEREST, Banner table sorints. The codes included are:

'FL','OB','CL','BN','HN','TP','TM','TB',

'HP','PC','VN','VA','VC','CB','SX'.

SC_Adm_Athletics (person_uid)

This function returns a horizontal listing of sport descriptions that the person_uid is involved in.  Data is taken from the ODS table Secondary School Subject where the subject code does not start with RATE.  Banner table is sorhsbj.

SC_Adm_Comment_Exists (person_uid, 'comment_code')

This admissions function which will return a 'Y' if the person_uid has an admissions comment record for the comment_code entered.  If there is no record, a null is returned.  Comment records are found in ODS table Admission Comments SC, Banner table sprcmnt.

SC_Adm_Contact_Exists (person_uid, 'contact_code')

This admissions function which will return a 'Y' if the person_uid has an admissions contact record for the contact_code entered.  If there is no record, a null is returned.  Contact records are found in ODS table Contact, Banner table sorcont.

SC_Adm_MaxTestScore (person_uid, 'test_code')

This admissions function which will return the highest (maximum) score for test_code for person_uid. If we have no data for the test and there is no record, a null is returned.  Test score records are found in ODS table Test.   Banner table sortest.

SC_Adm_Ath_GPA (person_uid)

This function returns a horizontal listing of sport grades that the person_uid is involved in. Data is taken from the ODS table Secondary School Subject, the GPA field, where the subject code does not start with RATE. If there is more than one sport, the grades appear in the same order as the SC_Adm_Sports results. Banner table is sorhsbj.

SC_Stu_Attr_Exists (student_uid, attribute_code, academic_period) 

This student function will return a 'Y' if the person_uid has a student attribute record for the attribute code and academic_period entered.  If there is no record, a null is returned.  Attributes are pulled from ODS table STUDENT ATTRIBUTE, Banner table sgrsatt.

SC_Student_Class (student_uid, academic_period)

This student function will pull a 3 character class (including J for J terms and AC for Adas) for student_uid

SC_Student_UG_Class (student_uid, academic_period)

This student function will pull the final UG 3 character class (including J for J terms and AC for Adas) for student_uid as of the academic_period. This may not be the current class if the student is doing graduate work. The class is pulled from the ODS Student Attributes table, Banner table sgrsatt

SC_Stu_Valid_DeptCrse (department_code, subject_code, subject_group, course_number)

This student function will return a ‘Y’ if the course reflected in the input parameters is valid for a major in the department. It was created for the “Courses Outside the Major” report. This report looks for a null value to be returned.

SC_Adv_GiftSocComs (person_uid, year, gift_society_code)

This advancement function will display the concatenated gift society comments for a particular constituent person_uid, 4 digit year, and gift_society_code. It is meant to be used with the Gift Society QS. Comments are separated by a semi-colon. 

SC_Adv_GPin (person_uid, year, gift_society_code)

This advancement function will return a 'Y' for a particular constituent person_uid, 4 digit year, and gift_society_code if that person has received a Grecourt Pin. It is meant to be used with the Gift Society QS.

SC_sfs_stu_class (return_type, class_year_senior, student_population, grad_year_intended)

This Student Financial Services function will return the Student Class Description or Student Class Sort Order for a particular student person_uid.  For example, Junior, Senior, etc.   

return_type:  'S' returns the Sort Order.  'D' returns the Description.
student_population = academic_study.student_population
grad_year_intended = academic_study.grad_year_intended
class_year_senior = inputted by calling program

SC_sfs_stu_type (return_type, student_population, citizenship_type)

This Student Financial Services function will return the Student Type Description or Student Type Sort Order for a particular student person_uid.  For example, Traditional U.S., Ada Comstock Scholars, etc.   

return_type:  'S' returns the Sort Order.  'D' returns the Description.
student_population = academic_study.student_population
citizenship_type = person_detail.citizenship_type

SC_sfs_stu_resd (return_type, student_population, student_status, room_assignment)

This Student Financial Services function will return the Student Resident Description or Student Resident Sort Order for a particular student person_uid.  For example, On-Camp in Dorm, Jr. Year Abroad, On Leave, Off-Camp Loc Apt, etc.

return_type:  'S' returns the Sort Order.  'D' returns the Description.
student_population = academic_study.student_population
student_status = academic_study.student_status
room_assignment = room_assignment.building