PTUS_CTXS_VW

(SQL View)
Index Back

List of search contexts view


SELECT DISTINCT PTUS_CNTX_TYPE , PTUS_CNTX_KEY1 FROM PSPTUS_CTX_DET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTUS_CNTX_TYPE Character(2) VARCHAR2(2) NOT NULL Context Type
H=Home Page
N=Portal Node
W=Work Center
2 PTUS_CNTX_KEY1 Character(65) VARCHAR2(65) NOT NULL Node Name\Workcenter ID

Prompt Table: PTUS_CNTX_VW