PSIBAPPLDEFN

(SQL Table)
 Index Back

IB Application Service Defn

IB Application Services.

  • Related Language Record: PSIBAPPLLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID.
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 PTIB_APPSRVGRP Character(30) VARCHAR2(30) NOT NULL Service Group
    4 PTIBAPPLTYPE Character(1) VARCHAR2(1) NOT NULL Field to denote whether a service is master or Alias
    A=Alias Service
    M=Primary Service

    Default Value: M

    5 PTIB_CONSUMER Number(3,0) SMALLINT NOT NULL Is Consumer
    6 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    7 PTIBAPPLNAME_MSTER Character(30) VARCHAR2(30) NOT NULL Application Service ID.
    8 PTIBURLPARAMNAME Character(128) VARCHAR2(128) NOT NULL Application Service Name for chat bot services.
    9 PTCBURLPARAMNAME Character(30) VARCHAR2(30) NOT NULL Application Service Name for chat bot services.
    10 PTIB_EXPORT Character(1) VARCHAR2(1) NOT NULL Export Service
    N=No Export
    Y=Export Service

    Default Value: N

    11 PTIB_EXPORT_CB Character(1) VARCHAR2(1) NOT NULL Export Service
    N=No
    Y=Enabled

    Default Value: N

    12 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    13 IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
    14 IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
    15 IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
    16 IB_SSL Number(1,0) SMALLINT NOT NULL IB_SSL
    17 PTIB_SUPPORT_XML Number(1,0) SMALLINT NOT NULL Support XML
    18 IBEXTERNALUSERID Character(30) VARCHAR2(30) NOT NULL External User ID
    19 IBEXTERNALPWD Character(254) VARCHAR2(254) NOT NULL Integration Broker External Password
    20 PTIB_AUTHOPTION Character(1) VARCHAR2(1) NOT NULL Authentication Option
    B=Basic Auth
    O=oAuth2
    21 PTAPP_NAME Character(100) VARCHAR2(100) NOT NULL Application Name

    Prompt Table: PSIBPSPTSEC_VW

    22 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    23 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    24 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    26 DESCRLONG Long Character CLOB Long Description