SCC_OPRNAME_VW

(SQL View)

SELECT A.OPRID , CASE WHEN A.EMPLID = ' ' THEN OPRDEFNDESC ELSE B.NAME_DISPLAY END FROM PSOPRDEFN A LEFT OUTER JOIN PS_SCC_PRI_NAME_VW B ON A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

2 NAME_DISPLAY_ATCH Character(50) VARCHAR2(50) NOT NULL Display Name used in the attachments grid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
2	NAME_DISPLAY_ATCH	Character(50)	VARCHAR2(50) NOT NULL	Display Name used in the attachments grid