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 |