COPH Active Student Information

Owned by Sunitha Balasubramanian (Deactivated)
Last updated: Jun 17, 2021
1 min read

COPH Active Student Information

This report displays all active COPH students from Banner who have not graduated. The advisor information is pulled from Archivum.

Report Elements Glossary Table


Report : COPH Active Student Information


Tab 1:  COPH Active Student Information

The report is refreshed daily at 7.30 am. 

Filters

Start Term

U Number

Report Elements


The table below lists all the elements used in the Reports. 


Element

Source

(System->Table->Column)

Description
USF_IDSPRIDEN - SPRIDEN_ID
FIRST_NAMESPRIDEN - SPRIDEN_FIRST_NAME
LAST_NAME SPRIDEN- SPRIDEN_LAST_NAME
EMAILGOREMAL - GOREMAL_EMAIL_ADDRESS
COLLEGE_CODESGBSTDN - SGBSTDN_COLL_CODE_1Coll is restricted to just pull in PH 
DEGREE_CODESGBSTDN- SGBSTDN_DEGC_CODE_1
CONCENTRATIONSGBSTDN - SGBSTDN_MAJR_CODE_CONC_!
START_TERMSTVTERM - STVTERM_DESCJOIN STVTERM TABLE ON STVTERM_CODE TO SGBSTDN_TERM_CODE_ADMIT FROM SGBSTDN TABLE 
GPASHRLGPA - SHRLGPA_GPA_HOURSTO_NUMBER (DECODE (SHRLGPA_GPA_HOURS,0, NULL,TRUNC (SHRLGPA_QUALITY_POINTS / SHRLGPA_GPA_HOURS, 2)))
CATALOGYEARSTVTERM - STVTERM_ACYR_CODECONCAT (CONCAT (CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 1, 2)), '/'),CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 3, 4)))
DEGREE_STATUSSGBSTDN - SGBSTDN_STST_CODEDECODE (STST_CODE, 'IS', 'Inactive', 'Active')
REGISTRATIONHOLDSWRHOLD - SWRHOLD_REASONSWRHOLD_HLDD_CODE = 'PH' AND JOIN SWRHOLD AND SPRIDEN TABLES ON SWRHOLD_PIDM AND SPRIDEN_PIDM
PROBATION_STATUSSTVASTD - STVASTD_DESCSTVASTD_PROBATION_IND = 'Y' AND JOIN SGRTTRM AND STVASTD TABLES ON SHRTTRM_ASTD_CODE_END_OF_TERM AND STVASTD_CODE
GRADUATE ADVISORappiandb.COPH_REF_gradAdvisor - gradAdvApnUserName
FACULTY MENTORappiandb.USF_REF_advisor - advApnUserName

Report Run Date

DAILY AT 7:30AMDate that the report data was refreshed from source