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`