RepoSetups, 59 (ver3.6.1)
Reporting engine report setup information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Columns_Display_Headers | 3.6.1 | Number(10,0) | Indicates whether column headers are to be displayed. 1= Yes, 2=No. |
Columns_Export_Headers | 3.6.1 | Number(10,0) | Indicates whether column headers are to be exported. 1= Yes, 2=No. |
Columns_Generate_Total_Line | 3.6.1 | Number(10,0) | For No Template or Simple Template this indicates whether a line is to be generated with totals of relevant columns. |
Columns_Multi_Order | 3.6.1 | Number(10,0) | Indicates whether the columns should appear Vertically or Horizontally. 0=Vertical 1=Horizontal |
Columns_Nbr_Items_Per_Line | 3.6.1 | Number(10,0) | Number of columns per line on the report. Defaults to 1 which means if this is not set (=0) then 1 is used. |
Columns_Nbr_Lines_Per_Page | 3.6.1 | Number(10,0) | Number of lines per page on the report. If 1 then this used to calculate number of pages. |
Columns_Nbr_Of_Break_Level | 3.6.1 | Number(10,0) | When No Template or Simple Template is used this indicates the number of levels that the report is to be broken up. |
Comments_To_User | 3.6.1 | CLOB | Any comment to appear on the report for the user benefit. |
Contact_Email | 3.6.1 | CLOB | Email of the contact person for this report. When execution is completed then an email can be sent to this address. |
Contact_Job_Title | 3.6.1 | Varchar(79) | Job title of the contact person for this report. |
Contact_Name | 3.6.1 | CLOB | Name of contact person for this report. |
Contact_Phone | 3.6.1 | CLOB | Phone number of the contact person for this report. |
Contact_URL | 3.6.1 | CLOB | URL for the contact person if one is available to be shown on the report. |
CreationBy | 3.6.1 | Varchar(79) | Full name of person creating this report. |
CreationDate | 3.6.1 | Date | Date this report was created. |
CreationTime | 3.6.1 | Number(10,0) | Time this report was created. |
DateOfImport | 3.6.1 | Date | Date this report was imported into PowerSchool. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this report. |
Destination_Email_Dest_Address | 3.6.1 | CLOB | Email address where this report is to be sent to. |
Destination_Email_Msg | 3.6.1 | CLOB | Any message to be included in the email message with the report. |
Destination_Email_Send_As_Atta | 3.6.1 | Number(10,0) | Indicates whether the report is to be sent as an attachment to the email instead of the body: 1= As Attachment. |
Destination_Email_Subject | 3.6.1 | CLOB | The subject of the email for this report. |
Destination_FTP_Password | 3.6.1 | Varchar(79) | Password to the FTP site for sending this report. |
Destination_FTP_Path | 3.6.1 | CLOB | Path where this report is to be sent to via FTP. |
Destination_FTP_Server_Name | 3.6.1 | CLOB | Name of the server where this report is to be sent to via FTP. |
Destination_FTP_User_Name | 3.6.1 | Varchar(79) | Username to the FTP site for sending this report. |
Destination_File_Path | 3.6.1 | CLOB | The file path of where this report is located. |
Destination_Type | 3.6.1 | Varchar(79) | Indicates whether this is an Email, FTP, Local, Browser or any other type of destination. |
Destination_Web_MIME_Type | 3.6.1 | Varchar(79) | Type of MIME for the report file, such as text/ps-export if destination is Browser or download. |
Disable_Curr_School_Only_Over | 3.6.1 | Number(10,0) | Indicates whether to disable the Current School Only override checkbox. 1= Disable. |
Disable_Destination_Over | 3.6.1 | Number(10,0) | Indicates whether to disable the Destination override checkbox. 1= Disable. |
Disable_Int_Char_Option_Over | 3.6.1 | Number(10,0) | Indicates whether to disable the International Character option. 1= Disable. |
Disable_Nbr_of_Items_Per_Line | 3.6.1 | Number(10,0) | Indicates whether to disable the Number of Items Per Line option. 1= Disable. |
Disable_Nbr_of_Lines_Per_Page | 3.6.1 | Number(10,0) | Indicates whether to disable the Number of Lines Per page option. 1= Disable. |
Disable_Use_Current_Sel_Over | 3.6.1 | Number(10,0) | Indicates whether to disable the User Current Selection option. 1= Disable. |
Dont_Reset_Page_Number | 3.6.1 | Number(10,0) | When the report is included in the Merger report whether to reset the Page numbers. |
DoubleQuoteSurrounded | 3.6.1 | Number(10,0) | Indicates whether the text is to be surrounded by Double Quotes: 1=Yes, 2=No. |
DoubleQuote_RemoveWhenEmpty | 3.6.1 | Number(10,0) | Remove the Double Quotes for empty strings. |
Due_Date | 3.6.1 | CLOB | Date this report is due. This could be a date or text, such as As Needed. |
Encoding_Type | 3.6.1 | Varchar(79) | The type of encoding on this report. Only choice available is HTML at this time. |
FieldDelimiter | 3.6.1 | Varchar(79) | Delimiter to be used on the result set for each field. Could be in ASCII format. |
FileFormat | 3.6.1 | Varchar(5) | Output File format to be used: CMA, TAB, SDF or custom delimiters - See Field and Record Delimiters. |
FileNameMaxLength | 3.6.1 | Number(10,0) | The total length of the filename allowed. |
FileNameTemplate | 3.6.1 | CLOB | Name of the file to be used as a template. Used by the Report Engine. |
FileNameTemplate_ | 3.6.1 | CLOB | Name of the file to be used as a template. |
FixedLength_TotalWidthInChars | 3.6.1 | Number(10,0) | If the report output is fixed length then the total size of the line. |
Footer_Display | 3.6.1 | Number(10,0) | Indicates whether the footer is to be displayed on the browser reports. 1=yes, 0=no. |
Footer_Export | 3.6.1 | Number(10,0) | Indicates whether the footer is to be exported on the reports. 1=yes, 0=no. |
Footer_Repeat_At_Breaks | 3.6.1 | Number(10,0) | Indicates whether the footer is to appear on every break point such as on every page. 1=yes, 0=no. |
Footer_Text | 3.6.1 | CLOB | Text to appear in the footer of the reports such as the ones in Report Cards. |
For_Current_School | 3.6.1 | Number(10,0) | This report to run only for the current school data. |
General_Owner_Info | 3.6.1 | CLOB | Owner information for this report. |
Header_Display | 3.6.1 | Number(10,0) | Indicates whether the header is to be displayed on the browser reports. 1=yes, 0=no. |
Header_Export | 3.6.1 | Number(10,0) | Indicates whether the header is to be exported on the reports. 1=yes, 0=no. |
Header_Repeat_At_Breaks | 3.6.1 | Number(10,0) | Indicates whether the header is to appear on every break point such as on every page. 1=yes, 0=no. |
Header_Text | 3.6.1 | CLOB | Text to appear in the header of the reports such as the ones in Report Cards. |
Include_In_List | 3.6.1 | Number(10,0) | Adds this report to the listing of reports that can be executed. |
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 different character set. Conversion, Automatic Conversion, No Conversion. |
List_Of_Values | 3.6.1 | CLOB | Any field-value pairs to be used as filtering criteria or display in Code format. |
LoadedFrom_Datestamp | 3.6.1 | Varchar(21) | Timestamp of the report file regardless of when loaded. This is checked to make sure that the same file is not loaded again. |
LoadedFrom_FileName | 3.6.1 | Varchar(79) | File name of the report to be loaded. Usually the first 79 characters of the file. |
LoadedFrom_FilePathOnly | 3.6.1 | CLOB | The full directory path of the where the file exist. On Mac it ends with: and on Win with /. |
Management_ReportVersion | 3.6.1 | Varchar(11) | Imported from the XML file and exported as XML when necessary. |
Merger_User_Vars_Action | 3.6.1 | Number(10,0) | How to merge the user variables during report execution: 0=No Set, Merge Variables-Remove Duplicates, All-Grouped by Report. |
ModificationBy | 3.6.1 | Varchar(79) | Name of person who last modified this report. |
ModificationDate | 3.6.1 | Date | Date this report was last modified. |
ModificationTime | 3.6.1 | Number(10,0) | Time this report was last modified. |
Param_Att_Codes | 4.0.0 | Number(10,0) | Indicates whether to show the Attendance Codes list display. |
Param_Att_Codes_Categ | 4.0.0 | Number(10,0) | Indicates whether to show the Attendance Code categories list display. |
Param_Att_Codes_Categ_Opt | 4.0.0 | CLOB | Options for the attendance code categories parameter. |
Param_Att_Codes_Options | 4.0.0 | CLOB | Options for the attendance code parameter such as UseSelection; boxesperline; popup; size; multiple. |
Param_Att_Conv | 4.0.0 | Number(10,0) | Indicates whether to show the Attendance Conversion popup display. |
Param_Att_Modes | 4.0.0 | Number(10,0) | Indicates whether to show the Attendance Mode popup display. |
Param_DateRange | 4.0.0 | Number(10,0) | Indicates whether to show the two entries for start and end dates. |
Param_DateToScan | 4.0.0 | Number(10,0) | Indicates whether to show the start date entry. |
Param_Dest | 4.0.0 | Number(10,0) | Indicates whether to show the destination popup display. |
Param_Grades | 4.0.0 | Number(10,0) | Indicates whether to show the Grade Levels for a particular school and its display format - checkboxes, popup or list. In district mode, the user gets all the Grade Levels available in the district. |
Param_Grades_Options | 4.0.0 | CLOB | This field contains the options for the Grade Level checkboxes. Also see Param_Grades. |
Param_Grades_Script | 4.0.0 | CLOB | This contains the reporting engine tags to be used, if any. |
Param_Items_Per_Line | 4.0.0 | Number(10,0) | Maximum number of items that can appear on a line. The reporting engine for mainly paginated reports uses this value internally. |
Param_JavaScript_ToInsert | 4.0.0 | CLOB | JavaScript to be inserted in the header of the web page. |
Param_Lines_Per_page | 4.0.0 | Number(10,0) | Maximum lines per page to display. The reporting engine mainly for paginated reports uses this internally. |
Param_Misc | 4.0.0 | Number(10,0) | Indicates whether to show the Special Program for the school as checkboxes, popup, or list. |
Param_Misc_Options | 4.0.0 | CLOB | The actual option to be used for display for Special Programs. Also see Param_Misc. |
Param_Periods | 4.0.0 | Number(10,0) | Indicates whether to show the checkboxes for the Periods. A grid of checkboxes will let the user to select any period for the current school. In district mode, no checkboxes will be shown since all periods are automatically selected. |
Param_Periods_Options | 4.0.0 | CLOB | Any options for the periods such as, sort order by day and ascending. |
Param_Prcs_Options | 4.0.0 | Number(10,0) | Indicates whether to show the Processing Options display. |
Param_Prcs_Options_Def | 4.0.0 | CLOB | This field contains the defaults for the Processing Options, which are selected. Also see Param_Prcs_Options |
Param_Rep_Segments | 4.0.0 | Number(10,0) | Indicates whether to show the popup that contains the reporting segments as well as the start and end dates. |
Param_Schools | 4.0.0 | Number(10,0) | Indicates whether to show the Schools popup display. This is useful if the user wants to select one or more schools. |
Param_Schools_Options | 4.0.0 | CLOB | The schools separated by semi-colons that are in the popup. Also see Param_Schools. |
Param_Schools_Script | 4.0.0 | CLOB | This contains the reporting engine tags to be used, |
Param_Source | 4.0.0 | Number(10,0) | Indicates whether to show the Source popup display. The popup allows the user to select between the current selection and all the students. |
Param_Starting_Page_Nbr | 4.0.0 | Number(10,0) | Indicates whether to show the Starting Page Number field display. This is useful mainly for paginated reports and is used internally by the reporting engine. |
Param_Submit_Button_Code | 4.0.0 | CLOB | Attribute to be inserted in the Submit button. |
Param_Teachers | 4.0.0 | Number(10,0) | Indicates whether to show the Teachers popup display. This is useful if you want the user to select one or more teachers. |
Param_Teachers_Options | 4.0.0 | CLOB | This field contains the options for the Teacher popup. Also see Param_Teachers. |
Param_Teachers_Script | 4.0.0 | CLOB | This contains the reporting engine tags to be used, Usually this is used to select the teacher record that is to be inserted in the popup menu. |
Param_Update_Script | 4.0.0 | CLOB | Reporting engine script to be run each time the page is updated. |
Param_UserVars_Sel_Script | 4.0.0 | CLOB | This field contains an optional reporting engine script that returns a value. This script can select records for the user variables depending on the mode. |
Param_Weeks | 4.0.0 | Number(10,0) | Indicates whether to show the popup containing the weeks for the current term display. |
Param_Weeks_Options | 4.0.0 | CLOB | This field contains the options for week's popup. Semi-colons separate the options. |
Programmer_Comments | 3.6.1 | CLOB | Any comments that a programmer of this report wants to keep. |
RecordDelimiter | 3.6.1 | Varchar(79) | Delimiter to be used on the result set for each record. Could be in ASCII format. |
ReportCategory | 3.6.1 | Varchar(31) | The category this report belongs to, such as Custom, State, etc. |
ReportID | 3.6.1 | Varchar(31) | Name of the report used for identification purposes. This is what shows up on the users report list to run. |
ReportName | 3.6.1 | CLOB | A more descriptive name of the report. |
ReportType | 3.6.1 | Varchar(79) | Type of report being used. Indicates what kind of Template to use: NO_TEMPLATE, SIMPLE_TEMPLATE, COMPLEX_TEMPLATE, MERGER, AGGREGATOR. |
Revision_Date | 3.6.1 | CLOB | The Date this report was revised in case it is to appear on the report itself. |
Send_Conf_To_Email_Address | 3.6.1 | CLOB | If this field is filled, upon completion of a report an email notice will be sent to this address. |
Send_Error_To_Email_Address | 3.6.1 | CLOB | If this field is populated upon encountering of an error during this report run an email notice will be sent to this address. |
State_ID | 3.6.1 | Varchar(11) | Country and state ID of this report, such as USA_CA. |
TableToUse | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TableToUse_Name | 3.6.1 | Varchar(31) | The name of master table to use for this report such as Students. |
Template | 3.6.1 | CLOB | Template to use for this report. For HTML it will have HTML tags in this column. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
Use_Current_Selection | 3.6.1 | Number(10,0) | Indicates whether to use Pre Query or Sub Queries or Just the Master Table: 1=Yes, use just Master Table. |
Use_Parameters_YN | 4.0.0 | Number(10,0) | Indicates if the report uses the parameters. |
UserModifiable | 3.6.1 | Number(10,0) | Indicates whether the user can Modify this report. |
Validation_Expression | 3.6.1 | CLOB | Optional expression: is executed for each record in the master selection. If 1 then all records are to be exported. |
Value_Type | 3.6.1 | Number(10,0) | Default Datatype of the Variable to be used: 1=Integer, 2=Real, 3=Text, 4=Date, 5=Boolean, 6=Time, 7= Undefined. |
XML_FormatVersion | 3.6.1 | Varchar(11) | The version of XML to be used for this report. If blank 1.0 |