HR_SP_MER3_TAO(SQL Table) |
Index Back |
|---|---|
Temp record for HR_SP_MERITTemporary record used in the Application Engine program HR_SP_MERIT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | PERIOD_BEGIN_DT |
Date(10) | DATE | Period Begin Date |
| 6 | PERIOD_END_DT |
Date(10) | DATE | Period End Date |
| 7 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 8 | 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 |
| 9 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |
| 10 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 11 | SP_FROM_DATE | Date(10) | DATE | From Date - used in Salary Planning |
| 12 | SP_TO_DATE | Date(10) | DATE | To Date - used in Salary Planning |
| 13 | SP_MER_INCR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Merit Increase Status
A=Approved I=Ineligible N=No Increase P=Proposed R=Processed |
| 14 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver EmplID |
| 15 | APPRVL_DT | Date(10) | DATE | Approval Date |
| 16 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 17 | SP_MER_INCR_MANUAL | Character(1) | VARCHAR2(1) NOT NULL |
Manually Updated flag
Y/N Table Edit |
| 18 | AMOUNT_PER_POINT | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount per point |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 20 | 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 |
| 21 | AMOUNT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent Amount |
| 22 | PCT_PER_POINT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent per point |
| 23 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Rate Code Group Name |
| 24 | SAL_PTS_PER_POINT | Number(5,0) | INTEGER NOT NULL | Salary Points Per Point |
| 25 | SAL_PTS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Salary Points Frequency |
| 26 | POINT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent of Points |
| 27 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 28 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 29 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |