LM_POSITION_NBRLM_OBJV_IDLM_REVIEW_RATINGPrompt Table: LM_RVW_RTNG_VW2
A=Active
I=Inactive
LM_POS_OBJV_VW1(SQL View) |
Index Back |
|---|---|
Position Objective ViewPosition Objective View |
| SELECT LM_POSITION_NBR , LM_OBJV_ID , LM_REVIEW_RATING , EFF_STATUS FROM PS_LM_POSTN_OBJV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_POSITION_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Position Number |
| 2 | LM_OBJV_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 3 | LM_REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
REview points for Rating models from HRMS
Prompt Table: LM_RVW_RTNG_VW2 |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |