<?php



$tdataJudgesNotApproved = array();
$tdataJudgesNotApproved[".searchableFields"] = array();
$tdataJudgesNotApproved[".ShortName"] = "JudgesNotApproved";
$tdataJudgesNotApproved[".OwnerID"] = "";
$tdataJudgesNotApproved[".OriginalTable"] = "applicform";


$defaultPages = my_json_decode( "{\"report\":\"report\",\"rprint\":\"rprint\",\"search\":\"search\"}" );

$tdataJudgesNotApproved[".pagesByType"] = my_json_decode( "{\"report\":[\"report\"],\"rprint\":[\"rprint\"],\"search\":[\"search\"]}" );
$tdataJudgesNotApproved[".pages"] = types2pages( my_json_decode( "{\"report\":[\"report\"],\"rprint\":[\"rprint\"],\"search\":[\"search\"]}" ) );
$tdataJudgesNotApproved[".defaultPages"] = $defaultPages;

//	field labels
$fieldLabelsJudgesNotApproved = array();
$fieldToolTipsJudgesNotApproved = array();
$pageTitlesJudgesNotApproved = array();
$placeHoldersJudgesNotApproved = array();

if(mlang_getcurrentlang()=="English")
{
	$fieldLabelsJudgesNotApproved["English"] = array();
	$fieldToolTipsJudgesNotApproved["English"] = array();
	$placeHoldersJudgesNotApproved["English"] = array();
	$pageTitlesJudgesNotApproved["English"] = array();
	$fieldLabelsJudgesNotApproved["English"]["Surname"] = "Surname";
	$fieldToolTipsJudgesNotApproved["English"]["Surname"] = "";
	$placeHoldersJudgesNotApproved["English"]["Surname"] = "";
	$fieldLabelsJudgesNotApproved["English"]["FirstName"] = "First Name";
	$fieldToolTipsJudgesNotApproved["English"]["FirstName"] = "";
	$placeHoldersJudgesNotApproved["English"]["FirstName"] = "";
	$fieldLabelsJudgesNotApproved["English"]["TertiaryInstitutionAdmitted"] = "Tertiary Institution Admitted";
	$fieldToolTipsJudgesNotApproved["English"]["TertiaryInstitutionAdmitted"] = "";
	$placeHoldersJudgesNotApproved["English"]["TertiaryInstitutionAdmitted"] = "";
	$fieldLabelsJudgesNotApproved["English"]["ProgramName"] = "Program Name";
	$fieldToolTipsJudgesNotApproved["English"]["ProgramName"] = "";
	$placeHoldersJudgesNotApproved["English"]["ProgramName"] = "";
	$fieldLabelsJudgesNotApproved["English"]["ScholarshipType"] = "Scholarship Type";
	$fieldToolTipsJudgesNotApproved["English"]["ScholarshipType"] = "";
	$placeHoldersJudgesNotApproved["English"]["ScholarshipType"] = "";
	$fieldLabelsJudgesNotApproved["English"]["NewApplicant"] = "New Applicant";
	$fieldToolTipsJudgesNotApproved["English"]["NewApplicant"] = "";
	$placeHoldersJudgesNotApproved["English"]["NewApplicant"] = "";
	$fieldLabelsJudgesNotApproved["English"]["Reapply"] = "Reapply";
	$fieldToolTipsJudgesNotApproved["English"]["Reapply"] = "";
	$placeHoldersJudgesNotApproved["English"]["Reapply"] = "";
	$fieldLabelsJudgesNotApproved["English"]["GPA"] = "GPA";
	$fieldToolTipsJudgesNotApproved["English"]["GPA"] = "";
	$placeHoldersJudgesNotApproved["English"]["GPA"] = "";
	$fieldLabelsJudgesNotApproved["English"]["approved1"] = "Approved1";
	$fieldToolTipsJudgesNotApproved["English"]["approved1"] = "";
	$placeHoldersJudgesNotApproved["English"]["approved1"] = "";
	$fieldLabelsJudgesNotApproved["English"]["approved2"] = "Approved2";
	$fieldToolTipsJudgesNotApproved["English"]["approved2"] = "";
	$placeHoldersJudgesNotApproved["English"]["approved2"] = "";
	$fieldLabelsJudgesNotApproved["English"]["approved3"] = "Approved3";
	$fieldToolTipsJudgesNotApproved["English"]["approved3"] = "";
	$placeHoldersJudgesNotApproved["English"]["approved3"] = "";
	$fieldLabelsJudgesNotApproved["English"]["Judge2Comment"] = "Judge2Comment";
	$fieldToolTipsJudgesNotApproved["English"]["Judge2Comment"] = "";
	$placeHoldersJudgesNotApproved["English"]["Judge2Comment"] = "";
	$fieldLabelsJudgesNotApproved["English"]["Judge3Comment"] = "Judge3Comment";
	$fieldToolTipsJudgesNotApproved["English"]["Judge3Comment"] = "";
	$placeHoldersJudgesNotApproved["English"]["Judge3Comment"] = "";
	$fieldLabelsJudgesNotApproved["English"]["JudgeComment"] = "Judge Comment";
	$fieldToolTipsJudgesNotApproved["English"]["JudgeComment"] = "";
	$placeHoldersJudgesNotApproved["English"]["JudgeComment"] = "";
	$fieldLabelsJudgesNotApproved["English"]["Documents"] = "Documents";
	$fieldToolTipsJudgesNotApproved["English"]["Documents"] = "";
	$placeHoldersJudgesNotApproved["English"]["Documents"] = "";
	$fieldLabelsJudgesNotApproved["English"]["1styear"] = "1styear";
	$fieldToolTipsJudgesNotApproved["English"]["1styear"] = "";
	$placeHoldersJudgesNotApproved["English"]["1styear"] = "";
	if (count($fieldToolTipsJudgesNotApproved["English"]))
		$tdataJudgesNotApproved[".isUseToolTips"] = true;
}


	$tdataJudgesNotApproved[".NCSearch"] = true;



$tdataJudgesNotApproved[".shortTableName"] = "JudgesNotApproved";
$tdataJudgesNotApproved[".nSecOptions"] = 0;

$tdataJudgesNotApproved[".mainTableOwnerID"] = "";
$tdataJudgesNotApproved[".entityType"] = 2;

$tdataJudgesNotApproved[".strOriginalTableName"] = "applicform";

	



$tdataJudgesNotApproved[".showAddInPopup"] = false;

$tdataJudgesNotApproved[".showEditInPopup"] = false;

$tdataJudgesNotApproved[".showViewInPopup"] = false;

//page's base css files names
$popupPagesLayoutNames = array();
$tdataJudgesNotApproved[".popupPagesLayoutNames"] = $popupPagesLayoutNames;


$tdataJudgesNotApproved[".listAjax"] = false;
//	temporary
$tdataJudgesNotApproved[".listAjax"] = false;

	$tdataJudgesNotApproved[".audit"] = false;

	$tdataJudgesNotApproved[".locking"] = false;


$pages = $tdataJudgesNotApproved[".defaultPages"];

if( $pages[PAGE_EDIT] ) {
	$tdataJudgesNotApproved[".edit"] = true;
	$tdataJudgesNotApproved[".afterEditAction"] = 1;
	$tdataJudgesNotApproved[".closePopupAfterEdit"] = 1;
	$tdataJudgesNotApproved[".afterEditActionDetTable"] = "";
}

if( $pages[PAGE_ADD] ) {
$tdataJudgesNotApproved[".add"] = true;
$tdataJudgesNotApproved[".afterAddAction"] = 1;
$tdataJudgesNotApproved[".closePopupAfterAdd"] = 1;
$tdataJudgesNotApproved[".afterAddActionDetTable"] = "";
}

if( $pages[PAGE_LIST] ) {
	$tdataJudgesNotApproved[".list"] = true;
}

$tdataJudgesNotApproved[".updateSelected"] = true;


$tdataJudgesNotApproved[".strSortControlSettingsJSON"] = "";




if( $pages[PAGE_VIEW] ) {
$tdataJudgesNotApproved[".view"] = true;
}

if( $pages[PAGE_IMPORT] ) {
$tdataJudgesNotApproved[".import"] = true;
}

if( $pages[PAGE_EXPORT] ) {
$tdataJudgesNotApproved[".exportTo"] = true;
}

if( $pages[PAGE_PRINT] ) {
$tdataJudgesNotApproved[".printFriendly"] = true;
}



$tdataJudgesNotApproved[".showSimpleSearchOptions"] = true; // temp fix #13449

// Allow Show/Hide Fields in GRID
$tdataJudgesNotApproved[".allowShowHideFields"] = true; // temp fix #13449
//

// Allow Fields Reordering in GRID
$tdataJudgesNotApproved[".allowFieldsReordering"] = true; // temp fix #13449
//

$tdataJudgesNotApproved[".isUseAjaxSuggest"] = true;




						

$tdataJudgesNotApproved[".ajaxCodeSnippetAdded"] = false;

$tdataJudgesNotApproved[".buttonsAdded"] = false;

$tdataJudgesNotApproved[".addPageEvents"] = false;

// use timepicker for search panel
$tdataJudgesNotApproved[".isUseTimeForSearch"] = false;




$tdataJudgesNotApproved[".allSearchFields"] = array();
$tdataJudgesNotApproved[".filterFields"] = array();
$tdataJudgesNotApproved[".requiredSearchFields"] = array();

$tdataJudgesNotApproved[".googleLikeFields"] = array();
$tdataJudgesNotApproved[".googleLikeFields"][] = "Surname";
$tdataJudgesNotApproved[".googleLikeFields"][] = "FirstName";
$tdataJudgesNotApproved[".googleLikeFields"][] = "GPA";
$tdataJudgesNotApproved[".googleLikeFields"][] = "approved1";
$tdataJudgesNotApproved[".googleLikeFields"][] = "approved2";
$tdataJudgesNotApproved[".googleLikeFields"][] = "approved3";
$tdataJudgesNotApproved[".googleLikeFields"][] = "NewApplicant";
$tdataJudgesNotApproved[".googleLikeFields"][] = "JudgeComment";
$tdataJudgesNotApproved[".googleLikeFields"][] = "Judge3Comment";
$tdataJudgesNotApproved[".googleLikeFields"][] = "Judge2Comment";
$tdataJudgesNotApproved[".googleLikeFields"][] = "Documents";
$tdataJudgesNotApproved[".googleLikeFields"][] = "Reapply";
$tdataJudgesNotApproved[".googleLikeFields"][] = "TertiaryInstitutionAdmitted";
$tdataJudgesNotApproved[".googleLikeFields"][] = "ScholarshipType";
$tdataJudgesNotApproved[".googleLikeFields"][] = "ProgramName";
$tdataJudgesNotApproved[".googleLikeFields"][] = "1styear";



$tdataJudgesNotApproved[".tableType"] = "report";

$tdataJudgesNotApproved[".printerPageOrientation"] = 0;
$tdataJudgesNotApproved[".nPrinterPageScale"] = 100;

$tdataJudgesNotApproved[".nPrinterSplitRecords"] = 40;

$tdataJudgesNotApproved[".geocodingEnabled"] = false;

//report settings

$tdataJudgesNotApproved[".reportPrintPartitionType"] = 1;
$tdataJudgesNotApproved[".reportPrintGroupsPerPage"] = 3;
$tdataJudgesNotApproved[".lowGroup"] = 2;



$tdataJudgesNotApproved[".reportGroupFields"] = true;
$tdataJudgesNotApproved[".pageSize"] = 5;
$tdataJudgesNotApproved[".showGroupSummaryCount"] = true;
$reportGroupFieldsList = array();
$reportGroupFields = array();
	$reportGroupFieldsList []= "GPA";

	$rgroupField = array();
	$rgroupField['strGroupField'] = "GPA";
	$rgroupField['groupInterval'] = 0;
	$rgroupField['groupOrder'] = 1;
	$rgroupField['showGroupSummary'] = "1";
	$rgroupField['crossTabAxis'] = "0";
	$reportGroupFields[] = $rgroupField;
	$reportGroupFieldsList []= "TertiaryInstitutionAdmitted";

	$rgroupField = array();
	$rgroupField['strGroupField'] = "TertiaryInstitutionAdmitted";
	$rgroupField['groupInterval'] = 0;
	$rgroupField['groupOrder'] = 2;
	$rgroupField['showGroupSummary'] = "1";
	$rgroupField['crossTabAxis'] = "0";
	$reportGroupFields[] = $rgroupField;
$tdataJudgesNotApproved[".reportGroupFieldsData"] = $reportGroupFields;
$tdataJudgesNotApproved[".reportGroupFieldsList"] = $reportGroupFieldsList;






$tdataJudgesNotApproved[".repShowDet"] = true;

$tdataJudgesNotApproved[".reportLayout"] = 0;

//end of report settings



$tdataJudgesNotApproved[".isDisplayLoading"] = true;







$tstrOrderBy = "ORDER BY `1styear`";
if(strlen($tstrOrderBy) && strtolower(substr($tstrOrderBy,0,8))!="order by")
	$tstrOrderBy = "order by ".$tstrOrderBy;
$tdataJudgesNotApproved[".strOrderBy"] = $tstrOrderBy;

$tdataJudgesNotApproved[".orderindexes"] = array();
	$tdataJudgesNotApproved[".orderindexes"][] = array(16, (1 ? "ASC" : "DESC"), "`1styear`");


$tdataJudgesNotApproved[".sqlHead"] = "SELECT Surname,  FirstName,  GPA,  approved1,  approved2,  approved3,  NewApplicant,  JudgeComment,  Judge3Comment,  Judge2Comment,  Documents,  Reapply,  TertiaryInstitutionAdmitted,  ScholarshipType,  ProgramName,  `1styear`";
$tdataJudgesNotApproved[".sqlFrom"] = "FROM applicform";
$tdataJudgesNotApproved[".sqlWhereExpr"] = "(`1styear` <> ' ')  AND   ( ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017)))";
$tdataJudgesNotApproved[".sqlTail"] = "";










//fill array of records per page for list and report without group fields
$arrRPP = array();
$arrRPP[] = 10;
$arrRPP[] = 20;
$arrRPP[] = 30;
$arrRPP[] = 50;
$arrRPP[] = 100;
$arrRPP[] = 500;
$arrRPP[] = -1;
$tdataJudgesNotApproved[".arrRecsPerPage"] = $arrRPP;

//fill array of groups per page for report with group fields
$arrGPP = array();
$arrGPP[] = 1;
$arrGPP[] = 3;
$arrGPP[] = 5;
$arrGPP[] = 10;
$arrGPP[] = 50;
$arrGPP[] = 100;
$arrGPP[] = -1;
$tdataJudgesNotApproved[".arrGroupsPerPage"] = $arrGPP;

$tdataJudgesNotApproved[".highlightSearchResults"] = true;

$tableKeysJudgesNotApproved = array();
$tdataJudgesNotApproved[".Keys"] = $tableKeysJudgesNotApproved;


$tdataJudgesNotApproved[".hideMobileList"] = array();




//	Surname
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 1;
	$fdata["strName"] = "Surname";
	$fdata["GoodName"] = "Surname";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","Surname");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "Surname";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Surname";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["Surname"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "Surname";
//	FirstName
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 2;
	$fdata["strName"] = "FirstName";
	$fdata["GoodName"] = "FirstName";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","FirstName");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "FirstName";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "FirstName";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["FirstName"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "FirstName";
//	GPA
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 3;
	$fdata["strName"] = "GPA";
	$fdata["GoodName"] = "GPA";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","GPA");
	$fdata["FieldType"] = 5;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "GPA";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "GPA";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "Number");

	
	
	
	
	
	
		$vdata["DecimalDigits"] = 2;

	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["GPA"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "GPA";
//	approved1
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 4;
	$fdata["strName"] = "approved1";
	$fdata["GoodName"] = "approved1";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","approved1");
	$fdata["FieldType"] = 3;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "approved1";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "approved1";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["approved1"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "approved1";
//	approved2
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 5;
	$fdata["strName"] = "approved2";
	$fdata["GoodName"] = "approved2";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","approved2");
	$fdata["FieldType"] = 3;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "approved2";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "approved2";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["approved2"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "approved2";
//	approved3
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 6;
	$fdata["strName"] = "approved3";
	$fdata["GoodName"] = "approved3";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","approved3");
	$fdata["FieldType"] = 3;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "approved3";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "approved3";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["approved3"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "approved3";
//	NewApplicant
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 7;
	$fdata["strName"] = "NewApplicant";
	$fdata["GoodName"] = "NewApplicant";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","NewApplicant");
	$fdata["FieldType"] = 3;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "NewApplicant";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "NewApplicant";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["NewApplicant"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "NewApplicant";
//	JudgeComment
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 8;
	$fdata["strName"] = "JudgeComment";
	$fdata["GoodName"] = "JudgeComment";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","JudgeComment");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "JudgeComment";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "JudgeComment";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["JudgeComment"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "JudgeComment";
//	Judge3Comment
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 9;
	$fdata["strName"] = "Judge3Comment";
	$fdata["GoodName"] = "Judge3Comment";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","Judge3Comment");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "Judge3Comment";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Judge3Comment";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=255";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["Judge3Comment"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "Judge3Comment";
//	Judge2Comment
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 10;
	$fdata["strName"] = "Judge2Comment";
	$fdata["GoodName"] = "Judge2Comment";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","Judge2Comment");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "Judge2Comment";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Judge2Comment";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=255";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["Judge2Comment"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "Judge2Comment";
//	Documents
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 11;
	$fdata["strName"] = "Documents";
	$fdata["GoodName"] = "Documents";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","Documents");
	$fdata["FieldType"] = 201;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "Documents";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Documents";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text area");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
				$edata["nRows"] = 100;
			$edata["nCols"] = 200;

	
	
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["Documents"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "Documents";
//	Reapply
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 12;
	$fdata["strName"] = "Reapply";
	$fdata["GoodName"] = "Reapply";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","Reapply");
	$fdata["FieldType"] = 3;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "Reapply";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "Reapply";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "number";

		$edata["EditParams"] = "";
		
		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
				$edata["validateAs"]["basicValidate"][] = getJsValidatorName("Number");
							
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["Reapply"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "Reapply";
//	TertiaryInstitutionAdmitted
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 13;
	$fdata["strName"] = "TertiaryInstitutionAdmitted";
	$fdata["GoodName"] = "TertiaryInstitutionAdmitted";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","TertiaryInstitutionAdmitted");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "TertiaryInstitutionAdmitted";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "TertiaryInstitutionAdmitted";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["TertiaryInstitutionAdmitted"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "TertiaryInstitutionAdmitted";
//	ScholarshipType
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 14;
	$fdata["strName"] = "ScholarshipType";
	$fdata["GoodName"] = "ScholarshipType";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","ScholarshipType");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "ScholarshipType";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "ScholarshipType";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=255";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["ScholarshipType"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "ScholarshipType";
//	ProgramName
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 15;
	$fdata["strName"] = "ProgramName";
	$fdata["GoodName"] = "ProgramName";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","ProgramName");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "ProgramName";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "ProgramName";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
	
			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["ProgramName"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "ProgramName";
//	1styear
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 16;
	$fdata["strName"] = "1styear";
	$fdata["GoodName"] = "1styear";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("JudgesNotApproved","1styear");
	$fdata["FieldType"] = 200;

		// report field settings
					// end of report field settings

	
	
			

		$fdata["strField"] = "1styear";

		$fdata["isSQLExpression"] = true;
	$fdata["FullName"] = "`1styear`";

	
	
				$fdata["UploadFolder"] = "files";

//  Begin View Formats
	$fdata["ViewFormats"] = array();

	$vdata = array("ViewFormat" => "");

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

	
		$vdata["truncateText"] = true;
	$vdata["NumberOfChars"] = 80;

	$fdata["ViewFormats"]["report"] = $vdata;
//  End View Formats

//	Begin Edit Formats
	$fdata["EditFormats"] = array();

	$edata = array("EditFormat" => "Text field");

	
		$edata["weekdayMessage"] = array("message" => "", "messageType" => "Text");
	$edata["weekdays"] = "[]";


	
	



	
	
	
	
			$edata["acceptFileTypes"] = ".+$";
		$edata["acceptFileTypesHtml"] = "";

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
			$edata["HTML5InuptType"] = "text";

		$edata["EditParams"] = "";
			$edata["EditParams"].= " maxlength=50";

		$edata["controlWidth"] = 200;

//	Begin validation
	$edata["validateAs"] = array();
	$edata["validateAs"]["basicValidate"] = array();
	$edata["validateAs"]["customMessages"] = array();
	
	
	//	End validation

	
	
	
	
	
	$fdata["EditFormats"]["search"] = $edata;
//	End Edit Formats


	$fdata["isSeparate"] = false;




// the field's search options settings
		$fdata["defaultSearchOption"] = "Contains";

			// the default search options list
				$fdata["searchOptionsList"] = array("Contains", "Equals", "Starts with", "More than", "Less than", "Between", "Empty", NOT_EMPTY);
// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 0;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

		$fdata["sortValueType"] = 0;
		$fdata["numberOfVisibleItems"] = 10;

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdataJudgesNotApproved["1styear"] = $fdata;
		$tdataJudgesNotApproved[".searchableFields"][] = "1styear";


$tables_data["JudgesNotApproved"]=&$tdataJudgesNotApproved;
$field_labels["JudgesNotApproved"] = &$fieldLabelsJudgesNotApproved;
$fieldToolTips["JudgesNotApproved"] = &$fieldToolTipsJudgesNotApproved;
$placeHolders["JudgesNotApproved"] = &$placeHoldersJudgesNotApproved;
$page_titles["JudgesNotApproved"] = &$pageTitlesJudgesNotApproved;

// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["JudgesNotApproved"] = array();

// tables which are master tables for current table (detail)
$masterTablesData["JudgesNotApproved"] = array();



// -----------------end  prepare master-details data arrays ------------------------------//


require_once(getabspath("classes/sql.php"));










function createSqlQuery_JudgesNotApproved()
{
$proto0=array();
$proto0["m_strHead"] = "SELECT";
$proto0["m_strFieldList"] = "Surname,  FirstName,  GPA,  approved1,  approved2,  approved3,  NewApplicant,  JudgeComment,  Judge3Comment,  Judge2Comment,  Documents,  Reapply,  TertiaryInstitutionAdmitted,  ScholarshipType,  ProgramName,  `1styear`";
$proto0["m_strFrom"] = "FROM applicform";
$proto0["m_strWhere"] = "(`1styear` <> ' ')  AND   ( ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017)))";
$proto0["m_strOrderBy"] = "ORDER BY `1styear`";
	
		;
			$proto0["cipherer"] = null;
$proto2=array();
$proto2["m_sql"] = "(`1styear` <> ' ')  AND   ( ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017)))";
$proto2["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(`1styear` <> ' ')  AND   ( ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017)))"
));

$proto2["m_column"]=$obj;
$proto2["m_contained"] = array();
						$proto4=array();
$proto4["m_sql"] = "`1styear` <> ' '";
$proto4["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto4["m_column"]=$obj;
$proto4["m_contained"] = array();
$proto4["m_strCase"] = "<> ' '";
$proto4["m_havingmode"] = false;
$proto4["m_inBrackets"] = true;
$proto4["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto4);

			$proto2["m_contained"][]=$obj;
						$proto6=array();
$proto6["m_sql"] = " ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017))";
$proto6["m_uniontype"] = "SQLL_OR";
	$obj = new SQLNonParsed(array(
	"m_sql" => " ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))) OR         ((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017))"
));

$proto6["m_column"]=$obj;
$proto6["m_contained"] = array();
						$proto8=array();
$proto8["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))";
$proto8["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))"
));

$proto8["m_column"]=$obj;
$proto8["m_contained"] = array();
						$proto10=array();
$proto10["m_sql"] = "NewApplicant IS TRUE";
$proto10["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto10["m_column"]=$obj;
$proto10["m_contained"] = array();
$proto10["m_strCase"] = "IS TRUE";
$proto10["m_havingmode"] = false;
$proto10["m_inBrackets"] = true;
$proto10["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto10);

			$proto8["m_contained"][]=$obj;
						$proto12=array();
$proto12["m_sql"] = "(approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE)";
$proto12["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS FALSE)"
));

$proto12["m_column"]=$obj;
$proto12["m_contained"] = array();
						$proto14=array();
$proto14["m_sql"] = "approved1 IS TRUE";
$proto14["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto14["m_column"]=$obj;
$proto14["m_contained"] = array();
$proto14["m_strCase"] = "IS TRUE";
$proto14["m_havingmode"] = false;
$proto14["m_inBrackets"] = true;
$proto14["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto14);

			$proto12["m_contained"][]=$obj;
						$proto16=array();
$proto16["m_sql"] = "approved2 IS TRUE";
$proto16["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto16["m_column"]=$obj;
$proto16["m_contained"] = array();
$proto16["m_strCase"] = "IS TRUE";
$proto16["m_havingmode"] = false;
$proto16["m_inBrackets"] = true;
$proto16["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto16);

			$proto12["m_contained"][]=$obj;
						$proto18=array();
$proto18["m_sql"] = "approved3 IS FALSE";
$proto18["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto18["m_column"]=$obj;
$proto18["m_contained"] = array();
$proto18["m_strCase"] = "IS FALSE";
$proto18["m_havingmode"] = false;
$proto18["m_inBrackets"] = true;
$proto18["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto18);

			$proto12["m_contained"][]=$obj;
$proto12["m_strCase"] = "";
$proto12["m_havingmode"] = false;
$proto12["m_inBrackets"] = true;
$proto12["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto12);

			$proto8["m_contained"][]=$obj;
$proto8["m_strCase"] = "";
$proto8["m_havingmode"] = false;
$proto8["m_inBrackets"] = true;
$proto8["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto8);

			$proto6["m_contained"][]=$obj;
						$proto20=array();
$proto20["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))";
$proto20["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))"
));

$proto20["m_column"]=$obj;
$proto20["m_contained"] = array();
						$proto22=array();
$proto22["m_sql"] = "NewApplicant IS TRUE";
$proto22["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto22["m_column"]=$obj;
$proto22["m_contained"] = array();
$proto22["m_strCase"] = "IS TRUE";
$proto22["m_havingmode"] = false;
$proto22["m_inBrackets"] = true;
$proto22["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto22);

			$proto20["m_contained"][]=$obj;
						$proto24=array();
$proto24["m_sql"] = "(approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE)";
$proto24["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS TRUE)"
));

$proto24["m_column"]=$obj;
$proto24["m_contained"] = array();
						$proto26=array();
$proto26["m_sql"] = "approved1 IS FALSE";
$proto26["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto26["m_column"]=$obj;
$proto26["m_contained"] = array();
$proto26["m_strCase"] = "IS FALSE";
$proto26["m_havingmode"] = false;
$proto26["m_inBrackets"] = true;
$proto26["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto26);

			$proto24["m_contained"][]=$obj;
						$proto28=array();
$proto28["m_sql"] = "approved2 IS TRUE";
$proto28["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto28["m_column"]=$obj;
$proto28["m_contained"] = array();
$proto28["m_strCase"] = "IS TRUE";
$proto28["m_havingmode"] = false;
$proto28["m_inBrackets"] = true;
$proto28["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto28);

			$proto24["m_contained"][]=$obj;
						$proto30=array();
$proto30["m_sql"] = "approved3 IS TRUE";
$proto30["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto30["m_column"]=$obj;
$proto30["m_contained"] = array();
$proto30["m_strCase"] = "IS TRUE";
$proto30["m_havingmode"] = false;
$proto30["m_inBrackets"] = true;
$proto30["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto30);

			$proto24["m_contained"][]=$obj;
$proto24["m_strCase"] = "";
$proto24["m_havingmode"] = false;
$proto24["m_inBrackets"] = true;
$proto24["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto24);

			$proto20["m_contained"][]=$obj;
$proto20["m_strCase"] = "";
$proto20["m_havingmode"] = false;
$proto20["m_inBrackets"] = true;
$proto20["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto20);

			$proto6["m_contained"][]=$obj;
						$proto32=array();
$proto32["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))";
$proto32["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))"
));

$proto32["m_column"]=$obj;
$proto32["m_contained"] = array();
						$proto34=array();
$proto34["m_sql"] = "NewApplicant IS TRUE";
$proto34["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto34["m_column"]=$obj;
$proto34["m_contained"] = array();
$proto34["m_strCase"] = "IS TRUE";
$proto34["m_havingmode"] = false;
$proto34["m_inBrackets"] = true;
$proto34["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto34);

			$proto32["m_contained"][]=$obj;
						$proto36=array();
$proto36["m_sql"] = "(approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE)";
$proto36["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS TRUE)"
));

$proto36["m_column"]=$obj;
$proto36["m_contained"] = array();
						$proto38=array();
$proto38["m_sql"] = "approved1 IS TRUE";
$proto38["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto38["m_column"]=$obj;
$proto38["m_contained"] = array();
$proto38["m_strCase"] = "IS TRUE";
$proto38["m_havingmode"] = false;
$proto38["m_inBrackets"] = true;
$proto38["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto38);

			$proto36["m_contained"][]=$obj;
						$proto40=array();
$proto40["m_sql"] = "approved2 IS FALSE";
$proto40["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto40["m_column"]=$obj;
$proto40["m_contained"] = array();
$proto40["m_strCase"] = "IS FALSE";
$proto40["m_havingmode"] = false;
$proto40["m_inBrackets"] = true;
$proto40["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto40);

			$proto36["m_contained"][]=$obj;
						$proto42=array();
$proto42["m_sql"] = "approved3 IS TRUE";
$proto42["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto42["m_column"]=$obj;
$proto42["m_contained"] = array();
$proto42["m_strCase"] = "IS TRUE";
$proto42["m_havingmode"] = false;
$proto42["m_inBrackets"] = true;
$proto42["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto42);

			$proto36["m_contained"][]=$obj;
$proto36["m_strCase"] = "";
$proto36["m_havingmode"] = false;
$proto36["m_inBrackets"] = true;
$proto36["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto36);

			$proto32["m_contained"][]=$obj;
$proto32["m_strCase"] = "";
$proto32["m_havingmode"] = false;
$proto32["m_inBrackets"] = true;
$proto32["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto32);

			$proto6["m_contained"][]=$obj;
						$proto44=array();
$proto44["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))";
$proto44["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE))"
));

$proto44["m_column"]=$obj;
$proto44["m_contained"] = array();
						$proto46=array();
$proto46["m_sql"] = "NewApplicant IS TRUE";
$proto46["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto46["m_column"]=$obj;
$proto46["m_contained"] = array();
$proto46["m_strCase"] = "IS TRUE";
$proto46["m_havingmode"] = false;
$proto46["m_inBrackets"] = true;
$proto46["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto46);

			$proto44["m_contained"][]=$obj;
						$proto48=array();
$proto48["m_sql"] = "(approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE)";
$proto48["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS FALSE) AND (approved2 IS TRUE) AND (approved3 IS FALSE)"
));

$proto48["m_column"]=$obj;
$proto48["m_contained"] = array();
						$proto50=array();
$proto50["m_sql"] = "approved1 IS FALSE";
$proto50["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto50["m_column"]=$obj;
$proto50["m_contained"] = array();
$proto50["m_strCase"] = "IS FALSE";
$proto50["m_havingmode"] = false;
$proto50["m_inBrackets"] = true;
$proto50["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto50);

			$proto48["m_contained"][]=$obj;
						$proto52=array();
$proto52["m_sql"] = "approved2 IS TRUE";
$proto52["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto52["m_column"]=$obj;
$proto52["m_contained"] = array();
$proto52["m_strCase"] = "IS TRUE";
$proto52["m_havingmode"] = false;
$proto52["m_inBrackets"] = true;
$proto52["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto52);

			$proto48["m_contained"][]=$obj;
						$proto54=array();
$proto54["m_sql"] = "approved3 IS FALSE";
$proto54["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto54["m_column"]=$obj;
$proto54["m_contained"] = array();
$proto54["m_strCase"] = "IS FALSE";
$proto54["m_havingmode"] = false;
$proto54["m_inBrackets"] = true;
$proto54["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto54);

			$proto48["m_contained"][]=$obj;
$proto48["m_strCase"] = "";
$proto48["m_havingmode"] = false;
$proto48["m_inBrackets"] = true;
$proto48["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto48);

			$proto44["m_contained"][]=$obj;
$proto44["m_strCase"] = "";
$proto44["m_havingmode"] = false;
$proto44["m_inBrackets"] = true;
$proto44["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto44);

			$proto6["m_contained"][]=$obj;
						$proto56=array();
$proto56["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))";
$proto56["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE))"
));

$proto56["m_column"]=$obj;
$proto56["m_contained"] = array();
						$proto58=array();
$proto58["m_sql"] = "NewApplicant IS TRUE";
$proto58["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto58["m_column"]=$obj;
$proto58["m_contained"] = array();
$proto58["m_strCase"] = "IS TRUE";
$proto58["m_havingmode"] = false;
$proto58["m_inBrackets"] = true;
$proto58["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto58);

			$proto56["m_contained"][]=$obj;
						$proto60=array();
$proto60["m_sql"] = "(approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE)";
$proto60["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS TRUE)"
));

$proto60["m_column"]=$obj;
$proto60["m_contained"] = array();
						$proto62=array();
$proto62["m_sql"] = "approved1 IS FALSE";
$proto62["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto62["m_column"]=$obj;
$proto62["m_contained"] = array();
$proto62["m_strCase"] = "IS FALSE";
$proto62["m_havingmode"] = false;
$proto62["m_inBrackets"] = true;
$proto62["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto62);

			$proto60["m_contained"][]=$obj;
						$proto64=array();
$proto64["m_sql"] = "approved2 IS FALSE";
$proto64["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto64["m_column"]=$obj;
$proto64["m_contained"] = array();
$proto64["m_strCase"] = "IS FALSE";
$proto64["m_havingmode"] = false;
$proto64["m_inBrackets"] = true;
$proto64["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto64);

			$proto60["m_contained"][]=$obj;
						$proto66=array();
$proto66["m_sql"] = "approved3 IS TRUE";
$proto66["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto66["m_column"]=$obj;
$proto66["m_contained"] = array();
$proto66["m_strCase"] = "IS TRUE";
$proto66["m_havingmode"] = false;
$proto66["m_inBrackets"] = true;
$proto66["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto66);

			$proto60["m_contained"][]=$obj;
$proto60["m_strCase"] = "";
$proto60["m_havingmode"] = false;
$proto60["m_inBrackets"] = true;
$proto60["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto60);

			$proto56["m_contained"][]=$obj;
$proto56["m_strCase"] = "";
$proto56["m_havingmode"] = false;
$proto56["m_inBrackets"] = true;
$proto56["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto56);

			$proto6["m_contained"][]=$obj;
						$proto68=array();
$proto68["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))";
$proto68["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))"
));

$proto68["m_column"]=$obj;
$proto68["m_contained"] = array();
						$proto70=array();
$proto70["m_sql"] = "NewApplicant IS TRUE";
$proto70["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto70["m_column"]=$obj;
$proto70["m_contained"] = array();
$proto70["m_strCase"] = "IS TRUE";
$proto70["m_havingmode"] = false;
$proto70["m_inBrackets"] = true;
$proto70["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto70);

			$proto68["m_contained"][]=$obj;
						$proto72=array();
$proto72["m_sql"] = "(approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)";
$proto72["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS TRUE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)"
));

$proto72["m_column"]=$obj;
$proto72["m_contained"] = array();
						$proto74=array();
$proto74["m_sql"] = "approved1 IS TRUE";
$proto74["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto74["m_column"]=$obj;
$proto74["m_contained"] = array();
$proto74["m_strCase"] = "IS TRUE";
$proto74["m_havingmode"] = false;
$proto74["m_inBrackets"] = true;
$proto74["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto74);

			$proto72["m_contained"][]=$obj;
						$proto76=array();
$proto76["m_sql"] = "approved2 IS FALSE";
$proto76["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto76["m_column"]=$obj;
$proto76["m_contained"] = array();
$proto76["m_strCase"] = "IS FALSE";
$proto76["m_havingmode"] = false;
$proto76["m_inBrackets"] = true;
$proto76["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto76);

			$proto72["m_contained"][]=$obj;
						$proto78=array();
$proto78["m_sql"] = "approved3 IS FALSE";
$proto78["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto78["m_column"]=$obj;
$proto78["m_contained"] = array();
$proto78["m_strCase"] = "IS FALSE";
$proto78["m_havingmode"] = false;
$proto78["m_inBrackets"] = true;
$proto78["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto78);

			$proto72["m_contained"][]=$obj;
$proto72["m_strCase"] = "";
$proto72["m_havingmode"] = false;
$proto72["m_inBrackets"] = true;
$proto72["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto72);

			$proto68["m_contained"][]=$obj;
$proto68["m_strCase"] = "";
$proto68["m_havingmode"] = false;
$proto68["m_inBrackets"] = true;
$proto68["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto68);

			$proto6["m_contained"][]=$obj;
						$proto80=array();
$proto80["m_sql"] = "((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017))";
$proto80["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "((NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)))     AND ((`1styear` =2016) OR (`1styear` =2017))"
));

$proto80["m_column"]=$obj;
$proto80["m_contained"] = array();
						$proto82=array();
$proto82["m_sql"] = "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))";
$proto82["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(NewApplicant IS TRUE) AND ((approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE))"
));

$proto82["m_column"]=$obj;
$proto82["m_contained"] = array();
						$proto84=array();
$proto84["m_sql"] = "NewApplicant IS TRUE";
$proto84["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto84["m_column"]=$obj;
$proto84["m_contained"] = array();
$proto84["m_strCase"] = "IS TRUE";
$proto84["m_havingmode"] = false;
$proto84["m_inBrackets"] = true;
$proto84["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto84);

			$proto82["m_contained"][]=$obj;
						$proto86=array();
$proto86["m_sql"] = "(approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)";
$proto86["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(approved1 IS FALSE) AND (approved2 IS FALSE) AND (approved3 IS FALSE)"
));

$proto86["m_column"]=$obj;
$proto86["m_contained"] = array();
						$proto88=array();
$proto88["m_sql"] = "approved1 IS FALSE";
$proto88["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto88["m_column"]=$obj;
$proto88["m_contained"] = array();
$proto88["m_strCase"] = "IS FALSE";
$proto88["m_havingmode"] = false;
$proto88["m_inBrackets"] = true;
$proto88["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto88);

			$proto86["m_contained"][]=$obj;
						$proto90=array();
$proto90["m_sql"] = "approved2 IS FALSE";
$proto90["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto90["m_column"]=$obj;
$proto90["m_contained"] = array();
$proto90["m_strCase"] = "IS FALSE";
$proto90["m_havingmode"] = false;
$proto90["m_inBrackets"] = true;
$proto90["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto90);

			$proto86["m_contained"][]=$obj;
						$proto92=array();
$proto92["m_sql"] = "approved3 IS FALSE";
$proto92["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto92["m_column"]=$obj;
$proto92["m_contained"] = array();
$proto92["m_strCase"] = "IS FALSE";
$proto92["m_havingmode"] = false;
$proto92["m_inBrackets"] = true;
$proto92["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto92);

			$proto86["m_contained"][]=$obj;
$proto86["m_strCase"] = "";
$proto86["m_havingmode"] = false;
$proto86["m_inBrackets"] = true;
$proto86["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto86);

			$proto82["m_contained"][]=$obj;
$proto82["m_strCase"] = "";
$proto82["m_havingmode"] = false;
$proto82["m_inBrackets"] = true;
$proto82["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto82);

			$proto80["m_contained"][]=$obj;
						$proto94=array();
$proto94["m_sql"] = "(`1styear` =2016) OR (`1styear` =2017)";
$proto94["m_uniontype"] = "SQLL_OR";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(`1styear` =2016) OR (`1styear` =2017)"
));

$proto94["m_column"]=$obj;
$proto94["m_contained"] = array();
						$proto96=array();
$proto96["m_sql"] = "`1styear` =2016";
$proto96["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto96["m_column"]=$obj;
$proto96["m_contained"] = array();
$proto96["m_strCase"] = "=2016";
$proto96["m_havingmode"] = false;
$proto96["m_inBrackets"] = true;
$proto96["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto96);

			$proto94["m_contained"][]=$obj;
						$proto98=array();
$proto98["m_sql"] = "`1styear` =2017";
$proto98["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto98["m_column"]=$obj;
$proto98["m_contained"] = array();
$proto98["m_strCase"] = "=2017";
$proto98["m_havingmode"] = false;
$proto98["m_inBrackets"] = true;
$proto98["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto98);

			$proto94["m_contained"][]=$obj;
$proto94["m_strCase"] = "";
$proto94["m_havingmode"] = false;
$proto94["m_inBrackets"] = true;
$proto94["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto94);

			$proto80["m_contained"][]=$obj;
$proto80["m_strCase"] = "";
$proto80["m_havingmode"] = false;
$proto80["m_inBrackets"] = false;
$proto80["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto80);

			$proto6["m_contained"][]=$obj;
$proto6["m_strCase"] = "";
$proto6["m_havingmode"] = false;
$proto6["m_inBrackets"] = true;
$proto6["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto6);

			$proto2["m_contained"][]=$obj;
$proto2["m_strCase"] = "";
$proto2["m_havingmode"] = false;
$proto2["m_inBrackets"] = false;
$proto2["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto2);

$proto0["m_where"] = $obj;
$proto100=array();
$proto100["m_sql"] = "";
$proto100["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto100["m_column"]=$obj;
$proto100["m_contained"] = array();
$proto100["m_strCase"] = "";
$proto100["m_havingmode"] = false;
$proto100["m_inBrackets"] = false;
$proto100["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto100);

$proto0["m_having"] = $obj;
$proto0["m_fieldlist"] = array();
						$proto102=array();
			$obj = new SQLField(array(
	"m_strName" => "Surname",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto102["m_sql"] = "Surname";
$proto102["m_srcTableName"] = "JudgesNotApproved";
$proto102["m_expr"]=$obj;
$proto102["m_alias"] = "";
$obj = new SQLFieldListItem($proto102);

$proto0["m_fieldlist"][]=$obj;
						$proto104=array();
			$obj = new SQLField(array(
	"m_strName" => "FirstName",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto104["m_sql"] = "FirstName";
$proto104["m_srcTableName"] = "JudgesNotApproved";
$proto104["m_expr"]=$obj;
$proto104["m_alias"] = "";
$obj = new SQLFieldListItem($proto104);

$proto0["m_fieldlist"][]=$obj;
						$proto106=array();
			$obj = new SQLField(array(
	"m_strName" => "GPA",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto106["m_sql"] = "GPA";
$proto106["m_srcTableName"] = "JudgesNotApproved";
$proto106["m_expr"]=$obj;
$proto106["m_alias"] = "";
$obj = new SQLFieldListItem($proto106);

$proto0["m_fieldlist"][]=$obj;
						$proto108=array();
			$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto108["m_sql"] = "approved1";
$proto108["m_srcTableName"] = "JudgesNotApproved";
$proto108["m_expr"]=$obj;
$proto108["m_alias"] = "";
$obj = new SQLFieldListItem($proto108);

$proto0["m_fieldlist"][]=$obj;
						$proto110=array();
			$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto110["m_sql"] = "approved2";
$proto110["m_srcTableName"] = "JudgesNotApproved";
$proto110["m_expr"]=$obj;
$proto110["m_alias"] = "";
$obj = new SQLFieldListItem($proto110);

$proto0["m_fieldlist"][]=$obj;
						$proto112=array();
			$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto112["m_sql"] = "approved3";
$proto112["m_srcTableName"] = "JudgesNotApproved";
$proto112["m_expr"]=$obj;
$proto112["m_alias"] = "";
$obj = new SQLFieldListItem($proto112);

$proto0["m_fieldlist"][]=$obj;
						$proto114=array();
			$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto114["m_sql"] = "NewApplicant";
$proto114["m_srcTableName"] = "JudgesNotApproved";
$proto114["m_expr"]=$obj;
$proto114["m_alias"] = "";
$obj = new SQLFieldListItem($proto114);

$proto0["m_fieldlist"][]=$obj;
						$proto116=array();
			$obj = new SQLField(array(
	"m_strName" => "JudgeComment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto116["m_sql"] = "JudgeComment";
$proto116["m_srcTableName"] = "JudgesNotApproved";
$proto116["m_expr"]=$obj;
$proto116["m_alias"] = "";
$obj = new SQLFieldListItem($proto116);

$proto0["m_fieldlist"][]=$obj;
						$proto118=array();
			$obj = new SQLField(array(
	"m_strName" => "Judge3Comment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto118["m_sql"] = "Judge3Comment";
$proto118["m_srcTableName"] = "JudgesNotApproved";
$proto118["m_expr"]=$obj;
$proto118["m_alias"] = "";
$obj = new SQLFieldListItem($proto118);

$proto0["m_fieldlist"][]=$obj;
						$proto120=array();
			$obj = new SQLField(array(
	"m_strName" => "Judge2Comment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto120["m_sql"] = "Judge2Comment";
$proto120["m_srcTableName"] = "JudgesNotApproved";
$proto120["m_expr"]=$obj;
$proto120["m_alias"] = "";
$obj = new SQLFieldListItem($proto120);

$proto0["m_fieldlist"][]=$obj;
						$proto122=array();
			$obj = new SQLField(array(
	"m_strName" => "Documents",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto122["m_sql"] = "Documents";
$proto122["m_srcTableName"] = "JudgesNotApproved";
$proto122["m_expr"]=$obj;
$proto122["m_alias"] = "";
$obj = new SQLFieldListItem($proto122);

$proto0["m_fieldlist"][]=$obj;
						$proto124=array();
			$obj = new SQLField(array(
	"m_strName" => "Reapply",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto124["m_sql"] = "Reapply";
$proto124["m_srcTableName"] = "JudgesNotApproved";
$proto124["m_expr"]=$obj;
$proto124["m_alias"] = "";
$obj = new SQLFieldListItem($proto124);

$proto0["m_fieldlist"][]=$obj;
						$proto126=array();
			$obj = new SQLField(array(
	"m_strName" => "TertiaryInstitutionAdmitted",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto126["m_sql"] = "TertiaryInstitutionAdmitted";
$proto126["m_srcTableName"] = "JudgesNotApproved";
$proto126["m_expr"]=$obj;
$proto126["m_alias"] = "";
$obj = new SQLFieldListItem($proto126);

$proto0["m_fieldlist"][]=$obj;
						$proto128=array();
			$obj = new SQLField(array(
	"m_strName" => "ScholarshipType",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto128["m_sql"] = "ScholarshipType";
$proto128["m_srcTableName"] = "JudgesNotApproved";
$proto128["m_expr"]=$obj;
$proto128["m_alias"] = "";
$obj = new SQLFieldListItem($proto128);

$proto0["m_fieldlist"][]=$obj;
						$proto130=array();
			$obj = new SQLField(array(
	"m_strName" => "ProgramName",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto130["m_sql"] = "ProgramName";
$proto130["m_srcTableName"] = "JudgesNotApproved";
$proto130["m_expr"]=$obj;
$proto130["m_alias"] = "";
$obj = new SQLFieldListItem($proto130);

$proto0["m_fieldlist"][]=$obj;
						$proto132=array();
			$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto132["m_sql"] = "`1styear`";
$proto132["m_srcTableName"] = "JudgesNotApproved";
$proto132["m_expr"]=$obj;
$proto132["m_alias"] = "";
$obj = new SQLFieldListItem($proto132);

$proto0["m_fieldlist"][]=$obj;
$proto0["m_fromlist"] = array();
												$proto134=array();
$proto134["m_link"] = "SQLL_MAIN";
			$proto135=array();
$proto135["m_strName"] = "applicform";
$proto135["m_srcTableName"] = "JudgesNotApproved";
$proto135["m_columns"] = array();
$proto135["m_columns"][] = "MPGID";
$proto135["m_columns"][] = "StudentSchoolID";
$proto135["m_columns"][] = "Surname";
$proto135["m_columns"][] = "FirstName";
$proto135["m_columns"][] = "Photo";
$proto135["m_columns"][] = "Gender";
$proto135["m_columns"][] = "DateofBirth";
$proto135["m_columns"][] = "PlaceofBirth";
$proto135["m_columns"][] = "DistrictOfBirth";
$proto135["m_columns"][] = "ProvinceOfBirth";
$proto135["m_columns"][] = "FatherVillage";
$proto135["m_columns"][] = "FatherLLG";
$proto135["m_columns"][] = "FatherDistrict";
$proto135["m_columns"][] = "FATHERJOB";
$proto135["m_columns"][] = "FATHERSNAME";
$proto135["m_columns"][] = "FATHERSURNAME";
$proto135["m_columns"][] = "FATHERPROV";
$proto135["m_columns"][] = "MOTHERJOB";
$proto135["m_columns"][] = "MOTHERNAME";
$proto135["m_columns"][] = "MOTHERSURNAME";
$proto135["m_columns"][] = "MOTHERNATIONAL";
$proto135["m_columns"][] = "FATHERNATIONAL";
$proto135["m_columns"][] = "FATHERCLAN";
$proto135["m_columns"][] = "MOTHERCLAN";
$proto135["m_columns"][] = "MOTHERRELIGION";
$proto135["m_columns"][] = "FATHERRELIGION";
$proto135["m_columns"][] = "FATHERBIRTHPLACE";
$proto135["m_columns"][] = "MOTHERBIRTHPLACE";
$proto135["m_columns"][] = "MotherVillage";
$proto135["m_columns"][] = "MotherLLG";
$proto135["m_columns"][] = "MotherDistrict";
$proto135["m_columns"][] = "MOTHERPROV";
$proto135["m_columns"][] = "LastInstitutuonAttended";
$proto135["m_columns"][] = "HighestGradeCompleted";
$proto135["m_columns"][] = "YearHighestGradeCompleted";
$proto135["m_columns"][] = "TertiaryInstitutionAdmitted";
$proto135["m_columns"][] = "ProgramName";
$proto135["m_columns"][] = "ProgramCode";
$proto135["m_columns"][] = "WitnessName";
$proto135["m_columns"][] = "WitnessOccupation";
$proto135["m_columns"][] = "WitnessAddress";
$proto135["m_columns"][] = "1styear";
$proto135["m_columns"][] = "1styearTesas";
$proto135["m_columns"][] = "1styearFee";
$proto135["m_columns"][] = "Paid1stYearFee";
$proto135["m_columns"][] = "Repeat1stYear";
$proto135["m_columns"][] = "Repeat1stTESAS";
$proto135["m_columns"][] = "Repeatd1stYearFee";
$proto135["m_columns"][] = "Paid1stYrRepeatFee";
$proto135["m_columns"][] = "Passd1stYear";
$proto135["m_columns"][] = "sem1year1";
$proto135["m_columns"][] = "Year2nd";
$proto135["m_columns"][] = "TESAS2ndYear";
$proto135["m_columns"][] = "Fee2ndYear";
$proto135["m_columns"][] = "Paid2ndYearFee";
$proto135["m_columns"][] = "Repeated2ndYear";
$proto135["m_columns"][] = "Repeat2ndYrTESAS";
$proto135["m_columns"][] = "Repeat2ndYearFee";
$proto135["m_columns"][] = "Paid2ndYrRepeatFee";
$proto135["m_columns"][] = "Passd2ndYear";
$proto135["m_columns"][] = "sem1year2";
$proto135["m_columns"][] = "Year3rd";
$proto135["m_columns"][] = "TESAS3rdYear";
$proto135["m_columns"][] = "Fee3rdYear";
$proto135["m_columns"][] = "Paid3rdYrFee";
$proto135["m_columns"][] = "Repeatd3rdYear";
$proto135["m_columns"][] = "Repeat3rdYrTESAS";
$proto135["m_columns"][] = "Repeatd3rdYrFee";
$proto135["m_columns"][] = "Paid3rdYrRepeatFee";
$proto135["m_columns"][] = "Passd3rdYear";
$proto135["m_columns"][] = "sem1year3";
$proto135["m_columns"][] = "Year4th";
$proto135["m_columns"][] = "TESAS4thYear";
$proto135["m_columns"][] = "Fee4thYear";
$proto135["m_columns"][] = "Paid4thYearFee";
$proto135["m_columns"][] = "Repeated4thYear";
$proto135["m_columns"][] = "Repeath4thYrTESAS";
$proto135["m_columns"][] = "Repeat4thYrFee";
$proto135["m_columns"][] = "Paid4thYrRepeatFee";
$proto135["m_columns"][] = "Passd4thYear";
$proto135["m_columns"][] = "sem1year4";
$proto135["m_columns"][] = "Year5th";
$proto135["m_columns"][] = "TESAS5thYear";
$proto135["m_columns"][] = "Fee5thYear";
$proto135["m_columns"][] = "Paid5thYearFee";
$proto135["m_columns"][] = "Repeat5thYear";
$proto135["m_columns"][] = "Repeat5thYrTESAS";
$proto135["m_columns"][] = "Repeat5thYrFEE";
$proto135["m_columns"][] = "Paid5thYrRepeatFee";
$proto135["m_columns"][] = "Passdd5thYr";
$proto135["m_columns"][] = "sem1year5";
$proto135["m_columns"][] = "Graduated";
$proto135["m_columns"][] = "YearGraduated";
$proto135["m_columns"][] = "PostingtoSchool";
$proto135["m_columns"][] = "PostingsLLG";
$proto135["m_columns"][] = "ScholarshipType";
$proto135["m_columns"][] = "Comments";
$proto135["m_columns"][] = "NewApplicant";
$proto135["m_columns"][] = "Judge1Comment";
$proto135["m_columns"][] = "Reapply";
$proto135["m_columns"][] = "EmailAddrssAppl";
$proto135["m_columns"][] = "MobileNoAppl";
$proto135["m_columns"][] = "GPA";
$proto135["m_columns"][] = "approved1";
$proto135["m_columns"][] = "approved2";
$proto135["m_columns"][] = "approved3";
$proto135["m_columns"][] = "Judge2Comment";
$proto135["m_columns"][] = "Judge3Comment";
$proto135["m_columns"][] = "JudgeComment";
$proto135["m_columns"][] = "Lat";
$proto135["m_columns"][] = "Lng";
$proto135["m_columns"][] = "Documents";
$proto135["m_columns"][] = "judge1id";
$proto135["m_columns"][] = "judee2id";
$proto135["m_columns"][] = "judge3id";
$proto135["m_columns"][] = "username";
$proto135["m_columns"][] = "transcripts";
$proto135["m_columns"][] = "acceptletter";
$proto135["m_columns"][] = "gradetencert";
$proto135["m_columns"][] = "grade12cert";
$proto135["m_columns"][] = "natid";
$proto135["m_columns"][] = "sem2year1";
$proto135["m_columns"][] = "sem2year2";
$proto135["m_columns"][] = "sem2year3";
$proto135["m_columns"][] = "sem2year4";
$proto135["m_columns"][] = "sem2year5";
$proto135["m_columns"][] = "y1housingtype";
$proto135["m_columns"][] = "y2housingtype";
$proto135["m_columns"][] = "y3housingtype";
$proto135["m_columns"][] = "y4housingtype";
$proto135["m_columns"][] = "y5housingtype";
$proto135["m_columns"][] = "comment1";
$proto135["m_columns"][] = "comment2";
$proto135["m_columns"][] = "comment3";
$proto135["m_columns"][] = "comment4";
$proto135["m_columns"][] = "comment5";
$proto135["m_columns"][] = "assessed";
$proto135["m_columns"][] = "assessed1";
$proto135["m_columns"][] = "assessed2";
$proto135["m_columns"][] = "assessed3";
$proto135["m_columns"][] = "assessed4";
$proto135["m_columns"][] = "assessed5";
$proto135["m_columns"][] = "parentsnowliving";
$proto135["m_columns"][] = "active";
$proto135["m_columns"][] = "reset_token";
$proto135["m_columns"][] = "reset_date";
$obj = new SQLTable($proto135);

$proto134["m_table"] = $obj;
$proto134["m_sql"] = "applicform";
$proto134["m_alias"] = "";
$proto134["m_srcTableName"] = "JudgesNotApproved";
$proto136=array();
$proto136["m_sql"] = "";
$proto136["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

$proto136["m_column"]=$obj;
$proto136["m_contained"] = array();
$proto136["m_strCase"] = "";
$proto136["m_havingmode"] = false;
$proto136["m_inBrackets"] = false;
$proto136["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto136);

$proto134["m_joinon"] = $obj;
$obj = new SQLFromListItem($proto134);

$proto0["m_fromlist"][]=$obj;
$proto0["m_groupby"] = array();
$proto0["m_orderby"] = array();
												$proto138=array();
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "JudgesNotApproved"
));

$proto138["m_column"]=$obj;
$proto138["m_bAsc"] = 1;
$proto138["m_nColumn"] = 0;
$obj = new SQLOrderByItem($proto138);

$proto0["m_orderby"][]=$obj;					
$proto0["m_srcTableName"]="JudgesNotApproved";		
$obj = new SQLQuery($proto0);

	return $obj;
}
$queryData_JudgesNotApproved = createSqlQuery_JudgesNotApproved();


	
		;

																

$tdataJudgesNotApproved[".sqlquery"] = $queryData_JudgesNotApproved;

$tableEvents["JudgesNotApproved"] = new eventsBase;
$tdataJudgesNotApproved[".hasEvents"] = false;

?>