Real World
Dashboards + Views
Tables
Python Process
People
100

We cannot push a release from staging to production until this day of the week

Thursday

100

Being a consultant I used this dashboard at least once a week

Timesheet Dashboard

100
When there is an issue with the timesheet configuration - the issue normally stems from this table

What is Contract

100

This script reminds consultants to submit their timesheets

remind_consultant_ts

100

This person is in charge of payroll for all non 3rd party contracts

Who is Gabby

200

A consultant emails that their timesheet is not visible in the portal - what do you do? 

create a new timesheet for them

200

When I get a new deal - I put the information into this dashboard

Contract Dashboard

200

When releasing a new release - we need to check this table because of its heavy reliance on javascript

What is Timesheet Detail

200

This script closes out contracts when they are past their end date

manage_contracts

200

This person is in charge of all 3p contracts

Who is Hayley

300

Gabby calls and says she cant access the attachment from the timesheet portal. What do you do?

Call Olha

300

David uses this dashboard once a month to collect money for his fathers empire

Invoice Dashboard

300

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

300

This script creates new payroll period dates and new timesheets for all consultants

timesheet management

300
This person runs all the invoices for Atlantic Partners

Who is David Gang

400

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

400

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

400

We use this table to insert all the timesheet detail ids and the bill rates for customer invoicing

What is Customer Invoice Line Timesheet

400

This script pushes the customer invoices to quickbooks

qb_invoice_push

400

This person is good friends with Monroe and is notorious for over promising. He is known for scope creep

Who is Warren Wright

500

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. 

500

This tracks how many people we've had to remind to input their information so they can get paid

Email Consultants
500

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

500

This script creates the user name and password and sends out the email to the new consultant

consultant_experience

500

This person is one of the main recruiters who is a grumpy old man

Who is Jim Goldfarb