Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for U_SR_ACADPG_TBL:

Table: U_SR_ACADPG_TBL - Acad Prog Rpt Values

Short Description: Setup table for custom reporting values

Long Description: Custom reporting categories tied to Academic Program

Useful Fields:

Field Name	Field Descr
ACAD_PROG	Code for Academic Program
EFFDT	Date the data or action takes effect
U_SR_RPT_CAREER	Reporting Career (UG or GR)
U_SR_RPT_DEG	Reporting Degree/Non-Degree
U_SR_RPT_PROG	Reporting Category based on Academic Program
U_SR_RPT_CREDIT	Reporting Credit/Non-Credit
U_SR_RPT_A_CAR	Career Category for Alternate Report
U_SR_RPT_A_PROG	Program Category for Alternate Report
U_SR_RPT_IPEDS	IPEDS code, a financial aid category

Criteria Notes:

Join from ACAD_PROG or ACAD_PROG_TBL

Related Tables: ACAD_PROG  ACAD_PROG_TBL 

For updates, corrections or questions Email Stephen Forrest.