Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_PERSON_ADDRESS Table   Tables and Data Elements   Salary Management Home   Data Warehouse Home

COMP_PERSON_ADDRESS Table - Data Element Index

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



Data element Definition
ADDRESS_TYPE

Indexed - yes
Format - varchar2 (1)
May be null? no
A 1-character code that indicates the type of address record. No data checking occurs for the current address. It is "current" only in the sense that it is what Payroll listed as the current address in the most recent record available for that employee. It is not necessarily true that this employee's record even exists in the Payroll system any more. Use Employment_Status in the COMP_PERSON table to select desired employees.

Values:

C     Current
P     Permanent

CITY

Indexed - yes
Format - varchar2 (30)
May be null? yes

The city or post office for the employee's address. Some values are abbreviations.

Example: PHILADELPHIA or PHILA

COMP_PERSON_ID

Indexed - yes
Format - number (12)
May be null? no

The unique ID for an employee in the PennWorks application. This number is not used in other data collections, and should not be used for reporting.
COUNTRY

Indexed - no
Format - varchar2 (2)
May be null? yes
The abbreviation for the country of the employee's address. Country will usually be null, indicating a U.S. address.

Example: CZ (Czechoslovakia)


Values:
Refer to the DWADMIN.COUNTRY_CODES table for values.

EXTRACT_DATE

Indexed - no
Format - date
May be null? yes

The date on which the COMP_PERSON_ADDRESS record was loaded to the Data Warehouse.
HOME_CENTER

Indexed - yes
Format - varchar2 (2)
May be null? yes
A 2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)


Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Home_Center = Center_Code.
HOME_DEPT_ORG

Indexed - yes
Format - varchar2 (4)
May be null? yes
The 4-digit number that represents the Organization that owns the employee's record and is responsible for its maintenance. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:
Refer to the DWADMIN.ORG_CODES table for values.
PENN_ID

Indexed - yes
Format - char (8)
May be null? yes
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse..
PHONE

Indexed - no
Format - varchar2 (15)
May be null? yes
The employee's primary home telephone number, including the area code.

Example: 2154567890

STATE

Indexed - yes
Format - varchar2 (2)
May be null? yes
The 2-character U.S. Postal Service code for the state portion of the employee's address.

Example: PA (Pennsylvania)

Values:
Refer to the DWADMIN.COMP_STATE_LIST table for values.
STREET1

Indexed - no
Format - varchar2 (30)
May be null? yes
The street address of the employee's residence. Street1 should include the apartment number, house number and street, box number, or rural route.
STREET2

Indexed - no
Format - varchar2 (30)
May be null? yes
Additional address information supplementing Street1, the street address of the employee's residence.
ZIP

Indexed - no
Format - varchar2 (15)
May be null? yes
The 5- or 9-digit zip code for the employee's address.

Examples: 19104 or 19104-1401


COMP_PERSON_ADDRESS Table   Tables and Data Elements   Salary Management 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