make_headcount_sql will generate a standard sql query for pulling headcount
data from Edify. This function is often used with the function utHelpR::uth_make_outcome_count to
produce pivot tables with headcount numbers. There are several types of headcounts
to choose from. To specify the type of headcount you would like, use the type parameter.
If you have questions about which version you should use in your report, please
contact Joy Lindsay. For more details see the headcount vignette. You can bring this
up by running the following code in your console.
vignette("headcount", package = "utDataStoR")
Arguments
- name
The name you want the SQL file to have in your sql folder.
- type
The type of headcount file you want. Defaults to 'current' headcount data. Other options are
'census' – data as of the census snapshot
'census_demographic' – headcount data with demographic data, as of census snapshot
'eot' – data as of the end of term snapshot
'ipeds' – data as it was reported to IPEDS
'pit' – point in time data