Centra HCM

Naming Convention : Stored Procedure Name : pPay_GetData1 Variable to use above stored procedure : fPay1 Advantages: we can assign multiple earning/deduction values using single stored procedure Eg : CREATE PROCEDURE pPay_GetData1 (      @xmlIn AS XML = NULL      ,@xmlOut AS XML = NULL OUT      ,@Result AS DECIMAL(18, 4) OUT      ) AS BEGIN      SET NOCOUNT ON;      SET @xmlOut = @xmlIn     DECLARE @EmpId AS VARCHAR(max),@PayrollRefType AS VARCHAR(100)      declare @ToDate as int=0     declare @BonusFromDate as int=0,@BonusToDate as int=0     --Retriving Employee Id      SELECT @EmpId = v.value('iEmpId[1]', 'varchar(max)')      FROM @xmlIn.nodes('/PayrollData') x(v)     --Retriving Payroll Date      SELECT @ToDate = v.value('...

1: Change the ‘Computer\HKEY_USERS\.DEFAULT\Software\Focus7\Server’ to 2 as shown below Port number by default port : 9000 3: Focus7’s Company Selection at Global Preferences FA Posting 4: In the ‘Global Preferences >> Integration’ select ERP Software as ‘Focus 7’ Master Syncing 5: Do the master mapping 6: Do the master field mapping at workflow