PSPTCSSRVDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTCS_SERVICEID	Character(30)	VARCHAR2(30) NOT NULL	Services ID
2	PTCS_SERVICENAME	Character(18)	VARCHAR2(18) NOT NULL	Service Name
3	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
4	PTCS_INITIALHEIGHT	Number(3,0)	SMALLINT NOT NULL	Initial Height
5	PTCS_SERVICEURLTYP	Character(4)	VARCHAR2(4) NOT NULL	Service URL Type: PSFT or Non PSFT PEP=Embeddable Pagelet POP=OBIEE Pagelet UAPC=Application Class UCON=Connector URL UESP=Embeddable SubPage UEXT=Non-PeopleSoft URL UGEN=Generic PeopleSoft URL UPGE=Peoplesoft Component UQRY=PeopleSoft Query USCR=PeopleSoft Script UTIL=PeopleSoft Tile Default Value: UPGE
6	PTCS_SERVICETYPE	Character(1)	VARCHAR2(1) NOT NULL	Service Type C=Content Reference G=Grouplet P=Pagelet S=Service Default Value: S
7	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). Prompt Table: PORTAL_NODE_VW
8	PTTILECATEGORY	Character(30)	VARCHAR2(30) NOT NULL	Fluid Content
9	PORTAL_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name
10	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
11	PC_EVENT_TYPE	Character(14)	VARCHAR2(14) NOT NULL	PeopleCode Event Name Default Value: FieldFormula
12	PC_FUNCTION_NAME	Character(30)	VARCHAR2(30) NOT NULL	PeopleCode Function Name Default Value: IScript_
13	PORTAL_MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name Prompt Table: PTCSMENUDEFN_VW
14	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name Prompt Table: PTCSMENUCOMP_VW
15	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
16	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN). Prompt Table: PTCSPNLGROUP_VW
17	PORTAL_URL_ADM	Long Character	CLOB	Portal URL
18	PTPPB_PAGELET_ID	Character(30)	VARCHAR2(30) NOT NULL	Pagelet ID Prompt Table: %EDITTABLE5
19	PTCS_QUERYNAME	Character(30)	VARCHAR2(30) NOT NULL	PS Query Name Prompt Table: %EDITTABLE4
20	PORTAL_URI_TEXT	Long Character(1024)	VARCHAR2(1024)	Portal URI Text
21	PTCS_ESCAPEPARAM	Character(1)	VARCHAR2(1) NOT NULL	Escape URL Parameters Y/N Table Edit Default Value: Y
22	PTCS_POST_MAPDATA	Character(1)	VARCHAR2(1) NOT NULL	Post mapping definition data Y/N Table Edit Default Value: N
23	PTCS_SECUSEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags
24	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
25	PTCS_SRVHELPTEXT	Long Character(1024)	VARCHAR2(1024)	Related Content Service help text
26	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID Prompt Table: PSPACKAGROOT_VW
27	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path Prompt Table: PSPACKAGPATH_VW
28	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID Prompt Table: PSPACKAGCLAS_VW
29	PTCS_VALID_FROM	Date(10)	DATE	Date From
30	PTCS_BULKACTION	Character(1)	VARCHAR2(1) NOT NULL	Bulk Action N=No Y=Yes
31	PTCS_VALID_TO	Date(10)	DATE	Valid to date
32	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference Default Value: 1
33	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.
34	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.
35	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
36	PTCS_SRVCATTR	Character(4)	VARCHAR2(4) NOT NULL	Template Based Default Value: GNRL