CSS ETL Process
Campus submission coordinator
Extracts data from
administrative system
Sends email transmittal
note to UCOP Prod
Control FTPs file to
Cc: UCOP data vsftp.ucop.edu server
steward and CSS
programmer/analyst
UCOP Production Control
Sends E-mail
Job run YES notification of
Submits edit job for the
CAMPUS Successful? availability of Edit
Reports
NO
Submits transform, Notifies CSS
extract & load jobs programmer/analyst
UCOP data steward &
Campus Submission
YES
Coordinators
All campus files NO Notifies CAMPUS
Data Quality control
approved? File approved of status of file and
process
corrections
YES
CSS Programmer/
Analyst
Notifies Prod NO YES
Fixes
Control to Data problem
job
run job again