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 |