Penn Computing

University of Pennsylvania
Penn Computing << go backback
GF_ACADEMIC_PROGRAM Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

GF_ACADEMIC_PROGRAM Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Academic_Program_ID Record key; system-generated.
Banner_College

The 2-character code for the graduate college in which the student is enrolled (in the legacy system, this is the graduate "division")

Values:

Banner College Code mapping to SRS Division Code
AL = CGS
AP = GAS
CM = ASC
CP = ASP
DM = DEN
DY = DPH
EM = GEN
EP = GEP
EX = GEX
FM = GFA
FP = GFP
GM = EDG
GP = EDP
LD = LWP
LR = LAW
LY = GPL
MP = BMP
MR = MED
NM = NUG
NP = NUP
SD = SWD
SM = SW
SP = SWP
VP = VEM
VR = VET
WM = WHG
WP = WHP
WX = WEM
ZB = EVE

Banner_School

The one-character code for the school in which the student is enrolled

Values:

Banner school code mapping to SRS school code
A = AS
C = AN
D = DM
E = EG
F = FA
G = ED
L = LW
M = MD
N = NU
S = SW
V = VM
W = WH

BRS_Division_Code

The 2-byte numeric code for divisions, used by the legacy BRS system.

BRS division to SRS division to Banner college code mapping:

31 GAS AP
32 EDG GM
33 GFA FM
34 WHG WM
35 SW SM
36 ASC CM
37 NUG NM
39 WEM WX
40 SWD SD
41 GEN EM
42 GEX EX
43 EDP GP
44 GFP FP
45 WHP WP
47 ASP CP
48 GEP EP
51 DEN DM
52 DPH DY
54 MED MR
56 LAW LR
57 GPL LY
58 VET VR
60 NUP NP
63 LWP LD
65 BMP MP
71 CGS AL
72 EVE ZB
77 SWP SP
84 VEM VP

Center

The two character code that represents the specific school or center to which the ORGANIZATION_CODE belongs. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)
Refer to the CNAC_CODES Table for values. The code for a school or center is the same as the first 2 characters of the CNAC.

Degree_Code The SRS code for the degree conferred at Penn. See the DWADMIN.DEGREE table for values.
Degree_ID Internal Grad Funding key to the DWNGSS.GF_DEGREE table.
Division_ID Internal Grad Funding key to the DWNGSS.GF_DIVISION table
Entered_By

not yet defined.

Entered_On The date the record was first created in the Grad Funding system.
Last_Edited_By not yet defined.
Last_Edited_On The date the record was last edited in the Grad Funding system.
Major_Code The SRS code for the major (also known as Grad Group). See the DWADMIN.MAJOR table for values.
Major_ID Intrenal Grad Funding key to the DWNGSS.GF_MAJOR table
ODS_ETL_Update_Dt Date the staging table was updated for this record.
SAM_School

The one character code for school from the Student Aid Management (SAM) system.

Mapping of SAM School codes to SRS School codes:

A - AN
C - AS
D - DM
E - EG
F - FA
L - LW
M - MD
N - NU
S - SQ
U - ED
V - VM
W - WH

 

School_ID Internal Grad Funding key to the DWNGSS.GF_SCHOOL table.
Special_Program_Code The SRS code for Special Program. See DWST.SPECIAL_PROGRAM for values.
Special_Program_ID Internal Grad Funding key to the DWNGSS.GF_SPECIAL_PROGRAM table
SRS_Division The SRS code for Division. See DWADMIN.DIVISION for values.
SRS_School The SRS code for School. See DWADMIN.SCHOOL for values.
STG_Merge_Dt Date the warehouse was last updated for this record.
Tuit_Group Numeric code for the Grad Funding Tuition Group. See DWNGSS.GF_TUIT_GROUP for values and descriptions.
Type_of_Student

A Grad Funding code that identifies the program level (Note: while this is similar to the DEGREE_LEVEL code in SRS, "Type of Student" is not a code used in SRS).

Values:

C - certificate or non-degree program
M - master's level graduate program
P - PhD program

GF_ACADEMIC_PROGRAM Table . Tables and Data Elements . Grad Funding 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