...
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 itIT-security 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 |
...