OPR_DEF_PM_VW

(SQL View)
Index Back

select A.OPRID, B.NAME1 from PS_OPR_DEF_TBL_PM A, PS_OPR_DEF_TBL_FS B where A.OPRID = B.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1