Troubleshooting
What table would you look at if PRC asks about a request?
STATUS
How do you find the owner of a CAR ID?
What is our CPRA Shared email name?
Consumer Privacy Request Research
Can you code a system without questionnaire sign off from tech owner
No
Where are the SASPY troubleshooting instructions located?
E:/DOCUMENTATATION/PROCEDURES/07_ON DEMAND
What does DPP do?
What Research programs can be run concurrently?
All of them (except for WEEKLY CPRA RESEARCH FINAL)
In what instances can you not go to ELZ for system coding?
Its not timely
OR
Doesn't contain all the data (within reason)
What does this code do?
df = elz.sd2df('CPRA_WEEKLY_RESEARCH', 'DPP', dtype=str)
downloads DPP.CPRA_WEEKLY_RESEARCH from sas server.
What does PRC stand for?
BONUS: Name 2 members
Privacy Request Coordinators
BONUS:
Ritu, Melete, Brittany
In DAILY CPRA STARTING POINT, why do we use AC360 to validate customers?
Because it combines several sources into one location so we can use more than just HOGAN CIS without having to code for several systems
What is the most important part of the Technical Info tab?
Primary Key (joining info)
code = elz.submit(''' SAS CODE ''')
How would you print the sas log in python for the above code?
print(code['LOG'])
OR
do elz.submit('''SAS CODE''')
What does ELZ stand for?
Enterprise Landing Zone
- Auto: Found as a customer, research is complete
- Manual: Not found as a customer, research is complete
- BLT: satisfied BLT requirements and more systems need to be manually searched
What is the Applicable Variables tab for?
Information for system owners for knowing what we will do with their data
What happens if you accidentally overwrite a permanent table?
Yes, you can submit a ticket via MyTech page
Who is John Rizek's replacement
Why do we transform data from a horizontal layout to a vertical layout?
- we needed to maintain context for some values
- for an element found in multiple systems, we needed an easy way to track where all of those were found without concatenating everything into a single cell
What is the best practice to format an element located in multiple tables in the system?
One row per table per element