COPH Active Student Information
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_ID | SPRIDEN - SPRIDEN_ID | |
FIRST_NAME | SPRIDEN - SPRIDEN_FIRST_NAME | |
LAST_NAME | SPRIDEN- SPRIDEN_LAST_NAME | |
GOREMAL - GOREMAL_EMAIL_ADDRESS | ||
COLLEGE_CODE | SGBSTDN - SGBSTDN_COLL_CODE_1 | Coll is restricted to just pull in PH |
DEGREE_CODE | SGBSTDN- SGBSTDN_DEGC_CODE_1 | |
CONCENTRATION | SGBSTDN - SGBSTDN_MAJR_CODE_CONC_! | |
START_TERM | STVTERM - STVTERM_DESC | JOIN STVTERM TABLE ON STVTERM_CODE TO SGBSTDN_TERM_CODE_ADMIT FROM SGBSTDN TABLE |
GPA | SHRLGPA - SHRLGPA_GPA_HOURS | TO_NUMBER (DECODE (SHRLGPA_GPA_HOURS,0, NULL,TRUNC (SHRLGPA_QUALITY_POINTS / SHRLGPA_GPA_HOURS, 2))) |
CATALOGYEAR | STVTERM - STVTERM_ACYR_CODE | CONCAT (CONCAT (CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 1, 2)), '/'),CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 3, 4))) |
DEGREE_STATUS | SGBSTDN - SGBSTDN_STST_CODE | DECODE (STST_CODE, 'IS', 'Inactive', 'Active') |
REGISTRATIONHOLD | SWRHOLD - SWRHOLD_REASON | SWRHOLD_HLDD_CODE = 'PH' AND JOIN SWRHOLD AND SPRIDEN TABLES ON SWRHOLD_PIDM AND SPRIDEN_PIDM |
PROBATION_STATUS | STVASTD - STVASTD_DESC | STVASTD_PROBATION_IND = 'Y' AND JOIN SGRTTRM AND STVASTD TABLES ON SHRTTRM_ASTD_CODE_END_OF_TERM AND STVASTD_CODE |
GRADUATE ADVISOR | appiandb.COPH_REF_gradAdvisor - gradAdvApnUserName | |
FACULTY MENTOR | appiandb.USF_REF_advisor - advApnUserName | |
Report Run Date | DAILY AT 7:30AM | Date that the report data was refreshed from source |