// TODO // create the screen to enter the recruiter to the LIST - not required // create the screen to enter the Sales Person to the LIST- not required // when adding a new row to the Incentive List we can select the Recruiter/salesperson from the drop down // Add percentage efforts to Each Person //

// Create a List of VISA Type - GC OPT Citizen, H1b // Create a List of Employee Type - C2C, W2, NewW2 // Create a List of Role - Sales, Recruiter

// Create a screen to enter the Salesperson/Recruiter to the IncentiveDetails Screen with the below fields

// Employee Info

// employeeName // firstName // lastName // employeeId // employeeRole // employeeIncentive, // isTeamLead

Transaction Info

// transactionId // team // salesPerName // salesPerEmpID // salesPerIncAmount // salesPerPerctEfforts // comSalesPerPerctEfforts // comSalesPerEmpID // comSalesPerEmpName // salesPersonComments // recName // recEmpID // recPerctEfforts // compRecruitPerctEfforts // compRecruitEmpID // compRecruitEmpName // recIncAmount // recComments // candidateName // candidateEmpID // candidateStDate // billRate // visaType // payRate // marginPerct // margin // incentiveTL // totalEmpIncentive // incentiveMonths : // incentiveStMonth // incentiveEndMonth // createdDate // createdBy // modifiedDate // modifiedBy // commentsToSalesPerson // comments // commentsToRecruiter // months:[] // managerIncentive

// commit to GIT git add . git commit -m "" git push -u origin rsrit-workforce-1

// Questions ?

// should we capture the employee details upfront // should we capture the employee ID? // does the incentive be repetitive monthly? // does the sales person and recruiter be same person? // can we have a list of employees with roles properly defined? // can we get proper teams names list // Can we show the total amount of the employee and the details in the same sheet

/*

h1b

{ "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":8/100 * actualBillRate "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 12/100 * actualPayRate, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table }

// Payrate Calculator // how the payrate in calculated from salary ? salary/2080 -- what is 2080 just curious // how do we get the salary ? -- entered by the user { "salary":90000,// how do we get the salary ? "payrate":43.666,// salary/2080 "billRate":"",// % basis ? "percentage":"",// % basis ? "payRatePerct":""// % basis ? }

// what is the text at the bottom ---? IncentiveSales Table

TMIncentives Table

*/

/*

OPT General { "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":10/100 * actualBillRate "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 8/100 * actualPayRate, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table }

OPT Guest House

{ "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":7/100 * actualBillRate "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 8/100 * actualPayRate, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table } IncentiveSales Table

TMIncentives Table

// how the payrate in calculated from salary ? salary/2080 -- what is 2080 just curious // how do we get the salary ? -- entered by the user { "salary":90000,// how do we get the salary ? "payrate":43.666,// salary/2080 "billRate":"",// % basis ? "percentage":"",// % basis ? "payRatePerct":""// % basis ? }

*/

/* GC

{ "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":6/100 * actualBillRate "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 12/100 * actualPayRate, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table }

// Payrate Calculator // how the payrate in calculated from salary ? salary/2080 -- what is 2080 just curious // how do we get the salary ? -- entered by the user { "salary":90000,// how do we get the salary ? "payrate":43.666,// salary/2080 "billRate":"",// % basis ? "percentage":"",// % basis ? "payRatePerct":""// % basis ? }

// what is the text at the bottom ---? IncentiveSales Table

TMIncentives Table

*/

/* C2C -- why did we have separate sheet for c2c??

{ "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":0, "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 0, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table }

EXP GC USC

{ "billRate":100.00,// actualBillRate - billRateCostsDeduc "actualBillRate":100.00, "billRateCostsDeduc":3/100 * actualBillRate "payRate":"",// actualPayRate - payRateCostsDeduc "actualPayRate":"", "payRateCostsDeduc": 12/100 * actualPayRate, "margin":,// billRate - payRate "marginPercent":, //(margin * 100)/actualBillRate "recruitSalesIncentive":"",// Calculated from Sales Incentives Table "managerIncentive":""// calculated from T M Incentive Table }

C2C Incentive Table

Notes:

If margin is $10-15 more, commission will be paid for 6 instalments if consultant works for 300 hours or more Margin of $15 consultant must bill for 500 hours

/return (