PSLSDEFN_VW

index back

IB Logical Schema View


SELECT IB_PACKAGEID , IB_SCHEMANAME , IB_VARIANTNAME , OBJECTOWNERID , IB_ISPRIVATE , IB_ISCONTAINER , IB_ISIMPORTED , DESCR , DESCRLONG FROM PSLSDEFN WHERE IB_ISCMPPRIM <> '1' AND IB_AUTOGENERATED = 0

  • Related language record: PSLSDEFN_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
    IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
    IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    IB_ISPRIVATE Character(1) VARCHAR2(1) NOT NULL Is Private

    Y/N Table Edit

    Default: N

    IB_ISCONTAINER Character(1) VARCHAR2(1) NOT NULL Message Document
    IB_ISIMPORTED Character(1) VARCHAR2(1) NOT NULL Is Imported
    0=Not Imported
    1=Imported

    Y/N Table Edit

    Default: N

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20