usp_HRMS_GetConsultancyAssignmentHistoryBySearch
 
usp_HRMS_GetPreOnBoardingBySearch
 
1094	CandidateDocsuploadURL

1095	BGVDocsuploadURL

1096	HealthDocumentUploadURL
 


Update tblAlertType

set AlertTypeName = 'Candidate Profile Forwarded'

where AlertTypeId = 100
 

 
tblHRMSJDStatus
tblHRMSCandidateOnBoardStatus
 
usp_HRMS_UpdateIsOnBoardDataProcessed
 
usp_MasterData_GetMasterDataByCodeInternalDetail
 
usp_MasterData_GetMasterDataByCodeInternal
 
tblHRMSCandidateMedicalTest
 
usp_HRMS_SaveCandidateMedicalTest
 
usp_HRMS_GetCandidateMedicalTestById
 
select * from tblAPITemplateColumn
where APITemplateColumnId = 116878
ANd APITemplateId = 81970
 
usp_HRMS_GetCandidateMedicalTestBySearch
 
usp_HRMS_GetPreOnBoardingFeedBackRoundBySearch
 
select ParentFieldName, * from tblAPITemplateColumn
where APITemplateId = 81923
and APITemplateColumnId = 114466

 
usp_HRMS_GetMasterDataByCode -- HRMSEmployeeByDepartment
 
select * from tblMasterData
where MasterDataId = 24344
 
usp_HRMS_GetCandidateSubmissionBySearch
 
usp_HRMS_GetOnBoardMedicalTestBySearch
 
HRMSCandidateOnBoardFinalStatus
HRMSCandidateOnBoardStatus
 
usp_MasterData_GetMasterDataByCodeDetail
 
usp_HRMS_GetMasterDataByCode -- HRMSCandidateOnBoardStatus
 
usp_HRMS_SaveFeedbackQuestionResults
 
usp_HRMS_UpdateOnBoardDocumentUploadPublishedById
 
usp_HRMS_GetMasterDataByCode -- HRMSConsultancyAssignment
 
usp_HRMS_GetHRResumeReviewBySearch
 
 
 
 
 
 
 
 select * from tblStaticAPITemplate
where StaticAPITemplateId = 19


Update tblAPITemplateColumn
set MasterModuleCode = 'HRMSEmployeeByDepartment'
where APITemplateColumnId = 114466



usp_HRMS_GetPreOnBoardingFeedBackRoundBySearch


usp_HRMS_GetOnBoardDocumentUploadBySearch