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. Each Requirement in a Component is a separate line. |
Component Text
|
The text description of the component. This text appears on the online
worksheet in Advisor InTouch. |
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")
|
Degree
|
The SRS degree whose requirements are defined by the Components used
in the worksheet.
VALUES:
Refer to the DEGREE table for valid values.
|
Division
|
The SRS Division whose degree requirements are defined in the Components
used in the worksheet.
VALUES:
Refer to the DIVISION table for valid values.
|
Major Minor
|
The SRS Major (or Minor) code whose requirements are defined in the Components
used in the worksheet.
VALUES:
Refer to the MAJOR_MINOR table for valid values.
|
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:
Refer to the CONCENTRATION table for valid values.
|
Course_ID
|
The Course ID of the course the student took to fulfill this Requirement.
If the requirement was waived or has not yet been completed, Course ID
will be null.
VALUES:
A value in 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_Section_Num
|
The 3-digit section number of the course the student took to fulfill this
requirement. If the course has not yet been taken, or the course was entered
as an AP or transfer credit course, then the section ID will be zero. |
Course_Term
|
The term in which the student has taken, or plans to take, the course
that will fulfill this requirement.
Penn divides the academic year into 3 terms or semesters: Fall, Spring,
and Summer. Terms are designated by the 4-digit calendar year, followed
by a term code. The Spring term code is A, the Summer term code is B,
and the Fall term code is C.
Example: 1995C means Fall 1995, 1996A means Spring 1996, 1996B means
Summer 1996
|
Requirement Line Text
|
The defining text as entered by the requirement builder in REQBUILD, to
appear alongside the course information on the worksheet in Advisor InTouch. |
Requirement Status
|
Indicates whether or not a requirement has been fulfilled.
VALUES:
S = Satisfied, entered either by auto-assign or manually by an advisor
F = course is currently being taken, and is conditionally approved. The course will satisfy the requirement, assuming the student successfully completes the course.
C = future override. If a course is to be taken in the future, but it does not satisfy the requirement, the advisor can enter an override, even though the course hasn't been taken yet.
N = Not approved
O = Override, as entered by the advisor.
P = Petition. Similar to an override, but required a formal petition to a school administrator or committee for override approval.
W = Waived. If a course appears here, it means that there was an attempt to satisfy the req with that course; it failed, and the req was subsequently overridden.
G = Grade not met. When a course was conditionally approved, or planned for a specified term, and that term is now over but the student did not earn the minimum grade requirement, the status changes automatically to a G.
T = planned course, for a future term. Similar to a conditional approval, but for a specified term in the future. Unlike the conditional approval, the worksheet program does not find and store the related SRS information about the course. If the student never takes the course, and the term passes, the worksheet displays a "?" for the advisor to see online, but the value for the Requirement Status does not change in the data warehouse.
Z = no action taken on this requirement.
CAUTION: the value of "Z" will not display if you are using the table dwadmin.apw_worksheet. If you need this, please use the APW_WORKSHEET_V view.
|
Requirement Comment
|
The explanatory text, if any, as entered in Advisor InTouch by the advisor
for this requirement.
See also the WORKSHEET_COMMENT table.
|
SSN
|
The Social Security number of this student. A Social Security number is
a unique number assigned to an individual by the federal Social Security
Administration.
|
Worksheet Item Update Date
|
The last date a specific line item (requirement) on a specific worksheet
was updated. Previous updates dates are not available; there is no audit-trail
of the dates of all actions taken on a requirement.
See also Worksheet Update Date.
|
Worksheet Item Update Inits
|
The initials of the Advisor who last updated a specific line item (i.e.
Requirement) on a specific Worksheet in Advisor InTouch. 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.
See also Worksheet Update Inits
|
Worksheet Item Update Pgm
|
The program id for auto updates, indicating the lastest update for a
specified requirement on a specified worksheet.
See also Worksheet Update Program.
|
Worksheet Name
|
The text name, as entered by the creating student or advisor, of a specified
worksheet. |
Worksheet Update Date
|
The last date any changes were made to a specific worksheet, whether
by a user or by the auto-assign program. Previous updates dates are not
available; there is no audit-trail of the dates of all actions taken on
a requirement.
See also Worksheet Item Update Date.
|
Worksheet Update Inits
|
The initials of the Advisor who last updated this Worksheet in Advisor
InTouch. 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.
See also Worksheet Item Update Inits
|
Worksheet Update Program
|
The program id for auto updates, indicating the lastest update for a
specified worksheet.
See also Worksheet Item Update Pgm.
|
Worksheet Update Time
|
The time of day of the latest update of the worksheet. |
Update Inits
|
The initials of the administrative mainframe users who last updated this
Requirement 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.
|