Alter Query(16-08-2024):

alter table adm_mst_tcompany add column payrun_dateflag char(2) default 'N';
<------22/05/2024---->HariAnna(Angular-Payroll->Salary Component)

alter table pay_trn_tsalary add column attendance_allowance double(13,2) default 0.00;
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;
Task: Loan and Allowance : -
alter table pay_trn_tsalary add column loanadvance_amount double(13,2) default 0.00;

<------27/05/2024----->Hariharan
Task- Monthly Payrun -Designation insert
alter table  pay_trn_tsalary add column designation_gid varchar(64) default null;
alter table  pay_trn_tsalary add column designation_name varchar(64) default null;
<------29/05/2024----->Alagu
alter table pay_trn_tsalary add column branch_gid varchar(64) default null;
alter table pay_trn_tsalary add column branch_name varchar(64) default null;
 
alter table pay_trn_tsalary add column department_name varchar(64) default null;
alter table pay_trn_tsalary add column department_gid varchar(64) default null;

<--------2024-05-23------->Hariharan
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`)
);
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`)
);
<------23/05/2024------>Hariharan
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);
<-----29/05/2024------>Alagu
Payroll t-module Scripts for Statutory Management:
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 ('PAYSTMfFM','PAYSTM','PAYSTMFRM',101,'ems_payroll/pay_trn_pfform.aspx',3,NULL,'Form 5&10','1','','','','Form 5&10','','','','N','N',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 ('PAYSTMPFM','PAYSTM','PAYSTMPFM',100,'ems_payroll/pay_trn_pfmanagement.aspx',3,NULL,'PF Management','1','','','','PF Management','','','','N','N',NULL,NULL,NULL,NULL,'Y',NULL,NULL,NULL,NULL);
<------21/05/2024------->Hariharan
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');
<-------23/05/2024---->Hariharan(Framework-Payroll)
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');

<-----29/05/2024------>Alagu
UPDATE `vcidex`.`adm_mst_tmoduleangular` SET `sref` = '/payroll/PayTrnPfmanagement' WHERE (`module_gid` = 'PAYSTMPFM');

UPDATE `vcidex`.`adm_mst_tmoduleangular` SET `sref` = '/payroll/form5&10' WHERE (`module_gid` = 'PAYSTMfFM');

02/09/2024-Ramalakshmi
alter table pay_mst_pfwithdrawalreason add column created_by varchar(64) default null;
alter table pay_mst_pfwithdrawalreason add column created_date datetime default null;

alter table pay_tmp_tpaytemp add column created_by varchar(64) default null;
alter table pay_tmp_tpaytemp add column created_date datetime default null;

alter table pay_trn_pfwithdrawaldetail add column created_by varchar(64) default null;
alter table pay_trn_pfwithdrawaldetail add column created_date datetime default null;

alter table pay_trn_tconsolidatedtailor add column created_by varchar(64) default null;
alter table pay_trn_tconsolidatedtailor add column created_date datetime default null;

alter table pay_trn_tform15dtl add column created_by varchar(64) default null;
alter table pay_trn_tform15dtl add column created_date datetime default null;

alter table pay_trn_ttailorsproduction add column created_by varchar(64) default null;
alter table pay_trn_ttailorsproduction add column created_date datetime default null;

alter table pay_rpt_salaryreport_v add column created_by varchar(64) default null;
alter table pay_rpt_salaryreport_v add column created_date datetime default null;

alter table pay_mst_tassignemployee2nonmanagement add column updated_by varchar(64) default null;
alter table pay_mst_tassignemployee2nonmanagement add column updated_date datetime default null;

alter table pay_mst_tassignemployee2wages add column updated_by varchar(64) default null;
alter table pay_mst_tassignemployee2wages add column updated_date datetime default null;

alter table pay_mst_tassigntemplate2monthlywageemployee add column updated_by varchar(64) default null;
alter table pay_mst_tassigntemplate2monthlywageemployee add column updated_date datetime default null;

alter table pay_mst_tmedicalexpense add column updated_by varchar(64) default null;
alter table pay_mst_tmedicalexpense add column updated_date datetime default null;

alter table pay_mst_tmonthlywagestemplate add column updated_by varchar(64) default null;
alter table pay_mst_tmonthlywagestemplate add column updated_date datetime default null;

alter table pay_mst_tnonmanagementwageassign2employee add column updated_by varchar(64) default null;
alter table pay_mst_tnonmanagementwageassign2employee add column updated_date datetime default null;

alter table pay_mst_tnonmanagementwagestemplate add column updated_by varchar(64) default null;
alter table pay_mst_tnonmanagementwagestemplate add column updated_date datetime default null;

alter table pay_mst_twagesassign2employee add column updated_by varchar(64) default null;
alter table pay_mst_twagesassign2employee add column updated_date datetime default null;

alter table pay_tmp_tpaytemp add column updated_by varchar(64) default null;
alter table pay_tmp_tpaytemp add column updated_date datetime default null;

alter table pay_mst_pfwithdrawalreason add column updated_by varchar(64) default null;
alter table pay_mst_pfwithdrawalreason add column updated_date datetime default null;

alter table pay_mst_tadditiondeduction add column updated_by varchar(64) default null;
alter table pay_mst_tadditiondeduction add column updated_date datetime default null;

alter table pay_tmp_tweeklyconsolidated add column updated_by varchar(64) default null;
alter table pay_tmp_tweeklyconsolidated add column updated_date datetime default null;

alter table pay_trn_pfwithdrawaldetail add column updated_by varchar(64) default null;
alter table pay_trn_pfwithdrawaldetail add column updated_date datetime default null;

alter table pay_trn_productiontailor add column updated_by varchar(64) default null;
alter table pay_trn_productiontailor add column updated_date datetime default null;

alter table pay_trn_productiontailor1 add column updated_by varchar(64) default null;
alter table pay_trn_productiontailor1 add column updated_date datetime default null;

alter table pay_trn_productiontailor2 add column updated_by varchar(64) default null;
alter table pay_trn_productiontailor2 add column updated_date datetime default null;

alter table pay_trn_tconsolidatedtailor add column updated_by varchar(64) default null;
alter table pay_trn_tconsolidatedtailor add column updated_date datetime default null;

alter table pay_trn_texitpfservice add column updated_by varchar(64) default null;
alter table pay_trn_texitpfservice add column updated_date datetime default null;

alter table pay_trn_tform15dtl add column updated_by varchar(64) default null;
alter table pay_trn_tform15dtl add column updated_date datetime default null;

alter table pay_trn_tmonthlywagesgroup add column updated_by varchar(64) default null;
alter table pay_trn_tmonthlywagesgroup add column updated_date datetime default null;

alter table pay_trn_tmonthlywagespayrun add column updated_by varchar(64) default null;
alter table pay_trn_tmonthlywagespayrun add column updated_date datetime default null;

alter table pay_trn_tmonthlywagespayrundtl add column updated_by varchar(64) default null;
alter table pay_trn_tmonthlywagespayrundtl add column updated_date datetime default null;

alter table pay_trn_tmonthlywagespayrunbatch add column updated_by varchar(64) default null;
alter table pay_trn_tmonthlywagespayrunbatch add column updated_date datetime default null;

alter table pay_trn_ttailorsalary add column updated_by varchar(64) default null;
alter table pay_trn_ttailorsalary add column updated_date datetime default null;

alter table pay_trn_ttailorspayrun add column updated_by varchar(64) default null;
alter table pay_trn_ttailorspayrun add column updated_date datetime default null;

alter table pay_trn_ttailorsproduction add column updated_by varchar(64) default null;
alter table pay_trn_ttailorsproduction add column updated_date datetime default null;

alter table pay_trn_ttaxdocument add column updated_by varchar(64) default null;
alter table pay_trn_ttaxdocument add column updated_date datetime default null;

alter table pay_trn_twagesgroup add column updated_by varchar(64) default null;
alter table pay_trn_twagesgroup add column updated_date datetime default null;

alter table pay_trn_twagesgroupdtl add column updated_by varchar(64) default null;
alter table pay_trn_twagesgroupdtl add column updated_date datetime default null;

alter table pay_trn_twagespayrunbatch add column updated_by varchar(64) default null;
alter table pay_trn_twagespayrunbatch add column updated_date datetime default null;

alter table pay_trn_twagespayrun add column updated_by varchar(64) default null;
alter table pay_trn_twagespayrun add column updated_date datetime default null;

alter table pay_trn_twagespayrundtl add column updated_by varchar(64) default null;
alter table pay_trn_twagespayrundtl add column updated_date datetime default null;

alter table pay_rpt_salaryreport_v add column updated_by varchar(64) default null;
alter table pay_rpt_salaryreport_v add column updated_date datetime default null;

11/09/2024-Alagu

Alter Query(Payroll):

alter table pay_trn_tsalarydtl add column statutory_flag varchar(1) default 'N';

24/09/2024--Alagu Ramalakshmi

alter table pay_mst_tsalarycomponent add column account_name varchar(64) after account_gid;


alter table hrm_mst_tdepartment add column account_gid varchar(64) after regional_departmentname, add column account_name varchar(64) after account_gid;