Penn Computing

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

COMP_PAY_REQUEST Table - Data Element Index

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



Data element Definition
ALLOWANCE_TYPE_ID

Indexed - yes
Format - number (22)
May be null? yes
The type of allowance, if any, associated with the request.
Values:
Refer to the DWCOMP.COMP_PAY_ALLOWANCE_TYPE table for values.
AMOUNT_RANGE_HIGH

Indexed - no
Format - number (10,3)
May be null? yes
The highest suggested total project amount, inclusive, for a pre-work payment.
 
AMOUNT_RANGE_LOW

Indexed - no
Format - number (10,3)
May be null? yes
The lowest suggested total project amount, inclusive, for a pre-work payment.
 
      
AWARD_TYPE_ID

Indexed - yes
Format - number (22)
May be null? yes
Indicates, for award pay requests, the type of award.
Values:
Refer to the DWCOMP.COMP_PAY_AWARD_TYPE_LIST table for values.
COMP_ATTACHMENT_GROUP_ID

Indexed - yes
Format - number (22)
May be null? yes
Uniquely identifies the group of attachments (if any exist) for this request.
COMP_PAY_REQUEST_ID

Indexed - yes
Format - number (22)
May be null? no
Uniquely identifies a record in the COMP_PAY_REQUEST table.
COPIED_FROM_PAY_REQUEST_ID

Indexed - yes
Format - number (22)
May be null? no
For requests which were copied from another, the unique identifier for the original request.
CREATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who created the record in the PennWorks Additional Pay module.
 
CREATION_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was created in the PennWorks Additional Pay module.
 
EARNINGS_TYPE

Indexed - yes
Format - char (3)
May be null? yes
The 3-character code indicating the type of earnings for the pay request.
Values:
Refer to the DWPAY.PAYROLL_EARNINGS table for values.
EXTRA_SERVICES_CODE_ID

Indexed - yes
Format - number (22)
May be null? yes
Indicates, for extra services pay requests, the type of extra service performed.
Values:
Refer to the DWCOMP.COMP_PAY_EXTRA_SERVICES_LIST table for values.
EXTRA_WORK_DUTIES

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N), for extra services pay requests, whether the extra work was beyond normal duties.
EXTRA_WORK_ROLE

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N), for extra services pay requests, whether the extra work was done outside of the person's job role.
EXTRACT_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the COMP_PAY_REQUEST record was loaded to the Data Warehouse.
 
FUNDING_SOURCE

Indexed - no
Format - varchar2 (500)
May be null? yes
A general description of the intended source of funding for a pre-work request
GROUP_PAY_CYCLE

Indexed - no
Format - varchar2 (2)
May be null? yes
For group pay requests, the pay cycle selected.
HIDDEN

Indexed - no
Format - varchar2 (1)
May be null? yes
System flag to indicate whether the request is visible via PennWorks based on processing status.
HOURS_OVER_FOURTY_SINGLE

Indexed - no
Format - varchar2 (2)
May be null? yes
Indicates (Y/N) whether hours over 40 are for a single pay.
INCENTIVE_PLAN

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N), for bonus pay requests, whether there is an incentive plan or retention letter on file.

LAST_UPDATE_DATE

Indexed - no
Format - date (7)
May be null? yes

The date on which the record was last updated in the PennWorks Additional Pay module.

LAST_UPDATE_TIMESTAMP

Indexed - no
Format - timestamp (6)
May be null? yes


The timestamp on which the record was last updated in the PennWorks Additional Pay module.
 
LAST_UPDATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who last updated the record in the PennWorks Additional Pay module.
 
MAN_SEP_CHECK

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N) whether the request is to be paid with a manual separate check.

PAY_REQUEST_DATE

Indexed - no
Format - date (7)
May be null? yes

The date that this request should be paid. The actual pay date may be later based on approvals.

PENSION_ADJ_SOURCE

Indexed - yes
Format - number (22)
May be null? yes
For CPUP benefits adjustment pay requests, the unique identifier of the source of the adjustment.
Values:
Refer to the DWCOMP.COMP_EXT_DIST_SOURCE_LIST table for values.

PERIODS_RECURRING

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

The number of periods in a recurring series.

PERFORMANCE_RATING_DATE

Indexed - no
Format - date (7)
May be null? yes

The performance rating date.

PREWORK_ORIGIN

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

Indicates whether this request originated as a pre-work request.

RECURRING

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

Indicates whether this request is a repeating request. These requests are approved in pre-work for a repeating pay cycle for the whole compensation date range.

REQUEST_REASON

Indexed - no
Format - varchar2 (1000)
May be null? yes
The reason for this request.
REQUEST_STATUS

Indexed - yes
Format - number (22)
May be null? yes
Indicates the status of the pay request.
Values:
Refer to the DWCOMP.COMP_PAY_STATUS_LOOKUP table for values.
REQUEST_TYPE_ID

Indexed - yes
Format - number (22)
May be null? yes
Indicates the type of pay request.
Values:
Refer to the DWCOMP.COMP_PAY_TYPE_LOOKUP table for values.
REQUESTER_HOME_CENTER

Indexed - yes
Format - char (2)
May be null? yes
For requesters who are Penn employees, the 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_Center = Center_Code.
      
 
REQUESTER_HOME_ORG

Indexed - yes
Format - char (4)
May be null? yes
For requesters who are Penn employees, 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.
      
REQUESTER_PENN_ID

Indexed - yes
Format - varchar2 (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.

SIGN_RET_BONUS

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N), for bonus pay requests, whether the additional pay signifies a sign-on or retention bonus.
SNAPSHOT_ID

Indexed - no
Format - number (12)
May be null? yes
System identifier for data as it was approved in prework.

STATUS_CHANGED_DATE

Indexed - no
Format - date (7)
May be null? yes

The date that the status was changed to its current value from a different one.

VACATION_AMOUNT

Indexed - yes
Format - number (22)
May be null? yes
For vacation pay requests, the dollar amount of pay requested.
VACATION_DAYS

Indexed - yes
Format - number (22)
May be null? yes
For vacation pay requests, the number of vacation days to pay.

WORK_FROM_DATE

Indexed - no
Format - date (7)
May be null? yes

The start date of when the work was performed for the pay request.

WORK_TO_DATE

Indexed - no
Format - date (7)
May be null? yes

The end date of when the work was performed for the pay request.


COMP_PAY_REQUEST 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