...
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 (SystemDatabase->Table->COLUMN) | Description | Frequency of Update | ||||||
---|---|---|---|---|---|---|---|---|---|
Employee
| Prodarch-> 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
| Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | The college of the student's most recent enrollment||||||||
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 |
...