<-------16/05/2024------> 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; alter table pay_trn_tsalary add column attendance_allowance double(13,2) default 0.00; <-------16/05/2024-------> Task: Loan and Allowance : - alter table pay_trn_tsalary add column loanadvance_amount double(13,2) default 0.00; <------21/05/2024------->Hariharan 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'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'ESS Portal' WHERE (`module_gid` = 'HRMEIM'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Employee Salary' WHERE (`module_gid` = 'PAYELMEMP'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Payment' WHERE (`module_gid` = 'PAYELMSPT'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Employee Bank' WHERE (`module_gid` = 'PAYMSTEBD'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Component Group ' WHERE (`module_gid` = 'PAYMSTGRP'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Components' WHERE (`module_gid` = 'PAYMSTSCT'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Salary Grade' WHERE (`module_gid` = 'PAYMSTSGT'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Employee to Salary' WHERE (`module_gid` = 'PAYMSTSTA'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Salary' WHERE (`module_gid` = 'PAYELM'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Loan' WHERE (`module_gid` = 'PAYLOM'); UPDATE `vcidex`.`adm_mst_Tmodule` SET `module_name` = 'Tax' WHERE (`module_gid` = 'PAYTAX'); Task: Loan and Allowance : - alter table pay_trn_tsalary add column loanadvance_amount double(13,2) default 0.00; 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; alter table pay_trn_tsalary add column attendance_allowance double(13,2) default 0.00; <------22/05/2024---->HariAnna(Angular-Payroll->Salary Component) ALTER TABLE pay_mst_tsalarycomponent ADD COLUMN source_variale longtext; ALTER TABLE pay_mst_tsalarycomponent ADD COLUMN formula_operator varchar(64) default null; ALTER TABLE pay_mst_tsalarycomponent ADD COLUMN formula_variable varchar(64) default null; <-------23/05/2024---->Hariharan(Framework-Payroll) delete from hrm_trn_tleavegrade2employee; delete from hrm_mst_tleavegradedtl; delete from hrm_mst_tleavetype; set sql_safe_updates=0; UPDATE `mootek`.`adm_mst_tcompany` SET `salary_startdate` = '2024-01-01' WHERE (`company_gid` = '1'); UPDATE `mootek`.`adm_mst_tcompany` SET `salary_startdate` = '2024-01-01' WHERE (`company_gid` = '1'); /* -- Query: select * from adm_mst_terror where error_code='PAY_SUC_700' -- Date: 2024-05-23 09:46 */ INSERT INTO `adm_mst_terror` (`error_gid`,`error_code`,`error_message`,`error_type`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('PAY2014103000025','PAY_SUC_1116','Loan Updated Successfully','SUCCESS',NULL,NULL,NULL,NULL); drop table pay_trn_tloan; CREATE TABLE `pay_trn_tloan` ( `loan_gid` varchar(45) NOT NULL DEFAULT '', `employee_gid` varchar(45) DEFAULT NULL, `loan_amount` double DEFAULT NULL, `loan_duration` int(11) DEFAULT NULL, `loan_repayment_startfrom` datetime DEFAULT NULL, `loan_remarks` text, `created_by` varchar(45) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `loan_refno` varchar(45) DEFAULT NULL, `type` varchar(45) DEFAULT NULL, `loan_id` varchar(64) DEFAULT NULL, `loan_status` varchar(15) DEFAULT NULL, `loanapproval_remarks` varchar(128) DEFAULT NULL, `grade_name` varchar(64) DEFAULT NULL, `net_salary` float(13,3) DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, `payment_mode` varchar(64) DEFAULT NULL, `deposit_bank` varchar(64) DEFAULT NULL, `cheque_no` varchar(64) DEFAULT NULL, `bank_name` varchar(64) DEFAULT NULL, `branch_name` varchar(64) DEFAULT NULL, `payment_date` date DEFAULT NULL, `transactionref_no` varchar(64) DEFAULT NULL, `bank_gid` varchar(64) DEFAULT NULL, `paid_Amount` float(13,2) DEFAULT NULL, `balance_amount` float(13,2) DEFAULT NULL, `repayment_amount` varchar(64) DEFAULT NULL, PRIMARY KEY (`loan_gid`), KEY `employee_gid` (`employee_gid`), KEY `loan_amount` (`loan_amount`), KEY `loan_repayment_startfrom` (`loan_repayment_startfrom`), KEY `loan_refno` (`loan_refno`), KEY `type` (`type`) ); drop table pay_trn_tloanrepayment; CREATE TABLE `pay_trn_tloanrepayment` ( `repayment_gid` varchar(45) NOT NULL DEFAULT '', `loan_gid` varchar(45) DEFAULT NULL, `repayment_duration` date DEFAULT NULL, `repayment_amount` double DEFAULT NULL, `actual_date` datetime DEFAULT NULL, `repaid_amount` double DEFAULT NULL, `repayment_remarks` text, `created_by` varchar(45) DEFAULT NULL, `created_date` datetime DEFAULT NULL, `type` varchar(45) DEFAULT NULL, `skip_flag` char(2) NOT NULL DEFAULT 'N', `split_flag` char(2) NOT NULL DEFAULT 'N', `skip_date` datetime DEFAULT NULL, `split_date` datetime DEFAULT NULL, `updated_by` varchar(64) DEFAULT NULL, `updated_date` datetime DEFAULT NULL, PRIMARY KEY (`repayment_gid`), KEY `loan_gid` (`loan_gid`), KEY `type` (`type`) );