RepoBatchSetups, 101 (ver3.6.1)
Reporting engine automated process items.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CheckSum | 3.6.1 | Varchar(33) | Checksum is used to make sure that users do not submit duplicate jobs. Indexed. |
Creation_Date | 3.6.1 | Date | Date this report was scheduled. |
Creation_Time | 3.6.1 | Number(10,0) | Time this report was scheduled. |
Creation_Timestamp | 3.6.1 | Varchar(15) | Timestamp of when this report was scheduled. Format: YYYYMMDDHHMISS |
Current_Selection_BLOB | 3.6.1 | BLOB | Takes the current selection for the specified table and packs the primary keys into an array in this BLOB. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Destination | 3.6.1 | Varchar(21) | If override allowed, the destination of the file is manually entered. |
End_Date | 3.6.1 | Date | Date when this report is completed. |
End_Time | 3.6.1 | Number(10,0) | Time when this report is completed. |
External_FileName | 3.6.1 | CLOB | The full path and internally assigned file name for the output file. |
External_FileSize | 3.6.1 | Number(10,0) | The file size of the actual output file whether PDF, Raw, or etc. |
FileName | 3.6.1 | CLOB | File name specified for the output of this report. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
International_Chars_Option | 3.6.1 | Number(10,0) | To be used to convert the characters to a different character set. Conversion, Automatic Conversion, No Conversion. |
Merger_Action | 3.6.1 | Varchar(21) | Action required for Merging this report. See RepoSetups.Merger_User_Vars_Action. |
Priority | 3.6.1 | Number(10,0) | Priority assigned to this report job based on users privileges and security: 1000= Maintenance (Group No Added, such as 1020), 2000=Admin, 3000=Teacher, 4000=Parent or Student, 5000= All Others. |
ReportID | 3.6.1 | Varchar(21) | The internal number for the Reports with which this record is associated. |
Report_Output | 4.2.0 | Image | View of the report output. |
ReportSetupID | 3.6.1 | Number(10,0) | The internal number for the parent RepoSetups with which this record is associated. Indexed. |
Resulting_Error_Code | 3.6.1 | Number(10,0) | Codes that indicate the error or action that took place, such as 116-Cancelled, 0=Reset, -106=Deleted, etc. |
Resulting_Error_Message | 3.6.1 | CLOB | Actual text message for the error or action that took place: Job Canceled by Maintenance. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Server_InstanceID | ver... | Number(10,0) | Identifier for the PowerSchool Server Instance. Indexed. |
Setups | 3.6.1 | Varchar(21) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Specific_Date | 3.6.1 | Date | If this report is to be run at a later date, contains the future Date. |
Specific_Time | 3.6.1 | Number(10,0) | If this report is to be run at a later Time, contains the future Time. |
Start_Date | 3.6.1 | Date | Date when to start execution of this report. |
Start_Time | 3.6.1 | Number(10,0) | Time when to start execution of this report. |
Start_Timestamp | 3.6.1 | Varchar(15) | Timestamp of when to start running this report. Format: YYYYMMDDHHMISS |
Status | 3.6.1 | Varchar(31) | Status of the report: Pending, Running, Completed or Cancelled. Indexed. |
TableToUse_Name | 3.6.1 | Varchar(31) | Name of the table to run this report on. |
Type | 3.6.1 | Number(10,0) | Type of report to be created, such as 0=Engine, 1=PDF, 2=HTML, 3=Export. |
Use_Current_Selection | 3.6.1 | Number(10,0) | Indicates whether to use the current selection based on the user environment for running the report. 1=Yes. |
UserID | 3.6.1 | Number(10,0) | Internal number associated with the user running this report, whether Teacher, Admin, etc. Indexed. |
User_Environment_BLOB | 3.6.1 | BLOB | Contains a key-pair value of the current user environment at the time of saving. |
User_Variables_As_Text | 3.6.1 | CLOB | Contains the User variables from report setup as text fields. |
When_To_Execute | 3.6.1 | Number(10,0) | When to run this report. Possible values:
|
What_To_Do_With_Result | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |