PSSERVICE

(SQL Table)
 Index Back

IB Services

  • Related Language Record: PSSERVICELANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 1

    3 IB_NAMESPACE Character(254) VARCHAR2(254) NOT NULL Service Namespace
    4 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    5 IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service

    Y/N Table Edit

    Default Value: N

    6 IB_REST_SERVICE Number(1,0) SMALLINT NOT NULL REST Service Type
    7 PT_OPEN_API Number(1,0) SMALLINT NOT NULL Open API
    8 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).
    9 IBEXTERNALUSERID Character(30) VARCHAR2(30) NOT NULL External User ID
    10 IBEXTERNALPWD Character(254) VARCHAR2(254) NOT NULL Integration Broker External Password
    11 TOKENTYPE Character(4) VARCHAR2(4) NOT NULL Authentication Token Type
    NONE=None
    STSD=SAML Token
    USRT=Username Token
    UTNP=Username Token, no password

    Default Value: NONE

    12 PTIB_APPSRVGRP Character(30) VARCHAR2(30) NOT NULL Service Group

    Prompt Table: PSIBSRVGROUP_VW

    13 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.
    14 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.
    15 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DESCRLONG Long Character CLOB Long Description