LM_OBJV_JOB_VW

(SQL View)
Index Back

Job and Objective Mapping

Mapping 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