PAVE
PETS
ESU History
SQL & Excel
Provider Types
100

What is PAVE

 Provider Application and Validation for Enrollment 

100

What is PETS?

Provider Enrollment Tracking System

100

How many times has the ESU team name changed

3 0r 4

100

SQL stands for

Structured Query Language


100

PT 22 

Physician Group

200

How many userIDs are active in PAVE PROD system

966

200

The Document # field lies in which 

AssignmentLog 

200

Who was the last team mgr?

Joshua P


200
Excel can be automated through?

VBA (Visual Basics for Apps)

200

PT 26

Physician & Osteopaths

300

How many userIDs are active in PAVE UAT system

2052

300

Paper Application provider type information are captured in which PETS table?

Cases

300

What was ESU last team Halloween costume theme 

Graveyard

300

What is the interface for users using the data warehouse and MS Access DB

Graphical User Interface

300

PT 9

Clinical Labs


400

Who is the third-party partner of PAVE with DHCS

Digital Harbor

400

What team/unit has the sole responsibility for PETS edits?

ESU


400

Which of the other units/teams in PED are under ESU's mgmt?

TSU

400
Which of these three systems: PETS, PAVE, Data Warehouse, doesn't permit users directly query via SQL

Data Warehouse

400

PT 30

Medical Transportation Ground

500

PAVE Access Request Forms must be sanctioned by ...?

At least a branch chief or section chief (if it is a password reset)

500

What PETS action has been banned by PED mgmt.?

Edit PETS notes after publishing


500

What floor was PED situated back in 1501 Capitol Ave

3rd floor. 

500

Excel uses drop down or custom filters, how would an analyst filter SQL?

Where clause
500

PT 9999

Unknown Provider Type

M
e
n
u