SP_MER_INCR_EE(SQL Table) |
Index Back |
|---|---|
Employee Merit Increases TableThe Employee Merit Increases is used to define salary increases (in Salary Planning) for an employee based on the employee's appraisal results (in ePerformance Management). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | PERIOD_BEGIN_DT |
Date(10) | DATE NOT NULL | Period Begin Date |
| 4 | PERIOD_END_DT |
Date(10) | DATE NOT NULL | Period End Date |
| 5 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 6 | EP_REVIEW_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged AR=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held |
| 7 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |
| 8 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 9 | SP_FROM_DATE | Date(10) | DATE | From Date - used in Salary Planning |
| 10 | SP_TO_DATE | Date(10) | DATE | To Date - used in Salary Planning |
| 11 | SP_MER_INCR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Merit Increase Status
A=Approved I=Ineligible N=No Increase P=Proposed R=Processed |
| 12 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver EmplID |
| 13 | APPRVL_DT | Date(10) | DATE | Approval Date |
| 14 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: BASE_RATECD_VW |
| 15 | SP_MER_INCR_MANUAL | Character(1) | VARCHAR2(1) NOT NULL |
Manually Updated flag
Y/N Table Edit Default Value: N |
| 16 | AMOUNT_PER_POINT | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount per point |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 18 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: COMP_FREQ_VW |
| 19 | AMOUNT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent Amount |
| 20 | PCT_PER_POINT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent per point |
| 21 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Rate Code Group Name
Prompt Table: COMPRT_GRP_TBL |
| 22 | SAL_PTS_PER_POINT | Number(5,0) | INTEGER NOT NULL | Salary Points Per Point |
| 23 | SAL_PTS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Salary Points Frequency |
| 24 | POINT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent of Points |
| 25 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 26 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 27 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |