Penn Computing

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

EMPLOYEE_TAX Table - Data Element Index

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



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

EMPLOYEE_TAX 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