EX_OPR_TMP_S_VW

(SQL View)
Index Back

User Template Search View

User Template Search View

SELECT a.oprid , b.name ,c.authorized_oprid FROM ps_ex_opr_tmpl_tbl a , ps_personal_data b , PS_EX_EE_AUTH_TBL c WHERE b.emplid = c.emplid

# 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 AUTHORIZED_OPRID Character(30) VARCHAR2(30) NOT NULL Authorized User ID