| Data element |
Definition |
ADDRESS_LINE_ONE
Indexed - no
Format - varchar2 (55)
May be null? yes
|
The first line of the employee's residence address. |
ADDRESS_LINE_TWO
Indexed - no
Format - varchar2 (55)
May be null? yes
|
Additional address information supplementing Address Line One. |
|
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_LONG_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.
|
| MAIL_CODE
Indexed - no
Format - varchar2 (4)
May be null? yes |
The 4-digit intramural mail code associated with the building in which the employee works (as maintained in the PennWorks system).
Values:
Refer to the DWADMIN.MAIL_CODES table for values.
|
PENN_ID
Indexed - yes
Format - varchar2 (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..
|
POSTAL_CODE
Indexed - no
Format - varchar2 (12)
May be null? yes
|
The postal code for the employee's address.
Examples: 19104 or 19104-1401 |
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.
|
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:
L Local
P Permanent
W Work |
