Majic Definition for Client (HCL-COMNET)

Contents of h_majic.sch

h_majic.mod


OBJECT pcat
{
	ATTRIBUTES Prob_Category
	{
		code	zcode	STRING REQUIRED;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "code,sym";
			FETCH "code,description";
			WHERE "delete_flag = 0";
		};
		REL_ATTR persistent_id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};

OBJECT tcat
{
	ATTRIBUTES Trouble_Code
	{
		code	zcode	STRING REQUIRED;
	};
};
OBJECT zmanufacturer
{
	ATTRIBUTES zManufacturer
	{
		sym		STRING REQUIRED;
		code		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED {ON_NEW DEFAULT 0;};
		location	loc_id	SREL loc;
		description	desc	STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT grc
{
	ATTRIBUTES General_Resource_Class
	{
		technology	ztech	SREL ztech;
		manufacturer_id	zmfr_id	SREL zmanufacturer;
		part_number	zpart_no	STRING;
	};
};
OBJECT nr
{
	ATTRIBUTES Network_Resource
	{
		code	zcode	STRING REQUIRED;
		classification	zclsftn	SREL zclassification;
		issue_date_to_cso	ziss_date_cso	DATE;
		return_date_to_com	zret_date_com	DATE;
	};
};
OBJECT nr_com
{
	ATTRIBUTES NR_Comment
	{
		delete_flag	zdel	SREL actbool REQUIRED {ON_NEW DEFAULT 0;};
		installation_date	zinst_date	DATE;
		failure_date	zfail_date	DATE;
		consignee	zconsignee	SREL cst;
		last_repaired_by	zrp_by_id	SREL agt;
		reason	zreason	STRING;
	};
};
OBJECT cr
{
	ATTRIBUTES Call_Req
	{
		installation	zinst_id	SREL zinst_demo;
		contact_type	zct_type_id	SREL ctp;

		caller	zcaller	STRING;
		old_serial_number	zold_srl_num	STRING;

		conveyance_expense	zconv_exp	STRING;
		tour_expense	ztour_exp	STRING;
		purchase_expense	zpurc_exp	STRING;
		other_expense	zothr_exp	STRING;
		start_date	zstart_date	DATE;
		arrival_date	zarriv_date	DATE;
		departure_date	zdepart_date	DATE;
		return_date	zreturn_date	DATE;

		call_report_date	zcall_report_date	DATE;
		call_end_date	zcall_end_date	DATE;

		travel_from	ztravel_from	STRING;
		travel_to	ztravel_to	STRING;
		travel_time	ztravel_time	DURATION { ON_NEW DEFAULT 0 ;};

		down_time	zdown_time	DURATION;
		accounted_down_time	zacc_down_time	DURATION;
		reason	zreason	STRING;
		zstatus	SREL zstatus;

		response_time	zresponse_time	DURATION;
		engineer_remarks	zce_remarks	STRING;
		manager_remarks	zmanager_remarks	STRING;
		customer_remarks	zcst_remarks	STRING;
		solve_mode	zsolve_mode_id	SREL zsolve_mode;
		registered	zregistered	SREL bool REQUIRED { ON_NEW DEFAULT 1; };

		spare	zproduct_code	SREL nr;
		zaction	STRING;
		payment_mode	zpayment_mode_id	SREL zpayment_mode;
		cheque_number	zcheque_number	STRING;
		cheque_date	zcheque_date	DATE;
		amount	zamt	STRING;
		amount_for	zamt_for	STRING;

		number_of_reminders	znum_rem	INTEGER;
		date_of_first_reminder	zrem1_date	DATE;
		date_of_second_reminder	zrem2_date	DATE;
		date_of_third_reminder	zrem3_date	DATE;
		reminder_description	zrem_desc	STRING;

		repiar_code	zrepair_code_id	SREL zrepair_code;
		spare_replaced_date	zspare_repl_date	DATE;
		ccr_number	zccr_no	STRING;
	};
	TRIGGERS
	{
		POST_CI val_fieldupdate_site(persistent_id, audit_userid, installation, contact_type, caller, old_serial_number, origin, conveyance_expense, tour_expense, purchase_expense, other_expense, start_date, arrival_date, departure_date, return_date, call_report_date, call_end_date, travel_from, travel_to, travel_time, down_time, accounted_down_time, reason, zstatus, response_time, engineer_remarks, manager_remarks, customer_remarks, solve_mode, registered, spare, zaction, payment_mode, cheque_number, cheque_date, amount, amount_for, number_of_reminders, date_of_first_reminder, date_of_second_reminder, date_of_third_reminder, date_of_fourth_reminder, reminder_description, repiar_code, spare_replaced_date,ccr_number) 40 ;
	};
};
OBJECT loc
{
	ATTRIBUTES Location
	{
		l_country		STRING {ON_NEW DEFAULT "India"; };
		zrcity_id		SREL zrcity;
	};
};
MODIFY cnt contact_num REQUIRED;
MODIFY cnt timezone {ON_NEW DEFAULT "GMT+0530";};

OBJECT cnt
{
	ATTRIBUTES Contact
	{
// Commmon fields
		contact_person	zcontact	STRING;
		phone_number2	c_public_phone	STRING;
		designation	zdesg_id	SREL zdesignation;
// Common for Customer and Employee
		area_office	zarea_id	SREL zarea_office {ON_NEW DEFAULT ""; };
// Customer
		line_of_business	zlob	SREL zlob;
		technology	ztech	SREL ztech;
// Consignee
		vsat_id	zvsat_id	STRING {ON_NEW DEFAULT ""; };
		city	zcity_id	SREL zcity {ON_NEW DEFAULT ""; };
		installation_detail	zinst_id	SREL zinst_demo;
		parent_customer	zparent_cst	SREL cst_parent {ON_NEW DEFAULT ""; };
// Employee
		joining_date	zjoin_date	DATE;
		posting_date	zpost_date	DATE;
		hirearchy_structure	zhier_struc	STRING;
		skill	zskill_id	SREL zskill;
		direct	c_nx_string1	STRING;
		indirect	c_nx_string2	STRING;
		in_absence	c_nx_string3	STRING;
		specializations	c_nx_string4	STRING;
		concept_of_team	c_nx_string5	STRING;
		job_responsibility	c_nx_string6	STRING;
		qualifications	zqual	SREL zqualifications;
		previous_experience	zprev_exp	STRING 20;
		current_experience	zcurr_exp	STRING 20;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "combo_name = last_name + first_name + middle_name, phone_number, vsat_id, contact_num, organization, location";
			WHERE "delete_flag = 0";
			MLIST OFF;
			RLIST OFF;
		};
		RESTRICT "alias = -1" { alias = -1 };
		REL_ATTR id;
		COMMON_NAME combo_name;
		FUNCTION_GROUP "inventory";
	};
	FACTORY cst_parent
	{
		RESTRICT "type = 2309 AND alias = -1" { type = 2309, alias = -1} ;
		DOMSET cst_parent_list "combo_name = last_name + first_name + middle_name, phone_number, contact_num, organization, location" "" DYNAMIC;
		STANDARD_LISTS
		{
			SORT_BY "combo_name = last_name + first_name + middle_name, phone_number, contact_num, organization, location";
			WHERE "delete_flag = 0";
			MLIST OFF;
			RLIST OFF;
		};
		REL_ATTR id;
		COMMON_NAME combo_name;
		FUNCTION_GROUP "inventory";
	};
};
OBJECT zclassification
{
	ATTRIBUTES zClassification
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED {ON_NEW DEFAULT 0;};
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zqualifications
{
	ATTRIBUTES zQualifications
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED {ON_NEW DEFAULT 0;};
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zskill
{
	ATTRIBUTES zSkill
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		enum		INTEGER REQUIRED;
		sym		STRING;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "enum";
			FETCH "sym";
		};
		REL_ATTR enum;
		FUNCTION_GROUP "admin";
	};
};
OBJECT zlob
{
	ATTRIBUTES zLine_Of_Business
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED {ON_NEW DEFAULT 0;};
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT ztech
{
	ATTRIBUTES zTechnology
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zstatus
{
	ATTRIBUTES zStatus
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zdesignation
{
	ATTRIBUTES zDesignation
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zcat
{
	ATTRIBUTES zCategory
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zstation
{
	ATTRIBUTES zStation
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zrepair_code
{
	ATTRIBUTES zRepair_Code
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zsolve_mode
{
	ATTRIBUTES zSolve_Mode
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zpayment_mode
{
	ATTRIBUTES zPayment_Mode
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zrcity
{
	ATTRIBUTES zRCity
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		sym		STRING REQUIRED;
		state SREL zstate;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zcity
{
	ATTRIBUTES zCity
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		code		STRING REQUIRED;
		sym		STRING REQUIRED;
		location		SREL loc;
		area_id		SREL zarea_office REQUIRED;
		station		SREL zstation REQUIRED;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zregion
{
	ATTRIBUTES zRegion
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		sym		STRING REQUIRED;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zregion_office
{
	ATTRIBUTES zRegion_Office
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		code		STRING REQUIRED;
		sym		STRING REQUIRED;
		location		SREL loc;
		contact_name		STRING;
		designation		SREL zdesignation;
		office_name		SREL zrcity;
		region		SREL zregion;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zarea_office
{
	ATTRIBUTES zArea_Office
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		code		STRING REQUIRED;
		sym		STRING REQUIRED;
		location		SREL loc;
		ro_id		SREL zregion_office;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zstate
{
	ATTRIBUTES zState
	{
		sym		STRING REQUIRED;
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zmonth
{
	ATTRIBUTES zMonth
	{
		delete_flag	del	INTEGER REQUIRED { ON_NEW DEFAULT 0 ; };
		enum		INTEGER;
		sym		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "enum";
			FETCH "sym";
		};
		REL_ATTR enum;
		FUNCTION_GROUP "admin";
	};
};
OBJECT zinst_demo
{
	ATTRIBUTES zInstallation_Demonstration
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		sym		STRING REQUIRED;
		consignee		SREL cst WRITE_NEW REQUIRED;
		log_agent		SREL cnt WRITE_NEW REQUIRED {ON_NEW DEFAULT USER; };
		category		SREL zcat REQUIRED;
		exp_date		DATE;
		readiness		SREL bool {ON_NEW DEFAULT 1; };
		re_site_srvy_date		DATE;
		why_not_ready		STRING;
		tnt_srvy_date		DATE REQUIRED;
		act_srvy_date		DATE;
		tnt_inst_date		DATE REQUIRED;
		act_inst_date		DATE;
		tnt_sint_date		DATE REQUIRED;
		act_sint_date		DATE;
		tnt_actv_date		DATE REQUIRED;
		act_actv_date		DATE;
		demo		INTEGER;
		sys_intg_req		INTEGER;
		total_time_provided	ttl_tm_prvd	INTEGER;
		amc_amount	amc_amt	INTEGER;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "sym,id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		COMMON_NAME sym;
		FUNCTION_GROUP "reference";
	};
};
OBJECT zeng_att
{
	ATTRIBUTES zEngineer_Attendance
	{
		delete_flag	del	SREL actbool REQUIRED { ON_NEW DEFAULT 0; };
		log_agent		SREL cnt WRITE_NEW REQUIRED {ON_NEW DEFAULT USER; };
		engineer		SREL agt WRITE_NEW REQUIRED;
		month		DATE REQUIRED;
		wrkng_days		INTEGER REQUIRED;
		in_prsnt_days		INTEGER REQUIRED;
		out_prsnt_days		INTEGER REQUIRED;
		desc		STRING;
	};
	FACTORY
	{
		STANDARD_LISTS
		{
			SORT_BY "id";
			WHERE "delete_flag = 0";
		};
		REL_ATTR id;
		FUNCTION_GROUP "reference";
	};
};