PSIBSVCSETUP

(SQL Table)
Index Back

IB Service setup.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 1

2 IB_NAMESPACE Character(254) VARCHAR2(254) NOT NULL Service Namespace
3 IB_SCHEMANAMESPACE Character(254) VARCHAR2(254) NOT NULL Schema Namespace
4 IB_TGTLOCATION Character(254) VARCHAR2(254) NOT NULL Target Location
5 IB_SECTGTLOCATION Character(254) VARCHAR2(254) NOT NULL Secure Target Location
6 IB_RESTTGTLOC Character(254) VARCHAR2(254) NOT NULL Target Location
7 IB_RESTSECTGTLOC Character(254) VARCHAR2(254) NOT NULL Secure Target Location
8 IB_SVCSTATUS Character(1) VARCHAR2(1) NOT NULL Service System Status
D=Development
P=Production

Default Value: D

9 IB_WSDLALIASCHECK Character(1) VARCHAR2(1) NOT NULL WSDL Generation Alias Check
E=Error
N=None
W=Warning

Default Value: N

10 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.
11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
12 IB_MULTIQUEUE Character(1) VARCHAR2(1) NOT NULL Enable Multi-queue

Y/N Table Edit

Default Value: N

13 PT_SRV_CNTCT_NAME Character(254) VARCHAR2(254) NOT NULL Contact Name
14 PT_SRV_CNTCT_URL Character(254) VARCHAR2(254) NOT NULL Contact URL
15 PT_SRV_CNTCT_EMAIL Character(254) VARCHAR2(254) NOT NULL Contact Email
16 PT_SRV_LCSNC_NAME Character(254) VARCHAR2(254) NOT NULL license name
17 PT_SRV_LCSNC_URL Character(254) VARCHAR2(254) NOT NULL license URL
18 PTIB_TOKENTYPE Character(1) VARCHAR2(1) NOT NULL Token Type
O=oAuth2 Token
P=PSFT Token

Default Value: P

19 PT_SRV_EXTDOC_DESC Character(254) VARCHAR2(254) NOT NULL Contact Email
20 PT_SRV_EXTDOC_URL Character(254) VARCHAR2(254) NOT NULL Contact Email
21 PT_SRV_TERMS_SRV Character(254) VARCHAR2(254) NOT NULL Terms of Service
22 PTIB_AUTHURL Character(254) VARCHAR2(254) NOT NULL Service Applications

Prompt Table: PTIB_APPNAME_VW