Smith College Admission Academics Student Life About Smith news Offices
  Home > Offices > Information Technology Services > TARA > Banner System > Cognos ReportNet Custom Functions  
 
       
 



Categories
Welcome
Getting Started
25Live Scheduling
Account Forms
Admin Systems*
BannerWeb
Cloud Storage
File Transfer
Google Apps
   Smith Mail
   Contacts
   Calendar
   Drive
Internet Browsers
Macintosh
   Connecting
   Backup & Restore
   Upgrading
   Related Apps
   Other Info
Microsoft Office
   Excel
   PowerPoint
   Word
Microsoft Windows
Mobile Devices
Moodle
Passwords
Printing
Security  
Smith Network
Smith Portal
Smith ResNet
Standard Software
Telephones
Terminal Emulators
Training
Unix
Viruses & Spyware
Web Development
Wireless Computing

*Smith login required

 

COGNOS REPORTNET CUSTOM FUNCTIONS

 

A function is a computer program which returns a value.  It may or may not use data parameter input enclosed in parenthesis.  The Smith custom functions are available for use in ReportNet  expression builder when creating a new data item, query calculation, or filter.  They may show up in your package on the functions tab under the Model category.  However, you can use them even if they do not show up on this tab.  Drag the function from the function tab or just type it in.  Then drag in your input parameters from your package data items.   The function will return a result as described below.  All the functions below were requested by Smith ODS  report writers.

 

General (no associated module)

 

Function

Description

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.

 

Admissions

 

Function

Description

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.

 

 

Student

 

Function

Description

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.

 

 

Advancement

 

Function

Description

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.

 

 

Student Financial Services

 

Function

Description

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

 

 

 


Back to top >



 

 


Copyright © 2008 Smith College Information Technology Services  |  Stoddard Hall  |  Northampton, MA 01063
413.585.3770  |  Questions or comments?  Send us email.  |   Last updated March 22, 2010


DirectoryCalendarCampus MapVirtual TourContact UsSite A-Z