LM_STG_PITEM_VW

(SQL View)
Index Back

SELECT A.EMPLID , A.LM_PROFILE_ID , A.LM_JP_TYPE , D.EFFDT , D.LM_REVIEW_RATING , D.LM_CAT_ITEM_ID , D.LM_RATING_MODEL , D.LM_EIP_CTRL_ID , D.LM_EIP_PRCS_STTS , D.AUDIT_ACTN FROM PS_LM_STG_PROFILES A , PS_LM_STG_PROF_ITM D WHERE A.LM_PROFILE_ID = D.LM_PROFILE_ID AND A.LM_EIP_CTRL_ID = D.LM_EIP_CTRL_ID AND A.LM_EIP_PRCS_STTS = D.LM_EIP_PRCS_STTS AND A.PROCESS_INSTANCE = D.PROCESS_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 LM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Profile ID
3 LM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Job Profile Types
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
6 LM_CAT_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Category Item field
7 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages
8 LM_EIP_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
9 LM_EIP_PRCS_STTS Character(1) VARCHAR2(1) NOT NULL EIP Process status
0=Not Processed
1=Validated
2=Invalid Data
3=Loaded Successfully
4=Invalid EmplRcd Number
5=Warning Message
10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values