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