Real World
We cannot push a release from staging to production until this day of the week
Thursday
Being a consultant I used this dashboard at least once a week
Timesheet Dashboard
What is Contract
This script reminds consultants to submit their timesheets
remind_consultant_ts
This person is in charge of payroll for all non 3rd party contracts
Who is Gabby
A consultant emails that their timesheet is not visible in the portal - what do you do?
create a new timesheet for them
When I get a new deal - I put the information into this dashboard
Contract Dashboard
When releasing a new release - we need to check this table because of its heavy reliance on javascript
What is Timesheet Detail
This script closes out contracts when they are past their end date
manage_contracts
This person is in charge of all 3p contracts
Who is Hayley
Gabby calls and says she cant access the attachment from the timesheet portal. What do you do?
Call Olha
David uses this dashboard once a month to collect money for his fathers empire
Invoice Dashboard
There are 3 Parts of the Customer Invoice: The Line Item, The Perm Placements and this table that gets the expense information
What is Invoice Adjustments
This script creates new payroll period dates and new timesheets for all consultants
timesheet management
Who is David Gang
The emails have not been running for the past few weeks. You just notice now. What do you do?
Reach out to Kevin to reach out to their internal team
This Dashboard was supposed to be rolled out to 10 people - but is only used by one grumpy old man to view his commissions
Recruiter Dashboard
We use this table to insert all the timesheet detail ids and the bill rates for customer invoicing
What is Customer Invoice Line Timesheet
This script pushes the customer invoices to quickbooks
qb_invoice_push
This person is good friends with Monroe and is notorious for over promising. He is known for scope creep
Who is Warren Wright
At what point do you get Eric involved in Atlantic Partners
Never... Always go to alex and ask him for help - then call corey while hes in class- and finally call Eric.
This tracks how many people we've had to remind to input their information so they can get paid
When a consultant forgets to input a timesheet - a python program kicks off, emails the consultant a reminder and inserts a record into this table
What is Timesheet Reach Out
This script creates the user name and password and sends out the email to the new consultant
consultant_experience
This person is one of the main recruiters who is a grumpy old man
Who is Jim Goldfarb