FPMPEREQUAT_TMP(SQL Table) |
Index Back |
|---|---|
Adjustment Constant Table |
| # | 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 | FP_AVG_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Average Type |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 6 | REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 7 | FP_CORPS_CD |
Character(6) | VARCHAR2(6) NOT NULL | Corps |
| 8 | REVIEW_FROM_DT | Date(10) | DATE | Review Period From |
| 9 | REVIEW_THRU_DT | Date(10) | DATE | Review Period To |
| 10 | FP_AVERAGE | Number(5,2) | DECIMAL(4,2) NOT NULL | Average |
| 11 | FP_MARK_NB | Number(2,0) | SMALLINT NOT NULL | Number of Assesment Points |
| 12 | FP_ADJUSTMNT_CST | Number(5,2) | DECIMAL(4,2) NOT NULL | Adjustment Constant |
| 13 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_VW |
| 14 | 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=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress Default Value: IP |
| 15 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 16 | CREATION_DT | Date(10) | DATE | Creation Date |