Penn Computing

University of Pennsylvania
Penn Computing << go backback

STUDENT HOLDS Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

STUDENT HOLDS Table - Data Element Index

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

GH - Graduation Hold

JD - Judicial

RG - Registrar
DV - Division Office

D1 - Div Office, Reason 1

D2 - Div Office, Reason 2

D3 - Div Office, Reason 3

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.

 

STUDENT HOLDS Table . Tables and Data Elements . Student 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