View: dbo.Privileges_SbprClientAccess_View
View definition
-- Privileges for SBPR Client Access.
CREATE VIEW dbo.Privileges_SbprClientAccess_View
AS
SELECT
privilege_KEY = P.privilege_KEY
FROM
dbo.Privilege P
WHERE privilege_KEY IN (
0, -- ACS
1, -- ACS_File
2, -- ACS_File_Import
1028, -- ACS_File_Import_Spreadsheet
1029, -- ACS_File_Import_Spreadsheet_COA
1031, -- ACS_File_Import_Spreadsheet_Emp
1086, -- ACS_File_Import_Spreadsheet_1095C
10, -- ACS_File_Exp
1102, -- ACS_File_Exp_Transactions
1104, -- ACS_File_Exp_1095C
1159, -- ACS_File_Exp_QuickBooks
22, -- ACS_File_PrintRep
1057, -- ACS_File_CopySBPRCLT
3, -- ACS_Actions
1082, -- ACS_Actions_AnalyzeCliAct
1101, -- ACS_Actions_AnalyzeCliAct_EmpEarnings
1158, -- ACS_Actions_AnalyzeCliAct_CliPaySchedule
4, -- ACS_Setup
17, -- ACS_Setup_Client
82, -- ACS_Setup_Client_Main
183, -- ACS_Setup_Client_Main_View
409, -- ACS_Setup_Client_Main_Edit
83, -- ACS_Setup_Client_PrInfo
427, -- ACS_Setup_Client_PrInfo_View
428, -- ACS_Setup_Client_PrInfo_Edit
1062, -- ACS_Setup_Client_PrInfo_PrSchedules
1063, -- ACS_Setup_Client_PrInfo_PrSchedules_View
1064, -- ACS_Setup_Client_PrInfo_PrSchedules_Add
1065, -- ACS_Setup_Client_PrInfo_PrSchedules_Edit
1066, -- ACS_Setup_Client_PrInfo_PrSchedules_Del
84, -- ACS_Setup_Client_PrTax
435, -- ACS_Setup_Client_PrTax_View
436, -- ACS_Setup_Client_PrTax_Edit
1209, -- ACS_Setup_Client_1099Form
1210, -- ACS_Setup_Client_1099Form_View
1211, -- ACS_Setup_Client_1099Form_Edit
173, -- ACS_Setup_Client_WorkerComp
451, -- ACS_Setup_Client_WorkerComp_View
452, -- ACS_Setup_Client_WorkerComp_Edit
1090, -- ACS_Setup_Client_ACA
1091, -- ACS_Setup_Client_ACA_View
1092, -- ACS_Setup_Client_ACA_Edit
1194, -- ACS_Setup_Client_Covid19Act
1195, -- ACS_Setup_Client_Covid19Act_View
1196, -- ACS_Setup_Client_Covid19Act_Edit
219, -- ACS_Setup_Client_Integrate
461, -- ACS_Setup_Client_Integrate_View
462, -- ACS_Setup_Client_Integrate_Edit
40, -- ACS_Setup_COA
222, -- ACS_Setup_COA_View
223, -- ACS_Setup_COA_Add
595, -- ACS_Setup_COA_Edit
224, -- ACS_Setup_COA_Del
20, -- ACS_Setup_UserPref
6, -- SBPR
7, -- SBPR_File
1043, -- SBPR_File_Import
1044, -- SBPR_File_Import_Spreadsheet
1045, -- SBPR_File_Import_Spreadsheet_Emp
1116, -- SBPR_File_Import_Spreadsheet_1095C
1117, -- SBPR_File_Exp
1118, -- SBPR_File_Exp_1095C
1160, -- SBPR_File_Exp_QuickBooks
8, -- SBPR_Actions
848, -- SBPR_Actions_PrChk
849, -- SBPR_Actions_PrChk_View
993, -- SBPR_Actions_PrChk_OnDemand
343, -- SBPR_Actions_PrChk_RatesAmts
994, -- SBPR_Actions_PrChk_PreviewPayroll
822, -- SBPR_Actions_PrChk_EditEmpFedAmt
823, -- SBPR_Actions_PrChk_EditEmpFedAmt_FICASS
824, -- SBPR_Actions_PrChk_EditEmpFedAmt_FICAMED
965, -- SBPR_Actions_PrChk_EditEmpFedAmt_FICAMED2
825, -- SBPR_Actions_PrChk_EditEmpFedAmt_FIT
989, -- SBPR_Actions_PrChk_EditEmpFedAmt_SIT
990, -- SBPR_Actions_PrChk_EditEmpFedAmt_Local
850, -- SBPR_Actions_PrChk_EditEmpFedAmt_Employer
967, -- SBPR_Actions_PrChk_Submit
1061, -- SBPR_Actions_PrChk_Del
1077, -- SBPR_Actions_PrChk_EnterHWCheck
1109, -- SBPR_Actions_BatchHWChecks
1110, -- SBPR_Actions_BatchHWChecks_View
1111, -- SBPR_Actions_BatchHWChecks_PreviewPayroll
1112, -- SBPR_Actions_BatchHWChecks_EnterBatch
1113, -- SBPR_Actions_BatchHWChecks_Del
-- 1114, -- SBPR_Actions_BatchHWChecks_GenLiab Removed for 2016.1.0 release.
9, -- SBPR_Setup
174, -- SBPR_Setup_Client
243, -- SBPR_Setup_Client_PrInfo
429, -- SBPR_Setup_Client_PrInfo_View
430, -- SBPR_Setup_Client_PrInfo_Edit
1067, -- SBPR_Setup_Client_PrInfo_PrSchedules
1068, -- SBPR_Setup_Client_PrInfo_PrSchedules_View
1069, -- SBPR_Setup_Client_PrInfo_PrSchedules_Add
1070, -- SBPR_Setup_Client_PrInfo_PrSchedules_Edit
1071, -- SBPR_Setup_Client_PrInfo_PrSchedules_Del
245, -- SBPR_Setup_Client_PrTax
437, -- SBPR_Setup_Client_PrTax_View
438, -- SBPR_Setup_Client_PrTax_Edit
1212, -- SBPR_Setup_Client_1099Form
1213, -- SBPR_Setup_Client_1099Form_View
1214, -- SBPR_Setup_Client_1099Form_Edit
175, -- SBPR_Setup_Client_WorkerComp
453, -- SBPR_Setup_Client_WorkerComp_View
454, -- SBPR_Setup_Client_WorkerComp_Edit
1093, -- SBPR_Setup_Client_ACA
1094, -- SBPR_Setup_Client_ACA_View
1095, -- SBPR_Setup_Client_ACA_Edit
1197, -- SBPR_Setup_Client_Covid19Act
1198, -- SBPR_Setup_Client_Covid19Act_View
1199, -- SBPR_Setup_Client_Covid19Act_Edit
1054, -- SBPR_Setup_BankSBPRCLT
1055, -- SBPR_Setup_BankSBPRCLT_View
1056, -- SBPR_Setup_BankSBPRCLT_Add
50, -- SBPR_Setup_Dept
276, -- SBPR_Setup_Dept_View
277, -- SBPR_Setup_Dept_Add
592, -- SBPR_Setup_Dept_Edit
278, -- SBPR_Setup_Dept_Del
51, -- SBPR_Setup_PrItem
101, -- SBPR_Setup_PrItem_Main
197, -- SBPR_Setup_PrItem_Main_View
198, -- SBPR_Setup_PrItem_Main_Add
354, -- SBPR_Setup_PrItem_Main_Edit
199, -- SBPR_Setup_PrItem_Main_Del
102, -- SBPR_Setup_PrItem_TaxExempt
355, -- SBPR_Setup_PrItem_TaxExempt_View
356, -- SBPR_Setup_PrItem_TaxExempt_Edit
508, -- SBPR_Setup_PrItem_SpecTiming
509, -- SBPR_Setup_PrItem_SpecTiming_View
510, -- SBPR_Setup_PrItem_SpecTiming_Edit
164, -- SBPR_Setup_PrItem_WorkerComp
357, -- SBPR_Setup_PrItem_WorkerComp_View
358, -- SBPR_Setup_PrItem_WorkerComp_Edit
49, -- SBPR_Setup_AccBen
181, -- SBPR_Setup_AccBen_Main
194, -- SBPR_Setup_AccBen_Main_View
195, -- SBPR_Setup_AccBen_Main_Add
353, -- SBPR_Setup_AccBen_Main_Edit
196, -- SBPR_Setup_AccBen_Main_Del
182, -- SBPR_Setup_AccBen_WorkerComp
351, -- SBPR_Setup_AccBen_WorkerComp_View
352, -- SBPR_Setup_AccBen_WorkerComp_Edit
52, -- SBPR_Setup_Emp
106, -- SBPR_Setup_Emp_Main
285, -- SBPR_Setup_Emp_Main_View
286, -- SBPR_Setup_Emp_Main_Add
518, -- SBPR_Setup_Emp_Main_Edit
287, -- SBPR_Setup_Emp_Main_Del
107, -- SBPR_Setup_Emp_Personal
520, -- SBPR_Setup_Emp_Personal_View
521, -- SBPR_Setup_Emp_Personal_Edit
108, -- SBPR_Setup_Emp_AccBen
524, -- SBPR_Setup_Emp_AccBen_View
525, -- SBPR_Setup_Emp_AccBen_Edit
109, -- SBPR_Setup_Emp_PyrlItem
511, -- SBPR_Setup_Emp_PyrlItem_View
528, -- SBPR_Setup_Emp_PyrlItem_Edit
512, -- SBPR_Setup_Emp_PyrlItem_Settings
513, -- SBPR_Setup_Emp_PyrlItem_Settings_Main
514, -- SBPR_Setup_Emp_PyrlItem_Settings_TaxExp
515, -- SBPR_Setup_Emp_PyrlItem_Settings_SpecTiming
516, -- SBPR_Setup_Emp_PyrlItem_Settings_WorkerComp
110, -- SBPR_Setup_Emp_PyrlTax
531, -- SBPR_Setup_Emp_PyrlTax_View
532, -- SBPR_Setup_Emp_PyrlTax_Edit
622, -- SBPR_Setup_Emp_PyrlTax_AdjTaxWage
547, -- SBPR_Setup_Emp_PyrlTax_WageExempt
111, -- SBPR_Setup_Emp_DirDep
535, -- SBPR_Setup_Emp_DirDep_View
536, -- SBPR_Setup_Emp_DirDep_Edit
472, -- SBPR_Setup_Emp_WorkerComp
539, -- SBPR_Setup_Emp_WorkerComp_View
540, -- SBPR_Setup_Emp_WorkerComp_Edit
1079, -- SBPR_Setup_Emp_Event
235, -- SBPR_Setup_Emp_CustFld
543, -- SBPR_Setup_Emp_CustFld_View
544, -- SBPR_Setup_Emp_CustFld_Edit
606, -- SBPR_Setup_Emp_EditMult
53, -- SBPR_Setup_EmpTmpl
121, -- SBPR_Setup_EmpTmpl_Main
288, -- SBPR_Setup_EmpTmpl_Main_View
289, -- SBPR_Setup_EmpTmpl_Main_Add
519, -- SBPR_Setup_EmpTmpl_Main_Edit
290, -- SBPR_Setup_EmpTmpl_Main_Del
122, -- SBPR_Setup_EmpTmpl_Personal
522, -- SBPR_Setup_EmpTmpl_Personal_View
523, -- SBPR_Setup_EmpTmpl_Personal_Edit
123, -- SBPR_Setup_EmpTmpl_AccBen
526, -- SBPR_Setup_EmpTmpl_AccBen_View
527, -- SBPR_Setup_EmpTmpl_AccBen_Edit
124, -- SBPR_Setup_EmpTmpl_PyrlItem
529, -- SBPR_Setup_EmpTmpl_PyrlItem_View
530, -- SBPR_Setup_EmpTmpl_PyrlItem_Edit
549, -- SBPR_Setup_EmpTmpl_PyrlItem_Settings
550, -- SBPR_Setup_EmpTmpl_PyrlItem_Settings_Main
551, -- SBPR_Setup_EmpTmpl_PyrlItem_Settings_TaxExp
150, -- SBPR_Setup_EmpTmpl_PyrlItem_Settings_SpecTiming
125, -- SBPR_Setup_EmpTmpl_PyrlTax
533, -- SBPR_Setup_EmpTmpl_PyrlTax_View
534, -- SBPR_Setup_EmpTmpl_PyrlTax_Edit
548, -- SBPR_Setup_EmpTmpl_PyrlTax_WageExempt
126, -- SBPR_Setup_EmpTmpl_DirDep
537, -- SBPR_Setup_EmpTmpl_DirDep_View
538, -- SBPR_Setup_EmpTmpl_DirDep_Edit
473, -- SBPR_Setup_EmpTmpl_WorkerComp
541, -- SBPR_Setup_EmpTmpl_WorkerComp_View
542, -- SBPR_Setup_EmpTmpl_WorkerComp_Edit
236, -- SBPR_Setup_EmpTmpl_CustFld
545, -- SBPR_Setup_EmpTmpl_CustFld_View
546) -- SBPR_Setup_EmpTmpl_CustFld_Edit