CS_SECSES_VW

(SQL View)
 Index Back

PTSF SetID Security


SELECT SI.SETID , 'A:ALL' FROM PS_SETID_TBL SI UNION ALL SELECT ' ' , 'A:ALL' FROM PS_INSTALLATION UNION ALL SELECT OPR.SETID , 'S:' %Concat OPR.SETID FROM PS_SETID_TBL OPR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SETID_SECURITY_SES Character(40) VARCHAR2(40) NOT NULL SETID Security