Penn Computing

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

PAR_TAX_ACH_BENEFITS Table - Data Element Index

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



Data element Definition
ACH_APPROVAL_IND

Indexed - no
Format - char(1)
May be null? yes

For records with a TRANSACTION_CODE of '85' (current payroll activity) and a DISTRIBUTION_TYPE of 'A' (advice), the value of this field will be 'A' if the prenote date on the employee's record has past; for other records, the value will be null.

Source: #XPAR-ACH-APPRV-IND

BIRTH_DATE

Indexed - no
Format - date
May be null? yes

The birth date of the employee.

Source: #XPAR-DATE-OF-BIRTH

BOND_AMOUNT

Indexed - no
Format - number(7,2)
May be null? yes

The amount of the bonds listed on this payroll transaction.

Source: #XPAR-BOND-AMT

CPUP_EXCESS_LIFE_AMOUNT

Indexed - no
Format - number(7,2)
May be null? yes

The Excess Life Amount charged on this transaction for life insurance over the $50,000 supplied by the CPUP Benefits Plan.

Source: #XPAR-CPUP-EXCESS-LIFE

DISTRIBUTION_INSTITUTION_ID

Indexed - no
Format - char(9)
May be null? yes

For records with a TRANSACTION_CODE of '85' (current payroll activity) and a DISTRIBUTION_TYPE of 'A' (advice), indicates the financial institution ID number. For other records, the value will be null.

Source: #XPAR-DISB-INSTITUTION-ID
DISTRIBUTION_TYPE

Indexed - no
Format - char(1)
May be null? yes

Indicates the form the distribution takes. For records with a TRANSACTION_CODE different from '85' (current payroll activity) this field will be empty.

Values:
A   advice
C   check
null
Source: #XPAR-DISB-TYPE
DOMESTIC_PARTNER_AMOUNT

Indexed - no
Format - number(7,2)
May be null? yes

The amount charged for taxable Domestic Partner benefits.

Souce: #XPAR-DOMESTIC-PARTNER

EXCESS_LIFE_AMOUNT

Indexed - no
Format - number(7,2)
May be null? yes

The Excess Life Amount charged on this transaction for life insurance over the $50,000 supplied by the University Benefits Plan.

Source: #XPAR-EXCESS-LIFE

EXTRACT_DATE

Indexed - yes
Format - date
May be null? no

The date the record was extracted from the Payroll system and loaded into the Warehouse.

FEDERAL_ALLOWANCES

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

The number of Federal allowances used to calculate federal taxes on this payroll transaction.

Source: #XPAR-FED-ALLOWANCES

FEDERAL_ADDL_ALLOWANCES

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

The number of additional Federal allowances used to calculate federal taxes on this payroll transaction.

Source: #XPAR-FED-ADDL-ALLOWANCES

FEDERAL_MARITAL_STATUS

Indexed - no
Format - char(1)
May be null? yes

The Federal marital status used to calculate federal taxes on this payroll transaction.

Values:
<empty>  defaults to S
S     single
M     married

#XPAR-FED-TX-MRT-STAT

HOME_DEPT_ORG

Indexed - yes
Format - char(4)
May be null? no

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.
Source: #XPAR-DEPT-NO
HOME_SCHOOL_CTR

Indexed - yes
Format - char(2)
May be null? no
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_School_Ctr = Center_Code.
Source: #UDPT-REPORTING-LVL(2,2)
LOCAL_TAX_CODE1

Indexed - yes
Format - char(3)
May be null? yes

The local entity taxed for this payroll transaction.

Values:
706   Philadelphia non-resident
707   Philadelphia resident
708   Pennsylvania local no tax
710   California local no ta
326   New York City resident
327   New York City non-resident.
Source: #XPAR-LOCAL-TAX-CODE-1
LOCAL_TAX_CODE2

Indexed - no
Format - char(3)
May be null? yes

Not currently used in the University Payroll system.

Source: #XPAR-LOCAL-TAX-CODE-2

NRA_ADD_TO_GROSS

Indexed - no
Format - char(1)
May be null? yes
A flag to indicate NRA taxing that inflates federal gross.

Values:
blank    not NRA elig
N        Non-Resident Alien
R        Resident Alien
NRA_RESIDENCY_STATUS

Indexed - no
Format - char(1)
May be null? yes
A flag to indicate if eligible for NRA Residency Status.

Values:
blank   not NRA elig
T       true, NRA elig
F       false, not NRA elig
NUMBER_OF_BONDS

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

The number of Bonds listed on this payroll transaction.

Source: #XPAR-NO-BONDS

OTHER_TAX_EXEMPT_AMOUNT

Indexed - no
Format - number(7,2)
May be null? yes
Source: #XPAR-OTHER-TAX-EXEM-AMT
PAR_SEQUENCE_NUMBER

Indexed - yes
Format - number(5)
May be null? no
The sequence number for PAR record, assigned during the data extract process.
PAY_CYCLE

Indexed - yes
Format - char(2)
May be null? no

The pay cycle.

Values:
W1 – weekly cycle
M1 – monthly cycle
M2 – monthly exec cycle
XX – W2 adjustment cycles

Source: #XPAR-PAY-CYCLE

PAY_DISPOSITION

Indexed - no
Format - char(1)
May be null? yes

Indicates the form the distribution takes. For records with a TRANSACTION_CODE of '85' (current payroll activity) the value will be 'D', indicating the department address is used. For records with TRANSACTION_CODES of other values, the field will be empty.

Values:
D   department address used
null
Source: #XPAR-PAY_DISPOSITION
PAY_END_DATE

Indexed - yes
Format - date
May be null? no

Date through which the transaction was made to the employee.

Source: #XPAR-PAY-END-DATE

PAY_SCHEDULE

Indexed - yes
Format - char(3)
May be null? no

Three digit schedule indicating the pay within the month.

Values:
001 – first weekly pay
002 – second weekly pay
003 – third weekly pay
004 – fourth weekly pay
005 – fifth weekly pay
006 – monthly pay
007 – monthly Executive Pay
998 – W-2 Executive adjustment cycle
999 – W-2 adjustment cycle
Source: #XPAR-SCHEDULE
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

PREVIOUS_SSN

Indexed - no
Format - char (9)
May be null? yes

The 9-character previous Social Security Number of the employee. If an employee record has been entered in the Payroll system with a temporary or incorrect Social Security Number, the HRIM/Records office can can change/correct it. The temporary or incorrect Social Security Number will be saved as the value of Previous_SSN. This column is not updated if the individuals SSN is changes after the PAR cycle for which the record was written.

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: #XPAR-PRIOR-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

Indexed - no
Format - varchar2 (1)
May be null? yes

The Political SubDivision (PSD) taxed for local earned income taxes (EIT) resulting from Pennsylvania Act 32.

Values:
E  Political  SubDivision (PSD) of employment
R  Political  SubDivision (PSD) of residence
SICK_ACCRUED

Indexed - no
Format - number (5,2)
May be null? yes

Not currently used in the University Payroll system.

Source: #XPAR-SICK-LV-DATE

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 Admininistration.

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: #XPAR-ID-NO

STATE_ALLOWANCES

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

The number of State allowances used to calculate federal taxes on this payroll transaction.

Source: #XPAR-STATE-ALLOWANCES

STATE_ADDL_ALLOWANCES

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

The number of additional State allowances used to calculate federal taxes on this payroll transaction.

Source: #XPAR-STATE-ADDL-ALLOWANCES

STATE_EMPLOYMENT

Indexed - yes
Format - char(3)
May be null? yes

The code for the state of employment.

Values:
039    Pennsylvania
031    New Jersey
005    California
033    New York

Source: #XPAR-STATE-EMPLOYMENT

STATE_MARITAL_STATUS

Indexed - no
Format - char(2)
May be null? yes

The State marital status used to calculate federal taxes on this payroll transaction.

Values:
<empty>  defaults to S
S     single
M     married

Source: #XPAR-STATE-TX-MRT-STAT

STATE_SPECIAL_INDICATOR

Indexed - no
Format - char(1)
May be null? yes

 

Source: #XPAR-STATE-SPECIAL-IND

STATE_TAXED

Indexed - yes
Format - char(3)
May be null? yes

The code for the state used to calculate tax.

Values:
039    Pennsylvania
031    New Jersey
005    California
033    New York

Source: #XPAR-STATE-TAXED

STATE_UI_ELIGIBILITY_INDICATOR

Indexed - no
Format - char(1)
May be null? yes

Indicates an individual override of eligibility for state unemployment insurance.

Source: #XPAR-UI-ELIG-IND

VACATION_ACCRUED

Indexed - no
Format - number (5,2)
May be null? yes

Not currently used in the University Payroll system.

Souce: #XPAR-VACTN-ACCRUED


PAR_TAX_ACH_BENEFITS 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