<?php



$tdatajudgescont2017 = array();
$tdatajudgescont2017[".searchableFields"] = array();
$tdatajudgescont2017[".ShortName"] = "judgescont2017";
$tdatajudgescont2017[".OwnerID"] = "";
$tdatajudgescont2017[".OriginalTable"] = "applicform";


$defaultPages = my_json_decode( "{\"edit\":\"edit\",\"export\":\"export\",\"list\":\"list\",\"print\":\"print\",\"search\":\"search\",\"view\":\"view\"}" );

$tdatajudgescont2017[".pagesByType"] = my_json_decode( "{\"edit\":[\"edit\"],\"export\":[\"export\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" );
$tdatajudgescont2017[".pages"] = types2pages( my_json_decode( "{\"edit\":[\"edit\"],\"export\":[\"export\"],\"list\":[\"list\"],\"print\":[\"print\"],\"search\":[\"search\"],\"view\":[\"view\"]}" ) );
$tdatajudgescont2017[".defaultPages"] = $defaultPages;

//	field labels
$fieldLabelsjudgescont2017 = array();
$fieldToolTipsjudgescont2017 = array();
$pageTitlesjudgescont2017 = array();
$placeHoldersjudgescont2017 = array();

if(mlang_getcurrentlang()=="English")
{
	$fieldLabelsjudgescont2017["English"] = array();
	$fieldToolTipsjudgescont2017["English"] = array();
	$placeHoldersjudgescont2017["English"] = array();
	$pageTitlesjudgescont2017["English"] = array();
	$fieldLabelsjudgescont2017["English"]["StudentSchoolID"] = "Student School ID";
	$fieldToolTipsjudgescont2017["English"]["StudentSchoolID"] = "";
	$placeHoldersjudgescont2017["English"]["StudentSchoolID"] = "";
	$fieldLabelsjudgescont2017["English"]["Surname"] = "Surname:";
	$fieldToolTipsjudgescont2017["English"]["Surname"] = "";
	$placeHoldersjudgescont2017["English"]["Surname"] = "";
	$fieldLabelsjudgescont2017["English"]["FirstName"] = "Full Name:";
	$fieldToolTipsjudgescont2017["English"]["FirstName"] = "";
	$placeHoldersjudgescont2017["English"]["FirstName"] = "";
	$fieldLabelsjudgescont2017["English"]["Photo"] = "Photo";
	$fieldToolTipsjudgescont2017["English"]["Photo"] = "";
	$placeHoldersjudgescont2017["English"]["Photo"] = "";
	$fieldLabelsjudgescont2017["English"]["Gender"] = "Gender";
	$fieldToolTipsjudgescont2017["English"]["Gender"] = "";
	$placeHoldersjudgescont2017["English"]["Gender"] = "";
	$fieldLabelsjudgescont2017["English"]["PlaceofBirth"] = "Placeof Birth";
	$fieldToolTipsjudgescont2017["English"]["PlaceofBirth"] = "";
	$placeHoldersjudgescont2017["English"]["PlaceofBirth"] = "";
	$fieldLabelsjudgescont2017["English"]["FatherDistrict"] = "District";
	$fieldToolTipsjudgescont2017["English"]["FatherDistrict"] = "";
	$placeHoldersjudgescont2017["English"]["FatherDistrict"] = "";
	$fieldLabelsjudgescont2017["English"]["MotherDistrict"] = "Mothers District";
	$fieldToolTipsjudgescont2017["English"]["MotherDistrict"] = "";
	$placeHoldersjudgescont2017["English"]["MotherDistrict"] = "";
	$fieldLabelsjudgescont2017["English"]["LastInstitutuonAttended"] = "Last Institutuon Attended";
	$fieldToolTipsjudgescont2017["English"]["LastInstitutuonAttended"] = "";
	$placeHoldersjudgescont2017["English"]["LastInstitutuonAttended"] = "";
	$fieldLabelsjudgescont2017["English"]["TertiaryInstitutionAdmitted"] = "Tertiary Institution Admitted";
	$fieldToolTipsjudgescont2017["English"]["TertiaryInstitutionAdmitted"] = "";
	$placeHoldersjudgescont2017["English"]["TertiaryInstitutionAdmitted"] = "";
	$fieldLabelsjudgescont2017["English"]["ProgramName"] = "Program Name";
	$fieldToolTipsjudgescont2017["English"]["ProgramName"] = "";
	$placeHoldersjudgescont2017["English"]["ProgramName"] = "";
	$fieldLabelsjudgescont2017["English"]["NewApplicant"] = "New Applicant";
	$fieldToolTipsjudgescont2017["English"]["NewApplicant"] = "";
	$placeHoldersjudgescont2017["English"]["NewApplicant"] = "";
	$fieldLabelsjudgescont2017["English"]["Reapply"] = "Reapply";
	$fieldToolTipsjudgescont2017["English"]["Reapply"] = "";
	$placeHoldersjudgescont2017["English"]["Reapply"] = "";
	$fieldLabelsjudgescont2017["English"]["HighestGradeCompleted"] = "Highest Grade Completed";
	$fieldToolTipsjudgescont2017["English"]["HighestGradeCompleted"] = "";
	$placeHoldersjudgescont2017["English"]["HighestGradeCompleted"] = "";
	$fieldLabelsjudgescont2017["English"]["EmailAddrssAppl"] = "Email Addrss Appl";
	$fieldToolTipsjudgescont2017["English"]["EmailAddrssAppl"] = "";
	$placeHoldersjudgescont2017["English"]["EmailAddrssAppl"] = "";
	$fieldLabelsjudgescont2017["English"]["MobileNoAppl"] = "Mobile No Appl";
	$fieldToolTipsjudgescont2017["English"]["MobileNoAppl"] = "";
	$placeHoldersjudgescont2017["English"]["MobileNoAppl"] = "";
	$fieldLabelsjudgescont2017["English"]["GPA"] = "GPA";
	$fieldToolTipsjudgescont2017["English"]["GPA"] = "";
	$placeHoldersjudgescont2017["English"]["GPA"] = "";
	$fieldLabelsjudgescont2017["English"]["approved1"] = "Approved1";
	$fieldToolTipsjudgescont2017["English"]["approved1"] = "";
	$placeHoldersjudgescont2017["English"]["approved1"] = "";
	$fieldLabelsjudgescont2017["English"]["approved2"] = "Approved2";
	$fieldToolTipsjudgescont2017["English"]["approved2"] = "";
	$placeHoldersjudgescont2017["English"]["approved2"] = "";
	$fieldLabelsjudgescont2017["English"]["approved3"] = "Approved3";
	$fieldToolTipsjudgescont2017["English"]["approved3"] = "";
	$placeHoldersjudgescont2017["English"]["approved3"] = "";
	$fieldLabelsjudgescont2017["English"]["DateofBirth"] = "Dateof Birth";
	$fieldToolTipsjudgescont2017["English"]["DateofBirth"] = "";
	$placeHoldersjudgescont2017["English"]["DateofBirth"] = "";
	$fieldLabelsjudgescont2017["English"]["MOTHERSURNAME"] = "Mother's Surname";
	$fieldToolTipsjudgescont2017["English"]["MOTHERSURNAME"] = "";
	$placeHoldersjudgescont2017["English"]["MOTHERSURNAME"] = "";
	$fieldLabelsjudgescont2017["English"]["WitnessName"] = "Witness Name";
	$fieldToolTipsjudgescont2017["English"]["WitnessName"] = "";
	$placeHoldersjudgescont2017["English"]["WitnessName"] = "";
	$fieldLabelsjudgescont2017["English"]["Judge1Comment"] = "Judge1Comment";
	$fieldToolTipsjudgescont2017["English"]["Judge1Comment"] = "";
	$placeHoldersjudgescont2017["English"]["Judge1Comment"] = "";
	$fieldLabelsjudgescont2017["English"]["Judge2Comment"] = "Judge2Comment";
	$fieldToolTipsjudgescont2017["English"]["Judge2Comment"] = "";
	$placeHoldersjudgescont2017["English"]["Judge2Comment"] = "";
	$fieldLabelsjudgescont2017["English"]["Judge3Comment"] = "Judge3Comment";
	$fieldToolTipsjudgescont2017["English"]["Judge3Comment"] = "";
	$placeHoldersjudgescont2017["English"]["Judge3Comment"] = "";
	$fieldLabelsjudgescont2017["English"]["Documents"] = "Documents";
	$fieldToolTipsjudgescont2017["English"]["Documents"] = "";
	$placeHoldersjudgescont2017["English"]["Documents"] = "";
	$fieldLabelsjudgescont2017["English"]["WitnessAddress"] = "Witness Address";
	$fieldToolTipsjudgescont2017["English"]["WitnessAddress"] = "";
	$placeHoldersjudgescont2017["English"]["WitnessAddress"] = "";
	$fieldLabelsjudgescont2017["English"]["MOTHERNAME"] = "Mother's Name";
	$fieldToolTipsjudgescont2017["English"]["MOTHERNAME"] = "";
	$placeHoldersjudgescont2017["English"]["MOTHERNAME"] = "";
	$fieldLabelsjudgescont2017["English"]["FATHERSNAME"] = "Father's Name";
	$fieldToolTipsjudgescont2017["English"]["FATHERSNAME"] = "";
	$placeHoldersjudgescont2017["English"]["FATHERSNAME"] = "";
	$fieldLabelsjudgescont2017["English"]["WitnessOccupation"] = "Witness Occupation";
	$fieldToolTipsjudgescont2017["English"]["WitnessOccupation"] = "";
	$placeHoldersjudgescont2017["English"]["WitnessOccupation"] = "";
	$fieldLabelsjudgescont2017["English"]["MPGID"] = "MPGID";
	$fieldToolTipsjudgescont2017["English"]["MPGID"] = "";
	$placeHoldersjudgescont2017["English"]["MPGID"] = "";
	$fieldLabelsjudgescont2017["English"]["FATHERSURNAME"] = "Father's Surname";
	$fieldToolTipsjudgescont2017["English"]["FATHERSURNAME"] = "";
	$placeHoldersjudgescont2017["English"]["FATHERSURNAME"] = "";
	$fieldLabelsjudgescont2017["English"]["1styear"] = "First Year";
	$fieldToolTipsjudgescont2017["English"]["1styear"] = "";
	$placeHoldersjudgescont2017["English"]["1styear"] = "";
	$fieldLabelsjudgescont2017["English"]["transcripts"] = "Transcripts";
	$fieldToolTipsjudgescont2017["English"]["transcripts"] = "";
	$placeHoldersjudgescont2017["English"]["transcripts"] = "";
	$fieldLabelsjudgescont2017["English"]["assessed"] = "Assessed";
	$fieldToolTipsjudgescont2017["English"]["assessed"] = "";
	$placeHoldersjudgescont2017["English"]["assessed"] = "";
	$pageTitlesjudgescont2017["English"]["view"] = "Assessment Screen 2017 [{%MPGID}]";
	$pageTitlesjudgescont2017["English"]["edit"] = "Assessment Screen [{%MPGID}]";
	if (count($fieldToolTipsjudgescont2017["English"]))
		$tdatajudgescont2017[".isUseToolTips"] = true;
}


	$tdatajudgescont2017[".NCSearch"] = true;



$tdatajudgescont2017[".shortTableName"] = "judgescont2017";
$tdatajudgescont2017[".nSecOptions"] = 0;

$tdatajudgescont2017[".mainTableOwnerID"] = "";
$tdatajudgescont2017[".entityType"] = 1;

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

	



$tdatajudgescont2017[".showAddInPopup"] = true;

$tdatajudgescont2017[".showEditInPopup"] = true;

$tdatajudgescont2017[".showViewInPopup"] = true;

//page's base css files names
$popupPagesLayoutNames = array();
			;
$popupPagesLayoutNames["add"] = "add";
			;
$popupPagesLayoutNames["edit"] = "add";
			;
$popupPagesLayoutNames["view"] = "add";
$tdatajudgescont2017[".popupPagesLayoutNames"] = $popupPagesLayoutNames;


	$tdatajudgescont2017[".listAjax"] = true;
//	temporary
$tdatajudgescont2017[".listAjax"] = false;

	$tdatajudgescont2017[".audit"] = false;

	$tdatajudgescont2017[".locking"] = false;


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

if( $pages[PAGE_EDIT] ) {
	$tdatajudgescont2017[".edit"] = true;
	$tdatajudgescont2017[".afterEditAction"] = 1;
	$tdatajudgescont2017[".closePopupAfterEdit"] = 1;
	$tdatajudgescont2017[".afterEditActionDetTable"] = "Detail tables not found!";
}

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

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

$tdatajudgescont2017[".updateSelected"] = true;


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




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

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

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

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



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

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

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

$tdatajudgescont2017[".isUseAjaxSuggest"] = true;

$tdatajudgescont2017[".rowHighlite"] = true;



						

$tdatajudgescont2017[".ajaxCodeSnippetAdded"] = false;

$tdatajudgescont2017[".buttonsAdded"] = false;

$tdatajudgescont2017[".addPageEvents"] = false;

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




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

$tdatajudgescont2017[".googleLikeFields"] = array();
$tdatajudgescont2017[".googleLikeFields"][] = "Surname";
$tdatajudgescont2017[".googleLikeFields"][] = "FirstName";
$tdatajudgescont2017[".googleLikeFields"][] = "StudentSchoolID";
$tdatajudgescont2017[".googleLikeFields"][] = "MPGID";
$tdatajudgescont2017[".googleLikeFields"][] = "MobileNoAppl";
$tdatajudgescont2017[".googleLikeFields"][] = "Photo";
$tdatajudgescont2017[".googleLikeFields"][] = "Documents";
$tdatajudgescont2017[".googleLikeFields"][] = "Gender";
$tdatajudgescont2017[".googleLikeFields"][] = "DateofBirth";
$tdatajudgescont2017[".googleLikeFields"][] = "PlaceofBirth";
$tdatajudgescont2017[".googleLikeFields"][] = "FatherDistrict";
$tdatajudgescont2017[".googleLikeFields"][] = "MOTHERNAME";
$tdatajudgescont2017[".googleLikeFields"][] = "MOTHERSURNAME";
$tdatajudgescont2017[".googleLikeFields"][] = "MotherDistrict";
$tdatajudgescont2017[".googleLikeFields"][] = "FATHERSNAME";
$tdatajudgescont2017[".googleLikeFields"][] = "FATHERSURNAME";
$tdatajudgescont2017[".googleLikeFields"][] = "TertiaryInstitutionAdmitted";
$tdatajudgescont2017[".googleLikeFields"][] = "WitnessName";
$tdatajudgescont2017[".googleLikeFields"][] = "WitnessAddress";
$tdatajudgescont2017[".googleLikeFields"][] = "WitnessOccupation";
$tdatajudgescont2017[".googleLikeFields"][] = "NewApplicant";
$tdatajudgescont2017[".googleLikeFields"][] = "Reapply";
$tdatajudgescont2017[".googleLikeFields"][] = "EmailAddrssAppl";
$tdatajudgescont2017[".googleLikeFields"][] = "GPA";
$tdatajudgescont2017[".googleLikeFields"][] = "approved1";
$tdatajudgescont2017[".googleLikeFields"][] = "approved2";
$tdatajudgescont2017[".googleLikeFields"][] = "approved3";
$tdatajudgescont2017[".googleLikeFields"][] = "Judge1Comment";
$tdatajudgescont2017[".googleLikeFields"][] = "Judge2Comment";
$tdatajudgescont2017[".googleLikeFields"][] = "Judge3Comment";
$tdatajudgescont2017[".googleLikeFields"][] = "LastInstitutuonAttended";
$tdatajudgescont2017[".googleLikeFields"][] = "HighestGradeCompleted";
$tdatajudgescont2017[".googleLikeFields"][] = "ProgramName";
$tdatajudgescont2017[".googleLikeFields"][] = "1styear";
$tdatajudgescont2017[".googleLikeFields"][] = "transcripts";
$tdatajudgescont2017[".googleLikeFields"][] = "assessed";



$tdatajudgescont2017[".tableType"] = "list";

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

$tdatajudgescont2017[".nPrinterSplitRecords"] = 40;

$tdatajudgescont2017[".geocodingEnabled"] = false;




$tdatajudgescont2017[".isDisplayLoading"] = true;

$tdatajudgescont2017[".isResizeColumns"] = true;





$tdatajudgescont2017[".pageSize"] = 20;

$tdatajudgescont2017[".warnLeavingPages"] = true;



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

$tdatajudgescont2017[".orderindexes"] = array();
	$tdatajudgescont2017[".orderindexes"][] = array(17, (1 ? "ASC" : "DESC"), "TertiaryInstitutionAdmitted");


$tdatajudgescont2017[".sqlHead"] = "SELECT Surname,  FirstName,  StudentSchoolID,  MPGID,  MobileNoAppl,  Photo,  Documents,  Gender,  DateofBirth,  PlaceofBirth,  FatherDistrict,  MOTHERNAME,  MOTHERSURNAME,  MotherDistrict,  FATHERSNAME,  FATHERSURNAME,  TertiaryInstitutionAdmitted,  WitnessName,  WitnessAddress,  WitnessOccupation,  NewApplicant,  Reapply,  EmailAddrssAppl,  GPA,  approved1,  approved2,  approved3,  Judge1Comment,  Judge2Comment,  Judge3Comment,  LastInstitutuonAttended,  HighestGradeCompleted,  ProgramName,  `1styear`,  transcripts,  assessed";
$tdatajudgescont2017[".sqlFrom"] = "FROM applicform";
$tdatajudgescont2017[".sqlWhereExpr"] = "(transcripts is not null) and (`1styear` <> 2018) AND (((gpa is not null) or (gpa <> 0)) is true) AND ((assessed is null) OR (assessed is false) is true) AND (`1styear` is not null) AND (((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))is true) AND (((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013)) is true)";
$tdatajudgescont2017[".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;
$tdatajudgescont2017[".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;
$tdatajudgescont2017[".arrGroupsPerPage"] = $arrGPP;


$tableKeysjudgescont2017 = array();
$tableKeysjudgescont2017[] = "MPGID";
$tdatajudgescont2017[".Keys"] = $tableKeysjudgescont2017;


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




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

	
	
	
			

		$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"]["view"] = $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"] = 110;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

		$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"]["view"] = $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"] = 90;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["FirstName"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "FirstName";
//	StudentSchoolID
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 3;
	$fdata["strName"] = "StudentSchoolID";
	$fdata["GoodName"] = "StudentSchoolID";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","StudentSchoolID");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["StudentSchoolID"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "StudentSchoolID";
//	MPGID
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 4;
	$fdata["strName"] = "MPGID";
	$fdata["GoodName"] = "MPGID";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","MPGID");
	$fdata["FieldType"] = 3;

	
		$fdata["AutoInc"] = true;

	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $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"] = 1;
		$fdata["filterMultiSelect"] = 0;
			$fdata["filterFormat"] = "Values list";
		$fdata["showCollapsed"] = false;

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["MPGID"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "MPGID";
//	MobileNoAppl
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 5;
	$fdata["strName"] = "MobileNoAppl";
	$fdata["GoodName"] = "MobileNoAppl";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","MobileNoAppl");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["MobileNoAppl"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "MobileNoAppl";
//	Photo
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 6;
	$fdata["strName"] = "Photo";
	$fdata["GoodName"] = "Photo";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Photo");
	$fdata["FieldType"] = 201;

	
	
	
			

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

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

		$fdata["DeleteAssociatedFile"] = true;

	
		$fdata["UploadCodeExpression"] = true;

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

	$vdata = array("ViewFormat" => "File-based Image");

	
	
				$vdata["ShowThumbnail"] = true;
	$vdata["ThumbWidth"] = 150;
	$vdata["ThumbHeight"] = 150;
	$vdata["ImageWidth"] = 320;
	$vdata["ImageHeight"] = 240;

			$vdata["multipleImgMode"] = 1;
	$vdata["maxImages"] = 0;

			$vdata["showGallery"] = true;
	$vdata["galleryMode"] = 2;
	$vdata["captionMode"] = 2;
	$vdata["captionField"] = "";

	$vdata["imageBorder"] = 1;
	$vdata["imageFullWidth"] = 1;


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

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

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

	$edata = array("EditFormat" => "Document upload");

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


	
	



	
	
	
	
							$edata["acceptFileTypes"] = "gif";
			$edata["acceptFileTypesHtml"] = ".gif";
						$edata["acceptFileTypes"] .= "|jpe";
			$edata["acceptFileTypesHtml"] .= ",.jpe";
						$edata["acceptFileTypes"] .= "|jpeg";
			$edata["acceptFileTypesHtml"] .= ",.jpeg";
						$edata["acceptFileTypes"] .= "|jpg";
			$edata["acceptFileTypesHtml"] .= ",.jpg";
						$edata["acceptFileTypes"] .= "|png";
			$edata["acceptFileTypesHtml"] .= ",.png";
		$edata["acceptFileTypes"] = "(".$edata["acceptFileTypes"].")$";

		$edata["maxNumberOfFiles"] = 9;

		$edata["maxFileSize"] = 2500;

		$edata["maxTotalFilesSize"] = 10000;

	
	
	
	
		$edata["controlWidth"] = 143;

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

		$edata["CreateThumbnail"] = true;
	$edata["StrThumbnail"] = "th";
			$edata["ThumbnailSize"] = 150;

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


//Filters settings
	$fdata["filterTotals"] = 1;
			$fdata["filterTotalFields"] = "NewApplicant";
		$fdata["filterFormat"] = "Options list";
		$fdata["showCollapsed"] = false;

	
	
	
		$fdata["filterCheckedMessageType"] = "Text";
	$fdata["filterCheckedMessageText"] = "Checked";
	$fdata["filterUncheckedMessageType"] = "Text";
	$fdata["filterUncheckedMessageText"] = "Unchecked";

//end of Filters settings


	$tdatajudgescont2017["Photo"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Photo";
//	Documents
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 7;
	$fdata["strName"] = "Documents";
	$fdata["GoodName"] = "Documents";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Documents");
	$fdata["FieldType"] = 201;

	
	
	
			

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

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

		$fdata["DeleteAssociatedFile"] = true;

	
		$fdata["UploadCodeExpression"] = true;

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

	$vdata = array("ViewFormat" => "File-based Image");

	
	
				$vdata["ShowThumbnail"] = true;
	$vdata["ThumbWidth"] = 150;
	$vdata["ThumbHeight"] = 150;
	$vdata["ImageWidth"] = 480;
	$vdata["ImageHeight"] = 320;

			$vdata["multipleImgMode"] = 1;
	$vdata["maxImages"] = 0;

			$vdata["showGallery"] = true;
	$vdata["galleryMode"] = 2;
	$vdata["captionMode"] = 2;
	$vdata["captionField"] = "";

	$vdata["imageBorder"] = 1;
	$vdata["imageFullWidth"] = 1;


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

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

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

	$edata = array("EditFormat" => "Document upload");

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


	
	



	
	
	
	
							$edata["acceptFileTypes"] = "doc";
			$edata["acceptFileTypesHtml"] = ".doc";
						$edata["acceptFileTypes"] .= "|docx";
			$edata["acceptFileTypesHtml"] .= ",.docx";
						$edata["acceptFileTypes"] .= "|pdf";
			$edata["acceptFileTypesHtml"] .= ",.pdf";
						$edata["acceptFileTypes"] .= "|rtf";
			$edata["acceptFileTypesHtml"] .= ",.rtf";
						$edata["acceptFileTypes"] .= "|txt";
			$edata["acceptFileTypesHtml"] .= ",.txt";
		$edata["acceptFileTypes"] = "(".$edata["acceptFileTypes"].")$";

		$edata["maxNumberOfFiles"] = 9;

		$edata["maxFileSize"] = 2800;

		$edata["maxTotalFilesSize"] = 8000;

	
	
	
	
		$edata["controlWidth"] = 200;

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

		$edata["CreateThumbnail"] = true;
	$edata["StrThumbnail"] = "th";
			$edata["ThumbnailSize"] = 150;

			
	
	
	
	$fdata["EditFormats"]["edit"] = $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


	$tdatajudgescont2017["Documents"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Documents";
//	Gender
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 8;
	$fdata["strName"] = "Gender";
	$fdata["GoodName"] = "Gender";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Gender");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["Gender"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Gender";
//	DateofBirth
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 9;
	$fdata["strName"] = "DateofBirth";
	$fdata["GoodName"] = "DateofBirth";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","DateofBirth");
	$fdata["FieldType"] = 135;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

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

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

	$edata = array("EditFormat" => "Date");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
		$edata["DateEditType"] = 5;
	$edata["InitialYearFactor"] = 47;
	$edata["LastYearFactor"] = 0;

	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["DateofBirth"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "DateofBirth";
//	PlaceofBirth
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 10;
	$fdata["strName"] = "PlaceofBirth";
	$fdata["GoodName"] = "PlaceofBirth";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","PlaceofBirth");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["PlaceofBirth"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "PlaceofBirth";
//	FatherDistrict
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 11;
	$fdata["strName"] = "FatherDistrict";
	$fdata["GoodName"] = "FatherDistrict";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","FatherDistrict");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["FatherDistrict"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "FatherDistrict";
//	MOTHERNAME
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 12;
	$fdata["strName"] = "MOTHERNAME";
	$fdata["GoodName"] = "MOTHERNAME";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","MOTHERNAME");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["MOTHERNAME"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "MOTHERNAME";
//	MOTHERSURNAME
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 13;
	$fdata["strName"] = "MOTHERSURNAME";
	$fdata["GoodName"] = "MOTHERSURNAME";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","MOTHERSURNAME");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["MOTHERSURNAME"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "MOTHERSURNAME";
//	MotherDistrict
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 14;
	$fdata["strName"] = "MotherDistrict";
	$fdata["GoodName"] = "MotherDistrict";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","MotherDistrict");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["MotherDistrict"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "MotherDistrict";
//	FATHERSNAME
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 15;
	$fdata["strName"] = "FATHERSNAME";
	$fdata["GoodName"] = "FATHERSNAME";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","FATHERSNAME");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["FATHERSNAME"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "FATHERSNAME";
//	FATHERSURNAME
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 16;
	$fdata["strName"] = "FATHERSURNAME";
	$fdata["GoodName"] = "FATHERSURNAME";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","FATHERSURNAME");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["FATHERSURNAME"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "FATHERSURNAME";
//	TertiaryInstitutionAdmitted
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 17;
	$fdata["strName"] = "TertiaryInstitutionAdmitted";
	$fdata["GoodName"] = "TertiaryInstitutionAdmitted";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","TertiaryInstitutionAdmitted");
	$fdata["FieldType"] = 200;

	
	
	
			

		$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"]["view"] = $vdata;
//  End View Formats

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

	$edata = array("EditFormat" => "Lookup wizard");

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


	
	

// Begin Lookup settings
				$edata["LookupType"] = 1;
	$edata["LookupTable"] = "uniprograms10";
	$edata["LookupConnId"] = "";
			$edata["autoCompleteFieldsOnEdit"] = 0;
	$edata["autoCompleteFields"] = array();
		$edata["LCType"] = 0;

	
		
	$edata["LinkField"] = "University Name";
	$edata["LinkFieldType"] = 200;
	$edata["DisplayField"] = "University Name";

	

	
	$edata["LookupOrderBy"] = "";

	
	
	
		$edata["SimpleAdd"] = true;

				//dependent dropdowns @deprecated data ?
	$edata["DependentLookups"] = array();
	$edata["DependentLookups"][] = "ProgramName";

	
	
		$edata["SelectSize"] = 1;

// End Lookup Settings


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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["TertiaryInstitutionAdmitted"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "TertiaryInstitutionAdmitted";
//	WitnessName
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 18;
	$fdata["strName"] = "WitnessName";
	$fdata["GoodName"] = "WitnessName";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","WitnessName");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["WitnessName"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "WitnessName";
//	WitnessAddress
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 19;
	$fdata["strName"] = "WitnessAddress";
	$fdata["GoodName"] = "WitnessAddress";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","WitnessAddress");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["WitnessAddress"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "WitnessAddress";
//	WitnessOccupation
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 20;
	$fdata["strName"] = "WitnessOccupation";
	$fdata["GoodName"] = "WitnessOccupation";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","WitnessOccupation");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["WitnessOccupation"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "WitnessOccupation";
//	NewApplicant
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 21;
	$fdata["strName"] = "NewApplicant";
	$fdata["GoodName"] = "NewApplicant";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","NewApplicant");
	$fdata["FieldType"] = 3;

	
	
	
			

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

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

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

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

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

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

	$fdata["ViewFormats"]["view"] = $vdata;
	$vdata = array("ViewFormat" => "Checkbox");

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

	$fdata["ViewFormats"]["list"] = $vdata;
	$vdata = array("ViewFormat" => "Checkbox");

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

	$fdata["ViewFormats"]["print"] = $vdata;
	$vdata = array("ViewFormat" => "Checkbox");

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

	
			
	
	
	
	$fdata["EditFormats"]["edit"] = $edata;
	$edata = array("EditFormat" => "Readonly");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = true;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["NewApplicant"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "NewApplicant";
//	Reapply
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 22;
	$fdata["strName"] = "Reapply";
	$fdata["GoodName"] = "Reapply";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Reapply");
	$fdata["FieldType"] = 3;

	
	
	
			

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

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

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

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

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

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["Reapply"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Reapply";
//	EmailAddrssAppl
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 23;
	$fdata["strName"] = "EmailAddrssAppl";
	$fdata["GoodName"] = "EmailAddrssAppl";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","EmailAddrssAppl");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 219;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["EmailAddrssAppl"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "EmailAddrssAppl";
//	GPA
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 24;
	$fdata["strName"] = "GPA";
	$fdata["GoodName"] = "GPA";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","GPA");
	$fdata["FieldType"] = 5;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

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

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

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

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

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

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




// the field's search options settings
	
	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

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

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

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

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

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

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




// the field's search options settings
	
	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

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

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

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

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

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

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




// the field's search options settings
	
	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["approved3"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "approved3";
//	Judge1Comment
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 28;
	$fdata["strName"] = "Judge1Comment";
	$fdata["GoodName"] = "Judge1Comment";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Judge1Comment");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




// the field's search options settings
	
	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["Judge1Comment"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Judge1Comment";
//	Judge2Comment
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 29;
	$fdata["strName"] = "Judge2Comment";
	$fdata["GoodName"] = "Judge2Comment";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","Judge2Comment");
	$fdata["FieldType"] = 200;

	
	
	
			

		$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"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

		$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"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["Judge3Comment"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "Judge3Comment";
//	LastInstitutuonAttended
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 31;
	$fdata["strName"] = "LastInstitutuonAttended";
	$fdata["GoodName"] = "LastInstitutuonAttended";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","LastInstitutuonAttended");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["LastInstitutuonAttended"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "LastInstitutuonAttended";
//	HighestGradeCompleted
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 32;
	$fdata["strName"] = "HighestGradeCompleted";
	$fdata["GoodName"] = "HighestGradeCompleted";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","HighestGradeCompleted");
	$fdata["FieldType"] = 200;

	
	
	
			

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

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

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

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

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

	
	
	
	
	
	
	
	
	
	
	
	
		$vdata["NeedEncode"] = true;

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

	$fdata["ViewFormats"]["view"] = $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["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


	$tdatajudgescont2017["HighestGradeCompleted"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "HighestGradeCompleted";
//	ProgramName
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 33;
	$fdata["strName"] = "ProgramName";
	$fdata["GoodName"] = "ProgramName";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","ProgramName");
	$fdata["FieldType"] = 200;

	
	
	
			

		$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"]["view"] = $vdata;
//  End View Formats

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

	$edata = array("EditFormat" => "Lookup wizard");

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


	
	

// Begin Lookup settings
				$edata["LookupType"] = 1;
	$edata["LookupTable"] = "uniprograms10";
	$edata["LookupConnId"] = "";
			$edata["autoCompleteFieldsOnEdit"] = 0;
	$edata["autoCompleteFields"] = array();
		$edata["LCType"] = 0;

	
		
	$edata["LinkField"] = "University Program Name";
	$edata["LinkFieldType"] = 0;
	$edata["DisplayField"] = "University Program Name";

	

	
	$edata["LookupOrderBy"] = "";

	
		$edata["UseCategory"] = true;
	$edata["categoryFields"] = array();
	$edata["categoryFields"][] = array( "main" => "TertiaryInstitutionAdmitted", "lookup" => "University Name" );

	
		$edata["SimpleAdd"] = true;


	
	
		$edata["SelectSize"] = 1;

// End Lookup Settings


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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 143;

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

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


	$fdata["isSeparate"] = false;




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

	// the end of search options settings


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

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

		$fdata["filterBy"] = 0;

	

	
	
//end of Filters settings


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

	
	
	
			

		$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"]["view"] = $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"]["edit"] = $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


	$tdatajudgescont2017["1styear"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "1styear";
//	transcripts
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 35;
	$fdata["strName"] = "transcripts";
	$fdata["GoodName"] = "transcripts";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","transcripts");
	$fdata["FieldType"] = 201;

	
	
	
			

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

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

		$fdata["DeleteAssociatedFile"] = true;

	
		$fdata["UploadCodeExpression"] = true;

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

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

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

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

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

	$edata = array("EditFormat" => "Document upload");

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


	
	



	
	
	
	
							$edata["acceptFileTypes"] = "bmp";
			$edata["acceptFileTypesHtml"] = ".bmp";
						$edata["acceptFileTypes"] .= "|doc";
			$edata["acceptFileTypesHtml"] .= ",.doc";
						$edata["acceptFileTypes"] .= "|docx";
			$edata["acceptFileTypesHtml"] .= ",.docx";
						$edata["acceptFileTypes"] .= "|gif";
			$edata["acceptFileTypesHtml"] .= ",.gif";
						$edata["acceptFileTypes"] .= "|jpe";
			$edata["acceptFileTypesHtml"] .= ",.jpe";
						$edata["acceptFileTypes"] .= "|jpeg";
			$edata["acceptFileTypesHtml"] .= ",.jpeg";
						$edata["acceptFileTypes"] .= "|jpg";
			$edata["acceptFileTypesHtml"] .= ",.jpg";
						$edata["acceptFileTypes"] .= "|pcx";
			$edata["acceptFileTypesHtml"] .= ",.pcx";
						$edata["acceptFileTypes"] .= "|pdf";
			$edata["acceptFileTypesHtml"] .= ",.pdf";
						$edata["acceptFileTypes"] .= "|png";
			$edata["acceptFileTypesHtml"] .= ",.png";
						$edata["acceptFileTypes"] .= "|rtf";
			$edata["acceptFileTypesHtml"] .= ",.rtf";
						$edata["acceptFileTypes"] .= "|txt";
			$edata["acceptFileTypesHtml"] .= ",.txt";
		$edata["acceptFileTypes"] = "(".$edata["acceptFileTypes"].")$";

		$edata["maxNumberOfFiles"] = 1;

		$edata["maxFileSize"] = 2800;

		$edata["maxTotalFilesSize"] = 5500;

	
	
	
	
		$edata["controlWidth"] = 200;

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

		$edata["CreateThumbnail"] = true;
	$edata["StrThumbnail"] = "th";
			$edata["ThumbnailSize"] = 150;

			
	
	
	
	$fdata["EditFormats"]["edit"] = $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


	$tdatajudgescont2017["transcripts"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "transcripts";
//	assessed
//	Custom field settings
	$fdata = array();
	$fdata["Index"] = 36;
	$fdata["strName"] = "assessed";
	$fdata["GoodName"] = "assessed";
	$fdata["ownerTable"] = "applicform";
	$fdata["Label"] = GetFieldLabel("judgescont2017","assessed");
	$fdata["FieldType"] = 3;

	
	
	
			

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

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

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

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

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

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

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

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

	$edata = array("EditFormat" => "Checkbox");

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


	
	



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

		$edata["maxNumberOfFiles"] = 1;

	
	
	
	
	
	
		$edata["controlWidth"] = 200;

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

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


	$fdata["isSeparate"] = false;




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

			// 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


	$tdatajudgescont2017["assessed"] = $fdata;
		$tdatajudgescont2017[".searchableFields"][] = "assessed";


$tables_data["judgescont2017"]=&$tdatajudgescont2017;
$field_labels["judgescont2017"] = &$fieldLabelsjudgescont2017;
$fieldToolTips["judgescont2017"] = &$fieldToolTipsjudgescont2017;
$placeHolders["judgescont2017"] = &$placeHoldersjudgescont2017;
$page_titles["judgescont2017"] = &$pageTitlesjudgescont2017;

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

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



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


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










function createSqlQuery_judgescont2017()
{
$proto3=array();
$proto3["m_strHead"] = "SELECT";
$proto3["m_strFieldList"] = "Surname,  FirstName,  StudentSchoolID,  MPGID,  MobileNoAppl,  Photo,  Documents,  Gender,  DateofBirth,  PlaceofBirth,  FatherDistrict,  MOTHERNAME,  MOTHERSURNAME,  MotherDistrict,  FATHERSNAME,  FATHERSURNAME,  TertiaryInstitutionAdmitted,  WitnessName,  WitnessAddress,  WitnessOccupation,  NewApplicant,  Reapply,  EmailAddrssAppl,  GPA,  approved1,  approved2,  approved3,  Judge1Comment,  Judge2Comment,  Judge3Comment,  LastInstitutuonAttended,  HighestGradeCompleted,  ProgramName,  `1styear`,  transcripts,  assessed";
$proto3["m_strFrom"] = "FROM applicform";
$proto3["m_strWhere"] = "(transcripts is not null) and (`1styear` <> 2018) AND (((gpa is not null) or (gpa <> 0)) is true) AND ((assessed is null) OR (assessed is false) is true) AND (`1styear` is not null) AND (((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))is true) AND (((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013)) is true)";
$proto3["m_strOrderBy"] = "ORDER BY TertiaryInstitutionAdmitted";
	
		;
			$proto3["cipherer"] = null;
$proto5=array();
$proto5["m_sql"] = "(transcripts is not null) and (`1styear` <> 2018) AND (((gpa is not null) or (gpa <> 0)) is true) AND ((assessed is null) OR (assessed is false) is true) AND (`1styear` is not null) AND (((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))is true) AND (((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013)) is true)";
$proto5["m_uniontype"] = "SQLL_AND";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(transcripts is not null) and (`1styear` <> 2018) AND (((gpa is not null) or (gpa <> 0)) is true) AND ((assessed is null) OR (assessed is false) is true) AND (`1styear` is not null) AND (((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))is true) AND (((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013)) is true)"
));

$proto5["m_column"]=$obj;
$proto5["m_contained"] = array();
						$proto7=array();
$proto7["m_sql"] = "transcripts is not null";
$proto7["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "transcripts",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto7["m_column"]=$obj;
$proto7["m_contained"] = array();
$proto7["m_strCase"] = "is not null";
$proto7["m_havingmode"] = false;
$proto7["m_inBrackets"] = true;
$proto7["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto7);

			$proto5["m_contained"][]=$obj;
						$proto9=array();
$proto9["m_sql"] = "`1styear` <> 2018";
$proto9["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

			$proto5["m_contained"][]=$obj;
						$proto11=array();
$proto11["m_sql"] = "((gpa is not null) or (gpa <> 0)) is true";
$proto11["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLNonParsed(array(
	"m_sql" => "((gpa is not null) or (gpa <> 0))"
));

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

			$proto5["m_contained"][]=$obj;
						$proto13=array();
$proto13["m_sql"] = "(assessed is null) OR (assessed is false) is true";
$proto13["m_uniontype"] = "SQLL_OR";
	$obj = new SQLNonParsed(array(
	"m_sql" => "(assessed is null) OR (assessed is false) is true"
));

$proto13["m_column"]=$obj;
$proto13["m_contained"] = array();
						$proto15=array();
$proto15["m_sql"] = "assessed is null";
$proto15["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "assessed",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

			$proto13["m_contained"][]=$obj;
						$proto17=array();
$proto17["m_sql"] = "(assessed is false) is true";
$proto17["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLNonParsed(array(
	"m_sql" => "(assessed is false)"
));

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

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

			$proto5["m_contained"][]=$obj;
						$proto19=array();
$proto19["m_sql"] = "`1styear` is not null";
$proto19["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto19["m_column"]=$obj;
$proto19["m_contained"] = array();
$proto19["m_strCase"] = "is not null";
$proto19["m_havingmode"] = false;
$proto19["m_inBrackets"] = true;
$proto19["m_useAlias"] = false;
$obj = new SQLLogicalExpr($proto19);

			$proto5["m_contained"][]=$obj;
						$proto21=array();
$proto21["m_sql"] = "((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))is true";
$proto21["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLNonParsed(array(
	"m_sql" => "((approved1 IS TRUE) AND (approved2 IS TRUE) AND (approved3 IS TRUE))"
));

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

			$proto5["m_contained"][]=$obj;
						$proto23=array();
$proto23["m_sql"] = "((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013)) is true";
$proto23["m_uniontype"] = "SQLL_UNKNOWN";
						$obj = new SQLNonParsed(array(
	"m_sql" => "((`1styear` = 2016) OR (`1styear` = 2015) OR (`1styear` = 2014) OR (`1styear` = 2013))"
));

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

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

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

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

$proto3["m_having"] = $obj;
$proto3["m_fieldlist"] = array();
						$proto27=array();
			$obj = new SQLField(array(
	"m_strName" => "Surname",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto29=array();
			$obj = new SQLField(array(
	"m_strName" => "FirstName",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto31=array();
			$obj = new SQLField(array(
	"m_strName" => "StudentSchoolID",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto31["m_sql"] = "StudentSchoolID";
$proto31["m_srcTableName"] = "judgescont2017";
$proto31["m_expr"]=$obj;
$proto31["m_alias"] = "";
$obj = new SQLFieldListItem($proto31);

$proto3["m_fieldlist"][]=$obj;
						$proto33=array();
			$obj = new SQLField(array(
	"m_strName" => "MPGID",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto33["m_sql"] = "MPGID";
$proto33["m_srcTableName"] = "judgescont2017";
$proto33["m_expr"]=$obj;
$proto33["m_alias"] = "";
$obj = new SQLFieldListItem($proto33);

$proto3["m_fieldlist"][]=$obj;
						$proto35=array();
			$obj = new SQLField(array(
	"m_strName" => "MobileNoAppl",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto35["m_sql"] = "MobileNoAppl";
$proto35["m_srcTableName"] = "judgescont2017";
$proto35["m_expr"]=$obj;
$proto35["m_alias"] = "";
$obj = new SQLFieldListItem($proto35);

$proto3["m_fieldlist"][]=$obj;
						$proto37=array();
			$obj = new SQLField(array(
	"m_strName" => "Photo",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto37["m_sql"] = "Photo";
$proto37["m_srcTableName"] = "judgescont2017";
$proto37["m_expr"]=$obj;
$proto37["m_alias"] = "";
$obj = new SQLFieldListItem($proto37);

$proto3["m_fieldlist"][]=$obj;
						$proto39=array();
			$obj = new SQLField(array(
	"m_strName" => "Documents",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto41=array();
			$obj = new SQLField(array(
	"m_strName" => "Gender",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto41["m_sql"] = "Gender";
$proto41["m_srcTableName"] = "judgescont2017";
$proto41["m_expr"]=$obj;
$proto41["m_alias"] = "";
$obj = new SQLFieldListItem($proto41);

$proto3["m_fieldlist"][]=$obj;
						$proto43=array();
			$obj = new SQLField(array(
	"m_strName" => "DateofBirth",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto43["m_sql"] = "DateofBirth";
$proto43["m_srcTableName"] = "judgescont2017";
$proto43["m_expr"]=$obj;
$proto43["m_alias"] = "";
$obj = new SQLFieldListItem($proto43);

$proto3["m_fieldlist"][]=$obj;
						$proto45=array();
			$obj = new SQLField(array(
	"m_strName" => "PlaceofBirth",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto45["m_sql"] = "PlaceofBirth";
$proto45["m_srcTableName"] = "judgescont2017";
$proto45["m_expr"]=$obj;
$proto45["m_alias"] = "";
$obj = new SQLFieldListItem($proto45);

$proto3["m_fieldlist"][]=$obj;
						$proto47=array();
			$obj = new SQLField(array(
	"m_strName" => "FatherDistrict",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto47["m_sql"] = "FatherDistrict";
$proto47["m_srcTableName"] = "judgescont2017";
$proto47["m_expr"]=$obj;
$proto47["m_alias"] = "";
$obj = new SQLFieldListItem($proto47);

$proto3["m_fieldlist"][]=$obj;
						$proto49=array();
			$obj = new SQLField(array(
	"m_strName" => "MOTHERNAME",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto49["m_sql"] = "MOTHERNAME";
$proto49["m_srcTableName"] = "judgescont2017";
$proto49["m_expr"]=$obj;
$proto49["m_alias"] = "";
$obj = new SQLFieldListItem($proto49);

$proto3["m_fieldlist"][]=$obj;
						$proto51=array();
			$obj = new SQLField(array(
	"m_strName" => "MOTHERSURNAME",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto51["m_sql"] = "MOTHERSURNAME";
$proto51["m_srcTableName"] = "judgescont2017";
$proto51["m_expr"]=$obj;
$proto51["m_alias"] = "";
$obj = new SQLFieldListItem($proto51);

$proto3["m_fieldlist"][]=$obj;
						$proto53=array();
			$obj = new SQLField(array(
	"m_strName" => "MotherDistrict",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto53["m_sql"] = "MotherDistrict";
$proto53["m_srcTableName"] = "judgescont2017";
$proto53["m_expr"]=$obj;
$proto53["m_alias"] = "";
$obj = new SQLFieldListItem($proto53);

$proto3["m_fieldlist"][]=$obj;
						$proto55=array();
			$obj = new SQLField(array(
	"m_strName" => "FATHERSNAME",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto55["m_sql"] = "FATHERSNAME";
$proto55["m_srcTableName"] = "judgescont2017";
$proto55["m_expr"]=$obj;
$proto55["m_alias"] = "";
$obj = new SQLFieldListItem($proto55);

$proto3["m_fieldlist"][]=$obj;
						$proto57=array();
			$obj = new SQLField(array(
	"m_strName" => "FATHERSURNAME",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto57["m_sql"] = "FATHERSURNAME";
$proto57["m_srcTableName"] = "judgescont2017";
$proto57["m_expr"]=$obj;
$proto57["m_alias"] = "";
$obj = new SQLFieldListItem($proto57);

$proto3["m_fieldlist"][]=$obj;
						$proto59=array();
			$obj = new SQLField(array(
	"m_strName" => "TertiaryInstitutionAdmitted",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto61=array();
			$obj = new SQLField(array(
	"m_strName" => "WitnessName",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto61["m_sql"] = "WitnessName";
$proto61["m_srcTableName"] = "judgescont2017";
$proto61["m_expr"]=$obj;
$proto61["m_alias"] = "";
$obj = new SQLFieldListItem($proto61);

$proto3["m_fieldlist"][]=$obj;
						$proto63=array();
			$obj = new SQLField(array(
	"m_strName" => "WitnessAddress",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto63["m_sql"] = "WitnessAddress";
$proto63["m_srcTableName"] = "judgescont2017";
$proto63["m_expr"]=$obj;
$proto63["m_alias"] = "";
$obj = new SQLFieldListItem($proto63);

$proto3["m_fieldlist"][]=$obj;
						$proto65=array();
			$obj = new SQLField(array(
	"m_strName" => "WitnessOccupation",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto65["m_sql"] = "WitnessOccupation";
$proto65["m_srcTableName"] = "judgescont2017";
$proto65["m_expr"]=$obj;
$proto65["m_alias"] = "";
$obj = new SQLFieldListItem($proto65);

$proto3["m_fieldlist"][]=$obj;
						$proto67=array();
			$obj = new SQLField(array(
	"m_strName" => "NewApplicant",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto69=array();
			$obj = new SQLField(array(
	"m_strName" => "Reapply",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto71=array();
			$obj = new SQLField(array(
	"m_strName" => "EmailAddrssAppl",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto71["m_sql"] = "EmailAddrssAppl";
$proto71["m_srcTableName"] = "judgescont2017";
$proto71["m_expr"]=$obj;
$proto71["m_alias"] = "";
$obj = new SQLFieldListItem($proto71);

$proto3["m_fieldlist"][]=$obj;
						$proto73=array();
			$obj = new SQLField(array(
	"m_strName" => "GPA",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto75=array();
			$obj = new SQLField(array(
	"m_strName" => "approved1",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto77=array();
			$obj = new SQLField(array(
	"m_strName" => "approved2",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto79=array();
			$obj = new SQLField(array(
	"m_strName" => "approved3",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto81=array();
			$obj = new SQLField(array(
	"m_strName" => "Judge1Comment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto81["m_sql"] = "Judge1Comment";
$proto81["m_srcTableName"] = "judgescont2017";
$proto81["m_expr"]=$obj;
$proto81["m_alias"] = "";
$obj = new SQLFieldListItem($proto81);

$proto3["m_fieldlist"][]=$obj;
						$proto83=array();
			$obj = new SQLField(array(
	"m_strName" => "Judge2Comment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto85=array();
			$obj = new SQLField(array(
	"m_strName" => "Judge3Comment",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto87=array();
			$obj = new SQLField(array(
	"m_strName" => "LastInstitutuonAttended",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto87["m_sql"] = "LastInstitutuonAttended";
$proto87["m_srcTableName"] = "judgescont2017";
$proto87["m_expr"]=$obj;
$proto87["m_alias"] = "";
$obj = new SQLFieldListItem($proto87);

$proto3["m_fieldlist"][]=$obj;
						$proto89=array();
			$obj = new SQLField(array(
	"m_strName" => "HighestGradeCompleted",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto89["m_sql"] = "HighestGradeCompleted";
$proto89["m_srcTableName"] = "judgescont2017";
$proto89["m_expr"]=$obj;
$proto89["m_alias"] = "";
$obj = new SQLFieldListItem($proto89);

$proto3["m_fieldlist"][]=$obj;
						$proto91=array();
			$obj = new SQLField(array(
	"m_strName" => "ProgramName",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto93=array();
			$obj = new SQLField(array(
	"m_strName" => "1styear",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_fieldlist"][]=$obj;
						$proto95=array();
			$obj = new SQLField(array(
	"m_strName" => "transcripts",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto95["m_sql"] = "transcripts";
$proto95["m_srcTableName"] = "judgescont2017";
$proto95["m_expr"]=$obj;
$proto95["m_alias"] = "";
$obj = new SQLFieldListItem($proto95);

$proto3["m_fieldlist"][]=$obj;
						$proto97=array();
			$obj = new SQLField(array(
	"m_strName" => "assessed",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

$proto97["m_sql"] = "assessed";
$proto97["m_srcTableName"] = "judgescont2017";
$proto97["m_expr"]=$obj;
$proto97["m_alias"] = "";
$obj = new SQLFieldListItem($proto97);

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

$proto99["m_table"] = $obj;
$proto99["m_sql"] = "applicform";
$proto99["m_alias"] = "";
$proto99["m_srcTableName"] = "judgescont2017";
$proto101=array();
$proto101["m_sql"] = "";
$proto101["m_uniontype"] = "SQLL_UNKNOWN";
	$obj = new SQLNonParsed(array(
	"m_sql" => ""
));

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

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

$proto3["m_fromlist"][]=$obj;
$proto3["m_groupby"] = array();
$proto3["m_orderby"] = array();
												$proto103=array();
						$obj = new SQLField(array(
	"m_strName" => "TertiaryInstitutionAdmitted",
	"m_strTable" => "applicform",
	"m_srcTableName" => "judgescont2017"
));

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

$proto3["m_orderby"][]=$obj;					
$proto3["m_srcTableName"]="judgescont2017";		
$obj = new SQLQuery($proto3);

	return $obj;
}
$queryData_judgescont2017 = createSqlQuery_judgescont2017();


	
		;

																																				

$tdatajudgescont2017[".sqlquery"] = $queryData_judgescont2017;

$tableEvents["judgescont2017"] = new eventsBase;
$tdatajudgescont2017[".hasEvents"] = false;

?>