...
Report Elements
Estimated GraduatesCourse Number
Anchor | ||||
---|---|---|---|---|
|
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 ( |
---|
Database->Table->COLUMN) | Description | Frequency of Update |
---|
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.
Employee
Xtrn_Change_Audit> EMPL_NAME | Name of student (last name concatenated with first name) | Daily | |||||||
Department
| Prodarch-> Xtrn_Change_Audit> DEPTNAME | Name of student (last name concatenated with first name) | Daily | ||||||
Student UID
|
Prodarch-> |
Xtrn_ |
Change_ |
Audit> STU_ |
USFID |
Name of |
student (last name concatenated with first name) | Daily | |||||
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
|
Prodarch-> |
Xtrn_Change_Audit>SBGI_CODE |
Transfer school SBGI Code | Daily | |||||
Term
|
Prodarch-> |
Xtrn_Change_Audit> TERM_CODE_ |
EFF | Term course was taken | Daily | ||||
Subject
|
Prodarch-> |
Xtrn_Change_Audit> SUBJ_CODE_INST | Subject Code of the course taken | Daily | |||||||
Course Number
| Prodarch-> Xtrn_Change_Audit> CRSE_NUMB_INST | Course Number of the course taken | Daily | ||||||
Timestamp
| Prodarch-> Xtrn_Change_Audit> TIMESTAMP | Timestamp when the XTRN attribute was added | Daily | ||||||
Total Records Returned
| Computed | Number of records returned in the report | Daily | ||||||
Data Refreshed On
| Date that the report data was refreshed | Daily | |||||||
Date Range
| Prodarch-> Xtrn_Change_Audit> TIMESTAMP | Date range of addition of XTRN attribute | Daily |
...