Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

COPH Active Student Information

...

Filters

Start Term

U Number

Report Elements


Anchor
Report Elements Glossary
Report Elements Glossary

...

Term
Element

Source

(System->Table->Column)

Description
Anchor
TermTerm
USF_IDSPRIDEN - SPRIDEN_ID
FIRST_NAMESPRIDEN - SPRIDEN_FIRST_NAME
LAST_NAME SPRIDEN- SPRIDEN_LAST_NAME
EMAILGOREMAL - GOREMAL_EMAIL_ADDRESS
COLLEGE_CODESGBSTDN - SGBSTDN_COLL_CODE_1Coll is restricted to just pull in PH 
DEGREE_CODESGBSTDN- SGBSTDN_DEGC_CODE_1
CONCENTRATIONSGBSTDN - SGBSTDN_MAJR_CODE_CONC_!
START_TERMSTVTERM - STVTERM_DESCJOIN STVTERM TABLE ON STVTERM_CODE TO SGBSTDN_TERM_CODE_ADMIT FROM SGBSTDN TABLE 
GPASHRLGPA - SHRLGPA_GPA_HOURSTO_NUMBER (DECODE (SHRLGPA_GPA_HOURS,0, NULL,TRUNC (SHRLGPA_QUALITY_POINTS / SHRLGPA_GPA_HOURS, 2)))
CATALOGYEARSTVTERM - STVTERM_ACYR_CODECONCAT (CONCAT (CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 1, 2)), '/'),CONCAT (20, SUBSTR (STVTERM_ACYR_CODE, 3, 4)))
DEGREE_STATUSSGBSTDN - SGBSTDN_STST_CODEDECODE (STST_CODE, 'IS', 'Inactive', 'Active')
REGISTRATIONHOLDSWRHOLD - SWRHOLD_REASONSWRHOLD_HLDD_CODE = 'PH' AND JOIN SWRHOLD AND SPRIDEN TABLES ON SWRHOLD_PIDM AND SPRIDEN_PIDM
PROBATION_STATUSSTVASTD - STVASTD_DESCSTVASTD_PROBATION_IND = 'Y' AND JOIN SGRTTRM AND STVASTD TABLES ON SHRTTRM_ASTD_CODE_END_OF_TERM AND STVASTD_CODE
GRADUATE ADVISORappiandb.COPH_REF_gradAdvisor - gradAdvApnUserName
FACULTY MENTORappiandb.USF_REF_advisor - advApnUserName

Report Run Date

Anchor
Report Run Date
Report Run Date

DAILY AT 7:30AMDate that the report data was refreshed from source

...