vpvi-39 - microsoft...vpvi-39: building a customization palace on vision’s foundation ward slager,...
TRANSCRIPT
![Page 1: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/1.jpg)
VPVI-39:Building a Customization Palace on Vision’s Foundation
Ward Slager, Technical Associates
![Page 2: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/2.jpg)
WARD SLAGER MSME, MDIV, OSHA30
40 years > Educator: Undergrad Physics, Engineering
Engineer: Alternate energy; USAF tech manuals
Project Manager: Pulp & Paper, Consumer products
Corporate Safety Manager (Engineering & Construction)
IT: Enterprise software support
Procure/deploy Sema4 - 1999
Migrate to Deltek Vision - 2010 (now 7.6, CU41)
Upgrade to Vantagepoint - 2020
INTRO
![Page 3: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/3.jpg)
“VISION” A VISION CUSTOM APP / Report FOR EVERY CORPORATE NEED
STRATEGY Four main concepts:
> What is my data and who needs it?
> How do I build a custom APP / Report? (by example)
> What needs aren’t “out of the box”? (i.e. custom)
> What magic makes customizations fast and friendly?
MOTIVATION Be KINGS/QUEENS of the PALACE as well as EXPERTS at your office.
OVERVIEW
![Page 4: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/4.jpg)
FEES, REIMBURSABLES, CONSULTANTSProject “detail” from Employees (timesheets, expense reports) & Vendors (POs, invoices)
HUMAN RESOURCES, RECRUITING, PAYROLL, PURCHASING
PROJECTSPROJECTS << PHASES << TASKS
Engineering / Supervision / LaborResource Plan (human & material); Execution: Budget, Schedule, Quality, Safety
CLIENT / PROJECT MANAGERS
Clients, contracts;
Project status (RPC, detail/summaries);
Accounts Receivable
BUSINESS MANAGER
& ACCOUNTING
Weekly, Monthly, Quarterly, Annual Cycles
CORPORATEFinancials
> What is my data and who needs it? DATA PYRAMID
For example:
![Page 5: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/5.jpg)
> How do I build a custom APP / Report?
DESCRIBE Respond to User(s) need: Write a “Spec” & identify Resources
DIAGRAM Detail the process in a Diagram: Input => Process => Output
DETAIL Vision - User Defined Components (UDC)
MSoft - SQL Server Management Studio (SSMS)
Vision - Scheduled WorkFlows (SWF)
Vision - Screen Designer
DEPLOY TEST, ERROR TRAP, TRAIN , TRY IT OUT, TWEAK
LET’S DO IT!!
![Page 6: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/6.jpg)
DESCRIBE! PayrollWrite a Spec …
1. Validate an employee’s SOCIAL SECURITY NUMBER
2. Validate spelling of an employee’s NAME
3. Validate easily, quickly AND obtain an OFFICIAL RECORD.
Kim from Payroll calls or emails you and says,
Ward, I desperately need 100% accurate employee datafor income tax reporting and payment … I need to
![Page 7: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/7.jpg)
DESCRIBE!
As you talk, she also says something very helpful:
I think SSA has something that helps do thisIF I can get them our data from Vision …
Collaboration is a MUST for success of ALL Customizations!
… Identify Resources
![Page 8: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/8.jpg)
DESCRIBE!… Identify Resources
SSN eVerify
https://www.ssa.gov/bso/bsowelcome.htm
![Page 9: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/9.jpg)
DIAGRAM
Input
=> Process
=> Output
Vision Custom App:
SSNVS eVerify
Enter Date Hired,
on or after
Payroll Administrator
navigate to
Payroll >> SSNVS eVerify tab;
Search for PY
REFRESH
YesData incorrect or
missing?
Stored Procedure
Updates grid
No
Correct / Add
Employee data
Export to Excel
Correct
Employee data
Download
& Review Results
Copy / Paste
Into .prn Template
Verification Failed?
BSO Verification
Upload to
SSO BSO SSNVS
Next Day
Yes
No
Store BSO download
In EE records
![Page 10: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/10.jpg)
Build the custom APP DETAIL
User Defined Components
. . . . . . . . . . Info Center + Tab(s) + Field(s) + Grid(s)
Sequel Server Management Studio
. . . . . . . . . . SQLs + Tables => Stored Procedures
Scheduled WorkFlows
. . . . . . . . . . . Stored Procedures
Screen Designer. . UDCs + Workflow Buttons + Labels
![Page 11: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/11.jpg)
DETAIL
UDCs
- Grid
WHEN COMPLETE
Tip:
Standardize
UDC names
TACG_IC_TAB_TITLE/CAPTION
![Page 12: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/12.jpg)
DETAIL
SSMS: SQL
Stored Procedure
Custom Field
Custom Grid
Tip: Comment
on essentials
Tip: “Enter”
to separate
lines for clarity
Tip:
Standardize
S.P. names
TASP_IC_TAB_ACTION
![Page 13: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/13.jpg)
DETAIL
SWF
TASP …
WHEN COMPLETE
![Page 14: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/14.jpg)
DETAIL
Screen
Designer
UDCs
Grid
Field
Workflow Button
SWF
WHEN COMPLETE
(VARIOUS “TOOLS”)
![Page 15: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/15.jpg)
DEPLOY
TEST (ERROR TRAP)
TRAIN HOW-TO
USERS TRY
TWEAK(!)
UPLOAD TO SSO-BSO
RESULTS FROM SSO-BSO
![Page 16: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/16.jpg)
WHO CAN SEE AND TO USE THIS APP / REPORT?
A GENTLE REMINDER ABOUT SECURITY
> ROLE SETTINGS – CHECK Info Centers; ADD Tabs
> SCREEN DESIGNER – SET LOCKED / HIDDEN ROLES
--Set for each UDC & entire grid OR individual columns
DEPLOY
![Page 17: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/17.jpg)
What other needs aren’t “out of the box”? UDICS!
12 User Defined Info Centers => 100+ tabs (“APP”s, Reports)
Project
![Page 18: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/18.jpg)
Project Mgmt
REPORTS
EXAMPLE
PROJECT
SUMMARIES
Fields
Workflow Button
Grids
![Page 19: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/19.jpg)
A FEW “NOT-OUT-OF-THE-BOX” CUSTOMIZATION EXAMPLES
ACA HEALTH INSURANCE TRACKING REPORT
![Page 20: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/20.jpg)
ANOTHER “NOT-OUT-OF-THE-BOX” CUSTOMIZATION
MOBILE TIMECLOCK INTEGRATION APP
![Page 21: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/21.jpg)
AND ANOTHER “NOT-OUT-OF-THE-BOX” CUSTOMIZATION
OSHA SAFETY TRAINING TRACKING APPTip:
Link to EE’s
supporting
documents
![Page 22: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/22.jpg)
MORE MAGIC TIPS
“FEEDBACK” FIELDS
![Page 23: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/23.jpg)
MORE MAGIC TIPS
“USER FRIENDLY”
GRID SORTING
1- ADD SORTORDER
COLUMN TO GRID &CHECK SORT - UDC
3- HIDE SORTORDER
COLUMN IN SCREEN DESIGNER
2- ADD SORTORDER
TO SQL.
![Page 24: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/24.jpg)
MORE MAGIC TIPS
“WHAT ARE MY OPTIONS” FOCUSED SQL SEARCHES:
![Page 25: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/25.jpg)
MORE MAGIC TIPS
“FOR YOUR EYES ONLY” SECURE USER ACCESS:
TO LIMIT WORKFLOW EXECUTION TO SPECIFIC USER(S),
USE IF & DBO.FW_GETUSERNAME() IN STORED PROCEDURES
![Page 27: VPVI-39 - Microsoft...VPVI-39: Building a Customization Palace on Vision’s Foundation Ward Slager, Technical Associates WARD SLAGER MSME, MDIV, OSHA30 visionsupport@technicalassociates.com](https://reader034.vdocuments.us/reader034/viewer/2022042402/5f10bb717e708231d44a8ca2/html5/thumbnails/27.jpg)