Penn Computing

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

COMP_INCREASE_BATCH Table - Data Element Index

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



Data element Definition
COMPLETED_RUN_DATE_MONTHLY

Indexed - no
Format - date (7)
May be null? yes
The date the overlay process occurred for the Salary Increase Program batch, for non-weekly employees only.
COMPLETED_RUN_DATE_WEEKLY

Indexed - no
Format - date (7)
May be null? yes
The date the overlay process occurred for the Salary Increase Program batch, for weekly hourly employees only.
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 Salary Increase Program module.
 
CREATION_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was created in the PennWorks Salary Increase Program module.
 
END_DATE_MONTHLY

Indexed - no
Format - date (7)
May be null? yes
The end effective date of this Salary Increase Program batch for monthly employees.
END_DATE_WEEKLY

Indexed - no
Format - date (7)
May be null? yes
The end effective date of this Salary Increase Program batch for weekly employees.
EXTRACT_DATE

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

Indexed - yes
Format - varchar2 (4)
May be null? yes
The fiscal year to which this Salary Increase Program batch applies.
FREEZE_DATE

Indexed - no
Format - date (7)
May be null? yes
The date as of which users can no longer make changes (in the PennWorks Salary Increase Program module) to records related to this batch.
INCREASE_BATCH_DESC

Indexed - yes
Format - varchar2 (300)
May be null? yes
Textual description of the Salary Increase Program batch.
Values:
Refer to the DWADMIN.COMP_INCREASE_BATCH table for values.
INCREASE_BATCH_ID

Indexed - yes
Format - number
May be null? no
Uniquely identifies a record in the COMP_INCREASE_BATCH table.
INCREASE_BATCH_TYPE

Indexed - yes
Format - varchar2 (2)
May be null? yes
The unique code identifying a Salary Increase Program batch.
Values:
Refer to the DWADMIN.COMP_INCREASE_BATCH table for values.
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 Salary Increase Program module.
 

LAST_UPDATE_DATE

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

The date on which the record was last updated in the PennWorks Salary Increase Program 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 Salary Increase Program module.
 
ROLE_CHANGE_SINCE_DATE

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

A predefined date for the entire batch used to flag role records that may need review after the beginning of the Salary Increase Program (e.g., those roles who Last_Update_Date follows this Role_Change_Since_Date).

 
SCHEDULED_RUN_DATE_MONTHLY

Indexed - no
Format - date (7)
May be null? yes
The scheduled date for the overlay process for the Salary Increase Program batch, for non-weekly employees only.
SCHEDULED_RUN_DATE_WEEKLY

Indexed - no
Format - date (7)
May be null? yes
The scheduled date for the overlay process for the Salary Increase Program batch, for weekly hourly employees only.
START_DATE_MONTHLY

Indexed - no
Format - date (7)
May be null? yes
The effective start date of the Salary Increase Program batch, for non-weekly employees only.
START_DATE_WEEKLY

Indexed - no
Format - date (7)
May be null? yes
The effective start date of the Salary Increase Program batch, for weekly hourly employees only.
UNIV_HIGH_PERC_FACULTY

Indexed - no
Format - number (5,2)
May be null? no
The upper bound, inclusive, of the percentage of change in salary for faculty allowed by the University for this Salary Increase Program batch.
UNIV_HIGH_PERC_STAFF

Indexed - no
Format - number (5,2)
May be null? no
The upper bound, inclusive, of the percentage of change in salary for staff allowed by the University for this Salary Increase Program batch.
UNIV_LOW_PERC_FACULTY

Indexed - no
Format - number (5,2)
May be null? no
The lower bound, inclusive, of the percentage of change in salary for faculty allowed by the University for this Salary Increase Program batch.
UNIV_LOW_PERC_STAFF

Indexed - no
Format - number (5,2)
May be null? no
The lower bound, inclusive, of the percentage of change in salary for staff allowed by the University for this Salary Increase Program batch.
UNIV_MAX_INC_FACULTY

Indexed - no
Format - number (5,2)
May be null? no
The maximum increase in salary in dollars, inclusive, for faculty allowed by the University for this Salary Increase Program batch.
UNIV_MAX_INC_STAFF

Indexed - no
Format - number (5,2)
May be null? no
The maximum increase in salary in dollars, inclusive, for staff allowed by the University for this Salary Increase Program batch.
UNIV_PERC_FACULTY

Indexed - no
Format - number (5,2)
May be null? no
The University-specified percentage increase for faculty, for this Salary Increase Program batch.
UNIV_PERC_STAFF

Indexed - no
Format - number (5,2)
May be null? no
The University-specified percentage increase for staff, for this Salary Increase Program batch.

COMP_INCREASE_BATCH 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