LM_OBJV_JOB_VW(SQL View) |
Index Back |
---|---|
Job and Objective MappingMapping an HR Job to ELM Objective |
SELECT A.LM_OBJV_ID , A.LM_JOBCODE_ID , A.EFFDT , A.LM_REVIEW_RATING , A.EFF_STATUS , A.LM_END_EFFDT , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_JOB_OBJV A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Objective ID. System Generated ID Number associated with each Objective.
Prompt Table: LM_OBJV_TBL_VW4 |
2 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
JobCode ID
Prompt Table: LM_JOBCODE_VW2 |
3 | LM_EFFDT | Date(10) | DATE NOT NULL | Effective Date |
4 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL |
REview points for Rating models from HRMS
Prompt Table: LM_RVW_RTNG_VW |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
6 | LM_END_EFFDT | Date(10) | DATE | The end effective date, automatically maintained, there's a doc on how this works, so read it |
7 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
8 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
9 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
10 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |