Page Comparison

The table below lists all the elements used in the FIF ReportsXTRN Audit Log report. Note that this data is being reported from a view created by IT-Security in PRODARCH database, which pulls information from audit logs in Banner and Employee department information from GEMS.

Element

Source

(

System

Database->Table->COLUMN)	Description	Frequency of Update

Select Cohort

Employee

Anchor

Department

	Employee

DepartmentStudent Active AnchorStudent ActiveStudent ActiveBanner-> Sgbstdn-> SGBSTDN_STST_CODEValues of Yes/No- Student is considered Active if enrolled in any of the latest 3 semestersDailyUID AnchorUIDUIDSID-> SID_Enrollments-> UIDUSF ID of StudentDailyLast Name AnchorLast NameLast NameSID-> SID_Person_Demo-> NAME_LASTLast Name of StudentDailyFirst Name AnchorFirst NameFirst NameSID-> SID_Person_Demo->NAME_FIRSTFirst Name of StudentDailyHours Left to Graduate AnchorHours Left to GraduateHours Left to GraduateBanner-> Advisor_TrackStudent-> HOURSLEFTTOGRADUATENumber of hours remaining to graduateDailyCurrent Cohort # AnchorCurrent Cohort #Current Cohort #ComputedNumber of students in the cohort based on the selected filters Students Addressed % AnchorStudents Addressed %Students Addressed %ComputedStudents are considered addressed if they have graduated or have an anticipated graduation term, a potential grad year, or student not returning filled out.

Students Addressed Distribution: Internal vs External

AnchorStudents Addressed Distribution: Internal vs ExternalStudents Addressed Distribution: Internal vs ExternalComputedInternal vs External is the ratio of addressed students who have been in the college the whole time (internal) versus those who have changed college (external). Total Records Returned AnchorTotal Records ReturnedTotal Records ReturnedComputedNumber of records returned in the report Data Refreshed on AnchorData Refreshed onData Refreshed on Date that the report data was refreshed overall.DailyLast Refreshed Date AnchorLast Refreshed DateLast Refreshed Date Date that the student record was last updatedDailyAdvisor Name AnchorAdvisor NameAdvisor Name

Banner->Sgradvr

Banner->Spriden->SPRIDEN_FIRST_NAME

Banner->Spriden->SPRIDEN_LAST_NAME

First name concatenated with Last NameDailyAdvisor Type AnchorDescriptionDescriptionBanner->Sgradvr->ADVR_CODERestricted to only Priority 1 Assigned Advisor and Priority 2 Assigned AdvisorDailyStudent Count AnchorStudent CountStudent CountBanner->SgradvrCount of number of students who have been assigned to that specific advisorDailyStudent

	Employee

Banner-> Sgrchrt

Students listed in Banner with an FTICFT<YY>08 cohort. For example, FTICFT1408, FTICFT1508. Note that these Banner cohorts FTICFT<YY>08 are translated to FIF20<YY>, for example FTICFT1408 is translated to FIF2014.

FIF2014 - This cohort includes First Time In College(FTIC) students who started in Summer 2014 and continued on to Fall 2014 as a Full Time student along with students who started in Fall 2014 as a Full Time student.

AnnualCampus Original AnchorCampus OriginalCampus Original

SID-> Sid_Enrollments-> HOMECAMPUS

The campus where the student was enrolled when he/she first entered the cohort.AnnualCollege Original AnchorCollege OriginalCollege OriginalSID-> Sid_Enrollments-> COLLEGEThecollege where the student was enrolled when he/she first entered the cohort.AnnualDepartment Original AnchorDepartment OriginalDepartment OriginalSID-> Sid_Enrollments-> DEPARTMENTThe department where the student was enrolled when he/she first entered the cohort.AnnualMajor Original AnchorMajor OriginalMajor OriginalSID-> Sid_Enrollments-> MAJORThe major where the student was enrolled when he/she first entered the cohort.AnnualCampus Current AnchorCampus CurrentCampus CurrentBanner-> Sgbstdn-> SGBSTDN_CAMP_CODEThe campus of the student's most recent enrollmentDailyCollege Current AnchorCollege CurrentCollege CurrentBanner-> Sgbstdn> SGBSTDN_COLL_CODE_1The college of the student's most recent enrollmentDailyDepartment Current AnchorDepartment CurrentDepartment CurrentBanner-> Sgbstdn-> SGBSTDN_DEPT_CODEThe department of the student's most recent enrollmentDailyMajor Current AnchorMajor CurrentMajor CurrentBanner-> Sgbstdn-> SGBSTDN_MAJR_CODE_1The major of the student's most recent enrollmentDailyActual Graduated AnchorActual GraduatedActual GraduatedBanner-> ShrdgmrGraduation status of Awarded for Bachelor level degrees in Banner within a 4 year window from the time of cohort start. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.DailyActual Graduated % AnchorActual Graduated %Actual Graduated %ComputedActual Graduated students as a percentage of FIF Cohort within a 4 year window from the time of cohort start. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.DailyActual Gap Anchor#Actual Gap#Actual GapComputedAdditional students who need to graduate within 4 years to meet the target graduation rateDailyEstimated Graduates AnchorEstimated GraduatesEstimated GraduatesEstimated to Graduate in 4 YearsComputedStudents Working Towards Graduation in the specified time and Actual Graduated studentsDailyEstimated 4 Year Graduation % AnchorEstimated 4 Year Graduation %Estimated 4 Year Graduation %ComputedEstimated Graduates as a percentage of FIF CohortDailyEstimated Gap AnchorEstimated GapEstimated GapComputedAdditional students who need an Anticipated Graduation Term before the end of the fourth year to meet the target graduation rateDailyAnticipated 4 Year Graduations by Term AnchorAnticipated 4 Year Graduations by TermAnticipated 4 Year Graduations by TermBanner-> Advisor_TrackStudent-> ANTICIPATEDGRADTERMStudents listed in SSM-FIF with an Anticipated Graduation Term before the end of the fourth year, but aren't documented as graduated in Banner. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018.DailyNot Expected to Graduate in 4 Years AnchorNot Expected to Graduate in 4 YearsNot Expected to Graduate in 4 YearsComputedStudents listed in SSM-FIF with an Anticipated Graduation Term after the end of the fourth year. For FIF2014 this would be Fall 2018 or after.DailyNot Expected to Graduate in 4 Years %ComputedNot Expected to Graduate in 4 Years as a percentage of FIF CohortDailyWorking Towards GraduationComputedStudents listed in SSM-FIF with an Anticipated Graduation Term before the end of the fourth year, but aren't documented as graduated in Banner. For FIF2014 this would be Fall 2017, Spring 2018, and Summer 2018.DailyReturn Status AnchorReturn Status Return Status Banner-> Advisor_TrackStudent-> ISSTUDENTNOTRETURNINGStudent Returning indicated Returning/Not Returning/Pending Review as identified by users in SSM-FIFDailyPotential Years to Graduate AnchorPotential Years to GraduatePotential Years to GraduateBanner-> Advisor_TrackStudent-> POTENTIALYEARTOGRADPotential Years to Graduate as selected in SSM-FIF. Options include 3,4,5,6,7+ and Pending ReviewDailyAnticipated Graduation Term AnchorAnticipated Graduation TermAnticipated Graduation TermBanner->Advisor_TrackStudent->ANTICIPATEDGRADTERMAnticipated Graduation Term as listed in SSM-FIF. This is computed based on the highest term in the DegreeWorks plan as identified by the 'FIF%' header for each student.DailyDegree Plan Available AnchorDegree Plan AvailableDegree Plan AvailableBanner->Advisor_TrackStudent-> HASFIFGRADPLAN

Yes/No/Pending Review

No indicates the FIF plan exists in DegreeWorks but is either unlocked or inactive

Pending Review indicates that no FIF plan exists in DegreeWorks.

DailyHours Left to Graduate AnchorHours Left to GraduateHours Left to Graduate DailyDegree Awarded AnchorDegree AwardedDegree AwardedBanner-> ShrdgmrValues of Yes/No based on graduation status of Awarded for Bachelor level degrees in Banner within a 4 year window from the cohort start date. Only students who got a degree from the same campus as where they started are now being counted as a successful grad for FIF reports.Daily

Prodarch-> Xtrn_Change_Audit> EMPL_NAME

Name of student (last name concatenated with first name)

Daily

Department

Anchor

	Department
	Department

Prodarch-> Xtrn_Change_Audit> DEPTNAME

Name of student (last name concatenated with first name)

Daily

Student UID

Anchor

	Student UID
	Student UID

Prodarch-> Xtrn_Change_Audit> STU_USFID

Name of student (last name concatenated with first name)

Daily

Student Name

Anchor

	Student Name
	Student Name

SID

Prodarch->

SID

Xtrn_

Person

Change_

Demo-

Audit>

NAME

STU_

LAST

LASTNAME

SID

Prodarch->

SID

Xtrn_

Person_Demo-> NAME_FIRSTLast name concatenated with First NameDailyMajor Change AnchorMajor ChangeMajor ChangeComputedBased on the major having changed from when the student first entered the cohort (original major) to the current major of the student based on the most recent enrollment termDailyAdvisor Assignment Date AnchorAdvisor Assignment DateAdvisor Assignment DateBanner->Sgradvr->ACTIVITY_DATEDate when a student was most recently assigned to a particular advisorDailyGraduation Application Status AnchorGraduation Application StatusGraduation Application StatusBanner->Shrdgmr->SHRDGMR_DEGS_CODEApplied (Advisor), Applied (Student), Awarded, Denied, NoneDailyRecent Major Change Date AnchorRecent Major Change DateRecent Major Change Date The most recent date of major changeDailySSM Activity Date AnchorSSM Activity DateSSM Activity Date Last date that any of the fields in the FIF tab in SIS has been changedDailyAdvised Students AnchorAdvised StudentsAdvised StudentsComputedCount of students who have been assigned to that specific dvisorDailyAdvisor UID AnchorAdvisor UIDAdvisor UID UID of AdvisorDailyStudents with Degree Plan % AnchorStudents with Degree Plan %Students with Degree Plan %ComputedPercentage of students who have been assigned to that specific advisor who have a degree plan in DegreeWorks as identified by the 'FIF%' header.DailyEstimated Graduates in 4 Years % AnchorEstimated Graduates in 4 Years %Estimated Graduates in 4 Years %ComputedStudents Working Towards Graduation in the specified time and Actual Graduated students as a percentage of the students the specific advisor has been assigned.DailyGraduation Application Status Date AnchorGraduation Application Status DateGraduation Application Status Date

Banner-> Shrdmgr-> SHRDGMR_APPL_DATE/

Banner-> Shrdmgr-> SHRDGMR_GRAD_DATE/

Banner-> Shrdmgr-> SHRDGMR_ACTIVITY_DATE

If graduation application status (SHRDGMR_DEGS_CODE) is Applied or Sought then “Application Date” is used
If graduation application status (SHRDGMR_DEGS_CODE) is Awarded then “Graduation Date” is used
If graduation application status (SHRDGMR_DEGS_CODE) is Denied then “Recent Activity Date” is used

DailyPlanner Term AnchorPlanner TermPlanner TermDegreeWorks->Dap_Plancrs_Dtl->DAP_TERMCourse term on the DegreeWorks PlannerDailyRegistration Open AnchorRegistration OpenRegistration OpenComputedIndicates whether or not a student can register for the term based on the registration start and end dates (SFRWCTL)DailyHold AnchorHoldHoldComputedStudent's concatenated list of holds from BannerDailyDegree AnchorDegreeDegreeDegreeWorks->Dap_Plancrs_Dtl->DAP_DEGREEStudent degree on the DegreeWorks PlannerDailyPlanned Hours AnchorPlanned HoursPlanned HoursDegreeWorks->Dap_Plancrs_Dtl->DAP_CREDITSTotal planned credit hours for the term per degree for the student on the DegreeWorks PlannerDailyCourse Credit Hours AnchorCourse Credit HoursCourse Credit HoursDegreeWorks->Rad_Class_Dtl->RAD_CREDITSTotal credit hours taken by the student for the termDailyReg Begin Date AnchorReg Begin DateReg Begin DateBanner->Sfrwctl->SFRWCTL_BEGIN_DATEFirst date the student is eligible to register for the termDailyReg End Date AnchorReg End DateReg End DateBanner->Sfrwctl->SFRWCTL_END_DATELast date the student is eligible to register for the termDaily Academic Standing AnchorAcademic StandingAcademic StandingBanner->Shrttrm->SHRTTRM_ASTD_CODE_END_OF_TERM Academic standing of the student as of the end-of-termDaily Course Term AnchorCourse TermCourse Term Banner->Shrtckn->SHRTCKN_TERM_CODE Term when the student completed the courseDaily Subject AnchorSubjectSubject Banner->Shrtckn->SHRTCKN_SUBJECT_CODE Subject code of the course takenDaily Course Course number of

Change_Audit>STU_FIRSTNAME

Name of student (last name concatenated with first name)

Daily

SBGI Code

Anchor

	SBGI Code
	SBGI Code

Prodarch-> Xtrn_Change_Audit>SBGI_CODE

Transfer school SBGI Code

Daily

Term

Anchor

	Term
	Term

Prodarch-> Xtrn_Change_Audit> TERM_CODE_EFF

Term course was taken

Daily

Subject

Anchor

	Subject
	Subject

Prodarch-> Xtrn_Change_Audit> SUBJ_CODE_INST

Subject Code of the course taken

Daily

Course Number

Anchor

	Course Number
	Course Number

Banner->Shrtckn->SHRTCKN_CRSE_NUMB

Prodarch-> Xtrn_Change_Audit> CRSE_NUMB_INST

Course Number of the course taken

Daily

Final Grade

Timestamp

Anchor

Final Grade

	Timestamp

Final Grade

	Timestamp

Banner->Shrtckg->SHRTCKG_GRDE_CODE_FINALFinal grade the student earned for the course Daily Section Number AnchorSection NumberSection Number Banner->Shrtckn->SHRTCKN_SEQ_NO Section number of the course taken Daily Concentration1 AnchorConcentration1Concentration1Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1

Concentration Code1 of the student's primary curriculum on the most recent enrollment

DailyConcentration1_2 AnchorConcentration1_2Concentration1_2Banner-> Sgbstdn-> SGBSTDN_MAJR_CODE_CONC_1_2

Concentration Code1_2 of the student's primary curriculum on the most recent enrollment

DailyStudent Email AnchorStudent EmailStudent EmailBanner->Goremal->GOREMAL_EMAIL_ADDRESS

Preferred email (If preference has been set by student) concatenated with usf email.

Business Logic - By default every student is assigned a '@mail.usf.edu' account which is shown in the data. If students have further set a 'preffered' account then it will be pulled in as well to go along with the default '@mail.usf.edu' account. In certain cases, if the student has set their '@mail.usf.edu' account then it will be duplicated and listed for complete coverage of communication options.

Prodarch-> Xtrn_Change_Audit> TIMESTAMP

Timestamp when the XTRN attribute was added

Daily

Total Records Returned

Anchor

	Total Records Returned
	Total Records Returned

Computed

Number of records returned in the report

Daily

Data Refreshed On

Anchor

	Data Refreshed On
	Data Refreshed On

Date that the report data was refreshed

Daily

Date Range

Anchor

	Date Range
	Date Range

Prodarch-> Xtrn_Change_Audit> TIMESTAMP

Date range of addition of XTRN attribute

Daily

...

Versions Compared

Old Version 3

New Version Current

Key

Report : XTRN Audit Log

Filters

Report Elements