RE_LS_ADM_OPRID (SQL View)	Index Back
Lease Administrators Lists all Operator IDs who are assigned with a role type of 'Internal Administrator'

RE_LS_ADM_OPRID

(SQL View)

Lease Administrators

Lists all Operator IDs who are assigned with a role type of 'Internal Administrator'

SELECT B.OPRID FROM PS_RE_PTY_TYPE A , PS_RE_INT_PARTY B , PS_SET_CNTRL_REC C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_RE_PTY_TYPE A_ED WHERE A.SETID = A_ED.SETID AND A.PARTY_TYPE_CD = A_ED.PARTY_TYPE_CD AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.PARTY_TYPE_CD = B.PARTY_TYPE_CD AND C.SETID = A.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.RECNAME = 'RE_PTY_TYPE' AND A.ROLE_TYP IN ('3','4')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).