Penn Computing

University of Pennsylvania
Penn Computing << go backback

ADDRESS Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

ADDRESS Table - Data Element Index

NOTE: The restriction flags on this table come from the Online Directory. Please see the ADDRESS table documentation, in the "Cautions" section, for a full discussion of how these flags are populated.
Data Element Mapping back to SRS Definition
Address_Type n/a A calculated 1-character alphabetic code that indicates the type of address record. A student may have multiple address records; this field shows which address the record contains.

Values:

B - Billing address
C - Current address
L - Local address
P - Permanent address
T - Temporary address

Address types of L and T will be extracted only if the address has an expiration date that is blank or greater than the current system date. It is possible for a student to have an expired local address or expired temporary address in the warehouse (the passing of an expiration date does not trigger that student's record to be re-extracted) but each time the student's record is extracted, the local and temporary addresses are re-evaluated.

Address_Type C is a calculated value: If the student has a temporary address, and the system date falls within the start and end date range of the temporary address, then the temporary address is assigned to Address_Type C Else If the student is an undergraduate student and the system date falls within the start and end date range for the summer term (May 1 through August 31), then the permanent address is assigned to Address_Type C Else If the student has a local address and the system date is less than the expiration date of the local address then local address is assigned to Address_Type C Else If the student has a permanent address, then the permanent address is assigned to Address_Type C Else If none of the above apply, then the student's billing address is assigned to Address_type C.

Campus_Address_Type AA154 LOCAL ADDRESS TYPE
NATURAL ALIAS: LO-TYP-BIO
Appears on screens 003 and 005.

A code that indicates the type of local (L) address for the student. A local address can be an off- campus address, a residence hall address, an academic department address, or a fraternity/sorority address. The value is null for all other address types.

Values:
[NULL] Off-campus address
A - Fraternity/Sorority address
D - Department address
R - Residence hall

Campus_Mail_Code

  For on-campus addresses (fraternity/sorority, department, and residence hall addresses), the 4-digit code associated with the building. This is the University mail code. This is a calculated column, derived from the zip plus four extension. Note: in BusinessObjects, the object that refers to this column is named simply "Mail Code."

See also Zip and Restrict_Address in the ADDRESS Table.

City for Permanent address: AA270 PERM ADDR CITY
NATURAL ALIAS: PM-CITY-BIO
Appears on screens 003 and 004.
for Local address: AA220 LOCAL ADDR CITY
NATURAL ALIAS: LO-CITY-BIO
Appears on screens 003 and 005
for Temporary address: AA91I CITY (TEMP)
NATURAL ALIAS: TM-CITY-BIO
Appears on screens 003 and 013
The city or post office of the address.

See also Restrict_Address in the ADDRESS Table.

Cautions:
Some international addresses (other than Canada) will have the state or province following
the name of the city in the City column.
Country for Permanent address: AA285 COUNTRY (PERM)
NATURAL ALIAS: PM-CRYCD-BIO
Appears on screens 003 and 004.
for Temporary address: AA91L COUNTRY (TEMP)
NATURAL ALIAS: TM-CNTRY-BIO
Appears on screens 003 and 013

The abbreviation of the country of the address. An asterisk (*) next to the value indicates that the value may be contained in the data, but is no longer a valid input entry into SRS. For example, CZ is the value for the Czech Republic. CS is the value for what was known as Czechoslovakia. While CS cannot be entered into SRS, students whose address was in Czechoslovakia will have the value CS in the country code. The asterisk is not part of the actual value.

See also Restrict_Address in the ADDRESS Table.

Cautions:

There is no Country for Local Address. The Country will usually be a blank value for addresses in the United States. Foreign addresses should always have a data value in Country.

Values: See the Country table. (Note that the "Country_Code" table in the Data Warehouse is NOT used for decoding Country when using Student Data.)

Effective_Date for Permanent address: AA155 PERM ADDRESS DATE
NATURAL ALIAS: P-ADD-DT-BIO
Appears on screens 003 and 004.
for Local address: AA156 BEGIN DATE (LOCAL)
NATURAL ALIAS: L-ADD-DT-BIO
Appears on screens 003 and 005
for Temporary address: AA91C BEGIN DATE (TEMP)
NATURAL ALIAS: TM-EF-DT-BIO
Appears on screens 003 and 013
The earliest date that the address is valid.
A date in MDY format with a slash (/) separator for example, 5/31/95.

See also Expiration_Date in the ADDRESS Table.

Expiration_Date
for Local address: AA153 LOCAL ADDR EXP
NATURAL ALIAS: LO-EXDT-BIO
Appears on screens 003 and 005
for Temporary address: AA91E END DATE (TEMP)
NATURAL ALIAS: TM-EX-DT-BIO
Appears on screens 003 and 013
The last date that the address is valid. The value is null for billing and permanent address types.

A date in MDY format with a slash (/) separator for example, 5/31/95.

See also Effective_Date in the ADDRESS Table.

First_Name This is a calculated column, parsed from AA010 STUDENT NAME
The student's first name. It is the first word of the student's name. Sometimes a compound name is hyphenated, for example, MARY-ANN. The name is in uppercase letters.

See also Middle_Name in the ADDRESS Table. See also Restrict_Name in the ADDRESS Table.

Last_Activity_Date
n/a
The date this record was downloaded via the SRS extract process and loaded into the Warehouse. This information is stored in the Warehouse in date format. (Note that this is not the SRS "last maintenance date" for bio/demo data.)

A date in MDY format with a slash (/) separator for example, 5/31/95.

Last_Name This is a calculated column, parsed from AA010 STUDENT NAME
The student's last name. It is the last word(s) in this student's name unless it is a recognized suffix. Hyphens may appear. The name is in uppercase letters.

Example: For JOHN H DOE JR, DOE is the last name.

See also Restrict_Name in the ADDRESS Table.

Middle_Name This is a calculated column, parsed from AA010 STUDENT NAME
The student's middle name(s) or initial(s). It is the second and succeeding words of the student's name. The system does not distinguish between a 2-word first name and a first name and a middle name. Sometimes, the student's middle name is only an initial with no period. The name is in uppercase letters.

Example: For MARY ANN DOE, MARY is the first name; ANN is the middle name For MARY A DOE, MARY is the first name; A is the middle initial with no period

See also Restrict_Name in the ADDRESS Table.

Penn_Id appears on SRS screen 103

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, but can be used on screen 103 to look up a student. It is populated in the Data Warehouse from a extract from PennCommunity.

Note that because the SSN is still the record key in SRS, it is possible for two records to accidentally get created in SRS with different SSNs, for the same person. When this happens, there will be two different records in the Data Warehouse with the same PennID. Please report all PennID duplicates to either Data Administration, or the Office of the University Registrar.

Phone for Permanent address: AA290 PERM ADDR PHONE
NATURAL ALIAS: PM-PHONE-BIO
Appears on screens 003 and 004.
for Local address: AA240 LOCAL ADDR PHONE
NATURAL ALIAS: LO-PHONE-BIO
Appears on screens 003 and 005
for Temporary address: AA91P PHONE (TEMP)
NATURAL ALIAS: TM-PHONE-BIO
Appears on screens 003 and 013
The telephone number associated with the address. For U.S. numbers, the format is the area code and 7-digit phone number. (For non-U.S. numbers, the city and country codes are not included; see Phone_City_Code and Phone_Country_Code.)

See also Restrict_Phone in the ADDRESS Table.

Personal_Use_Phone AA95N PHONE 4 (OTHER)
NATURAL ALIAS: OT-PHON4-BIO
Appears on screens 003 and 005
The area code, exchange and 4-digit subscriber number of the student's "personal use" phone number. Stored separately from local phone in SRS and the warehouse, "personal use" phone can be updated by students via InTouch, and if available will replace local phone in the Directory. Personal_Use_Phone will only be populated in the warehouse for Address_Type "L". For all other address types, Personal_Use_Phone will be null.

See also Restrict_Phone in the ADDRESS Table.

Phone_City_Code
for Permanent address: AA292 PERM ADDR CTY PHONE
NATURAL ALIAS: PM-CTYPH-BIO
Appears on screens 003 and 004.
for Temporary address: AA91R PHONE CITY CODE(TEMP)
NATURAL ALIAS: BL-CTYPH-BIO
Appears on screens 003 and 013
The 4 digit City Code for non-US telephone numbers. For local address types, the Phone_City_Code will be null.

See also Restrict_Phone in the ADDRESS Table.

Phone_Country_Code
for Permanent address: AA291 PERM ADDR CNT PHONE
NATURAL ALIAS: PM-CNTPH-BIO
Appears on screens 003 and 004.
for Temporary address: AA91Q PHONE CNTY CODE(TEMP)
NATURAL ALIAS: BL-CNTPH-BIO
Appears on screens 003 and 013
The 3 digit Country Code for non-US telephone numbers. For local address types, the Phone_City_Code will be null. See also Restrict_Phone in the ADDRESS Table.
Restrict_Address

This data element comes from the Online Directory.

 

(Note: if an inactive student has restrict flags in SRS, and their flags are not being updated from the Online Directory, then the SRS restrict flags will be used to populate this column in the Address table.)

Indicates whether the student has notified the University to restrict their address information from release to persons outside of the University.

Note: In the data warehouse, this applies to the address type on the same row as the restriction: local, permanent, or temporary. There are no flags on the billing address; billing address is always presumed to be restricted.

Values:

N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation.

If you see a student with a NULL in this column, it is because they are inactive and their restrict_address was not populated from the Online Directory and there was no previous restrict flag to load from SRS.

Restrict_Address_Penn

This data element come from the OnLine Directory, and not from SRS.

 

Indicates whether the student has notified the University to restrict their address information from release to anyone.

Note: In the data warehouse, this applies to the address type on the same row as the restriction: local, permanent, or temporary. There are no flags on the billing address; billing address is always presumed to be restricted.

Values:

N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation, who needs it in order to do the business of the University.

Restrict_Name

This data element comes from the Online Directory.

 

Note: if an inactive student has restrict flags in SRS, and their flags are not being updated from the Online Directory, then the SRS restrict flags will be used to populate this column in the Address table.

Indicates whether a student has notified the University to restrict his or her name from release to persons outside of the University.

Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation.

If you see a student with a NULL in this column, it is because they are inactive and their restrict_name was not populated from the Online Directory and there was no previous restrict flag to load from SRS.

Restrict_Name_Penn This data element come from the OnLine Directory, and not from SRS.

Indicates whether a student has notified the University to restrict his or her name from release to anyone.

Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation, who needs it in order to do the business of the University.

Restrict_Phone

This data element comes from the Online Directory.

 

Note: if an inactive student has restrict flags in SRS, and their flags are not being updated from the Online Directory, then the SRS restrict flags will be used to populate this column in the Address table.

Indicates whether a student has notified the University to restrict his or her phone number from release to persons outside of the University.

Note: In the data warehouse, this applies to the phone associated with the address type on the same row as the restriction: local, permanent, or temporary. There are no flags on the billing address; billing address phone is always presumed to be restricted.

Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation.

If you see a student with a NULL in this column, it is because they are inactive and their restrict_phone was not populated from the Online Directory and there was no previous restrict flag to load from SRS.

Restrict_Phone_Penn This data element come from the OnLine Directory, and not from SRS.

Indicates whether a student has notified the University to restrict his or her Phone Number from release to anyone.

Values:
N - The student has placed no restriction on this information.
Y - Restricted. Do not include this data in your query unless it for use by someone with an official University affiliation, who needs it in order to do the business of the University.

Ssn
in the Attributes File: AA005 STUDENT ID
NATURAL ALIAS: SID-AA
in the Miscellaneous File: AM007 STUDENT ID
NATURAL ALIAS: SID-AM
in the Student Term File: RT010 STUDENT ID
NATURAL ALIAS: SID-RT
The SSN appears in the context line of all SRS screens that contain student-specific data.
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. In SRS, the SSN is used as the unique Student ID, and is the record key to all files containing student-specific data.

Cautions:
The SSN should never be openly displayed on any report or included in any dataset intended for public consumption. In addition, the SSN should not be included on any report or dataset that will be given to persons who do not have an explicit need to know in order to perform their job for the University.

State
for Permanent address: AA275 PERM ADDR STATE
NATURAL ALIAS: PM-STATE-BIO
Appears on screens 003 and 004.

for Local address: AA225 LOCAL ADDR STATE
NATURAL ALIAS: LO-STATE-BIO
Appears on screens 003 and 005

for Temporary address: AA91J STATE (TEMP)
NATURAL ALIAS: TM-STATE-BIO
Appears on screens 003 and 013
The abbreviation of the state, Canadian province, or U. S. territory of the addre

See also Restrict_Address in the ADDRESS Table.

Street1
for Permanent address: AA260 PERM ADDR STREET1
NATURAL ALIAS: PM-STR1-BIO
Appears on screens 003 and 004.
for Local address: AA210 LOCAL ADDR STREET1
NATURAL ALIAS: LO-STR1-BIO
Appears on screens 003 and 005
for Temporary address: AA91G STREET 1 (TEMP)
NATURAL ALIAS: TM-STR1-BIO
Appears on screens 003 and 013
The apartment number, house number and street, box number or rural route of the address.

See also Street2 in the ADDRESS Table.

See also Restrict_Address in the ADDRESS Table.

Street2
for Permanent address: AA265 PERM ADDR STREET2
NATURAL ALIAS: PM-STR2-BIO
Appears on screens 003 and 004.
for Local address: AA215 LOCAL ADDR STREET2
NATURAL ALIAS: LO-STR2-BIO
Appears on screens 003 and 005
for Temporary address: AA91H STREET 2 (TEMP)
NATURAL ALIAS: TM-STR2-BIO
Appears on screens 003 and 013
Used to continue the information from Street1 in the ADDRESS Table.
Suffix
This is a calculated column, parsed from AA010 STUDENT NAME
A modifier added to the end of the student's name. The suffix is in uppercase letters.

Example: JOHN H DOE JR, JR is considered the suffix.

See also Restrict_Name in the ADDRESS Table.

Title
AA027 STUDENT TITLE
NATURAL ALIAS: STITLE-BIO
Salutation used in association with student mailings. This field is never null. That is, if a salutation has not been specified, MR is assigned for males and MS for females. The title is in uppercase letters with no periods.

Example: MR, MS, RAB

See also Restrict_Name in the ADDRESS Table.

Values:
[Null]
ADM
BISH
BGEN
BR
CAPT
COL
CMDR
DRS
DR
DMRS
FR
GEN
HNMR
HON
LTC
LT
MAJ
MISS
MSGR
MRDR
MR
MMRS
MRS
MS
PAST
PROF
RAB
REV
RVMS
SEN
SHK
SIR
SR
None specified
Admiral
Bishop
Bri Gen
Brother
Captain
Colonel
Commndr
Doctors
Doctor
Doctor and Mrs.
Father
General
Hon. and Mr.
Honrble
Lt. Col.
Lieutenant
Major
Miss
Monsgr
Mr. and Dr.
Mr.
Mr. and Mrs.
Mrs.
Ms.
Pastor
Prof.
Rabbi
Rev.
Rev. and Mrs.
Senator
Sheik
Sir
Sister
Zip
for Permanent address: AA280 PERM ADDR ZIP
NATURAL ALIAS: PM-ZIP-BIO
Appears on screens 003 and 004.

for Local address: AA235 LOCAL ADDR ZIP
NATURAL ALIAS:LO-ZIP-BIO
Appears on screens 003 and 005

for Temporary address: AA91K ZIP CODE (TEMP)
NATURAL ALIAS: TM-ZIP-BIO
Appears on screens 003 and 013

The postal code of the address.

The column is 10 bytes in size. For non-US zip codes, if SRS has a foreign posal code, it will appear in the zip column.

For US zip codes that are "zip + four", the zip code is formatted with a hyphen between the fifth and sixth number. For example, if the zip code in SRS is:

191045555

In the dwadmin.address.zip column, the zip will be:

19104-5555

 


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