SADPDLPRCFVWLNG

(SQL View)
 Index Back

Prospect Attribute Prompt

Prospect Attribute Prompt - Related Language

SELECT A.SCC_CAF_ATTRIB_NM , B.LANGUAGE_CD , B.DESCR FROM PS_SCC_CAF_RAT_VW A , PS_SCC_CAF_ATTR_LN B WHERE A.RECNAME='ADM_PRSPCT_CAR' AND (A.SCC_ENTITY_ID IS NULL OR A.SCC_ENTITY_ID IN ( SELECT DISTINCT X.SCC_ENTITY_ID FROM PS_SCC_CAF_RAT_ENT X WHERE X.RECNAME = 'ADM_PRSPCT_CAR' AND A.SCC_ENTITY_ID = X.SCC_ENTITY_ID)) AND B.SCC_CAF_ATTRIB_NM = A.SCC_CAF_ATTRIB_NM

  • Related Language Record for SADPDLPRSCAF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description