Body
Summary
The International Admissions Daily Data dashboard shows International Admissions statistics for each college and university-wide. The data is updated from PeopleSoft Campus Solutions every morning before 9:00 AM, Monday through Saturday. Activity from Saturday and Sunday is updated on Monday morning, due to technical agreements with UH System Computing.
Detailed Description
The International Admissions Daily Data dashboard presents admissions funnel data and statistics for International Admissions for the Spring, Summer, and Fall terms. The term can be selected by clicking on the appropriate button in the upper left corner of the dashboard. The "University" tab shows consolidated numbers for all four colleges, and the other tabs focus on the individual colleges.
Data Lineage
Note: A link will be provided in the future that will allow users to view the lineage of the data.
Data Source: PeopleSoft (PS) CS
Table Name(s):
- PS_ACAD_PLAN_TBL
- PS_ACAD_PROG
- PS_ADDRESSES
- PS_ADDR_ORDER_TBL
- PS_ADM_APPL_DATA
- PS_ADM_APPL_PLAN
- PS_ADM_APPL_PROG
- PS_CITIZENSHIP
- PS_EMAIL_ADDRESSES
- PS_EXT_ACAD_SUM
- PS_EXT_ORG_TBL
- PS_PERSONAL_DATA
- PS_PERSONAL_PHONE
- PS_PROG_RSN_TBL
- PS_STDNT_GRPS_HIST
- PS_STDNT_TEST_COMP
- PS_VISA_PMT_DATA
Data Transformation Source:
- Database: sqldw-prd\sql19dwprod
- Schema: SECURE
- Table Name(s):
- CS.MQ_IntlAdmissions - Contains the results of a complex join of the source tables.
- View Name(s):
- CS.IntlAdmissionsDataForColleges - Adds descriptive text for display on the dashboard.
Dashboard Criteria:
- STRM = [choose from the latest Spring, Summer, or Fall term]
Recommended Dashboards/Reports
Currently, there are no equivalent dashboards or reports.
Similar Dashboards/Reports
Currently, there are no similar dashboards or reports.