| Data element |
Definition |
EXTRACT_DATE
Indexed - yes
Format - date
May be null? no
|
The date the EMPLOYEE_TAX record was extracted from the Payroll
system and loaded into the Warehouse. |
| FEDERAL_ADDITIONAL_ALLOWANCES
Indexed - no
Format - number (2)
May be null? yes |
Additional Federal Allowances on the employee's W-4 statement.
Source: XDBS-FED-ADDL-ALLOWANCES |
| FEDERAL_ALLOWANCES
Indexed - no
Format - number (2)
May be null? yes |
Federal Allowances on the employee's W-4 statement.
Source: XDBS-FED-ALLOWANCES |
| FEDERAL_TAX_MARITAL_STATUS Indexed - no
Format - varchar2 (1)
May be null? yes |
Tax status for the employee's W-4 statement.
Source: XDBS-FED-TX-MRT-STAT |
| FICA_ELIGIBLE_FLAG
Indexed - no
Format - varchar2 (1)
May be null? yes |
Indicator of FICA eligibility.
Source: XDBS-FICA-ELIGIBLE
Values:
Y Eligible for FICA or Medicare
M Eligible for Medicare only
N Not eligible for FICA or Medicare |
| HOME_DEPT_ORG
Indexed - yes
Format - char (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)
Source: XPAR-DEPT-NO
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
| HOME_SCHOOL_CTR
Indexed - yes
Format - char (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)
Source: UDBS-HOME-SCHOOL
Values:
Refer to the DWADMIN.ORG_CODES table, for values where
Home_School_Ctr = Center_Code.
|
| LOCAL_ENTITY1
Indexed - no
Format - varchar2 (3)
May be null? yes |
The local entity on the employee record.
Source: XDBS-LOCAL-ENTITY-1 |
| LOCAL_ENTITY2
Indexed - no
Format - varchar2 (3)
May be null? yes |
The second local entity on the employee record.
Source :XDBS-LOCAL-ENTITY-2 |
| LOCAL_ENTITY_TAXED1
Indexed - no
Format - varchar2 (3)
May be null? yes |
The local entity taxed.
Source: XDBS-LOCAL-TAXED-1 |
| LOCAL_ENTITY_TAXED2
Indexed - no
Format - varchar2 (3)
May be null? yes |
The second local entity taxed.
Source: XDBS-LOCAL-TAXED-2 |
| NON_RESIDENT_CERTIFICATE_IND
Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: XDBS-NONRES-CERT-IND |
| NRA_ADD_TO_GROSS_INDICATOR
Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: UDBS-NRA-ADD-TO-GROSS |
| NRA_RESIDENCY_STATUS
Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: UDBS-RESIDENCY-STATUS |
| OTHER_TAX_EXEMPT_AMOUNT
Indexed - no
Format - number (9,2)
May be null? yes |
Source: XDBS-OTHER-TAX-EXEM-AMT |
| 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.
Source: Determined by mapping SSN to Penn_ID |
| PSD_EMPLOY
Indexed - no
Format - varchar2 (6)
May be null? yes |
The Political SubDivision (PSD) of employment for local earned income taxes (EIT) resulting from Pennsylvania Act 32. |
| PSD_RESIDENCE
Indexed - no
Format - varchar2 (6)
May be null? yes |
The Political SubDivision (PSD) of residence for local earned income taxes (EIT) resulting from Pennsylvania Act 32. |
| PSD_TAXED_EMP
Indexed - no
Format - varchar2 (6)
May be null? yes |
The Political SubDivision (PSD) of employment taxed for local earned income taxes (EIT) resulting from Pennsylvania Act 32. |
| PSD_TAXED_RES
Indexed - no
Format - varchar2 (6)
May be null? yes |
The Political SubDivision (PSD) of residence taxed for local earned income taxes (EIT) resulting from Pennsylvania Act 32. |
| SSN
Indexed - yes
Format - char (9)
May be null? no
|
The 9-digit Social Security Number of the employee. A Social
Security Number is a unique number assigned to an individual by the federal
Social Security Administration.
Values in this column will only be displayed to individuals with access to employee SSN data; all other users will retrieve nulls in this column.
Source: XDBS-ID-NUMBER |
| STATE_ADDITIONAL_ALLOWANCES
Indexed - no
Format - number (2)
May be null? yes |
Additional State Allowances on the employee's W-4 statement.
Source: XDBS-STATE-ADDL-ALLOWANCES |
| STATE_ALLOWANCES
Indexed - no
Format - number (2)
May be null? yes |
State Allowances on the employee's W-4 statement.
Source: XDBS-STATE-ALLOWANCES |
| STATE_EMPLOYED Indexed - no
Format - varchar2 (3)
May be null? yes |
Source: XDBS-STATE-EMPLOYED |
| STATE_OF_EMPLOYMENT
Indexed - no
Format - varchar2 (3)
May be null? yes |
State of employment.
Source: XDBS-STATE-EMPLOYMENT
Values:
001 – AL, Alabama
002 – AK, Alaska
003 – AZ, Arizona
004 – AR, Arkansas
005 – CA, California
006 – CO, Colorado
007 – CT, Connecticut
008 – DE, Delaware
009 – DC, Dist of Columbia
010 – FL, Florida
011 – GA, Georgia
012 – HI, Hawaii
013 – ID, Idaho
014 – IL, Illinois
015 – IN, Indiana
016 – IA, Iowa
017 – KS, Kansas
018 – KY, Kentucky
019 – LA, Louisiana
020 – ME, Maine
021 – MD, Maryland
022 – MA, Massachusetts
023 – MI, Michigan
024 – MN, Minnesota
025 – MS, Mississippi
026 – MO, Missouri
027 – MT, Montana
028 – NE, Nebraska
029 – NV, Nevada
030 – NH, New Hampshire
031 – NJ, New Jersey
032 – NM, New Mexico
033 – NY, New York
034 – NC, North Carolina
035 – ND, North Dakota
036 – OH, Ohio
037 – OK, Oklahoma
038 – OR, Oregon
039 – PA, Pennsylvania
040 – RI, Rhode Island
041 – SC, South Carolina
042 – SD, South Dakota
043 – TN, Tennessee
044 – TX, Texas
045 – UT, Utah
046 – VT, Vermont
047 – VA, Virginia
048 – WA, Washington
049 – WV, West Virginia
050 – WI, Wisconsin
051 – WY, Wyoming
052 – PR, Puerto Rico |
| STATE_OF_RESIDENCE Indexed - no
Format - varchar2 (3)
May be null? yes |
State of residence.
Source: XDBS-STATE-RESIDENCE
Values:
001 – AL, Alabama
002 – AK, Alaska
003 – AZ, Arizona
004 – AR, Arkansas
005 – CA, California
006 – CO, Colorado
007 – CT, Connecticut
008 – DE, Delaware
009 – DC, Dist of Columbia
010 – FL, Florida
011 – GA, Georgia
012 – HI, Hawaii
013 – ID, Idaho
014 – IL, Illinois
015 – IN, Indiana
016 – IA, Iowa
017 – KS, Kansas
018 – KY, Kentucky
019 – LA, Louisiana
020 – ME, Maine
021 – MD, Maryland
022 – MA, Massachusetts
023 – MI, Michigan
024 – MN, Minnesota
025 – MS, Mississippi
026 – MO, Missouri
027 – MT, Montana
028 – NE, Nebraska
029 – NV, Nevada
030 – NH, New Hampshire
031 – NJ, New Jersey
032 – NM, New Mexico
033 – NY, New York
034 – NC, North Carolina
035 – ND, North Dakota
036 – OH, Ohio
037 – OK, Oklahoma
038 – OR, Oregon
039 – PA, Pennsylvania
040 – RI, Rhode Island
041 – SC, South Carolina
042 – SD, South Dakota
043 – TN, Tennessee
044 – TX, Texas
045 – UT, Utah
046 – VT, Vermont
047 – VA, Virginia
048 – WA, Washington
049 – WV, West Virginia
050 – WI, Wisconsin
051 – WY, Wyoming
052 – PR, Puerto Rico |
| STATE_SPECIAL_INDICATOR Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: XDBS-STATE-SPECIAL-IND |
| STATE_TAXED Indexed - no
Format - varchar2 (3)
May be null? yes |
State taxed.
Source: XDBS-STATE-TAXED
Values:
001 – AL, Alabama
002 – AK, Alaska
003 – AZ, Arizona
004 – AR, Arkansas
005 – CA, California
006 – CO, Colorado
007 – CT, Connecticut
008 – DE, Delaware
009 – DC, Dist of Columbia
010 – FL, Florida
011 – GA, Georgia
012 – HI, Hawaii
013 – ID, Idaho
014 – IL, Illinois
015 – IN, Indiana
016 – IA, Iowa
017 – KS, Kansas
018 – KY, Kentucky
019 – LA, Louisiana
020 – ME, Maine
021 – MD, Maryland
022 – MA, Massachusetts
023 – MI, Michigan
024 – MN, Minnesota
025 – MS, Mississippi
026 – MO, Missouri
027 – MT, Montana
028 – NE, Nebraska
029 – NV, Nevada
030 – NH, New Hampshire
031 – NJ, New Jersey
032 – NM, New Mexico
033 – NY, New York
034 – NC, North Carolina
035 – ND, North Dakota
036 – OH, Ohio
037 – OK, Oklahoma
038 – OR, Oregon
039 – PA, Pennsylvania
040 – RI, Rhode Island
041 – SC, South Carolina
042 – SD, South Dakota
043 – TN, Tennessee
044 – TX, Texas
045 – UT, Utah
046 – VT, Vermont
047 – VA, Virginia
048 – WA, Washington
049 – WV, West Virginia
050 – WI, Wisconsin
051 – WY, Wyoming
052 – PR, Puerto Rico |
| STATE_TAXED_CODE
Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: XDBS-STATE-TAXED-CODE |
| STATE_TAX_MARITAL_STATUS Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: XDBS-FED-TX-MRT-STAT |
| UNEMPLOYMENT_ELIGIBILITY_IND
Indexed - no
Format - varchar2 (1)
May be null? yes |
Source: XDBS-UI-ELIG-IND |
