PSIBSCHEMAPARAM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTIBAPPLNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Service ID. (see PSIBAPPLDEFN).
2	PTIBSCHEMANAME	Character(30)	VARCHAR2(30) NOT NULL	Schema Name
3	PARAM_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	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
5	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID
6	PT_PARMLENGTH	Number(5,0)	INTEGER NOT NULL	Parameter Length
7	IB_REQUIRED	Number(1,0)	SMALLINT NOT NULL	IB Required
8	PTIB_PARAMVAL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Value Type F=Fixed Value R=Runtime Value
9	PTIB_PARAM_VALUE	Character(100)	VARCHAR2(100) NOT NULL	Parameter Value
10	PTIB_JSON_DESC	Long Character	CLOB	JSON Schema