Penn Computing

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

PAR_GROSS_TO_NET 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 record was extracted from the Payroll system and loaded into the Warehouse.

GROSS_TO_NET_AMOUNT

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

The amount of the gross-to-net transaction.

Source: #XPAR-CUR-AMT

GROSS_TO_NET_CODE

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

The gross-to-net code, indicating reductions, deductions, and contributions effected in this pay cycle.

Values:
Refer to the DWPAY.PAYROLL_GROSS_TO_NET table for values.

Source: #XPAR-CUR-CD

GROSS_TO_NET_TYPE

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

Defines the type of transaction.

Values:
R    reduction (pre-tax)
S    shelter (pre-tax)
T    tax
D    deduction (after tax)
C    employer contribution

Source: #XPAR-GTN-TYPE

GTN_SOURCE_CODE

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

Defines the source of the gross-to-net transaction.

Values:
<empty>   normal
A         GTN from prepayment
S         GTN suspended (not taken)
R         GTN suspended as receivable (not taken)
N         GTN was not taken
D         GTN taken from previously suspended balance
V         GTN taken from previously suspended receivable

Source: #XPAR-SOURCE-CD

GTN_SPECIAL_TRANSACTION

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

Defines the type of gross-to-net transaction - indicates whether the transaction is a one-time or normal occurence.

Values: 
<empty>   normal
O         one-time
R         refund

Source: #XPAR-SPEC-TRANS

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)
PAR_GRS_SEQUENCE_NUMBER

Indexed - no
Format - number(5)
May be null? yes
The sequence number identifying each gross-to-net record within the PAR record; assigned during the extract process.
PAR_SEQUENCE_NUMBER

Indexed - no
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_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

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


PAR_GROSS_TO_NET 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