COPH Active Student Information
This
Report Elements Glossary Table
Report : COPH Active Student Information |
---|
Prompts
Tab 1: COPH Active Student Information
This report
Filters
There aren't any report filters
Report Elements
The table below lists all the elements used in the Reports.
Element | Source (System->Table->Column) | Description | Frequency of Update |
---|---|---|---|
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 |