| Data element |
Definition |
BUILDING
Indexed - yes
Format - char (26)
May be null? yes |
The name of the building associated with the Mail_Code.
Example: WALNUT WEST (6228)
Values:
Refer to the DWADMIN.MAIL_CODES table for values.
|
|
CITY
Indexed - no
Format - char (15)
May be null? yes
|
The city or post office associated with the Mail_Code. (Note:
this is not always populated.)
Examples: PHILADELPHIA, ARDMORE
|
GROUP_CODE
Indexed - no
Format - char (4)
May be null? yes
|
This column is not used.
|
| MAIL_CODE
Indexed - yes
Format - char (4)
May be null? no
|
The 4-digit University intramural mail code associated with
the location where intramural mail is delivered. Note: This is not necessarily
the same as the U.S. Postal Service zip-code-plus-four extension.
Example: 6228 (WALNUT WEST)
Values:
Refer to the DWADMIMN.MAIL_CODES table for values.
|
|
STATE
Indexed - no
Format - char (2)
May be null? yes
|
The 2-character U.S. Postal Service code that identifies the
state associated with the Mail_Code. (Note: this is not always populated.)
Example: PA (Pennsylvania)
|
STREET
Indexed - no
Format - char (21)
May be null? no |
The street address associated with the Mail_Code. It should
include the building number and street.
Example: 3401 WALNUT STREET (6228)
|
ZIP_CODE
Indexed - no
Format - char (9)
May be null? yes |
The 5- or 9-digit zip code associated with the Mail_Code.
(Note: this is not always populated.)
Examples: 19104 or 191041401
|
