LM_OPRID_ORG_VW

(SQL View)
 Index Back

Oprid organization view


SELECT A.OPRID , B.LM_ORGANIZATION_ID FROM PS_LM_PERSON_OPRID A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON D WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND D.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND B.LM_ACTIVE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID