CREATE TABLE `hrm_trn_temployeeuploadexcellog` (
`uploadexcellog_gid` varchar(64) NOT NULL,
`uploaded_by` varchar(45) DEFAULT NULL,
`uploaded_date` datetime DEFAULT NULL,
`fileextenssion` varchar(45) DEFAULT NULL,
`importcount` int(11) DEFAULT NULL,
PRIMARY KEY (`uploadexcellog_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
<-------16/05/2024------>Komathi
Task : Attendance allowance and Integration:-
alter table hrm_mst_tattendanceconfig add column attendance_allowanceflag varchar(1) default 'N';
alter table hrm_mst_tattendanceconfig add column allowed_leave varchar(3) default '0';
alter table hrm_mst_tattendanceconfig add column allowance_amount double(13,2) default 0.00;
<------28/05/2024------>
alter table adm_mst_tentity modify column created_date datetime default null;
alter table adm_mst_tentity modify column updated_date datetime default null;
ALTER TABLE adm_mst_tentity ADD COLUMN entity_prefix VARCHAR(64) DEFAULT NULL AFTER entity_code;
31/05/2024
<-- Asset List -->PradeepRaj
alter table hrm_mst_temployeeassetlist
add asset_count varchar(255);
alter table hrm_mst_temployeeassetlist
add created_by varchar(255);
alter table hrm_mst_temployeeassetlist
add created_date datetime;
alter table hrm_mst_temployeeassetlist
add assigned_count varchar(255);
alter table hrm_mst_temployeeassetlist
add available_count varchar(255);
alter table hrm_mst_temployeeassetlist
add updated_date datetime;
alter table hrm_mst_temployeeassetlist
add updated_by varchar(255);
/*
-- Query: select * from adm_mst_ttemplate where template_gid='TMPL2405130003'
LIMIT 0, 1000
-- Date: 2024-06-15 15:03
*/
INSERT INTO `` (`template_gid`,`template_name`,`templatetype_gid`,`template_content`,`created_by`,`created_on`,`updated_by`,`updated_date`,`template_path`) VALUES ('TMPL2405130003','Relieving Letter New','4',' Dear username,
\n Your request is hereby accepted and you are relieved from the services of the company by the closing hours of Currentdate.
\n We wish to place on record that you had been under the employment of Vcidex Solutions Pvt Ltd since Dateofjoining with the current position as Senior Software Engineer.
\n We thank you for your contribution to the Company and wish you all success in your future endeavors.
With Best Wishes,
\n For Vcidex Solutions Pvt Ltd.,
\n
\n
\n
\n Authorized Signatory
','SUSM1709250002','2018-08-03 11:10:58','U1','2024-05-09 15:21:33',NULL);
/*
-- Query: select * from adm_mst_ttemplate where template_name='Experiencetem'
LIMIT 0, 1000
-- Date: 2024-06-15 15:01
*/
INSERT INTO `` (`template_gid`,`template_name`,`templatetype_gid`,`template_content`,`created_by`,`created_on`,`updated_by`,`updated_date`,`template_path`) VALUES ('TMPL240427878','Experiencetem','1','
This is to certify that Mr.first_name-Designation had been working with us in
our organization from Joiningdate to Relieving date, during his stay with us we
found intellectual and committed in his work.
We at Vcidex Solutions Private limited wish all success in his future endeavors
For Vcidex Solutions Pvt Ltd.,
Authorized Signatory
','U1','2024-04-26 17:04:19','U1','2024-06-15 11:22:43',NULL);
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Holiday Grade' WHERE (`module_gid` = 'HRMCFGHOG');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Leave Grade' WHERE (`module_gid` = 'HRMCFGLEG');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Employee' WHERE (`module_gid` = 'HRMOFLADM');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Probation Period' WHERE (`module_gid` = 'HRMOFLMGT');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Time Regulation' WHERE (`module_gid` = 'HRMREMATT');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Role' WHERE (`module_gid` = 'HRMROLSUM');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Shift Type' WHERE (`module_gid` = 'HRMSFTSTM');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Attendance' WHERE (`module_gid` = 'HRMATN');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Leave' WHERE (`module_gid` = 'HRMLEV');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Regulation' WHERE (`module_gid` = 'HRMREM');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Role' WHERE (`module_gid` = 'HRMROL');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Shift' WHERE (`module_gid` = 'HRMSFT');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Employee OnBoard' WHERE (`module_gid` = 'HRMOFL');
UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Recruitment' WHERE (`module_gid` = 'HRMREC');
<25/06/2024>-----Prithika
UPDATE `vcidex`.`adm_mst_tmodule` SET `lw_flag` = 'Y', `sref` = '/hrm/HrmMstExpenseclaim' WHERE (`module_gid` = 'HRMCLMCEX');
<12/09/2024>Bharathi
ALTER TABLE hrm_mst_tbranch ADD status CHAR(2) NOT NULL DEFAULT 'Y';
17/09/2024--Bharathi
CREATE TABLE `hrm_trn_temployeeuploadexcelerrorlog` (
`uploaderrorlog_gid` varchar(64) NOT NULL,
`uploadexcellog_gid` varchar(64) NOT NULL,
`remarks` varchar(245) DEFAULT NULL,
`first_name` varchar(64) NOT NULL,
`last_name` varchar(64) NOT NULL,
`user_code` varchar(64) NOT NULL,
`created_by` varchar(64) DEFAULT NULL,
`created_date` datetime DEFAULT NULL,
PRIMARY KEY (`uploaderrorlog_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
[10:03 AM] Bharathi S
ALTER TABLE hrm_mst_tdepartment ADD status CHAR(2) NOT NULL DEFAULT 'Y';
[10:03 AM] Bharathi S
ALTER TABLE hrm_mst_tbranch ADD status CHAR(2) NOT NULL DEFAULT 'Y';
27/09/2024--Pradeep raj
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) VALUES ('HRMAPP','HRM','HRMAPP',114,'ems_hrm/hr_transaction.aspx#',2,2,'Performance Management','1','','','','Performance Management','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) VALUES ('HRMAPPMNG','HRMAPP','HRMAPPMNG',100,'ems_hrm/hrm_trn_appraisalmanagement.aspx',3,3,'Appraisal Management','1','','','','Appraisal Management','','','','N','Y',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) VALUES ('HRMHSTDPD','HRMAPP','HRMHSTDPD',104,'ems_hrm/hrm_trn_depromotedetailssummary.aspx',3,NULL,'Depromote Details','1','','','','Depromote Details','','','','N','N',NULL,NULL,NULL,NULL,'Y','/hrm/HrmTrnDepromotedetailssummary',NULL,NULL,NULL);
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) VALUES ('HRMEIMPRM','HRMAPP','HRMEIMPRM',103,'ems_hrm/hrm_trn_promotionsummary.aspx',3,3,'Promotion Management','1','../images/ico_promotion_RS.gif','COMPANY POLICY','','Promotion Management','','','','N','Y',NULL,NULL,NULL,NULL,'Y','/hrm/HrmTrnPromotionsummary',NULL,NULL,NULL);
INSERT INTO `adm_mst_tsequence` (`sequence_gid`,`sequence_code`,`sequence_name`,`sequence_format`,`sequence_curval`,`sequence_flag`,`branch_flag`,`department_flag`,`year_flag`,`month_flag`,`location_flag`,`company_code`,`delimeter`,`runningno_prefix`,`finyear`,`carry_forward`,`created_by`,`created_date`,`updated_by`,`updated_date`,`product_flag`,`section_flag`,`block_flag`,`unit_flag`) VALUES ('HREM2405090237','HREM','Appraisal2Employee','4','0','N','N','N','N','','N','','','','2024','N',NULL,NULL,NULL,NULL,'Y','Y','Y','Y');