SCD_MAN_RCPT_VW

(SQL View)
 Index Back

Recipients


SELECT 'IN' ,A.oprid ,A.oprdefndesc ,B.EMAILID FROM PSOPRDEFN A ,PSUSEREMAIL B WHERE A.OPRID = B.OPRID AND B.PRIMARY_EMAIL = 'Y' AND B.EMAILID <> ' ' UNION SELECT 'RO' , rolename ,descr ,' ' FROM PSROLEDEFN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_EVALUATOR_TYPE Character(2) VARCHAR2(2) NOT NULL Evaluator Type
IN=Individual
RO=Role

Default Value: IN

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 SCD_DESCR45 Character(45) VARCHAR2(45) NOT NULL 45 Character Description
4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address