SCC_ENTP_AT_VW

(SQL View)
 Index Back

ER


SELECT A.SCC_ENTITY_ID , A.SCC_PROP_NAME , B.SCC_ENTITY_NAME , A.SCC_PROP_LABEL , A.SCC_PROP_TYPE , ' ' , A.SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS A , PS_SCC_ENTITY_REG B WHERE A.SCC_ENTITY_ID=B.SCC_ENTITY_ID AND A.SCC_PROP_TYPE<>'60' UNION ALL SELECT A.SCC_ENTITY_ID , A.SCC_PROP_NAME , B.SCC_ENTITY_NAME , A.SCC_PROP_LABEL , A.SCC_PROP_TYPE , C.SSR_ITEM_ATTR_TYPE , A.SCC_PROP_DESCR FROM PS_SCC_ENT_PROPS A , PS_SCC_ENTITY_REG B , PS_SSR_ITEM_ATTR C WHERE A.SCC_ENTITY_ID=B.SCC_ENTITY_ID AND A.SCC_PROP_TYPE='60' AND A.SCC_PROP_NAME=C.SSR_ITEM_ATTR

  • Related Language Record: SCC_ENTP_AT_V_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    2 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
    3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    4 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label
    5 SCC_PROP_TYPE Character(2) VARCHAR2(2) NOT NULL Property Type
    10=String
    20=Number
    30=Datetime
    40=Date
    50=Time
    6 SSR_ITEM_ATTR_TYPE Character(2) VARCHAR2(2) NOT NULL Academic Item Attribute Type
    10=List of Valid Values
    20=Free-form Text
    30=Numeric
    40=Table Validation
    50=Long Text
    60=Translate Table Validation
    70=Date

    Default Value: 10

    7 SCC_PROP_DESCR Long Character CLOB Description