PSIBSVCSETUP(SQL Table) |
Index Back |
|---|---|
IB Service setup. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |