Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE LIST Table . Tables and Data Elements . Academic Planning Worksheet Data Home . Data Warehouse Home

COURSE LIST 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.

Course ID

Identifies the course related to the course section in which the student is enrolled. Course_Id is a component of Section_Id in the ENROLLMENT_ALL_V Table. A value of the format of 2, 3 or 4- alphabetic characters, followed by 2, 1 or 0 blanks (respectively) for the Subject_Area; followed by 3 numeric characters for the Course_Number. For example, 'MATH001', 'EE 691'.

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.

Course List Name

The name of the course list, as entered by the administrative mainframe operator using REQBUILD.

Owner Department

The academic department that owns and maintains the course list. The department must be in the school and division to which this list belongs. Only operators from the owning department may update the list. Note: when Owner Dept is null, the list is owned and maintained by the Owner Division.

Values:

Any valid 4-character SRS department code. See DEPT table for values.

Owner Division

The academic division that owns and maintains the course list. Only operators from the owning division may update the list. If there is also a value in Owner Department, the administrative operator must have both the correct division and department in his or her SRS Security profile in order to update the list.

Values:

Any valid 3-character SRS division code. See DIVISION table for values.

Update Date

The last date the Course List was updated in the administrative mainframe application REQBUILD.

Update Inits

The initials of the administrative mainframe users who last updated this Course List in REQBUILD. These initials are maintained in the SRS Security Module by the SRS System Administrator. Initials are assigned to a user when he or she first gets an account. CAUTION: if the user has an account to use the mainframe SRS application and an account to use Advisor InTouch, their initials will not be the same in both applications.

Note: there is currently no mapping of initials to a person's name available in the Data Warehouse. To investigate the full name of a person associated with Update Inits, please contact the Office of the University Registrar.

 

COURSE LIST 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