PSIBAPPLDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTIBAPPLNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Service ID.
2	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
3	PTIB_APPSRVGRP	Character(30)	VARCHAR2(30) NOT NULL	Service Group
4	PTIBAPPLTYPE	Character(1)	VARCHAR2(1) NOT NULL	Field to denote whether a service is master or Alias A=Alias Service M=Primary Service Default Value: M
5	PTIB_CONSUMER	Number(3,0)	SMALLINT NOT NULL	Is Consumer
6	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
7	PTIBAPPLNAME_MSTER	Character(30)	VARCHAR2(30) NOT NULL	Application Service ID.
8	PTIBURLPARAMNAME	Character(128)	VARCHAR2(128) NOT NULL	Application Service Name for chat bot services.
9	PTCBURLPARAMNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Service Name for chat bot services.
10	PTIB_EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Service N=No Export Y=Export Service Default Value: N
11	PTIB_EXPORT_CB	Character(1)	VARCHAR2(1) NOT NULL	Export Service N=No Y=Enabled Default Value: N
12	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
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	IB_SSL	Number(1,0)	SMALLINT NOT NULL	IB_SSL
17	IBEXTERNALUSERID	Character(30)	VARCHAR2(30) NOT NULL	External User ID
18	IBEXTERNALPWD	Character(254)	VARCHAR2(254) NOT NULL	Integration Broker External Password
19	PTIB_AUTHOPTION	Character(1)	VARCHAR2(1) NOT NULL	Authentication Option B=Basic Auth O=oAuth2
20	PTAPP_NAME	Character(100)	VARCHAR2(100) NOT NULL	Application Name Prompt Table: PSIBPSPTSEC_VW
21	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.
22	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
24	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
25	DESCRLONG	Long Character	CLOB	Long Description