SCC_ENT_VWP_VW

(SQL View)
 Index Back

Entity View Properties

Entity View Properties combined with Entity Properties used by the Entitty Registry Cache.

SELECT A.SCC_ENT_VIEW_ID , A.SCC_ENTITY_ID , B.SCC_PROP_NAME , C.SCC_PROP_TYPE , C.SCC_ENT_LOCK , B.SCC_ORDER_NBR , C.FIELDNAME , B.SCC_SHOW_TO_XML , B.SCC_PARSE_FROM_XML , B.SCC_SHOW_LOV_DESCR , C.SCC_PROP_XML_TAG , C.SCC_IN_PROD , C.SCC_IN_STAGE , C.SCC_PROP_REQUIRED , C.SCC_PROP_LABEL , C.SCC_PROP_DESCR , C.SCC_EP_DEFTYPE , C.SCC_PROP_DEFAULT , C.SCC_LOV_RECNAME , C.SCC_LOV_FIELDNAME , C.SCC_SL_LOV_CONTEXT , C.SCC_LOV_UID , A.SCC_ENT_VIEW_DFLT , C.SCC_EPROP_LIST , C.SCC_EPROP_ATTRIB , C.SCC_CAF_ATTRIB_NM , C.SCC_EPROP_LOV_REQ , C.SCC_EPROP_SKP_LOV , C.SCC_ZERO_NUMBER FROM PS_SCC_ENTITY_VIEW A , PS_SCC_ENT_VW_PROP B , PS_SCC_ENT_PROPS C WHERE A.SCC_ENT_VIEW_ID=B.SCC_ENT_VIEW_ID AND A.SCC_ENTITY_ID=C.SCC_ENTITY_ID AND B.SCC_PROP_NAME=C.SCC_PROP_NAME

  • Related Language Record: SCC_ENT_VWP_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENT_VIEW_ID Character(40) VARCHAR2(40) NOT NULL Entity View ID
    2 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    3 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
    4 SCC_PROP_TYPE Character(2) VARCHAR2(2) NOT NULL Property Type
    10=String
    20=Number
    30=Datetime
    40=Date
    50=Time
    5 SCC_ENT_LOCK Number(1,0) SMALLINT NOT NULL Lock
    6 SCC_ORDER_NBR Number(3,0) SMALLINT NOT NULL Order Number
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 SCC_SHOW_TO_XML Character(1) VARCHAR2(1) NOT NULL to XML

    Y/N Table Edit

    9 SCC_PARSE_FROM_XML Character(1) VARCHAR2(1) NOT NULL Editable

    Y/N Table Edit

    10 SCC_SHOW_LOV_DESCR Character(1) VARCHAR2(1) NOT NULL Show LOV Description

    Y/N Table Edit

    11 SCC_PROP_XML_TAG Character(50) VARCHAR2(50) NOT NULL Element (XML)
    12 SCC_IN_PROD Character(1) VARCHAR2(1) NOT NULL In Production

    Y/N Table Edit

    Default Value: N

    13 SCC_IN_STAGE Character(1) VARCHAR2(1) NOT NULL In Stage

    Y/N Table Edit

    Default Value: N

    14 SCC_PROP_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    Default Value: N

    15 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label
    16 SCC_PROP_DESCR Long Character CLOB Description
    17 SCC_EP_DEFTYPE Character(2) VARCHAR2(2) NOT NULL Default Type
    10=Record
    20=Custom
    30=Skip

    Default Value: 30

    18 SCC_PROP_DEFAULT Character(254) VARCHAR2(254) NOT NULL Property Default
    19 SCC_LOV_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: SCC_LOV_REC_PT

    20 SCC_LOV_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: SCC_LOV_FLD_PT

    21 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context

    Prompt Table: SCC_LOV_CTXT

    22 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID
    23 SCC_ENT_VIEW_DFLT Character(1) VARCHAR2(1) NOT NULL Entity View Default

    Y/N Table Edit

    Default Value: N

    24 SCC_EPROP_LIST Character(1) VARCHAR2(1) NOT NULL Entity Property List

    Y/N Table Edit

    Default Value: N

    25 SCC_EPROP_ATTRIB Character(1) VARCHAR2(1) NOT NULL Entity Property Attribute

    Y/N Table Edit

    Default Value: N

    26 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
    27 SCC_EPROP_LOV_REQ Character(1) VARCHAR2(1) NOT NULL Entity Property Request List of Values

    Y/N Table Edit

    28 SCC_EPROP_SKP_LOV Character(1) VARCHAR2(1) NOT NULL Entity Property Skip List of Values

    Y/N Table Edit

    29 SCC_ZERO_NUMBER Character(1) VARCHAR2(1) NOT NULL Treat Zero as a Number

    Y/N Table Edit