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