PSIBPARAM

(SQL Table)
Index Back

Application Service parameters

IB Application Services parameters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).
2 PTIBAPPLOPR Character(30) VARCHAR2(30) NOT NULL Application Service Opr ID
3 IB_URI_SEQ Number(5,0) INTEGER NOT NULL Sequence Number
4 IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method
5 PARAM_NAME Character(50) VARCHAR2(50) NOT NULL Name
6 PTIBPARAMTYPE Character(4) VARCHAR2(4) NOT NULL Parameter Type
IN=Input Parameter
OUT=Output Parameter
RES=Resource Parameter
7 PTIBPARAMDTYPE Character(4) VARCHAR2(4) NOT NULL Parameter Data Type
BOOL=Boolean
CMPA=Compound Array
COMP=Compound
CUST=Custom
DATE=Date
DOC=Document
INT=Integer
NLST=Number List
NUM=Number
SLST=String List
STR=String
TIME=Time
8 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
9 PT_PARMLENGTH Number(5,0) INTEGER NOT NULL Parameter Length
10 IB_REQUIRED Number(1,0) SMALLINT NOT NULL IB Required
11 PTIB_PARAMVAL_TYPE Character(1) VARCHAR2(1) NOT NULL Value Type
F=Fixed Value
R=Runtime Value

Default Value: R

12 PTIB_PARAM_VALUE Character(100) VARCHAR2(100) NOT NULL Parameter Value
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 IBCORRELATIONID Character(36) VARCHAR2(36) NOT NULL Correlation ID
17 PTIB_JSON_DESC Long Character CLOB JSON Schema