COPH Active Student Information
...
| Table of Contents | ||
|---|---|---|
|
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
| Anchor | ||||
|---|---|---|---|---|
|
The table below lists all the elements used in the Reports.
| Element | Source (System->Table->Column) | Description | Frequency of Update | ||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
| 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 | ||||||||
| 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 | |||||||
Report Run Date
| DAILY AT 7:30AM | Date that the report data was refreshed from source |