FPMPEREQUAT_TMP(SQL Table) |
Index Back |
---|---|
Adjustment Constant Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(1) | VARCHAR2(1) NOT NULL | Average Type | |
3 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
|
4 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
5 | Number(8,0) | INTEGER NOT NULL | Document ID | |
6 | Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID | |
7 | 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=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held Default Value: IP |
15 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
16 | CREATION_DT | Date(10) | DATE | Creation Date |