{
	"keyColumn": "emp_main_id",
	"wildsearch": "true",
	"detailHeaderColumnPrefix": "Employees: ",
	"handleFile": "true",
	"detailHeaderColumns": ["emp_code"],
	"breadCrumbColumn": "emp_code",
	"orderBy": {
		"id": "DESC"
	},
	"relations": {
		"Leave Requests": {
			"name": "Leave",
			"section": "leavehradd",
			"child_table": "tbl_emp_leaves",
			"parent_join_column": "emp_main_id",
			"child_join_column": "emp_id"
		},
		"Attendance": {
			"name": "Attendance",
			"section": "attendanceadd",
			"child_table": "tbl_attendance",
			"parent_join_column": "emp_main_id",
			"child_join_column": "emp_id"
		},
		"Employee Qualifications": {
			"name": "Qualification",
			"section": "empqualifications",
			"child_table": "tbl_emp_qualifications",
			"parent_join_column": "emp_main_id",
			"child_join_column": "emp_id"
		},
		"Employee Certification": {
			"name": "Certification",
			"section": "empcertifications",
			"child_table": "tbl_emp_certifications",
			"parent_join_column": "emp_main_id",
			"child_join_column": "emp_id"
		},
		"Employee Job History": {
			"name": "Job History",
			"section": "empjobshistory",
			"child_table": "tbl_emp_jobhistory",
			"parent_join_column": "emp_main_id",
			"child_join_column": "emp_id"
		}
	},
	"listColumns": ["profile_pic", "emp_code", "first_name", "last_name", "department_id"],
	"showColumns": ["id", "emp_main_id", "profile_pic", "emp_code", "first_name", "last_name", "department_id", "designation_id", "reporting_id", "shift_id", "joining_date"],
	"detailColumns": ["id", "emp_code", "department_id", "designation_id", "reporting_id", "team_id", "first_name", "last_name", "gender", "dob", "religion", "blood_group", "marital_status", "family_details", "fathers_name", "paddress", "caddress", "phone", "mobile", "location", "official_mail", "yahoo_mail", "personal_mail", "technical_skills", "bank_name", "account_no", "pan_no", "pf_no", "initial_salary", "joining_date", "appriasal_date", "added_date", "relieving_date", "emergency_contact_name", "emergency_contact_phone", "active", "profile_pic"],
	"columns": {
		"id": {
			"name": "ID",
			"editoptions": {
				"type": "hidden"
			}
		},
		"emp_code": {
			"name": "EMP CODE",
			"searchable": "true",
			"sortable": "true"
		},
		"department_id": {
			"name": "DEPARTMENT",
			"searchable": "true",
			"sortable": "true",
			"external": "true",
			"externalOptions": {
				"externalTable": "tbl_departments",
				"externalColumn": "id",
				"externalShowColumn": "dep_name"
			}
		},
		"designation_id": {
			"name": "DESIGNATION",
			"searchable": "true",
			"sortable": "true",
			"external": "true",
			"externalOptions": {
				"externalTable": "tbl_designations",
				"externalColumn": "id",
				"externalShowColumn": "desig_name"
			}
		},
		"reporting_id": {
			"name": "REPORTING PERSON",
			"searchable": "true",
			"sortable": "true",
			"external": "true",
			"externalOptions": {
				"externalTable": "tbl_employee",
				"externalColumn": "emp_main_id",
				"externalShowColumn": "first_name"
			}
		},
		"team_id": {
			"name": "TEAM",
			"searchable": "true",
			"sortable": "true",
			"external": "true",
			"externalOptions": {
				"externalTable": "tbl_teams",
				"externalColumn": "id",
				"externalShowColumn": "title"
			}
		},
		"first_name": {
			"name": "FIRST NAME",
			"searchable": "true",
			"sortable": "true"
		},
		"last_name": {
			"name": "LAST NAME",
			"searchable": "true",
			"sortable": "true"
		},
		"gender": {
			"name": "Gender"
		},
		"dob": {
			"name": "DOB",
			"dbFormat": "date",
			"displayFormat": "Y/m/d"
		},
		"religion": {
			"name": "RELIGION"
		},
		"blood_group": {
			"name": "Status"
		},
		"marital_status": {
			"name": "Marital Status",
			"sortable": "true"
		},
		"family_details": {
			"name": "FAMILY DETAILS"
		},
		"fathers_name": {
			"name": "FATHER'S NAME"
		},
		"paddress": {
			"name": "PERMANENT ADDRESS"
		},
		"caddress": {
			"name": "CONTACT ADDRESS"
		},
		"phone": {
			"name": "PHONE"
		},
		"mobile": {
			"name": "MOBILE"
		},
		"location": {
			"name": "LOCATION"
		},
		"official_mail": {
			"name": "OFFICIAL EMAIL"
		},
		"yahoo_mail": {
			"name": "YAHOO EMAIL"
		},
		"personal_mail": {
			"name": "PERSONAL EMAIL"
		},
		"technical_skills": {
			"name": "TECHNICAL SKILLS"
		},
		"joining_date": {
			"name": "JOINEDDATE",
			"dbFormat": "date",
			"displayFormat": "Y/m/d"
		},
		"bank_name": {
			"name": "BANK NAME"
		},
		"account_no": {
			"name": "ACCOUNT NO"
		},
		"pan_no": {
			"name": "PAN NO"
		},
		"pf_no": {
			"name": "PF NO"
		},
		"initial_salary": {
			"name": "INITIAL SALARY"
		},
		"appriasal_date": {
			"name": "LAST APPRIASAL DATE",
			"dbFormat": "date",
			"displayFormat": "Y/m/d"
		},
		"added_date": {
			"name": "ADDEDDATE",
			"dbFormat": "date",
			"displayFormat": "Y-m-d"
		},
		"relieving_date": {
			"name": "RELIEVING DATE",
			"dbFormat": "date",
			"displayFormat": "Y/m/d"
		},
		"active": {
			"name": "Active"
		},
		"profile_pic": {
			"name": "PHOTO",
			"customColumn": "true",
			"customaction": "Cmshelper::getProfilePic",
			"editoptions": {
				"type": "file",
				"label": "PHOTO",
				"class": "file",
				"hint": "Upload file for this section"
			}
		},
		"emergency_contact_name": {
			"name": "Emergency Contact Name"
		},
		"emergency_contact_phone": {
			"name": "Emergency Contact Phone"
		}
	},
	"opertations": ["view"],
	"operationLabel": {
		"viewTitle": "ViewEmployeeDetails"
	}
}