HMCR_SRV_PR_LNG

(SQL View)
 Index Back

Services Prompt Rel Lang

Related Lang Record for HMCR_SRV_PROMPT

SELECT A.PORTAL_LABEL , B.LANGUAGE_CD , B.DESCR254 FROM PSPRSMDEFN A , PSPRSMDEFNLANG B , PSPRSMSYSATTRVL C WHERE A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_REFTYPE = B.PORTAL_REFTYPE AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_NAME = C.PORTAL_NAME AND A.PORTAL_REFTYPE = C.PORTAL_REFTYPE AND A.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND A.PORTAL_NAME = 'HC_REGISTRY' AND A.PORTAL_REFTYPE <> 'F' AND C.PORTAL_ATTR_NAM = 'TYPE' AND C.PORTAL_ATTR_VAL LIKE 'SRV'

  • Related Language Record for HMCR_SRV_PROMPT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HMCR_PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Service/Exception/Type name for storing in cache
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254