Folder File Name

menu DM_RETAIL_IG_MENU
Privilege CONFIG_DATA
calibration DM_RETAIL_HR_CREATE_CALIBRATION_HEADER_OVERALL_RATING
calibration DM_RETAIL_HR_CREATE_CALIBRATION_LIST
Bonus DM_RETAIL_HR_GET_PCMRATING
Images DM_RETAIL_HR_CODELIST
CompanyLeave UPDATE_COMPANYLEAVE_TABLE
Ticketing UPDATE_TICKET_OWNER
 Type Update / New
Table data insert NEW
Table data insert NEW
SP UPDATE
SP UPDATE
SP UPDATE
SP UPDATE
SP UPDATE
Table data insert UPDATE
 Remarks
Add new menu items
For new menu item previledges
Release the rating and finalize
For employee list in calibration
PCM rating calculation, taking it from overall PCM rating column as
per the discussion with Faiyyaz
FISCAL YEAR
update the mapping of Marriage leave
Update the ticket owner mapping as per HR
Folder File Name
sql/Expense DM_RETAIL_HR_GET_EXPENSE_CLAIM_ENQUIRY.sql
sql/Images DM_RETAIL_HR_GET_EMPLOYEEPROFILEDETAILS.sql
sql/Images DM_RETAIL_HR_GET_EMPLOYEE_SEARCH.sql
sql/Images DM_RETAIL_IG_GETPICKLISTDETAILS.sql
sql/Images DM_RETAIL_HR_CODELIST.sql
sql/Loan DM_RETAIL_HR_GET_LOANDETAILSFORENQUIRY.sql
sql/Travel UPDATE-DM_RETAIL_HR_GET_TRAVEL_SEARCH.sql
sql/calibration EmpCalibration_Header.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_DETAIL_RATING.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_HEADER.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_HEADER_OVERALL_RATING.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_LIST.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_MATRIX.sql
sql/calibration DM_RETAIL_HR_CREATE_CALIBRATION_SUBJECT.sql
sql/calibration DM_RETAIL_HR_DELETE_CALIBRATION_HEADER_DETAIL.sql
sql/calibration DM_RETAIL_HR_GET_CALIBRATION_DETAIL.sql
sql/calibration DM_RETAIL_HR_GET_CALIBRATION_HEADER.sql
sql/calibration DM_RETAIL_HR_GET_CALIBRATION_SUBJECT.sql
sql/calibration DM_RETAIL_HR_GET_EMPLOYEE_LIST.sql
sql/calibration DM_RETAIL_HR_GET_EMPLOYEE_SEARCH.sql
sql/calibration DM_RETAIL_HR_UPDATE_CALIBRATION_SUBJECT.sql
sql/calibration DM_RETAIL_HR_VALIDATE_EMPLOYEESCODES.sql
sql/calibration DM_RETAIL_IG_GETCLASSIFICATION.sql
sql/calibration DM_RETAIL_HR_GET_CALIBRATION.sql
sql/calibration EmpCalibration_Detail.sql
sql/calibration EmpCalibration_Subject.sql
sql/calibration DM_RETAIL_IG_GETEMPLOYEELOCATION.sql
sql/performance EmpPerformance_PCM_KPI.sql
sql/performance DM_RETAIL_HR_CREATE_PERFORMANCE_DETAIL.sql
sql/performance DM_RETAIL_HR_CREATE_PERFORMANCE_DETAIL_KPI_COMMENT.sql
sql/performance DM_RETAIL_HR_DELETE_PERFORMANCE_DETAIL.sql
sql/performance DM_RETAIL_HR_GET_KPI.sql
sql/performance DM_RETAIL_HR_GET_PERFORMANCE_DETAIL.sql
sql/performance DM_RETAIL_HR_GET_PERFORMANCE_DUE_DATE.sql
sql/performance DM_RETAIL_HR_GET_PERFORMANCE_KPI_WEIGHTAGE.sql
sql/performance DM_RETAIL_HR_GET_PERFORMANCE_PCM_KPI.sql
sql/performance DM_RETAIL_HR_UPDATE_SECTION_RATINGS.sql
sql/performance EmpPerformance_Detail.sql
sql/performance EmpPerformance_Header.sql
sql/performance EmpPerformance_Header_Alter_PrimaryKey.sql
sql/performance EmpPerformance_KPI.sql
sql/performance performance_due_date.sql
sql/performance performance_kpi_percentage.sql
sql/Bonus CONFIG_DATA_CURR_YEAR.sql
sql/Bonus DM_RETAIL_HR_GET_PCMRATING.sql
sql/EmpFacility DM_RETAIL_HR_GET_EMPLOYEE_FACILITIES.sql
sql/FAQ CREATE_SP_ADD_UDATE_DELETE_FAQ_HEADERS_QA.sql
sql/FAQ CREATE_TABLE_FAQ_HEADERS_QA.sql
sql/Ticketing Store Procedure [Link]
sql/Ticketing Table [Link]
sql/login DM_RETAIL_IG_GET_USER_AD_FLAG.sql
sql/login DM_RETAIL_IG_GETBIOMETRICLOGINCHECK_AD.sql
sql/login DM_RETAIL_IG_GETMPINLOGINCHECK_AD.sql
sql/login DM_RETAIL_IG_SAVE_OTP.sql
sql/login DM_RETAIL_IG_UPDATEUSER_BIOMETRIC.sql
sql/login DM_RETAIL_IG_UPDATEUSER_MPIN.sql
sql/login DM_RETAIL_IG_USER_OTP.sql
sql/login DM_RETAIL_IG_VERIFY_OTP.sql
sql/login [Link]
sql/others DM_RETAIL_CODELIST.sql
sql/others DM_RETAIL_HR_GET_COMPOFFENQUIRYSEARCHDETAILS.sql
sql/others DM_RETAIL_HR_GET_OVERTIMEENQUIRYSEARCHDETAILS.sql
sql/table_desc_fixes table_desc_fixes.sql
sql/Loan DM_RETAIL_HR_GET_LOANDETAILSFORENQUIRY
 Type Remarks
SP Get expense claim enquiry
SP Update the Get Employee Profile details
SP Employee image path building
SP For different Get detail purpose, like get delegate approvers, travel city etc
SP differt HRCode updates
SP Loan details
SP For Travel search with more params
TABLE Calibration table
SP create calibration detail
SP update calibration header table detail each fileds
SP To save, finalize and release rating
SP Get calibration list
SP PCM vs Performance matrix data
SP Calibration subject selection
SP Cancel/delete calibration
SP Get calibration details
SP get c alibration header, participant filter and subject filter
SP Get calibration subjects
SP Get Employee list
SP Search employy
SP update calibration subjects
SP validation for employee codes
SP get classificaitons
SP Get clibration
TABLE Calibration detail table
TABLE calibration subject table
SP Get employee locations
TABLE CPM KPI table
SP create perforamnce details
SP KPI comments
SP Delete performance details
SP to get the KPIs
SP get performance details
SP due date
SP KPI weightage
SP get PCM KPIs
SP Set overall perforamnce rating and other details
TABLE Table for performance detail
TABLE Table for performance header

TABLE Table fpr performance KPIs

TABLE table for due date
TABLE Table for kpi percentage
SCRIPT Inser current fiscal year script
SP Get the pcm rating
SP To create employee facility data
SP All SP for FAQ
TABLE DB Table for FAQ
SP All SP for tickets
TABLE All table for tickets
SP USER AD flag SP
SP Get biomatric login check for mobile
SP get Mpin login check for mobile
SP Save OTP
SP Update user biomatric for mobile
SP update user mpin for mobile
TABLE Table for user OTP
SP Verify user otp
Alter user table to add two column for biomatric and mpin
SP get retail codes from list
SP compoff enquiry search
SP over time enquiry search
rename the company name as per given as issue
SP Get Loan detail for enquiry