Penn Computing

University of Pennsylvania
Penn Computing << go backback

REQUIREMENT_VALID Table . Tables and Data Elements . Academic Planning Worksheet Data Home . Data Warehouse Home

REQUIREMENT_VALID Table - Data Element Index

Catalog_Term

The unique term, or pseudo-term, that along with Division, Degree, Major and Concentration, identifies a set of requirements in a component. If there are two sets of requirements for the same Division,Degree,Major,Concentration, then Catalog Term is used to distinguish between them. For example, if a school updates its degree requirements for new students, but wants to keep the old requirements for continuing students, each set of requirements has a unique Catalog Term. In most cases, Catalog Term is the term, in YYYYT format, when the set of requirements went into effect.

Component_Line_ID

A system-generated number, used to uniquely identify a line in a Component.

Component_Type

A one-character code whose value describes the group of requirements contained in a component.

VALUES:

D - Division-wide requirements ("everyone getting this degree in this division must do these things")
M - Major requirements ("everyone taking this major must do these things")
N - Minor requirements ("everyone completing this minor must do these things")

Concentration

Further defines a Major. In SRS, majors can be associated with concentrations. Concentrations cannot exist without majors. Minors do not have concentrations. Majors with different concentrations will have different and separate Components, one for each major/concentraiton combination.

VALUES:

See CONCENTRATION table for valid values.

Course_List_ID

System generated ID number that identifies the Course List that is to be used when determining whether or not the course taken by the student fulfills the requirement. Course List ID must contain data if the Validation Method is of type CL.

Degree

The SRS degree whose requirements are defined by a Component.

VALUES:

Refer to the DEGREE table for valid values.

Division

The SRS Division whose degree requirements are defined in a Component.

VALUES:

Refer to the DIVISION table for valid values.

Major_Minor

The 4-charcters SRS Major (or Minor) code whose requirements are defined in a Component.

VALUES:

Refer to the MAJOR_MINOR table for valid values.

Valid_Method

Identifies a way in which the requirement can be satisfied. A requirement can have multiple (up to 10) validation methods. For example, a requirement can be defined as fulfillable by taking a General Requirement course in Arts and Letters (Valid_Method = A) OR taking a course from a speficied list (Valid_Method = CL and Course_List_ID not null).

VALUES:

     AM - AM/MS research requirement     
     CO - a specified course
CA - a specified course attribute GC - override: grade check
EA - a specified enrollment attribute EB - examination benchmark
CL - a specified course list
LA - language requirement (from SRS term file) RR - research requirement
TR - teaching requirement OT - other

Val_Value

Validation Value. When a requirement has a Validation Method of CO, CA, EA, EB, LR, or TR there must be data in the Validation Value.

For method CO, the Validation Value will have the course ID, in SRS format (Examples: ECON001, CSE 110).

For method CA, the Validation Value must be an acceptable code from the Distribution Requirement in the SRS Course Inventory file (Examples: A, S, 1, W).

For method EA, the Validation Value must be an acceptable code for Section Code in the Student Term File (Examples: G, NC).

For method EB, the Validation Value can be:

EB1: Master's Final Exam Date
EB2: Qualifications Exam Date
EB3: Advanced to Candidacy Date
EB4: Preliminary Exam Date
EB5: Preliminary Exam Date #2
EB6: Oral Exam Date
EB7: Oral Defense Date

For method LR, the Validation Value can be:

LR1: Language Requirement 1
LR2: Language Requirement 2
LR3: Language Requirement 3
LR4: Language Requirement 4

For method TR, the Validation Value can be:

Values Codes:

TR1: Teaching Requirement 1
TR2: Teaching Requirement 2
TR3: Teaching Requirement 3
TR4: Teaching Requirement 4
TRW: Teaching Requirement
TRS: Teaching Requirement

For validation code TR, the worksheet process should follow the following logic:

If Value code is TR1, TR2, TR3 or TR4:

Search the four teaching requirement units in SRS for valid course id/term entries and populate the course/term data in the worksheet line according to the Worksheet Display specifications in Table 1- Teaching Requirement below. If no course/term data is found, display blank on the worksheet.

If Value Code is TRW:

Check the Waived indicator on SRS screen 144. If the waive indicator equals N, G or S, populate the appropriate text in the worksheet line according to the Worksheet Display specifications Table 1- Teaching Requirement below. If Waived indicator is blank, display blank on the worksheet.

If Value Code is TRS:

Check the Satisfied indicator on SRS screen 144. If the satisfied indicator equals Y, populate the appropriate text in the worksheet line according to the Worksheet Display specifications Table 1- Teaching Requirement below. If Satisfied indicator is blank, display blank on the worksheet.

Requirements can have up to 10 Validation Methods, and each method can have different Validation Values.

 

REQUIREMENT_VALID Table . Tables and Data Elements . Academic Planning Worksheet Data Home . Data Warehouse Home

 


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania