AccuTrack/AccuSQL: Understanding Generated Codes for Exported Reports

AccuTrack/AccuSQL: Understanding Generated Codes for Exported Reports

Below is a list of Unique Fields and Generated Codes that appear on Reports that have been exported into Excel format:

Common Fields
TaskID = Category ID
SubId = Activity ID
Taskdesc = Category
Subtask = Activity
Input_id = Student ID

Sign In and Out Source Values
0: Student sign-in screen.
1: Max sign-in period used, round trip etc. other then below.
2: Administrator signed student in/out.
3: AccuTrack signed out student on shutdown from sign-in screen
4: AccuTrack signed out student on shutdown from System Administration.
5: Sign in/out occurred from Edit Logs screen
6: Max sign-in limit adjusted value used.
7: Minimum visit duration used (activity has No Sign-out flag set).
8: Intake System sign-in from queue
9: RC device sign in/out
10: Intake System sign in/out
11: AccuTask Handler Auto sign-out
12: iAccu sign in/out
13: iAccu Sign-Out from app
14: iAccu Sign-Out from StaffPanel and StaffTab
15: iAccu Sign-Out from tablet
16: Sign in/out from WebGateway

Flags
inFlag and outFlag are simply "preparations for report" transforming in_source and out_source
~if source is real time then flag is empty otherwise
This Flags are really for Internal purposes only

    • Related Articles

    • AccuTrack/AccuSQL: How to Change the Database Location

      Method 1: Sign-in to the AccuSQL client as a system administrator and change the database location Step 1:      Open AccuTrack/AccuSQL and log in with Admin credentials. Now, from the right-side menu of the System Administration screen, ...

    • AccuSql/AccuTrack - Reports not printing or running/Enabling Minds Eye Report Engine

      AccuSql/AccuTrack - Reports not printing or running/Enabling Minds Eye Report Engine We use an Activex control called "MindsEyeReportEnginePro1.ocx" to enable the interactions in the AccuSQL reports viewer.  If for some reason it seems like that ...

    • AccuSQL 2019 Subscription Installation Instructions

      1. Click on the HighTail link that was sent to you. Click on the Download All button. 2. Click Save 3. Click on the downloaded files  4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL 6.  Double click on the application ...

    • AccuSQL 2019 Platinum Installation Instructions

      1. Click on the HighTail link that was sent to you. Click the Download All button 2. Click Save 3. Click on the downloaded files 4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL2019_DIST 6. Double click on setup.exe 7. ...

    • AccuTrack/AccuSQL: How to Use the Reports Center

      Step 1:       Click on the Reports Center console Step 2:       Select the Period in the lower left-hand corner. Click the thumbtack to lock down the selected Period Select a Report category from the Standard tab in the upper left-hand corner     ...