The university where you work has two different applications that contain student data: 1) a student tuition billing system and 2) a student academics and enrollment system.

You are responsible for the integration work necessary to build a single master list of students in the data warehouse.

A key part of your integration work will be to specify the data transformations necessary as part of the ETL.

Relevant data fields in the student tuition billing system:

Last Name: STRING (40)

First Name: STRING (25)

Academic Status: STRING (3) with the following permissible values:

FGS Full-time student in good standing

PGS Part-time student in good standing

FAP Full-time student on academic probation

PAP Part-time student on academic probation

Relevant data fields in the student academics and enrollment system:

Last Name: STRING (35)

First Name: STRING (15)

Enrollment Status: STRING (10) with the following permissible values:

Full-time

Part-time

Academic Status: STRING (13) with the following permissible values:

Good standing

Probation

__________________________________

YOUR ASSIGNMENT: Show the ETL transformations needed to unify the fields listed from the two different student-related applications into the data warehouse