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 RELATIONSHIPS:

Table: RELATIONSHIPS - Relationships

Short Description: Relationships defined between two people

Long Description: Parents, guardians, and family members of students.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
PEOPLE_RELATION	Relationship of the relation to the EMPLID
EMPLID_RELATED	ID number of the relation

Criteria Notes:

Do not pull contact and bio demo data from this record, use it only to identity relations.

Every relationship is reciprocal. A row of data where EMPLID is the student and EMPLID_RELATED is the father will have a second row of data from EMPLID the father and EMPLID_RELATED is the student.

For contact and bio demo data join to U_CC_PDATA_TBL, and SCC query views.

Related Tables: ACAD_PROG  STDNT_CAR_TERM  U_CC_PDATA_TBL  U_SA_AUTH_ACCT  U_SA_AUTH_GRANT  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.