Versions Compared

Old Version 14

changes.mady.by.user Revati Vogeti

Saved on

compared with

New Version Current

changes.mady.by.user Revati Vogeti

Saved on

Key

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

...

Department

Employee

Student UID

Date Range


 

Report Elements

Student Name

SBGI Code

Term

Subject

Estimated Gap

Actual Gap

Actual Graduated

Estimated GraduatesCourse Number

Timestamp

Total Records Returned

Data Refreshed onOn

  

Anchor
Report Elements Glossary
Report Elements Glossary

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.

 

Department DepartmentDepartmentBanner Sgrchrt

Employee

The campus of the student's most recent enrollmentBanner Sgbstdn> SGBSTDNCOLLCODE1The college the student's most recent enrollmentThe college of the student's most recent enrollmentThe college of the student's most recent enrollmentThe college of the student's most recent enrollment
Element

Source

(SystemDatabase->Table->COLUMN)

DescriptionFrequency of Update

Employee

Anchor

Employee

Employee

Prodarch->

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.

Annual
Anchor
EmployeeEmployeeBanner-> Sgbstdn-> SGBSTDN_CAMP_CODE
Xtrn_Change_Audit> EMPL_NAMEName of student (last name concatenated with first name)Daily

Department

Anchor
Department
Department

Prodarch-> Xtrn_Change_Audit> DEPTNAMEName of student (last name concatenated with first name)Daily

Student UID

Anchor
Student UID
Student UID

BannerProdarch-> Sgbstdn> SGBSTDNXtrn_COLLChange_CODEAudit> STU_1USFIDThe college Name of the student's most recent enrollmentstudent (last name concatenated with first name)Daily

Student Name

Anchor
Student Name
Student Name

Prodarch-> Xtrn_Change_Audit> STU_LASTNAME

Prodarch->

Xtrn_

Change_

Audit>STU_

FIRSTNAME

Name of student (last name concatenated with first name)Daily

SBGI Code

Anchor
SBGI Code
SBGI Code

BannerProdarch-> Sgbstdn> SGBSTDN_COLLXtrn_Change_Audit>SBGI_CODE_1Transfer school SBGI CodeDaily

Term

Anchor
Term
Term

BannerProdarch-> Sgbstdn> SGBSTDN_COLLXtrn_Change_Audit> TERM_CODE_1EFFTerm course was takenDaily

Subject

Anchor
Subject
Subject

BannerProdarch-> Sgbstdn> SGBSTDN_COLL_CODE_1Xtrn_Change_Audit> SUBJ_CODE_INSTSubject Code of the course takenDaily

Course Number

Anchor
Course Number
Course Number

Prodarch-> Xtrn_Change_Audit> CRSE_NUMB_INSTCourse Number of the course takenDaily

Timestamp

Anchor
Timestamp
Timestamp

Prodarch-> Xtrn_Change_Audit> TIMESTAMPTimestamp when the XTRN attribute was addedDaily

Total Records Returned

Anchor
Total Records Returned
Total Records Returned

ComputedNumber of records returned in the reportDaily

Data Refreshed On

Anchor
Data Refreshed On
Data Refreshed On


Date that the report data was refreshedDaily

Date Range

Anchor
Date Range
Date Range

Prodarch-> Xtrn_Change_Audit> TIMESTAMPDate range of addition of XTRN attributeDaily

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...