Table Name

Description

INSTITUTION_TBL

Setup table for Institution. Includes Description.

Note: The Prompt table to be used for the Institution value to enforce security is INSTITUTN_SCRTY.

TERM_VAL_TBLP

Global setup table for Term Values. Includes Description.

TERM_TBLP

Setup table for Term Dates by Institution, Career. Includes Description, Term Begin Date and End Date.

ACAD_CALTRM_TBL

Setup table for registration events within the Term by Institution, Career, Calendar ID and Term. Includes Census Date, Confer Date, Withdrawal and Cancel Dates.

AID_YEAR_TBLP

Setup table for Financial Aid Year by Institution. Includes Description, Academic Year Start and End Dates.

AID_YR_CAR_TERM

Setup table for Term in relation to Financial Aid Year and Award Period by Institution and Career.

*Note: Dates in table are specific to Loans, not commonly used outside of specific FA operational reporting.

ACAD_CAR_TBLEP

Setup table for Academic Career by Institution. Includes Effective Date, Description, Grade and Repeat settings.

CAMPUS_TBLEP

Setup table for Campus by Institution. Includes Effective Date, Description and Location Code. Parent record to LOCATION_TBL

LOCATION_TBLEP

Setup table for Location by Institution and Campus. Includes Effective Date and Description. Child record to CAMPUS_TBL

ACAD_PROG_TBLEP

Setup table for Academic Programs by Institution. Includes Effective Date, Description, Career, Calendar ID, Academic Group, Academic Organization, FA Primacy, and registration event settings and controls.

ACAD_GROUP_TBLEP

Setup table for Academic Groups by Institution. Includes Effective Date and Description.

ACAD_ORG_TBLEP

Setup table for Academic Organizations by Institution. Includes Effective Date and Description.

ACAD_PLAN_TBLE

Setup table for Academic Plans by Institution. Includes Effective Date, Description, Plan Type, Academic Program, Degree, Diploma Description, Transcript Description and CIP Code.

Note: Do not join on ACAD_CAREER when connecting to other tables, the field is not populated in this table.

Parent table to ACAD_PLAN and ADM_APPL_PLAN.

PROG_ACTION_TBLE

Setup table for Program Actions. Includes Effective Date and Description. Parent record to PROG_RSN_TBL. Table also used for ACAD_PROG program actions.

Table Name

Description

SCC_PERDATA_QVW

Contains information related to the student’s name, address, sex, birth date, martial status.

Should not be used for military information, VA benefit, or disability. This information will be stored in another table.

SCC_EMAIL_QVW

View of the person’s email address. Recommended to use the preferred flag for criteria when pulling a person’s email address

Table Name

Description

CITIZENSHIP

Citizenship data by Emplid. Includes Citizenship Status code and Country of Citizenship. Child record to CITIZEN_STS_TBL

CITIZEN_STS_TBLP

Citizenship Status setup table. Includes Country of Citizenship, Citizenship Status and Description. Parent record to CITIZENSHIP.

EXTERNAL_SYSTEM

Data Services view built from EXTERNAL_SYSTEM and STDNT_CAR_TERM to connect to the external system data by Institution and Emplid. Includes External System Code and External System ID.

Recommended in place of EXTERNAL_SYSTEM and EXTERNAL_SYSKEY

This record is considered Highly Sensitive and requires special permission to access. Highly Sensitive data is National ID/SSN.

RESIDENCY_OFF

Residency data by Emplid, Career and Institution. Includes Effective Term, Residency date and Residency codes for Admissions, Financial Aid and Tuition, as well as any Exception Codes.

RESIDENCY_TBLE

Setup table for Residency Codes. Includes Effective Date and Description.

Table Name

Description

SRVC_IND_DATA

Service Indicator data by Institution, Emplid and Service Indicator. Includes Service Indicator Reason, Department and Dates.

AUDIT_SRVC_IND

Service Indicator history audit record by Emplid, Institution, Service Indicator Code, Audit Date Time Stamp and Action. Includes Service Indicator Reason, Department, and Dates.

SRVC_IND_SEL_VW

Service Indicator data by Institution, Emplid and Service Indicator. Includes Service Indicator Code, Reason, and Department, View is from and same as SRVC_IND_DATA with less output fields.

SRVC_IND_CD_TBLEP

Setup table for Service Indicator Codes by Institution. Includes Effective Date, Description, Positive Service Indicator Flag and Default Reason Code. Parent record to SRVC_IN_RSN_TBL.

SRVC_IN_RSN_TBLEP

Setup table for Service Indicator Reasons by Institution and Service Indicator Code. Includes Effective Date, Description and Department ID Owner.

Child record to SRVC_IND_CD_TBL.

SERVICE_IMPACTE

Service Indicator Impact data by Institution, Service Indicator Code and Service Impact. Includes Effective Date and Long Description.

SRVC_IMPACT_TBLEP

Setup table for Service Impacts by Institution. Includes Effective Dates, Descriptions and Impacts.

Table Name

Description

STDNT_GRPS_HIST

Query table for active students in Student Groups by Emplid, Institution, Student Group and Term. Includes Description and Comments.

Note, effective dates in this table may be applied for specific semesters.

Table Name

Description

ADM_APPL_PROGE

Applicant Program data by Institution, Career, Emplid and Application Nbr. Includes Effective Date, Admit Term and Campus.

Parent record to ADM_APPL_DATA and ADM_APPL_PLAN

*Note: Once student is Matriculated (or PROG_STATUS = ‘AC’) the record changes are no longer recorded here and you must use ACAD_PROG to get current Program data. Do not join on STDNT_CAR_NBR between ADM_APPL_% and ACAD_P% tables, do join on ADM_APPL_NBR.

ADM_APPL_DATA

Applicant Detail data by Institution, Career, Emplid and Application Nbr. Includes Effective Date, Admit Type, Application Details and Fee data.

Common Admissions reporting requires join between ADM_APPL_PROG and ADM_APPL_DATA.

Child record to ADM_APPL_PROG

*Note: Once student is Matriculated (or PROG_STATUS = ‘AC’) the record changes are no longer recorded here and you must use ACAD_PROG to get current Program data. Do not join on STDNT_CAR_NBR between ADM_APPL_% and ACAD_P% tables, do join on ADM_APPL_NBR.

ADM_APPL_PLANE

Applicant Plan data by Institution, Career, Emplid and Application Nbr. Includes Effective Date, Plan and Requirement Term.

Child record to ADM_APPL_PROG

*Note: Once student is Matriculated (or PROG_STATUS = ‘AC’) the record changes are no longer recorded here and you must use ACAD_PROG to get current Program data. Do not join on STDNT_CAR_NBR between ADM_APPL_% and ACAD_P% tables, do join on ADM_APPL_NBR.

ADMIT_TYPE_TBLE

Setup table for Admissions Types by Institution. Includes Effective Date, Description, Career and Readmit flag.

EXT_ACAD_DATA

Applicant High School/Transfer data by Emplid, External Organization, and External Career. Includes Transcript Type, Status and Attendance dates.

Parent record to EXT_ACAD_SUM AND EXT_COURSE

Note: Do not join EXT_CAREER to ACAD_CAREER when connecting to other tables.

EXT_ACAD_SUM

Applicant High School/Transfer data by Emplid, External Organization, External Career and Institution. Includes External GPA.

Child record to EXT_ACAD_DATA

Note: Do not join EXT_CAREER to ACAD_CAREER when connecting to other tables.

EXT_COURSE

Applicant Transfer Course data by Emplid, External Organization, External Career and Institution. Includes External Course Description, School Subject, Course Nbr, Units and Grade. The data resides here before the Transfer Course Credit Rules are applied. This data feeds the TRNS_CRSE_% tables.

Child record to EXT_ACAD_DATA

EXT_ORG_VW

Setup table for External Organizations. Includes Description, Address data, and Organization Type.

View built from parent record EXT_ORG_TBL and child record ORG_LOCATION and is limited to only active status as of the current date. Recommended in place of EXT_ORG_TBL for current data

EXT_ORG_TBLEP

Setup table for External Organizations. Includes Status, Effective Date and Description.

Parent record to ORG_LOCATION and EXT_ORG_TBL_ADM - selects only the Ext Org Type = ‘SCHL’ and includes ATP code, FICE code, etc.

Table Name

Description

CRSE_CATALOGE

Course Catalog data by Course ID. Includes Status, Effective Date, Course Descriptions, Equivalent Course, Course Units Minimum and Maximum, Grading Basis, Course Topic and Repeat designations.

Parent record to CRSE_OFFER and CRSE_COMPONENT.

In combination, the Course Catalog tables CRSE_CATALOG, CRSE_OFFER and CRSE_COMPONENT are Parent records and feed to the Class Schedule and CLASS_TBL, CLASS_ASSOCIATION and CLASS_COMPONENT.

Note: This is an effective dated record commonly joined to the Class Schedule Term level tables. The logic to determine the Course Effective Date for the correct Term should be Less Than or Equal to the Term End Date in the Max Effective Date sub-query for accuracy.

Example: CRSE_CATALOG.EFFDT <= TERM_TBL.TERM_END_DT

CRSE_OFFERE

Course Offering data by Course ID, Course Offer Number. Includes Effective Date, Institution, Subject, Catalog Number, Academic Organization, Academic Career, Requirement Group and CIP Code.

Child record to CRSE_CATALOG.

In combination, the Course Catalog tables CRSE_CATALOG, CRSE_OFFER and CRSE_COMPONENT are Parent records and feed to the Class Schedule and CLASS_TBL, CLASS_ASSOCIATION and CLASS_COMPONENT.

Note: This is an effective dated record commonly joined to the Class Schedule Term level tables. The logic to determine the Course Effective Date for the correct Term should be Less Than or Equal to the Term End Date in the Max Effective Date sub-query for accuracy.

Example: CRSE_OFFER.EFFDT <= TERM_TBL.TERM_END_DT

CRSE_COMPONENTE

Course Component data by Course ID. Includes Effective Date, Component, and Component Contact Hours.

Child record to CRSE_CATALOG.

In combination, the Course Catalog tables CRSE_CATALOG, CRSE_OFFER and CRSE_COMPONENT are Parent records and feed to the Class Schedule and CLASS_TBL, CLASS_ASSOCIATION and CLASS_COMPONENT.

Note: This is an effective dated record commonly joined to the Class Schedule Term level tables. The logic to determine the Course Effective Date for the correct Term should be Less Than or Equal to the Term End Date in the Max Effective Date sub-query for accuracy.

Example: CRSE_COMPONENT.EFFDT <= TERM_TBL.TERM_END_DT

CRSE_ATTR_VALUE

Course Attribute Values by Course ID and Course Attribute. Includes Effective Date and Description. Child record to CRSE_ATTR_TBL.

CRSE_ATTR_TBL

Setup table for Course Attributes. Includes Effective Date, Status and Description. Parent record to CRSE_ATTR_VALUE.

CRSE_TOPICSE

Course topics by Course ID. Includes Effective Date, Course Topic ID, Repeat Designations and Description. Outer-join to CRSE_CATALOG.

Child Record to CRSE_CATALOG

SUBJECT_TBL

Setup table for Subjects by Institution. Includes Effective Date, Description, Academic Organization and CIP Code.