Enrollment Withdrawal Audit Report
On this page:
Introduction
This report outputs a PDF that lists each enrollment record that falls within the user-specified date range along with any modifications made to those records. The original record is always included in the report, regardless of whether or not modifications have been made. Additional rows are output for each change or set of changes to the record as logged in the audit tables. The audit columns identify the prior and new field values, the user who made the update, the IP address from which it was logged, and the date and time of the modifications. Users may specify additional parameters to limit the results to changes made by selected users or IP addresses, or to changes made within a specified date or time range.
Selection Criteria
Selection criteria determine which database records are used in the report.
There are no selection criteria for this report.
Report Input
Each of the available run options and data fields for the report are described below. For help with report navigation and generation, see Generate Reports.
Note: To include all modifications within the specified start and end date, leave the Modified options blank.
Field | Description |
---|---|
Select Schools | The multi-select list allows the user to use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract. Note: At the school level, only the current school is available. |
Select Students | Select one of the following to indicate which students to include in the report:
Notes:
|
Start Date | Choose a start date for the report. |
End Date | Choose an end date for the report. |
Include Students marked as Exclude from PEIMS | Select Yes or No (default) to indicate whether to include students marked as Exclude from PEIMS. |
Include No Shows | Select Yes (default) or No to indicate whether to include No Show enrollments. |
Include enrollments at other schools the student has attended | Select Yes (default) or No to indicate whether to include enrollments at other schools in the district that the student has attended. |
Select IP Address | Enter an IP address to filter results based on a specific IP address. |
Select Who Modified | Enter the name of an administrator to filter results based on a specific person making modifications. |
When Modified Start Date | Choose a date to filter results by a specific modified start date. |
When Modified End Date | Choose a date to filter results by a specific modified end date. |
Report Output
The original record is reported regardless of whether changes have been made to the record. Additional rows are output for each change or set of changes to the record as logged in the audit tables. The audit columns identify the prior and new field values, the user who made the update, the IP address from which it was logged, and the date and time of the modifications.
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Position | Data Element | Description | [Table]FieldName |
---|---|---|---|
Header | |||
1 | Last | The student's last name. | [Students]Last_Name |
2 | First | The student's first name. | [Students]First_Name |
3 | Middle | The student's middle name. | [Students]Middle_Name |
4 | Local ID | The student's locally assigned ID number. | [Students]Student_Number |
5 | Unique ID | The student's state-assigned ID number. | [Students]State_StudentNumber |
6 | School | The name of the school the student attends. | [Schools]Name |
Body | |||
1 | Current Record | The type of record. | Derived |
2 | School | The school where the record exists. | [Schools]Name |
3 | Entry Date | The student's entry date. | [Students]EntryDate [ReEnrollments]EntryDate |
4 | Entry Code | The student's entry code. | [Students]EntryCode [ReEnrollments]EntryCode |
5 | Entry Comment | The entry comment related to this record. | [Students]TransferComment [ReEnrollments]EntryComment |
6 | Exit Date | The student's exit date. | [Students]ExitDate [ReEnrollments]ExitDate |
7 | Exit Code | The student's exit code. | [Students]ExitCode [ReEnrollments]ExitCode |
8 | Exit Comment | The exit comment related to this record. | [Students]ExitComment [ReEnrollments]ExitComment |
9 | Grade | The student's grade level at the time of the record. | [Students]Grade_Level |
10 | State Gr | The student's state-assigned grade level at the time of the record. | [S_TX_STU_X]State_Grade_Level [S_TX_REN_X]State_Grade_Level |
11 | Track | The student's academic track. | [Students]Track [ReEnrollments]Track |
12 | When Modified | The date and time the record was modified. | [AU_Students]Transaction_Date [AU_TX_STU_X]Transaction_Date [AU_Reenrollments]Transaction_Date [AU_S_TX_REN_X]Transaction_Date |
13 | User | The user who modified the record. | [AU_Students]WhoModifiedID [AU_TX_STU_X]WhoModifiedID [AU_Reenrollments]WhoModifiedID [AU_S_TX_REN_X]WhoModifiedID |
14 | IP Address | The IP address related to this record. | [AU_Students]IP_Address [AU_TX_STU_X]IP_Address [AU_Reenrollments]IP_Address [AU_S_TX_REN_X]IP_Address |
15 | Change | The change(s) the user made to the record. | Old value: [AU_Students]O_[FieldName] from Students New value: [AU_Students]N_[FieldName] from Students Old value: [AU_TX_STU_X]O_[FieldName] from TX_STU_X New value: [AU_TX_STU_X]N_[FieldName] from TX_STU_X Old value: [AU_Reenrollments]O_[FieldName] from Reenrollments New value: [AU_Reenrollments]N_[FieldName] from Reenrollments Old value: [AU_S_TX_REN_X]O_[FieldName] from S_TX_REN_X New value: [AU_S_TX_REN_X]N_[FieldName] from S_TX_REN_X |