XTRN Audit Log
The XTRN Audit Log report lists the employees who input an XTRN attribute on a transfer course. This report is then reviewed by the various departments to ensure if the XTRN attribute was entered judiciously.
Report Elements Glossary Table
Report : XTRN Audit Log |
|---|
Filters
Report Elements
The table below lists all the elements used in the XTRN 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-> 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 |