PSIBBASEPARAM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTIBAPPLNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Service ID. (see PSIBAPPLDEFN).
2	PARAM_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	PTIBPARAMDTYPE	Character(4)	VARCHAR2(4) NOT NULL	Parameter Data Type BIN=Binary 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
4	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
5	PT_PARMLENGTH	Number(5,0)	INTEGER NOT NULL	Parameter Length
6	PTIB_PARAMVAL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Value Type F=Fixed Value R=Runtime Value Default Value: R
7	PTIB_PARAM_VALUE	Character(100)	VARCHAR2(100) NOT NULL	Parameter Value
8	IB_PACKAGEID	Character(100)	VARCHAR2(100) NOT NULL	Referenced Package
9	IB_SCHEMANAME	Character(100)	VARCHAR2(100) NOT NULL	Document Name
10	IB_VARIANTNAME	Character(30)	VARCHAR2(30) NOT NULL	Version Name
11	IBCORRELATIONID	Character(36)	VARCHAR2(36) NOT NULL	Correlation ID
12	PTIB_JSON_DESC	Long Character	CLOB	JSON Schema