HCSC_CLK_CEG_VW

(SQL View)
 Index Back

Component Lockdown Eligibility

List of Components available for product

SELECT DISTINCT B.PORTAL_URI_SEG2 , B.PORTAL_URI_SEG3 FROM PSPRSMDEFN B WHERE 1=1 AND EXISTS (SELECT 'X' FROM PSPTCSSRVCONF A WHERE A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PTCS_SERVICEID IN ('HCSC_CLK_EVENTMAP_SEDT') AND A.PORTAL_NAME = '_PTCS_PTEVMAP') AND EXISTS (SELECT 'X' FROM PSPTCSSRVCONF A WHERE A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PTCS_SERVICEID IN ( 'HCSC_CLK_EVENTMAP_PACT') AND A.PORTAL_NAME = '_PTCS_PTEVMAP' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: PY_LCKPNLGRP_VW

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Prompt Table: PY_LCKPGPMKT_VW