SS_LIST_VW

(SQL View)
 Index Back

SS Framework Group ID List Vw

Used in Self Service Framework. View used in Select Peoplecode behind list page that puts an occurrence of SS_GRP_ID into scroll level 1.

SELECT DISTINCT A.TRANSACTION_NAME , B. ROLEUSER , A. SS_GRP_ID , B. SS_ROLETYPE , A. ORIGINATORID , A. SUBMITTED_DT , B. CURRENT_STEP FROM PS_SS_KEYS A , PS_SS_PROCESS_DTL B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID AND A.SS_TRANS_ID = B.SS_TRANS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
3 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 SS_ROLETYPE Character(3) VARCHAR2(3) NOT NULL Used in SS Framework
ADM=Administrator
APR=Approver
INP=Interested Party
ORG=Originator
5 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
6 SUBMITTED_DT Date(10) DATE Used in SS Framework
7 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number