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 NameField TypeColumn TypeDescription
    IB_PACKAGEIDCharacter(100)VARCHAR2(100) NOT NULLReferenced Package
    IB_SCHEMANAMECharacter(100)VARCHAR2(100) NOT NULLDocument Name
    IB_VARIANTNAMECharacter(30)VARCHAR2(30) NOT NULLVersion Name
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    IB_ISPRIVATECharacter(1)VARCHAR2(1) NOT NULLIs Private

    Y/N Table Edit

    Default: N

    IB_ISCONTAINERCharacter(1)VARCHAR2(1) NOT NULLMessage Document
    IB_ISIMPORTEDCharacter(1)VARCHAR2(1) NOT NULLIs Imported
    0=Not Imported
    1=Imported

    Y/N Table Edit

    Default: N

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19