SCC_ENTCLD_VW

(SQL View)
 Index Back

SELECT A.SCC_ENTITY_ID , A.SCC_ENTITY_CHLD_ID , A.SCC_ORDER_NBR , B.SCC_ENTITY_NAME , B.SCC_ENTITY_DESCR , B.SCC_APPCLASSNAME , C.SCC_ENT_TYPE_DEFAC , C.SCC_ENTITY_TYPE_ID , B.SCC_RECNAME , B.SCC_STG_RECNAME , A.SCC_ENTITY_EMBED , A.SCC_ENT_CHLD_ENCAP , A.SCC_ENTITY_MIN , A.SCC_ENTITY_MAX , B.SCC_ELEMENT_NAME , A.SCC_ELEMENT_WRAP , B.SCC_STATUS , A.SCC_ENTITY_HIDE FROM PS_SCC_ENTITY_CHLD A , PS_SCC_ENTITY_REG B , PS_SCC_ENTITY_TYPE C WHERE A.SCC_ENTITY_CHLD_ID=B.SCC_ENTITY_ID AND B.SCC_ENTITY_TYPE_ID=C.SCC_ENTITY_TYPE_ID

  • Related Language Record: SCC_ENTCLD_VW_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_ENTITY_CHLD_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    3 SCC_ORDER_NBR Number(3,0) SMALLINT NOT NULL Order Number
    4 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    5 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
    6 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

    Prompt Table: HRS_APPCLASS_PT

    7 SCC_ENT_TYPE_DEFAC Character(190) VARCHAR2(190) NOT NULL Entity Type Default Class
    8 SCC_ENTITY_TYPE_ID Character(40) VARCHAR2(40) NOT NULL Entity Type ID
    9 SCC_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
    10 SCC_STG_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
    11 SCC_ENTITY_EMBED Character(1) VARCHAR2(1) NOT NULL Embed

    Y/N Table Edit

    12 SCC_ENT_CHLD_ENCAP Character(50) VARCHAR2(50) NOT NULL Child Encapsulation
    13 SCC_ENTITY_MIN Character(3) VARCHAR2(3) NOT NULL Min Children
    14 SCC_ENTITY_MAX Character(3) VARCHAR2(3) NOT NULL Max Children
    15 SCC_ELEMENT_NAME Character(30) VARCHAR2(30) NOT NULL Element Name
    16 SCC_ELEMENT_WRAP Character(30) VARCHAR2(30) NOT NULL Element Wrapper
    17 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Active
    I=Inactive
    18 SCC_ENTITY_HIDE Character(1) VARCHAR2(1) NOT NULL Hide Child Entity

    Y/N Table Edit

    Default Value: N