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