search

bcgov / post-secondary-supply-model

A repository to house the code base for Post-Secondary Supply Model (PSSM)
Apache License 2.0
0 stars 0 forks source link

Load PTIB #3

Closed stephanieyurchak closed 4 months ago

stephanieyurchak commented 5 months ago

I added a load script for PTIB built off of the stp enrol branch.

Decided to go with machine readable column names compared to previous cycles: year - Year credential - Credential (Program) (Program) cip - CIP age_group - Age Group immigration_status - Immigration Status sum_of_graduates - Sum of Graduates sum_of_enrolments - Sum of Enrolments sum_of_total_enrolments - Sum of Total Enrolments

Name of table to be loaded into decimal is PTIB_Credentials based on the table name from PSSM_2019-2020_Private Training Institutions.R (T_Private_Institutions_Credentials_Imported_2021-03).

stephanieyurchak commented 5 months ago

I updated to readxl, added dbreadtable statement to the testing code at the bottom, and switched to the new data. I had to add some cleaning code for the cip column with the new data.