USE [DynamicDBCompare]
GO
/----------Type: StoredProcedure Name: stnETSOrderPersonByOrderId_Search----------/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
create PROCEDURE [dbo].[stnETSOrderPersonByOrderId_Search]
(
@PersonId varchar(10),
@OrderId varchar(6)
)
AS
select
companyname = rtrim(cmi.companyname),
orderid = rtrim(opdr.orderid),
datefield1 = rtrim(convert(varchar(10),opdr.datefield1,101)),
datefield2 = rtrim(convert(varchar(10),opdr.datefield2,101)),
paystructure = ops.description,
payrate = ops.payrate,
billrate = ops.billrate,
timesheettype = ops.timesheettype,
po = oh.DefaultCompanyPO,
Contact = isnull(case when PI.Title is null
then LTrim(RTrim(PI.FirstName)) + ' ' + LTrim(RTrim(PI.LastName))
else LTrim(RTrim(PI.FirstName)) + ' ' + LTrim(RTrim(PI.LastName)) + ' - ' + LTrim(RTrim(PI.Title))
end,'ACCOUNTS PAYABLE'),
PayInfo.PayCycle,
detailRecId = max(opdr.detailRecId)
from
order_person_detail_record opdr join order_header oh
on opdr.orderid = oh.orderid
join order_Pay_Structure ops
on opdr.paystructurecounter = ops.paystructurecounter and opdr.orderid = ops.orderid
join company_master_id cmi
on oh.companyid = cmi.companyid
join person_identification pid
on opdr.personid = pid.personid
inner join Order_Type_Description ot
on Ot.orderType = oh.orderType
left outer join Person_Identification PI
on oh.Contact = PI.PersonID
inner join Payroll_Information PayInfo
on OPDR.PersonID = PayInfo.PersonID
where @PersonId = opdr.personid and
right('0000'+ @OrderId,6) = opdr.orderId and
pid.persontype <> 'KK' and
ot.OrderTypeGroup = 'TP' and
oh.orderType!='IO'
group by cmi.companyname, opdr.orderid, opdr.personid, opdr.paystructurecounter,opdr.datefield1, opdr.datefield2,ops.description,PI.Title,PI.FirstName,PI.LastName,
ops.payrate,ops.billrate,ops.timesheettype, oh.DefaultCompanyPO,PayInfo.PayCycle,opdr.detailRecId
order by opdr.paystructurecounter
/----------Type: Table Name: DA12312011_Person_File_GroupInsert----------/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[DA12312011_Person_File_GroupInsert](
[PersonId] [varchar](10) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[DocumentName] [varchar](50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL
) ON [PRIMARY]
SET ANSI_PADDING OFF
/----------Type: Table Name: Person_Timesheet_Input----------/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Person_Timesheet_Input]') AND type in (N'U'))
DROP Table Person_Timesheet_Input
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[Person_Timesheet_Input](
[OrderId] [char](6) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
[StartDate] [datetime] NOT NULL,
[PersonId] [char](10) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
[PayStructureCounter] [char](2) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
[JobId] [varchar](25) COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
[Day1] [decimal](18, 3) NULL,
[Day2] [decimal](18, 3) NULL,
[Day3] [decimal](18, 3) NULL,
[Day4] [decimal](18, 3) NULL,
[Day5] [decimal](18, 3) NULL,
[Day6] [decimal](18, 3) NULL,
[Day7] [decimal](18, 3) NULL,
[Day8] [decimal](18, 3) NULL,
[Day9] [decimal](18, 3) NULL,
[Day10] [decimal](18, 3) NULL,
[Day11] [decimal](18, 3) NULL,
[Day12] [decimal](18, 3) NULL,
[Day13] [decimal](18, 3) NULL,
[Day14] [decimal](18, 3) NULL,
[Day15] [decimal](18, 3) NULL,
[Day16] [decimal](18, 3) NULL,
[Day17] [decimal](18, 3) NULL,
[Day18] [decimal](18, 3) NULL,
[Day19] [decimal](18, 3) NULL,
[Day20] [decimal](18, 3) NULL,
[Day21] [decimal](18, 3) NULL,
[Day22] [decimal](18, 3) NULL,
[Day23] [decimal](18, 3) NULL,
[Day24] [decimal](18, 3) NULL,
[Day25] [decimal](18, 3) NULL,
[Day26] [decimal](18, 3) NULL,
[Day27] [decimal](18, 3) NULL,
[Day28] [decimal](18, 3) NULL,
[Day29] [decimal](18, 3) NULL,
[Day30] [decimal](18, 3) NULL,
[Day31] [decimal](18, 3) NULL,
[YearWeek] [char](6) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[RunId] [int] NULL,
[DayByAssociate] [varchar](350) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[DayByClient] [varchar](350) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[DayByMember] [varchar](350) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[SubmittedByAssociate] [char](1) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[ApprovedByClient] [char](1) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[ApprovedByMember] [char](1) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[ModifiedBy] [varchar](10) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[ModifiedOn] [datetime] NULL,
[ModifiedNote] [varchar](50) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
[TimeSheetId] [char](4) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
CONSTRAINT [PK_Person_Timesheet_Input] PRIMARY KEY CLUSTERED
(
[OrderId] ASC,
[StartDate] ASC,
[PersonId] ASC,
[PayStructureCounter] ASC,
[JobId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFF
/----------Type: Trigger Name: ets_run_control_detail_trg_upd----------/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ets_run_control_detail_trg_upd]') AND type in (N'U'))
DROP Trigger ets_run_control_detail_trg_upd
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TRIGGER [dbo].[ETS_Run_Control_Detail_TRG_Upd] ON [dbo].[ETS_Run_Control_Detail]
FOR UPDATE
AS
insert into ETS_Run_Control_Detail_Audit
select *, 'U', columns_updated(), getdate(), Suser_Sname()
from deleted
GRANT SELECT ON [dbo].[Company_Mast] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Mast] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Company_Mast] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersChequeCurrentTS] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Profile_Template] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveAddHelp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderTypeWithGroup_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[ISO_Service_Codes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[ISO_Service_Codes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[ISO_Service_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Service_Codes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[ISO_Service_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Service_Codes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[ISO_Service_Codes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[ISO_Service_Codes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Service_Codes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[ISO_Service_Codes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminPersonInactive_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompSkills] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditApplication_Save] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Contact_Info_Audit] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGetActiveOrdLoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonOrderId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunPrintedOn_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantPersonDuplicates_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonProfile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTopXXByPersonId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeAttendanceReport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAISNotificationEmailBody_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCompSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[temp_GetLeadHistory] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelDynamicInterviewedByReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderLocationInternal_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPayCardSaveActResult] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonLoginInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetHotJobs] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Telephone_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Telephone_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Telephone_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Telephone_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Telephone_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Telephone_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Telephone_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Telephone_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Telephone_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Telephone_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetExistedTS] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Person_Detail_Record] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Person_Detail_Record] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Person_Detail_Record] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Person_Detail_Record] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Person_Detail_Record] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Person_Detail_Record] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Person_Detail_Record] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Person_Detail_Record] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Person_Detail_Record] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Person_Detail_Record] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFileTitle_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyDetailedShiftUnique_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskCompleted_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunToExport_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetHardcopyLocation] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalDeductionTS_Copy] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectCompDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderIsEOrder_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAltContact_Delete] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Master_Sales_Activity] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonAddress_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139ROEReport_Search] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Telephone] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Telephone] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Telephone] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Telephone] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Telephone] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Telephone] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Telephone] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Telephone] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Telephone] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Telephone] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardHired_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentActiveIncomplete_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCChkStatusAddHotList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditRequestCompanyInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDocumentById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetProperty] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetUserInfo] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetUserInfo] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTUpdateUser] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTUpdateUser] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompShifts] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnHowDidYouHeardAboutUs_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersChequeCurrent] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFilesFromResume_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIUpdateWkFigures] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTopXXByPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMKTAddPersonNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedResultForPrint_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPersonMarkInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexTree_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Header_Audit] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Header_Audit] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header_Audit] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Header_Audit] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139TermNotDate_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonType_Set] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Skill] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Skill] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Skill] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Skill] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Skill] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Skill] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Skill] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Skill] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBusinessInfo_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Profile_Notes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Profile_Notes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Profile_Notes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Profile_Notes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyType_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeInOutHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTOrderPayStructureByStartDate_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [Consultant] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [guest] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [SalesStaff] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [Staffing Edge] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [Support] AS [dbo]
GRANT SELECT ON [dbo].[Candidate_Call_Template] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spAdminUpdateSkill] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReferenceQuestion_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroupById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminMemberManagerLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrdPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersPayStubsDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderISOServiceCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserByGroupId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditOrderWebPostedInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdHeadDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddOrderPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnUserSignature_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchCompanyResult_SaveGet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByCompanyId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrder_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSMasterTSCreation] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeUpdateSwipeFlag] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectNewOne_Perm] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFile_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonEndDate_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAdminDeleteSkill] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonRecruitment_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Task_User] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnSalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonEmailByUserId_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnReportOrderPriority_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskStatus_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Skill_Criteria] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Skill_Criteria] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Skill_Criteria] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Skill_Criteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLead_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteCompInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetVanDeductions] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSecurityUserLogin_Validate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderOtherRequirements_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetEdgeIndexesAdmin] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostingList_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[SubVerticals] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFile_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNote_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNewsHead] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNewsHead] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNewsHead] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNewsHead] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantTitle_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteEmployeeDeduction] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollRecordOfEmploymentByTrackingID_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnConcatNoteFiles] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSalesReps] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchSkillCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteInternal_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFile_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Run_Control_Detail] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnReportSalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonOfficialLanguage_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonLocationByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdMatchPersResInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteRegInt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReference_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGetExpDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMemberLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveMed] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderJANHistory_Update] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Time_Sheet_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Time_Sheet_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Time_Sheet_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Time_Sheet_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Time_Sheet_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrder_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFile_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardPermUnfilledOrders_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Skill] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Skill] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Skill] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Skill] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Skill] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Skill] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Skill] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Skill] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetReminderUsers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelEAPInvoiceBackup] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139WeeksPerYear_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunByExport_Test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchPersonFascastFile_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Identification_Int] TO [M-Team] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentStatus_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantXML_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCModifyDetails] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCompNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonClassification_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportNew2Old1] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelEmployeeHowHeardAboutUs] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserInfo_Save] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Sales_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDocuments_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyShift_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersActFlt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBRegSetting_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Result_Desc] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Result_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Result_Desc] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Result_Desc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheet_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDuplicate_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderSalesTypeOrderByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetRptISOLevel2] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteIDsForSearchByLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSEmptyTimesheet_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectForAddPermTS] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroupDescription_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeTSCreationDay] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveRef] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesTypeSkill_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[mobNote_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanySkill_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNSCallBackMgr_GetDBServerName] TO [STLogWriter] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonEmailByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetEdgeIndexes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonEmailFromOutlook_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditRequestResult_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCDeleteTimesheet] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMemberCommissionRate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonEmail_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersCheque] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReferenceQuestionCustomDDL_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Match_Company_Result] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Match_Company_Result] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Company_Result] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Company_Result] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Company_Result] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderSalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersonComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[jobPersonActivateCodeByAvailableFrom_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFillupCompPoForRun4] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spFillupCompPoForRun5] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSkill_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebpostedPositionHeld_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDeduction_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAttritionReason_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayCardActResult_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetBirthdateReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexFileById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPersonRecruitment_Assess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCFastAddPerson] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Contact_Note] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Contact_Note] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Contact_Note] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Note] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Contact_Note] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Note] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Contact_Note] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Contact_Note] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Note] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Contact_Note] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[ISOLevel] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[ISOLevel] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[ISOLevel] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISOLevel] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[ISOLevel] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISOLevel] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[ISOLevel] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[ISOLevel] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[ISOLevel] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[ISOLevel] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeletePay] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetEmployeeDeductions] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyHolidayStatus_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdMSeachID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderTitle_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Quotes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Quotes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Quotes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Quotes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Quotes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Quotes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Quotes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Quotes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Quotes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Quotes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonActiveOrderCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyMaxIDInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactDateByPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompanyCheck] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderTerminationReason_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSavePersProfile] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Requirements_Other] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Requirements_Other] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Requirements_Other] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Other] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Requirements_Other] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Other] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Requirements_Other] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Requirements_Other] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Other] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Requirements_Other] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Run_Export_Log] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Run_Export_Log] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[Run_Export_Log] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCustomGroup_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139Timesheet_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignment_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonName_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelPaidNotBilled] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompany_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeLoginCheck] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAISMustBeSent_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchDocument_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeResetSwipeFlag] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderETTPersonNoEmail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyInfo_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyOrdersInternal_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetDedProjectionRpt] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteOrdInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetInputByMember_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSkillTree_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditCompanyLocationInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonMaxID_Correct] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetActiveMembers] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetActiveMembers] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetOrderType] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Requirements_Skills] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Requirements_Skills] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Requirements_Skills] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Skills] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Requirements_Skills] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Skills] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Requirements_Skills] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Requirements_Skills] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Requirements_Skills] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Requirements_Skills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanySkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAcceptability_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSaved_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindGetList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReference_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayCardSecQuestion_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrder_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFileById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNoteTimeRange_test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptMaster_CS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadTitle_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimesheet_Refresh] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderCompanyName_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportCustomer_new] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelStatHolidayReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminTemplateLink_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRun_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCompanyByRunId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeletePersSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnIDPresented_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTimeSheetInput_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersChequeTS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteCodeByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetContactTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyProfileTemplate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[_stnFECompanyDetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersWkHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserAdminFunction_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDuplicate_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnBulkROEPendingReminder_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserInactive_Set] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Date_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Date_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Date_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Date_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Date_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Date_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Date_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Date_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Date_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Date_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Ord_Require] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptDetailDB] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantWorkHistory_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRegHours_test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactDateByOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroupById_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNote_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditOrderInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddMatchPersResult] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[_stnFEActiveOrders_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTMemberTimesheetByYearWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCModDelete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyLastPayment_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[jobCompanyOverCreditLimitCreditRequest_Add] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Swipe_Clock] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_security_HasAdminAccess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelCompanyHowHeardAboutUsSummary] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Chk] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Chk] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Chk] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPersVertical] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersSwipes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebpostedInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminConfig100DDL_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportMAS2Old] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnBulkROE_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSAddStat] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[Company_SIC_Codes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_SIC_Codes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_SIC_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Codes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_SIC_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Codes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_SIC_Codes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_SIC_Codes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Codes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_SIC_Codes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPosting_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSINreport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDocument_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchCompanyType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFootwearSwipeAdd] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadProfileNote_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTask_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrdHeadDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonByPersonId_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDoNotMarketSkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMktPersonSearch] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Work_History] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Work_History] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Work_History] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_History] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Work_History] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_History] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Work_History] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Work_History] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_History] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Work_History] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Document] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Document] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Document] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Document] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Document] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Document] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Document] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Document] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Document] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Document] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunPersonByYearWeek_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSOverTimeHours_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkill_Delete] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[TS_Customer_Group] TO [Finance] AS [dbo]
GRANT INSERT ON [dbo].[TS_Customer_Group] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[TS_Customer_Group] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[TS_Customer_Group] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[TS_Customer_Group] TO [Staffing Edge] AS [dbo]
GRANT INSERT ON [dbo].[TS_Customer_Group] TO [Staffing Edge] AS [dbo]
GRANT SELECT ON [dbo].[TS_Customer_Group] TO [Staffing Edge] AS [dbo]
GRANT UPDATE ON [dbo].[TS_Customer_Group] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonRegistration_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnGetOrderJobBoardDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNSCallBackMgr] TO [STLogWriter] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersonSpouse] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEPerson_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdISOL] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderLocationByProvince_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBNoteByPersonId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminApplicantDocumentForImport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactByEmail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportNew2Old] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderStatusInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebgetManagerEmail] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebgetManagerEmail] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebgetManagerEmail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebgetManagerEmail] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonNameByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAdminFunctions] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSMasterTSInfo] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spPayCardGetActInfo] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Cheque_Route] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Cheque_Route] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Cheque_Route] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Cheque_Route] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Cheque_Route] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Cheque_Route] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Cheque_Route] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Cheque_Route] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Cheque_Route] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Cheque_Route] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonView_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPayrollExportTest_Start] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyTimesheetType_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Pay_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Pay_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Pay_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Pay_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Pay_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Pay_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Pay_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetReports] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeErrorNotOnOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSiNTERNALRun_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchHasOnlineReg_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonFiles_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFileById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanySICDescription_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteFile_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskAssignedTo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersonInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPrimaryLocation_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Delivery_Code] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectForAddTS] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_updateschenkerunsuitable] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNotesByFilterCond_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetChequeActiveCompany] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFECompanyList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSProperty_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetLast10Swipes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFileById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentTimesheet_Refresh] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRun_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPhone_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayrollStubOption_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSFillTimesheet] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSModifyBy_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantWorkHistoryWiz_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollTimesheetMinMaxYearWeekTest_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[delBill139AuditInfo_get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSalesType] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pers_Detl] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pers_Detl] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pers_Detl] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimeSheet_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillCategory_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedByKeyWordAndCountry_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyClientCareTeam_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddOrdReqSkill] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCommList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSExportControlInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSamsungSplit] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Search_Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Person_Result] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Person_Result] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Person_Result] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Person_Result] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Person_Result] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCustomGroupDesc_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Unacceptable] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNotePersonActiveOrdersByUser_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalTimeSheet_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroup_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelMatchCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminPersonDocument_Import] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetErrorReport_CS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[jobCompanyWithOutBilling_Inactivate] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Telephone] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Telephone] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Telephone] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Telephone] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Telephone] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Telephone] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Telephone] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Telephone] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Telephone] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Telephone] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPayCycle_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFile_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnTimesheetType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_PersonAltContact_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyViewedByUser_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillBranch_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddUserTime] TO [SystemService] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyQuote_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantSkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindUpdate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByIdRangeAndLocation_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunByYearWeek_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFileById_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Report] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Report] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Report] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Report] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantWorkHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAdminReminderUsers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInternal_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderJANHistory_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddOrdQuickNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimeSheetMinMaxDateByClient_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipePersonNameWithID_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimeSheet_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMemberConfig_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[detailactivereport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalDeductionTS_Insert] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[User_Viewed_Person] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFECompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spHasWorkFirst] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonChequeByChequeNumber_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddMatchCompResult] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportTsheets] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnPersonNameById] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollPayCycle_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelSearchCompByNameID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCounsellors] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Key_Notes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Key_Notes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Key_Notes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Key_Notes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Key_Notes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Key_Notes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Key_Notes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Key_Notes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Key_Notes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Key_Notes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spLoginAudit] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyClientCareMember_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetCompanyJobs] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetCompanyJobs] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetCompanyJobs] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_CJOParseHeader] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectTimeSheet] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocumentIdByFilename_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalTimeSheet_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptMaster] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Activity_Config] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOutstandingAR] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonOrderByClient_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInternalActiveUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCustomerListRptMaster] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSYearWeekData_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSecurityETTSessionStatus_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchResultDC_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrolVacationPaid_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonRecruitment_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedByOrderTypeGroup_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPerson_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInactive_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskFilterCodeByUser_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantInfoWiz_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdatePayrollSent] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimeSheet_Duplicate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteWorkHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteDescByNoteId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayCardActInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelRecruitmentSourceSummary] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindDetailUpdate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWorkHistDetailByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdHeadDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportCustomer] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTakerByOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminPersonInactiveInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Person_Result_Info] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Person_Result_Info] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Person_Result_Info] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Person_Result_Info] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[PWD_History] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPaystructure_Duplicate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTransferPayroll2Member] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spTransferPayroll2Member] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteAltContact] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetActiveCode] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPayrollReportMemberID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectNewOne] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPersonVacForCurrentWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnPersonNameTitleById] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInternalActiveByBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonRecruitment_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeErrorReportCS_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocument_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBySIN_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnProvinceByProvinceCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalDeductions] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSSelectForAddTS1] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSecurityETTSessionStatus_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertOneTimesheet] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Search_Match] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentActiveComplete_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeOneComplexShiftInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditOrderPersonDetailRecordInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBySwipeCardNum_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelCompanyHowHeardAboutUs] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyContact_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWorkHistByComapny_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRunShift] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardStartReportByDateRange_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantStatus_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalTimeSheet_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFileById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUSPayrollStateTax_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbyofficetypecust_HrTotals] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteFromCallResult_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTask_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrderPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTSearchPersByID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserTask_Switch] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSetAllUserTime] TO [SystemService] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSkill_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_PersonRegInt_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetExportControlInfo] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyProfileInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPersonInternal_Search] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Payroll_Information] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Payroll_Information] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Payroll_Information] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Payroll_Information] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Payroll_Information] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Payroll_Information] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Payroll_Information] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Payroll_Information] TO [SalesStaff] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptMaster_RIM] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAddStatTimesheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonTodays_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCreditOver] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteProf] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyWithMoreLocations_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkill_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSetAllUsersVersion] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTypeGroupById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranch_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWorkHistByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMRSLProject_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedByKeyWordAndCategory_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReportCompany_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructure_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAvailableUSStateTax_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Ident] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Ident] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Person_Ident] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyLoanShift_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Invoice_Option] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Invoice_Option] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Invoice_Option] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Invoice_Option] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Invoice_Option] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Invoice_Option] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Invoice_Option] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Invoice_Option] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Invoice_Option] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Invoice_Option] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddReportActivity_new] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchCompRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddNoteOrd] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetInternalPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPerson_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonIdByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSVanDeduction] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSavePersonCheck] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnInvoiceTypeDesc_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNoteTaker] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrdePerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportTSExtraInfo] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCompanyCustomGroup_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantPendingDocument_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnInvoiceTypeDesc_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindGetCounter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNewBusinessRpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentOrderPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPhoto_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompany_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGetExpenseList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersNoteTaker] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Pay_Structure] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Pay_Structure] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Pay_Structure] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pay_Structure] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Pay_Structure] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pay_Structure] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Pay_Structure] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Pay_Structure] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Pay_Structure] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Pay_Structure] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelDirectDepositWarning] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_UserOldGroup_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonRecruitmentFromWeb_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyBillingSite_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetReportCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRptGetPersTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddNoteContPers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMiscPermInvoiceInfo_get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyContactByID_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedResult_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeDeptShiftWithStartEndTime_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeErrorShouldBeOff_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLocationsByMemberId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spHasAdminAccess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCompanyCustomGroup_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCFindSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetInputByClient_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBClassByOrderId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonName_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestPayCycleExpData] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestPayCycleExpData] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderCompany_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersChqDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSkillTreeBuilder] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWSIBFiles_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFile_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTClientTimesheetByStartDate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPhone_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPersonInternal_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalProperty_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[fnBill139MinMaxTerminationPay] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[View_Open_Order] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDocumentById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalOrderPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddWorkHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompMatch] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteCodeByOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnProcedureParameterType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderViewedByUser_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeAdd_ClockID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRun_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAltContact_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptMasterDB_CS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDeduction_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetMemberID] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchPersResInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskByUser_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Contact_Info] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Contact_Info] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Contact_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Contact_Info] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Contact_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Contact_Info] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Contact_Info] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Contact_Info] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Contact_Info] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Contact_Info] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[startreport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveNoteinf] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocumentById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexFolder_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderViewedByUser_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCredit_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetDeductionTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollDeductionType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdISODetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddMatchPersToOrder] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderByOrderId_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBMemberFile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFileById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddSkillsFromList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTaskAsNewOne_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderZeroPayRatePayStructure_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonRiskMessage_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdISO] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeFillTimesheets_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipePersonHoursInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompType] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBIncidentInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Identification] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Identification] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Identification] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Identification] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Identification] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Identification] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Identification] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Identification] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Identification] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Identification] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnBill139RiskTypeMessages] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Criteria_Desc] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Criteria_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Criteria_Desc] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Criteria_Desc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddEmployeeDeduction] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTopXXByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPersonRecruitment_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdReqSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersTypesNoInternal] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelHelpList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersAbstract] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeShiftDetailedShift_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSCopyDeductionTS] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipePersonHours_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonCanBeActive_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompIndexDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReportName_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFileToWSIBFile_Copy] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelCommList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAdminNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderJobBoardById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnBill139RiskClassificationMsg] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantSkills_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderMailConfirmInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentPersonByOrder_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyClassStaffType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_MemberVersion_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeAdd] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactByOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetRptISOLevel] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteRef] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSkillsByCategory_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Unsuitable_Company] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSVanDeductImport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadContact_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersContactInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetErrorReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetUsers] TO [SystemService] AS [dbo]
GRANT EXECUTE ON [dbo].[spUnsatisfactoryRatingsrpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnInvoiceType_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[TS] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Index] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Index] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Classification_Index] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Index] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Index] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Index] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Index] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Index] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Index] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Index] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompMarkupCreditRegOff] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[delBill139PersonFileId_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAsEOrder_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteCodeByPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelFromMatchCompRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTChangePwd] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSMasterTSCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollTimesheetMinMaxYearWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocumentDescription_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactDistributionList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantSkills_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTSecurityUserPassword_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignment_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMemberID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportTsheets1] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddReportActivity] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderTerminationInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnEmailAISPreviewInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNoteCodes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Profile_Template] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNote_Count] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByFilter_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Occurrence_Reason] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonLocationIdByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebAddNoteToComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139TestInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalEmploye_Export] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardEndReport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[activereport] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_ISO_Service] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_ISO_Service] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_ISO_Service] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_ISO_Service] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_ISO_Service] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_ISO_Service] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_ISO_Service] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_ISO_Service] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_ISO_Service] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_ISO_Service] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Vertical_News] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Profile] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Profile] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Profile] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Profile] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Profile] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Profile] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Profile] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Profile] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Profile] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Profile] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetDuplicateSwipeID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGenerateWkFigures] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFile_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranch_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Currency] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Currency] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Currency] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Currency] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Currency] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Currency] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Currency] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Currency] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Currency] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Currency] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdEmp] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Header] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Header] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Header] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Header] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Header] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Header] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Header] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetExistedPermTS] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptMasterDB] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByLocation_Count] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCFillTimesheet] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCFillTimesheet] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Person_Criteria] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Person_Criteria] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Person_Criteria] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Person_Criteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicant_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderETTInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Contact_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Contact_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Contact_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Contact_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Contact_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Contact_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Contact_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Contact_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskSnoozeTime_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDescription_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyByLinkId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantAsPerson_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTaskById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPaystubInvalidEmail_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPostedOnline_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeSaveDailyTS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompProfileNotes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateAltContact] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFile_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReference] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetInternalActivePerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetUserAccess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersDoNotMarketSkill] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetScreenName] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetActiveInternalPersonPlus] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollChequeRouting_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantRegistrationDuplicity_Check] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Processing] TO [Finance] AS [dbo]
GRANT INSERT ON [dbo].[Company_Processing] TO [Finance] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Processing] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Company_Processing] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Processing] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[Company_Processing] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Processing] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Processing] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Processing] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Processing] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Processing] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Processing] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Processing] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Processing] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Processing] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Processing] TO [Staffing Edge] AS [dbo]
GRANT INSERT ON [dbo].[Company_Processing] TO [Staffing Edge] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Processing] TO [Staffing Edge] AS [dbo]
GRANT SELECT ON [dbo].[Company_Processing] TO [Staffing Edge] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Processing] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateNoteCodeHL2GN] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonDetailRecord_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTask_Count] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdMatchResDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkill_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimeSheet_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEPerson_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[SalesSum] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditNoteByCompanyId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonProfileTemplate_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Holiday_Code_Status] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Holiday_Code_Status] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Holiday_Code_Status] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Holiday_Code_Status] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Holiday_Code_Status] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Holiday_Code_Status] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Holiday_Code_Status] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Holiday_Code_Status] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Holiday_Code_Status] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Holiday_Code_Status] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminConfigSetting_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalPayroll_Export] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadContactByContactId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyTitle_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnORJBSkillCategories_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimeSheetMinMaxDate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSinDuplicity_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebVertPersSearch] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebVertPersSearch] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebVertPersSearch] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_SecurityAccess_Grant] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOptionValue] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSOrderPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompQuot] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyContactByLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNonWFNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedByKeyWord_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternaltimeSheetByKey_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminCompanyDocument_Import] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteSrchResNum] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunCreationSetting_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stn_Note_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTSearchCompByID] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Task_Status] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrdLocation] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReport_Generate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTitle_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Conta_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Conta_Info] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Person_Conta_Info] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderJobBoards_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSkillIndexes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyById_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderJobCategoryByOrderType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139Info_Recalculate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardTempUnfilledOrders_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetMemberID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnInvoiceType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderMaxIDInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUseCompNoteFilter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTSEPersonInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompClassStaff] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetDBRoles] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetDBRoles] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateDummy2] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebsiteInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Credit] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Credit] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Credit] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Credit] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Company_Criteria] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Company_Criteria] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Company_Criteria] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Company_Criteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTSUpload] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnHowDidYouHeardAboutUsByKey_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertDeductionTS] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[Province] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Province] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Province] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Province] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Province] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Province] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Province] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Province] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Province] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Province] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCardId_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCustomGroup_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetByClient_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWFSkill_Has] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectMarketing] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectMarketing] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalPayrollSent_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnProvince_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructureByCounter_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Conta_Notes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Conta_Notes] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Conta_Notes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderStatus_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalExportData_Test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedCriteria_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyTypes_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Person_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Match_Person_Result] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Match_Person_Result] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Match_Person_Result] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Match_Person_Result] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Match_Person_Result] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveQuickNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminPersonDocumentForImport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spClassNotesrpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedSkillGroup_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportPayroll] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Marketing_Statistic] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSMailingList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocumentFolder_Change] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPayrollExportTestResult_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentRun_Create] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Shifts] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Shifts] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Shifts] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Shifts] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Shifts] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Shifts] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Shifts] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Shifts] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Shifts] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Shifts] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCTsheetReports] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCTsheetReports] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelreportList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbyofficerepcust] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbyofficerepcust] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebWorkopolis] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebWorkopolis] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebWorkopolis] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebWorkopolis] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139ROECondition_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRayExportData] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonRegistrationByEmail_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFile_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditRequestlimit_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserMember_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Location] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Location] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Location] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Location] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Location] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Location] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Location] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Location] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Location] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Location] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonQLevel66_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTest] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetUserTime] TO [SystemService] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSTestExportData_new] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSTestExportData_new] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSDeductions] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSDeductions] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPermanentType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonOnRun_Test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteMed] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonCellPhone_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCheckSIN] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertVanDeductionTS] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertVanDeductionTS] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertVanDeductionTS] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spInsertISOProcessId] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNotePersInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompStaffMem] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReportCriteria_get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDetailByUserId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactList_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetRptCSIndex] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCompDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelStatSummary] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserAdminFunction_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskDismissed_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexFolderParent_Change] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonRecruitment_Assess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexLog_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonViewedByUser_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteMatPersSearchID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEPersonList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetInternalPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentStatus_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSecurityUserPassword_Change] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicant_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderNZeroPayRatePayStructure_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCTsheetReports20010704] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Help] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Help] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Help] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Help] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Help] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Help] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Help] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Help] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Help] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Help] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkill_Add] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Profile] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Profile] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Profile] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Profile] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyIdByDomain_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyShiftInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderRequirementsOther_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAttritionReport] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Document] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Document] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Document] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Document] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Document] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Document] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Document] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Document] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Document] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Document] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonActiveCodes_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchPersonResultForPrint_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMemberVersion] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMemberVersion] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTakerByPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMarketingPersonProfile_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExport4Ray] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalExtraInfo_Export] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDocument_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebCounter] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebCounter] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebCounter] TO [guest] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebCounter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebCounter] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBMemberFile_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFileTitle_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompQuot] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[endreport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCompQuickNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchActiveCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCredit_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonActiveOnOrder_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskMultipleAssignment_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCreditClass_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Attrition_Reason] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillCategory_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnSalesRepIdByOrderId] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesType_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonLast2Swipes_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentPerson_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCreditByOrderId_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonViewedByUser_Search] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Master_ID] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Master_ID] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Master_ID] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Master_ID] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Master_ID] TO [FullAdmin] AS [dbo]
GRANT DELETE ON [dbo].[Company_Master_ID] TO [M-Team] AS [dbo]
GRANT INSERT ON [dbo].[Company_Master_ID] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Company_Master_ID] TO [M-Team] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Master_ID] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Master_ID] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Master_ID] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Master_ID] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Master_ID] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Master_ID] TO [Staffing Edge] AS [dbo]
GRANT INSERT ON [dbo].[Company_Master_ID] TO [Staffing Edge] AS [dbo]
GRANT SELECT ON [dbo].[Company_Master_ID] TO [Staffing Edge] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Master_ID] TO [Staffing Edge] AS [dbo]
GRANT DELETE ON [dbo].[Company_Master_ID] TO [Support] AS [dbo]
GRANT INSERT ON [dbo].[Company_Master_ID] TO [Support] AS [dbo]
GRANT SELECT ON [dbo].[Company_Master_ID] TO [Support] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Master_ID] TO [Support] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateUserTime] TO [SystemService] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubCategories] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubCategories] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubCategories] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubCategories] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdateRunControl] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyDetailedShift_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchPersonResult_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeLast10Swipes_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonActiveCodeDescriptionById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPerson_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMarketingPersonSkill_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashBoardActiveOnOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFECreditRequestNote_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteSearchResult] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[TimeSheets] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[TimeSheets] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[TimeSheets] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheets] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[TimeSheets] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheets] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[TimeSheets] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[TimeSheets] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheets] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[TimeSheets] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnTelType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spOrdSearchComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkillsBySalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompProces] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Staff] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Staff] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Classification_Staff] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Staff] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Staff] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Staff] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Staff] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Staff] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Staff] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Staff] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUSSatatesTax_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectSubCategories] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectSubCategories] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectSubCategories] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectSubCategories] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddOrdPayL] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Complex_Shift_Information] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Complex_Shift_Information] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Complex_Shift_Information] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Complex_Shift_Information] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Complex_Shift_Information] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Complex_Shift_Information] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Complex_Shift_Information] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Complex_Shift_Information] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Complex_Shift_Information] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Complex_Shift_Information] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompProf] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCreditClass_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Association] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Association] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Association] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Association] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Association] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Association] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Association] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Association] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Association] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Association] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchCompanyOrders] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAsEOrder_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalTimeSheet_Duplicate] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchPersCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderDefaultValues_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddNoteComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetEmpOweRpt] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[fnCCTeamMemberByCompany] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTypeDescriptionById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexFolderName_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalRun_Create] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_ActiveCode] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMktGetHeader] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExcelExport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonMaxIDInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderCanBeDeleted_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrderPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonHLNote_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedCustomDDL_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchCompCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollEmploymentRecordDefaultValues_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantWiz_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnREportCompanyTypes_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonNotInternalType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetISOServiceCode] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTypeForClient_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveMCompRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersChqHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSetUserAccess] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersActOrdCompany] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteOrdPayL] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactList_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveSkillMDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskAssignedToList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestDuplicated] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalMinYearWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveRegInt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalExportData_Test1] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalVanOrderPerson_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFileById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTTimeSheetCreate_Test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddUnionDuesToRun4] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMaretingPersonProfile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderETTInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[jobPersonUnacceptable_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCompanyGroup_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSIN_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetByMember_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeAttrition_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEPayType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminApplicantDocument_Import] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPersonByOrder_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchUnsuitableCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNSCallBackMgr_4US] TO [STLogWriter] AS [dbo]
GRANT EXECUTE ON [dbo].[stnExcelReportDDLBySPName_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSelectPersPayStubs] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdReqSkills] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetVanDedYearWeek] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadCustomerDuplicates_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spLevelOfServicerpt] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Index_Description] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Index_Description] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Index_Description] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Index_Description] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Index_Description] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Index_Description] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Index_Description] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Index_Description] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Index_Description] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Index_Description] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderActiveInactivePerson_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportTSF] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnUSPayrollFilingStatus_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSkillMgrIndexes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByOrderId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadContact_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchPersRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMktCompanySearch] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSRunSearch] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetSalesRep] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyOrders_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMarketingPersonWorkHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructureDetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrderToMoveInfo] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Types] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Types] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Types] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Types] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Types] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Types] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Types] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Types] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Types] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Types] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchSavedActiveCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCInsertOneTimesheet] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCInsertOneTimesheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdMPersRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeDeptDetailedShifts_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSkills_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetSalesType] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnMRSLProjectHoursByIssueId] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkillsByCategory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonEmail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkill_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdateTimeSheet] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_File] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCompQuot] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebsiteInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyViewedByUser_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbycust] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbycust] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetOrderLocation] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersHLNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillGroup_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[fnOrdersBySalesRepLocation] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeErrorCardNotRegistered_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteForTSEI_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelActivenotpaid] TO [kmcmullen] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelActivenotpaid] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportEmployee_new] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[repLevelOfServiceSortingOptions_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteExternal_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexDocument_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelSearchEmpByNameIDSIN] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportNew2Old2] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCreditDefRpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddUserActivityLog] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadAsCustomer_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAdminAddIndex] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnEmailNoticeOfTermination_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDynamicInterviewedByReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139OPDR_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Attrition_Reason] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[OT_payStruct] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalPayCycleExpData_Test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByLocation_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSalesSummary] TO [3nwiesner] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSalesSummary] TO [3shamulecki] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSalesSummary] TO [3shyndman] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSalesSummary] TO [3syhyndman] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersActiveOrders] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteShif] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spToggleOrderStatus] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersSkillsDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetByMember_Approve] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrdPersName] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetConfigInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUseCompNoteTimeFilter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadProfileNote_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReference_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAndUserOfiiceId_Compare] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyLocationWithExtraInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Time_Sheet_Type] TO [Finance] AS [dbo]
GRANT INSERT ON [dbo].[Time_Sheet_Type] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[Time_Sheet_Type] TO [Finance] AS [dbo]
GRANT DELETE ON [dbo].[Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Time_Sheet_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Time_Sheet_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Time_Sheet_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Time_Sheet_Type] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Active_Codes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Active_Codes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Active_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Active_Codes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Active_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Active_Codes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Active_Codes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Active_Codes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Active_Codes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Active_Codes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139Zone_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddQuickNote] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[fnOrdersBySalesRep] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderETTPersonWithoutEmail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesTypeById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedStatus_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMarketingNote_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportActivity] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnEmailAISInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPersonRecruitment_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddWorkFirstNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPostedOnline_Confirm] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[User_Person] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[User_Person] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[User_Person] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[User_Person] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[User_Person] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[User_Person] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[User_Person] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[User_Person] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[User_Person] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[User_Person] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompCreditInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyInternal_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInternalActive_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFECompany_Save] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Type_Description] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardFilledOrdersByBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchPersFltRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayStubs_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardFilledOrders_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetHistoryByClient_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptDetail_CS] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeHistory_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Job_Related_Info] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Job_Related_Info] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Job_Related_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Job_Related_Info] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Job_Related_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Job_Related_Info] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Job_Related_Info] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Job_Related_Info] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Job_Related_Info] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Job_Related_Info] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDeduction_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyClassIndex_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesType_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchCompFltRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentFiles_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompContact] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchResult_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeOccurrenceReason_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSVanAddOrderPerson] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSVanAddOrderPerson] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminActiveUsers_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSPermanentOrderPersonByOrderId_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spCandidatCallrpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersNoteTimeRange] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Time_Sheet_Type_Desc] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Time_Sheet_Type_Desc] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Time_Sheet_Type_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type_Desc] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Time_Sheet_Type_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type_Desc] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Time_Sheet_Type_Desc] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Time_Sheet_Type_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Time_Sheet_Type_Desc] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Time_Sheet_Type_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[View1] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[View1] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[View1] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructure_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyTypesByPermition_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTakerByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillCategory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantDocument_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalPayCycleExpData_Test1] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAltContactById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexFolder_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrderComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersChqHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCDeleteAll0] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompType_NonActive] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompType_NonActive] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompType_NonActive] TO [Staffing Edge] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnCountry_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompProf] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBFileToPersonFile_Copy] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderTypeGroupByOrderId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSecurityIsValidLogin_Check_old] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spJobGetDetails] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrder] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderNZeroPayRatePayStructure_Ge] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeDeptShifts_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersChqHistCurrent] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdPayL] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139Process_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnReportNoteCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportEmployee_new2] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeHours_Calc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spIncompOrderRpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeAttritionReason_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderClass_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSCustomGroup_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRun_UnExport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spJobGetSalesTypes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[View_Order_Header] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderWebPostedByCategory_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroupByCategoryId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminWebPostingSetting_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMarketingPersonInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeFromIP_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonIdByEmail_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Desc] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Desc] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Search_Match_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Desc] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Desc] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Desc] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Desc] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Desc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeRawSwipe_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantResume_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnRptNoteCode_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindGetSnoozeTime] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMemberGetSalesTypes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetMatchResultDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnProject_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderHeaderDescription_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteIDsForSearch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardHotlistReport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonActiveOrders_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompmatres] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelCustomerHours13weeks] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetSTVersionInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersAltCont] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAllMatchResultDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructure_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonFileTitle_Set] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Activity_Staff] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddNotePers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetHardCopyLoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNoteContact] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestExportData] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestExportData] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPerson_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Skill] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Skill] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Skill] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Skill] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Skill] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Skill] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Skill] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Skill] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Skill] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetErrorReport_RIM] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillBranch_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserAdminFunction_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMemberPersonInfoSettings_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSInsertOneTimesheet_Perm] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanySkill_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnRecruitmentType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReferenceQuestion_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnBusinessPotential_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompQuote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyName_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyCredit_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteGroupInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonISODetail_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetSTShifts] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSavePerson] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[imptable] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[imptable] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[imptable] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[imptable] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[imptable] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[imptable] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[imptable] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[imptable] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[imptable] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[imptable] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGetWkFigures] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Subvendor] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonOrder_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSDeleteTimeSheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetInput_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnReportLevelOfServiceSortingOptions_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalRunIDByYearWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompmat] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyLocation_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeComplexShiftWithStartEndTime_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Admin_Note_Codes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateTimeSheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonReferenceByHistoryId_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[ISO_Process_Required] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[ISO_Process_Required] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[ISO_Process_Required] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Process_Required] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[ISO_Process_Required] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Process_Required] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[ISO_Process_Required] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[ISO_Process_Required] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[ISO_Process_Required] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[ISO_Process_Required] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonChqHistoryDetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFile_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddMatchCriteria] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddGST] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDynamicSchenkerMoveOTforRun4] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFile_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicant_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBMemberFile_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonName_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantWorkHistory_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEAssignmentInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbycustTotals] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbycustTotals] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAttritionReason] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayStubOption_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnISOLevel_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroup_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkillCodeChange_Add] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[fnBill139ProcessYearweek] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreditRequestMemResult_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeTSCreation] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetLastPayment] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonOrderIdByClient_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderViewedByUser_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBPersonInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyProfileInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNewOrdersEnteredrpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetActivityNotes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMemberOnlineLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantSkill_Delete] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Skill_Desc] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Skill_Desc] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Skill_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Skill_Desc] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Skill_Desc] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Skill_Desc] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Skill_Desc] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Skill_Desc] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Skill_Desc] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Skill_Desc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUnsuitableCompany_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCModTimesheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadContact_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollROEBulk_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Van_Deductions] TO [Finance] AS [dbo]
GRANT INSERT ON [dbo].[Van_Deductions] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Van_Deductions] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[Van_Deductions] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Van_Deductions] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Van_Deductions] TO [yyu] AS [dbo]
GRANT INSERT ON [dbo].[Van_Deductions] TO [yyu] AS [dbo]
GRANT SELECT ON [dbo].[Van_Deductions] TO [yyu] AS [dbo]
GRANT UPDATE ON [dbo].[Van_Deductions] TO [yyu] AS [dbo]
GRANT SELECT ON [dbo].[Task_Priority] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPlainJobList] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPlainJobList] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPlainJobList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebPlainJobList] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactListDescription_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonChqHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkill_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAllNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFileById_Get] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_Hist] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_Hist] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Person_Work_Hist] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Admin_Reports] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTMemberTimesheetByDateRange_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSAddGST] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompCredit] TO [3nwiesner] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompCredit] TO [3shyndman] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompCredit] TO [3syhyndman] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompCredit] TO [Staffing Edge] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheetView] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheetView] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[TimeSheetView] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteCompDesc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeSTShifts_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnSubvendor_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompany] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonLoginInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonNew_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeReportEmp_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateAR] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonCompanyLocation_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayroll_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Medical_Status] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Medical_Status] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Medical_Status] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Medical_Status] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Medical_Status] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Medical_Status] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Medical_Status] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Medical_Status] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Medical_Status] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Medical_Status] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeCompanyDept_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalTimesheet_Refresh] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptDetail_CS_Smart] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDocument_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetOpenDeductionRpt] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRptDetailDay] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderHeaderDescription_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Type] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Type] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Type] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Type] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLeadHistory_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTTimesheet_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTaskFromEmail_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSChequeDelivery] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSChequeDelivery] TO [yyu] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Search_Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Company_Result] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Company_Result] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Search_Match_Company_Result] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Search_Match_Company_Result] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Search_Match_Company_Result] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Search_Match_Company_Result] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSGetChqHandoutRpt] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskByFilter_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveMPersRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddSamsungDeductionsToRun10] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPersSearchRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBIncidentHireDate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveMCond] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantFileTitle_Set] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_Registration_Interview] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Registration_Interview] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Registration_Interview] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Registration_Interview] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Registration_Interview] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Registration_Interview] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Registration_Interview] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Registration_Interview] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Registration_Interview] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Registration_Interview] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonMoreCompanyLocation_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyOrderActivePerson_Count] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayStubsDetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSAddSIN4Run10] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCWFViewAllNotes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderFile_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWorkFirstEarnings] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSTimesheetWithoutHours_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnORJBSkillBranchGroupDesc_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyProfileNote_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnUserViewedHistory_delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnProvinceByCountry_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderCompanyId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyLocation_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateCompSkills] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Business_Info] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteDesc_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAltContacts_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollBiweeklyStartdate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnObjectCanBeRemoved_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spIsInUserOldGroup] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrder_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkillCategories_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSkillOnlineRegCategories_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonChequeHistory_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTRemoveUser] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelPermPaymentRecvd] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spIsOrdPayrateZero] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnIndexTreeItems_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebAddNoteToPers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetRptInternalPers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spRemindGetDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[permstatusreport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchCompanyResultForPrint_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_SIC_Des] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_SIC_Des] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_SIC_Des] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Des] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_SIC_Des] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Des] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_SIC_Des] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_SIC_Des] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_SIC_Des] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_SIC_Des] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSkillsByOnlineCategory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBusinessInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTSearchCompByName] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompPerson] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Applicant_Info] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Comp_Tele] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Comp_Tele] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Comp_Tele] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Comp_Tele] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Comp_Tele] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Comp_Tele] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonWorkHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyWithLocation_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddAltContact] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardTempUnfilledOrdersByBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonInternal_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTCreateUser] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[TS_Customer_Group_Lookup] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminMemberLocationBranchManager_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyNonActiveTypes_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSavePay] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateWkHr] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBRegSetting_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNoteTimeRange] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLead_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCustomerListRptDetail] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalCustomer_Export] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnORJBSkillByCategory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPaystubRefusedEmail_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139Zone_Save] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[User_Admin_Function] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactList_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUnsuitableCompany_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderClass_Update] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonNameByUserIdWithOutCheck_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSRunControlInfo] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAvailableFromType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnReportTypeNote_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPerson_Add] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[How_Did_You_Hear_About_Us] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[How_Did_You_Hear_About_Us] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[How_Did_You_Hear_About_Us] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[How_Did_You_Hear_About_Us] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[How_Did_You_Hear_About_Us] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[How_Did_You_Hear_About_Us] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[How_Did_You_Hear_About_Us] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[How_Did_You_Hear_About_Us] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[How_Did_You_Hear_About_Us] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[How_Did_You_Hear_About_Us] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanySkills_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAISMustBeSentNotifi_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOverCreditLimit] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBLocationDescription_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAdminUpdateIndex] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteTask_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalExportControlInfo_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Location_Of_HardCopy] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Location_Of_HardCopy] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Location_Of_HardCopy] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Location_Of_HardCopy] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Location_Of_HardCopy] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Location_Of_HardCopy] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Location_Of_HardCopy] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Location_Of_HardCopy] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Location_Of_HardCopy] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Location_Of_HardCopy] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminMemberLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebMarketingComp] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAltContact_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdatePersCheque] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIGetExpenseType] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrdHead] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAcceptability_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnSalesRepByOrderId] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersPayrollInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonAvailableFrom_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLead_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportEMP] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyInvoiceOption_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveOrdMPersCond] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminCompanyDocumentForImport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDepartmentsByLocation_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCmnOLRProvinceByCountry_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersQuickNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteContactDateByCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPayStructure_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[repNewBusinessEnteredSortingOptions_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[ID_Presented] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[ID_Presented] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[ID_Presented] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ID_Presented] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[ID_Presented] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[ID_Presented] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[ID_Presented] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[ID_Presented] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[ID_Presented] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[ID_Presented] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyProfileNote_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Location_Lookup] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Location_Lookup] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Location_Lookup] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Location_Lookup] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Location_Lookup] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Location_Lookup] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Location_Lookup] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Location_Lookup] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Location_Lookup] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Location_Lookup] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPhoto_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddDoc] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSaveCompanyName] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardRecruitment_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayroll_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPersSwipeHrs] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetChequeTSCompany] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonContactList_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroupByCategoryId_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelGetReportList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderMaxID_Correct] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantRegistration_Confirm] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipePersonHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUnsuitableCompany_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserAvailableAdminFunction_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSOrderPersonByOrderId_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskForReminderByUser_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyFile_Add] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Verticals] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[Verticals] TO [Finance] AS [dbo]
GRANT UPDATE ON [dbo].[Verticals] TO [Finance] AS [dbo]
GRANT INSERT ON [dbo].[Verticals] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Verticals] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Verticals] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskPriority_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSMasterTS_Create] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestSpeed1] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Person_YearWeek] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_YearWeek] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_YearWeek] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_YearWeek] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSalesTypeById_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAdminNotesUsers] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSamsungBirthdates] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestExportData_test] TO [Finance] AS [dbo]
GRANT SELECT ON [dbo].[View_All_Note_Codes] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[User_Time] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[User_Time] TO [public] AS [dbo]
GRANT REFERENCES ON [dbo].[User_Time] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[User_Time] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[User_Time] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Edge_Index] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Edge_Index] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Edge_Index] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Edge_Index] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubVertInfo] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubVertInfo] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubVertInfo] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebGetSubVertInfo] TO [yyu] AS [dbo]
GRANT DELETE ON [dbo].[Company_Class_Staff_Type] TO [M-Team] AS [dbo]
GRANT INSERT ON [dbo].[Company_Class_Staff_Type] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Company_Class_Staff_Type] TO [M-Team] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Class_Staff_Type] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Class_Staff_Type] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Class_Staff_Type] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Class_Staff_Type] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Class_Staff_Type] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCAddOneTimesheet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTSecurityUserPassword_Reset] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Skill_desc_test] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Skill_desc_test] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Skill_desc_test] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Skill_desc_test] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelChequeDeliveryListing] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[GL_Accounts] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[GL_Accounts] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[GL_Accounts] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[GL_Accounts] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[GL_Accounts] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[GL_Accounts] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[GL_Accounts] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[GL_Accounts] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[GL_Accounts] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[GL_Accounts] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillGroup_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantBackButtonDuplicity_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminORJBSkillBranchGroup_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnGetOrderSalesRep] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddCommList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdateTSDetail] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdateTSDetail] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSUpdateTSDetail] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCreaditRequestCompanyInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskFilterCompanyByUser_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBankInfoHistory_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonTerminationNotice_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesTypeSkill_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonDetailRecord_Save] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Task] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDescription_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSInternalRun_Delete] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompStafForWizard] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportMAS] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Note_Codes] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Note_Codes] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Note_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Note_Codes] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Note_Codes] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Note_Codes] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Note_Codes] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Note_Codes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Note_Codes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Note_Codes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCListSkills] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Order_Header_Description] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Order_Header_Description] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Order_Header_Description] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header_Description] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Header_Description] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header_Description] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Order_Header_Description] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Order_Header_Description] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Header_Description] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Order_Header_Description] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyStaffMember_Get] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Other] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Other] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Company_Classification_Other] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Other] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Other] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Other] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Company_Classification_Other] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Company_Classification_Other] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Company_Classification_Other] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Company_Classification_Other] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonBill139TermNoteDate_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonInternalActive_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPayrollSent] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPayrollSent] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPayrollSent] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetPayrollSent] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantURL_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelChequeDeliveryList] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPersonISODetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantStatus_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTJobId_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelMatchPersRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNews] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNews] TO [FullAdmin] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNews] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWebSelectNews] TO [yyu] AS [dbo]
GRANT DELETE ON [dbo].[Person_Reference_Check] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Person_Reference_Check] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Person_Reference_Check] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Check] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Reference_Check] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Check] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Person_Reference_Check] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Person_Reference_Check] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Reference_Check] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Person_Reference_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPostedOnline_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDeleteMatCompSearchID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spPCExportEmp2Old] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetCompNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBIncidentData_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminMemberManager_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonCompanyName_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchPersonResult_SaveGet] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETStimeSheetByKey_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAdminDeleteIndex] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Reminder] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserTime_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserPasswordExpDate_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetByStartDate_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnSwipeDetailedCompanyShifts_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetAllAndAdminNoteCodes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditOrderWebPosted_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashBoardActiveOnOrderByBranch_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersInfo2Datatransfer_LastYear] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersInfo2Datatransfer_LastYear] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderAssignedRequired_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMemberGetOpenOrders] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderByKeyWord_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminUserTime_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOnlinePostingReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSTCreateUserAll] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMCLLocationsByMemberId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestBType] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spETSExportPayroll_new] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonProfile_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetStatusReport] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetStatusReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetStatusReport] TO [rgonder] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetStatusReport] TO [yyu] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETSRunIDByYearWeek_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkill_Add] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Person_Iso_Serv] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Person_Iso_Serv] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Person_Iso_Serv] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDetail_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminNoteCode_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonPayrollInfo_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnMatchCompanyResult_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteByIdRange_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUsePersNoteFilter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminOnlineSkillGroup_Add] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Order_Status_Description] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelClaimsListing] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spWorkPermitRpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteReminder_Search] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Screen_Identification] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Screen_Identification] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Screen_Identification] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Screen_Identification] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Screen_Identification] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Screen_Identification] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Screen_Identification] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Screen_Identification] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Screen_Identification] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Screen_Identification] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Users] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Users] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Users] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Users] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Users] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Users] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Users] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Users] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Users] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Users] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUpdateWorkHist] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelFromMatchPersRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDescription_Get] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Swipes] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Swipes] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Swipes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollPayType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPhoneByOrderId_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[sp_ExcelSwipesReport] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Credit_Class] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Credit_Class] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Credit_Class] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Credit_Class] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Credit_Class] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Credit_Class] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Credit_Class] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Credit_Class] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Credit_Class] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Credit_Class] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spMoveCreditOver] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spExcelEmployeeHowHeardAboutUsSummary] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyPrimaryLocation_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonSIN_Save] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Pay_Cycle] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Pay_Cycle] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Pay_Cycle] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Cycle] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Pay_Cycle] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Cycle] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Pay_Cycle] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Pay_Cycle] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Cycle] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Pay_Cycle] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderETTInfo_Check] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[fnBill139RiskType] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spUsePersNoteTimeFilter] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteFileById_Download] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderInternalPerson_Search] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonDocuments_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAdminSkillTree_Create] TO [public] AS [dbo]
GRANT DELETE ON [dbo].[Config] TO [FullAdmin] AS [dbo]
GRANT INSERT ON [dbo].[Config] TO [FullAdmin] AS [dbo]
GRANT REFERENCES ON [dbo].[Config] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Config] TO [FullAdmin] AS [dbo]
GRANT UPDATE ON [dbo].[Config] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Config] TO [M-Team] AS [dbo]
GRANT DELETE ON [dbo].[Config] TO [public] AS [dbo]
GRANT INSERT ON [dbo].[Config] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Config] TO [public] AS [dbo]
GRANT UPDATE ON [dbo].[Config] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spNewOrdersEnStatrpt] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPayrollEmploymentRecordDefaultValuesTest_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnLead_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteFromDistributionList_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFIReport] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonTypeGroupById_Get_old] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnDashboardStartReport_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnOrderPostedOnlineRequest_Submit] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spTestSpeed] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spFISaveExpense] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spGetOrderNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicant_Register] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPersonUserInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnApplicantSkill_Save] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnNoteFromContactDistributionList_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spAddPersNote] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnFEDocument_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbyofficetypecust] TO [Finance] AS [dbo]
GRANT EXECUTE ON [dbo].[profitbyofficetypecust] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[aging2] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnAuditPersonInfo_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnETTPersonTimesheetPrint_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyMaxID_Correct] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPaystubInvalidEmail_Process] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Info] TO [FullAdmin] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Info] TO [M-Team] AS [dbo]
GRANT SELECT ON [dbo].[Pay_Info] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSwipeGetRunID] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyDocument_Add] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnTaskReminder_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnWSIBMemberFileTitle_Set] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spDelMatchCompRes] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnCompanyMrgCalcSalesType_Get] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spSetCoststozero] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[stnPerson_Delete] TO [public] AS [dbo]
GRANT SELECT ON [dbo].[Vertical_Header] TO [public] AS [dbo]
GRANT EXECUTE ON [dbo].[spJobGetOpenJobs] TO [public] AS [dbo]
ALTER TABLE [dbo].[Applicant_History] ADD CONSTRAINT [DF_Applicant_History_ApplicantId] DEFAULT (newid()) FOR [ApplicantId]
ALTER TABLE [dbo].[SubVerticals] WITH CHECK ADD CONSTRAINT [FK_SUBVER_REF_VERTICALS] FOREIGN KEY([VerticalID])
REFERENCES [Verticals] ([VerticalID])
ALTER TABLE [dbo].[SubVerticals] CHECK CONSTRAINT [FK_SUBVER_REF_VERTICALS]
ALTER TABLE [dbo].[SubVerticals] WITH CHECK ADD CONSTRAINT [FK_SUBVERTICALS_REF_SKILL] FOREIGN KEY([SkillCode])
REFERENCES [Skill] ([SkillCode])
ALTER TABLE [dbo].[SubVerticals] CHECK CONSTRAINT [FK_SUBVERTICALS_REF_SKILL]
ALTER TABLE [dbo].[Sales_Lead_Info] ADD CONSTRAINT [DF__Sales_Lea__LeadI__6FC04DC4] DEFAULT (newid()) FOR [LeadId]
ALTER TABLE [dbo].[Company_Person_Recruitment] ADD CONSTRAINT [DF_Company_Person_Recruitment_RowNum] DEFAULT (newid()) FOR [RowNum]
ALTER TABLE [dbo].[Person_Work_History] WITH NOCHECK ADD CONSTRAINT [FKPerson_Work_History_1] FOREIGN KEY([PersonId])
REFERENCES [Person_Identification] ([PersonId])
ALTER TABLE [dbo].[Person_Work_History] CHECK CONSTRAINT [FKPerson_Work_History_1]
ALTER TABLE [dbo].[Person_Work_History] WITH CHECK ADD CONSTRAINT [FKPerson_Work_History_4] FOREIGN KEY([EmployerId], [LocationCode])
REFERENCES [Company_Location] ([CompanyId], [LocationCode])
ALTER TABLE [dbo].[Person_Work_History] CHECK CONSTRAINT [FKPerson_Work_History_4]
ALTER TABLE [dbo].[Contact_Distribution_List_Description] ADD DEFAULT ('I') FOR [Status]
ALTER TABLE [dbo].[Sales_Lead] ADD CONSTRAINT [DF_Sales_Lead_LeadId] DEFAULT (newid()) FOR [LeadId]
ALTER TABLE [dbo].[Sales_Lead_Contact] ADD CONSTRAINT [DF__Sales_Lea__Conta__71A89636] DEFAULT (newid()) FOR [ContactId]
ALTER TABLE [dbo].[Person_Contact_Info] ADD CONSTRAINT [dfProvince] DEFAULT ('ON') FOR [ProvinceCode]
ALTER TABLE [dbo].[Person_Contact_Info] ADD CONSTRAINT [dfCountry] DEFAULT ('CA') FOR [CountryCode]
ALTER TABLE [dbo].[Person_Identification] ADD CONSTRAINT [DF__person_id__NotAv__41A3B202] DEFAULT (getdate()) FOR [NotAvailableTill]
ALTER TABLE [dbo].[Person_Identification] ADD CONSTRAINT [DF__person_id__Avail__4297D63B] DEFAULT ('01/01/2050') FOR [AvailableTill]
ALTER TABLE [dbo].[Person_Unsuitable_Company] ADD CONSTRAINT [DF_Person_Unsuitable_Company_ModifiedOn] DEFAULT (getdate()) FOR [ModifiedOn]
ALTER TABLE [dbo].[Person_Unsuitable_Company] ADD CONSTRAINT [DF_Person_Unsuitable_Company_Deleted] DEFAULT ('N') FOR [Deleted]
ALTER TABLE [dbo].[Vertical_News] WITH CHECK ADD CONSTRAINT [FK_V_News_REF_VERTICALS] FOREIGN KEY([VerticalID])
REFERENCES [Verticals] ([VerticalID])
ALTER TABLE [dbo].[Vertical_News] CHECK CONSTRAINT [FK_V_News_REF_VERTICALS]
ALTER TABLE [dbo].[Order_Header] WITH NOCHECK ADD CONSTRAINT [CK_Order_Header_NumOfPeople] CHECK (([NumOfPeople] > 0))
ALTER TABLE [dbo].[Order_Header] CHECK CONSTRAINT [CK_Order_Header_NumOfPeople]
ALTER TABLE [dbo].[ORJB_Skill_Branch] ADD CONSTRAINT [DF_ORJB_Skill_Branch_BranchGroupId] DEFAULT ((1)) FOR [BranchGroupId]
ALTER TABLE [dbo].[ORJB_Skill_Branch] ADD CONSTRAINT [DF_ORJB_Skill_Branch_OrderNum] DEFAULT ((1)) FOR [OrderNum]
ALTER TABLE [dbo].[General_Header] WITH CHECK ADD CONSTRAINT [FK_GHeader_REF_HEADER_TYPE] FOREIGN KEY([HeaderType])
REFERENCES [Header_Type] ([HeaderType])
ALTER TABLE [dbo].[General_Header] CHECK CONSTRAINT [FK_GHeader_REF_HEADER_TYPE]
ALTER TABLE [dbo].[Province] ADD CONSTRAINT [DF_Province_CountryCode] DEFAULT ('CA') FOR [CountryCode]
ALTER TABLE [dbo].[Person_Profile] WITH NOCHECK ADD CONSTRAINT [FK_Person_Profile_REF_Person_Identification] FOREIGN KEY([PersonID])
REFERENCES [Person_Identification] ([PersonId])
ALTER TABLE [dbo].[Person_Profile] CHECK CONSTRAINT [FK_Person_Profile_REF_Person_Identification]
ALTER TABLE [dbo].[Company_Classification_Staff] WITH CHECK ADD CONSTRAINT [FKCompany_Class_Staff_2] FOREIGN KEY([ClassCounter])
REFERENCES [Company_Index_Description] ([ClassCounter])
ALTER TABLE [dbo].[Company_Classification_Staff] CHECK CONSTRAINT [FKCompany_Class_Staff_2]
ALTER TABLE [dbo].[Order_Person_Recruitment] ADD CONSTRAINT [DF_Order_Person_Recruitment_RowNum] DEFAULT (newid()) FOR [RowNum]
ALTER TABLE [dbo].[Company_Header] WITH CHECK ADD CONSTRAINT [FK_CompHeader_REF_Comp_Master_ID] FOREIGN KEY([CompanyId])
REFERENCES [Company_Master_ID] ([CompanyId])
ALTER TABLE [dbo].[Company_Header] CHECK CONSTRAINT [FK_CompHeader_REF_Comp_Master_ID]
ALTER TABLE [dbo].[Van_Deductions] WITH CHECK ADD CONSTRAINT [FK_Van_Deductions_Company_Master_ID] FOREIGN KEY([CompanyID])
REFERENCES [Company_Master_ID] ([CompanyId])
ALTER TABLE [dbo].[Van_Deductions] CHECK CONSTRAINT [FK_Van_Deductions_Company_Master_ID]
ALTER TABLE [dbo].[Van_Deductions] WITH CHECK ADD CONSTRAINT [FK_Van_Deductions_Order_Pay_Structure] FOREIGN KEY([OrderID], [PayStructureCounter])
REFERENCES [Order_Pay_Structure] ([OrderId], [PayStructureCounter])
ALTER TABLE [dbo].[Van_Deductions] CHECK CONSTRAINT [FK_Van_Deductions_Order_Pay_Structure]
ALTER TABLE [dbo].[Van_Deductions] WITH NOCHECK ADD CONSTRAINT [FK_Van_Deductions_Person_Identification] FOREIGN KEY([PersonID])
REFERENCES [Person_Identification] ([PersonId])
ALTER TABLE [dbo].[Van_Deductions] CHECK CONSTRAINT [FK_Van_Deductions_Person_Identification]
ALTER TABLE [dbo].[Van_Deductions] WITH CHECK ADD CONSTRAINT [FK_Van_Deductions_TimeSheets] FOREIGN KEY([AppYearWeek], [AppRunID], [AppTimesheetID])
REFERENCES [TimeSheets] ([YearWeek], [RunId], [TimeSheetId])
ALTER TABLE [dbo].[Van_Deductions] CHECK CONSTRAINT [FK_Van_Deductions_TimeSheets]
ALTER TABLE [dbo].[ETS_Timesheets_Extra_Info] ADD CONSTRAINT [DF_ETS_Timesheets_Extra_Info_Transferred] DEFAULT ('N') FOR [Transferred]
ALTER TABLE [dbo].[Applicant_Info] ADD CONSTRAINT [DF_Applicant_info_ApplicantId] DEFAULT (newid()) FOR [ApplicantId]
ALTER TABLE [dbo].[Applicant_Status] ADD CONSTRAINT [DF_Applicant_Status_ApplicantId] DEFAULT (newid()) FOR [ApplicantId]
ALTER TABLE [dbo].[Verticals] WITH CHECK ADD CONSTRAINT [FK_VERTICALS_REF_SKILL] FOREIGN KEY([SkillCode])
REFERENCES [Skill] ([SkillCode])
ALTER TABLE [dbo].[Verticals] CHECK CONSTRAINT [FK_VERTICALS_REF_SKILL]
ALTER TABLE [dbo].[Config] ADD DEFAULT ('MemberID+''-''+@RunID+''-''+left(Lastname,5)') FOR [ChqSorting]
ALTER TABLE [dbo].[Vertical_Header] WITH CHECK ADD CONSTRAINT [FK_V_Header_REF_VERTICALS] FOREIGN KEY([VerticalID])
REFERENCES [Verticals] ([VerticalID])
ALTER TABLE [dbo].[Vertical_Header] CHECK CONSTRAINT [FK_V_Header_REF_VERTICALS]