| Data element |
mapping back to SRS |
Definition |
| Hold_Status |
AM145 HOLD STATUS
NATURAL ALIAS: HD-STAT-AM
appears on SRS screens 010 and 012 |
The current status of a hold (active or cleared).
Values:
A - Hold Active
C - Hold Cleared
|
| Hold_Status_Date |
AM 119 HOLD MAINT DATE
NATURAL ALIAS: HD-MN-DT-AM
does not appear in online SRS |
System-generated date in SRS, populated when the Hold_Status is changed.
May also be the last date a Waiver was added or removed. |
| Hold_Type |
AM110 HOLD TYPE
NATURAL ALIAS: HD-TYPE-AM
appears on SRS screens 010 and 012 |
The hold type determines what, if any, academic activity will be affected
by the hold.
Values:
G - General Comment
T - Transcript
R - Registration
B - both Transcript and Registration
H - Miscellaneous
|
| Hold_Reason |
AM130 HOLD REASON
NATURAL ALIAS: HD-REAS-AM
appears on SRS screens 010 and 012 |
Identifies the reason the hold was placed on the student's record. Use
with Hold Comments for best understanding.
Values:
XX - See Narrative
FN - Financial Hold Online
FB - Financial Hold Batch
CL - Collections Hold, Delinquent Loan
CB - Collections Hold, Receivable
EP - Early Decision
GH - Graduation Hold
JD - Judicial
RG - Registrar
DV* - Division Office (obsolete)
D1 - Div Office, Reason 1
D2 - Div Office, Reason 2
D3 - Div Office, Reason 3
SA - Special Account
OT - Other
|
- Hold_Restriction
|
AM120 HOLD RESTRICTION
NATURAL ALIAS: HD-RESTR-AM
appears on SRS screens 010 and 012 |
Identifies whether the hold may be viewed by all, or only by the entering
office.
Values:
G - General use - no restrictions
P - Private use - online viewable
only by the entry office
|
| Hold_Effective_Term |
AM125 EFFECTIVE TERM
NATURAL ALIAS: HD-EF-TM-AM
appears on SRS screens 010 and 012 |
The first term a registration hold is to take effect. |
| Hold_Entry_Date |
AM124 ENTRY DATE
NATURAL_ALIAS: HD-EF-DT-AM
appears on SRS screens 010 and 012 |
The date the hold was entered in SRS. |
| Hold_Entry_Dept |
AM122 ENTRY OFFICE
NATURAL ALIAS: HD-OFFIC-AM
appears on SRS screens 010 and 012
|
The SRS code for the department or administrative office that entered
the hold or hold comment.
Values: Refer to the DEPT table. |
| Hold_Waiver_Term |
AM142 WAIVER TERM
NATURAL ALIAS: HD-WV-TM-AM
appears on SRS screens 010 and 012 |
The term through which the hold is to be waived.
|
| Hold_Waiver_Date |
AM141 WAIVER DATE
NATURAL ALIAS: HD-WV-DT-AM
appears on SRS screens 010 and 012 |
The date the hold waiver was entered in SRS. |
| Hold_Comments |
AM128 COMMENT TEXT
NATURAL ALIAS: HD-TEXT-AM
appears on SRS screens 010 and 012 |
Text which, when used with Hold Reason, further explains the reason for
the hold being placed on the student's record. |
| Penn_Id |
n/a |
The 8-digit identification number assigned to the student when their
record was created in the PennCommunity database. No two persons have
the same Penn_ID. Only persons affiliated with the University will be
assigned a Penn_ID.
Penn_ID is not stored in SRS. It is populated in the Data Warehouse
from a extract from PennCommunity.
|
| Ssn |
AA005 STUDENT ID
NATURAL_ALIAS: SID-AA
the record key for all student data in SRS; appears
in the context line of all student-related screens
|
For students who are United States citizens or permanent residents,
the Student ID number in SRS is generally 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.
For foreign students and a few other exceptions, the value in this
column may be a Penn-assigned ssn.
Note: Never release a student's Social Security number to
anyone without the student's permission. Whenever possible,
do not include SSN in your query results, and if you must do so,
you do so with the full knowlege that you will be held responsibile
for the careful maintenance of any datafiles, reports or other stored
data containing SSNs.
Please see http://www.upenn.edu/privacy/ for more about the University's
policies and general cautions regarding the use of SSNs. |
