SCC_EDS_PT

(SQL View)
 Index Back

Entity Data Set Prompt Table

Entity Data Set Prompt Table

SELECT A.SCC_ENT_PRFL_ID , A.SCC_ENTITY_ID , B.SCC_ENT_PRFL_NAME , C.SCC_ENTITY_NAME FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENTITY_PRFL B , PS_SCC_ENTITY_REG C WHERE A.SCC_ENTITY_ID=C.SCC_ENTITY_ID AND A.SCC_ENT_PRFL_ID=B.SCC_ENT_PRFL_ID AND B.SCC_ENT_PRFL_TYPE='40' AND C.SCC_ENTITY_TYPE_ID='SCC_ETYPE_20130116133604'

  • Related Language Record: SCC_EDS_PT_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENT_PRFL_ID Character(40) VARCHAR2(40) NOT NULL Entity Profile ID

    Prompt Table: SCC_EPFL_EDS_PT

    2 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    3 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name
    4 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name