HCSC_CLK_ESTNVW

(SQL View)
 Index Back

Show new Components

Show Components not in component Eligibility record

SELECT DISTINCT A.OBJECTOWNERID , A.PNLGRPNAME , A.MARKET , A.DESCR ,'N' ,'NW' FROM PSPNLGRPDEFN A WHERE EXISTS ( SELECT 'X' FROM PSPRSMDEFN B WHERE A.PNLGRPNAME = B.PORTAL_URI_SEG2 AND A.MARKET = B.PORTAL_URI_SEG3 AND B.PORTAL_NAME='EMPLOYEE' AND B.PORTAL_CREF_USGT='TARG') AND NOT EXISTS ( SELECT 'X' FROM PS_HCSC_CLK_CMPELG D WHERE A.OBJECTOWNERID = D.HCSC_CLK_PROD_ID AND A.PNLGRPNAME = D.PNLGRPNAME AND A.MARKET = D.MARKET )

  • Related Language Record: HCSC_CLK_ESN_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCSC_CLK_PROD_ID Character(4) VARCHAR2(4) NOT NULL Product owner ID
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 HCSC_CLK_ELIGLKDWN Character(1) VARCHAR2(1) NOT NULL Indicator for Component Eligible for Process/Genral based Lockdown

    Y/N Table Edit

    6 HCSC_CLK_ENBL_STAT Character(2) VARCHAR2(2) NOT NULL Indicates Event mapping status. It shows any of the 4 values - Enabled/Not Enabled/Failed/New/Overidden
    DI=Not Enabled
    EN=Enabled
    FD=Failed
    NW=New
    OV=Overriden