LM_JOBCODE_IDLM_OBJV_IDLM_REVIEW_RATINGPrompt Table: LM_RVW_RTNG_VW2
A=Active
I=Inactive
LM_JOB_OBJV_VW1(SQL View) |
Index Back |
|---|---|
Job Objective ViewJob Objective View |
| SELECT LM_JOBCODE_ID , LM_OBJV_iD , LM_REVIEW_RATING , EFF_STATUS FROM PS_LM_JOB_OBJV |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_JOBCODE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 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 |