COPH Active Student Information
This report displays all active COPH students from Banner who have not graduated. The advisor information is pulled from Archivum.
| Table of Contents | ||
|---|---|---|
|
...
Report : COPH Active Student Information |
|---|
...
Tab 1: COPH Active Student Information
This report The report is refreshed daily at 7.30 am.
Filters
There aren't any report filtersStart Term
U Number
Report Elements
| Anchor | ||||
|---|---|---|---|---|
|
The table below lists all the elements used in the Reports.
| Element | Source (System->Table->Column) | Description | Frequency of Update | |||||
|---|---|---|---|---|---|---|---|---|
| Anchor | Term | Term | Term||||||
| 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 |
...