...
The table below lists all the elements used in the FIF Reports.XTRN Audit Log report. Note that this data is being reported from a view created by it-security in PRODARCH database
| 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
| Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | ||||||||
| Computed | Number of records returned in the report | Daily | |||||||
Data Refreshed On
| Banner-> Sgbstdn> SGBSTDN_COLL_CODE_1 | ||||||||
| Date that the report data was refreshed | Daily |
...