{
	"name": "query/manager/resource/capacity/resource_effeciency.json",
	"table": [
		{
			"record_type": [""],
			"table": "capacity"
		}
	],
	"parameter": {
		"end_date": "",
		"person": [""],
		"record_state": 0,
		"show_sql": false,
		"start_date": ""
	},
	"order": [
		"reff.person_id",
		">",
		"reff.resource_id",
		">",
		"reff.start_time",
		"<",
		"reff.end_time",
		">",
		"reff.record_id",
		">"
	],
	"query": [
		["reff.resource_effeciency_state", ">=", "record_state"],
		"and",
		["reff.end_time", ">=", "start_date"],
		"and",
		["reff.start_time", "<", "end_date"]
	],
	"query_not_in_use": ["and", ["reff.person_id", "in", "person"]]
}