COPH Active Student Information
...
Filters
Start Term
U Number
Report Elements
Anchor | ||||
---|---|---|---|---|
|
...
Element | Source (System->Table->Column) | Description | ||||||
---|---|---|---|---|---|---|---|---|
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 |
...