PSFP_FEED (SQL Table)	Index Back
Feed Definitions

PSFP_FEED

(SQL Table)

Feed Definitions

Related Language Record: PSFP_FEED_LANG

Parent Record Of PSFP_ATTRS PSFP_ATTRS_LANG PSFP_PARMS PSFP_PARMS_LANG PSFP_PUB_SITES PSFP_SECURITY PSFP_SETTINGS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID

2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
Default Value: 1

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

5 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

6 PTFP_CATEGORY_ID Character(30) VARCHAR2(30) NOT NULL Category ID (see PSFP_CATEGORY).
Prompt Table: PSFP_CATEGORY

7 PTFP_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type (see PSFP_DATATYPE).
Prompt Table: PSFP_DATATYPE

8 PTFP_FEED_FORMAT Character(3) VARCHAR2(3) NOT NULL Feed Format
A10=ATOM 1.0
ORA=OraRSS
R20=RSS 2.0
Default Value: A10

9 PTFP_CACHE_TYPE Character(4) VARCHAR2(4) NOT NULL Caching Type
NONE=None - Do not cache
PRIV=Private - Used Based
PUBL=Public - Common Usage
ROLE=Role - Security Based
Default Value: NONE

10 PTFP_CACHE_TIME Number(5,0) INTEGER NOT NULL Minutes to Cache

11 PTFP_OPR_AUTH_TYPE Character(3) VARCHAR2(3) NOT NULL User Authentication Type
ALL=All Requests
ANO=Anonymous Requests
NON=Default Authentication
Default Value: NON

12 PTFP_OPR_ID Character(100) VARCHAR2(100) NOT NULL User ID

13 PTFP_OPR_PWD Character(100) VARCHAR2(100) NOT NULL Password

14 PTFP_SEC_TYPE Character(4) VARCHAR2(4) NOT NULL Security Type
PUBL=Public Access
RT=Real Time Security
SECR=Select Security Access
Default Value: PUBL

15 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
Prompt Table: PSOPERATION

16 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
Prompt Table: PSPRDMDEFN

17 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: PSMSGNODEDEFN

18 PUBLISHTIMESTAMP DateTime(26) TIMESTAMP DateTime of Last Feed Publish

19 PTFP_FEED_TEMPLATE Character(2) VARCHAR2(2) NOT NULL Feed Template
N=No
Y=Yes
Default Value: N

20 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

21 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

22 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.

23 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTFP_FEED_ID	Character(30)	VARCHAR2(30) NOT NULL	Feed ID
2	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference Default Value: 1
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
6	PTFP_CATEGORY_ID	Character(30)	VARCHAR2(30) NOT NULL	Category ID (see PSFP_CATEGORY). Prompt Table: PSFP_CATEGORY
7	PTFP_DATATYPE_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Type (see PSFP_DATATYPE). Prompt Table: PSFP_DATATYPE
8	PTFP_FEED_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Feed Format A10=ATOM 1.0 ORA=OraRSS R20=RSS 2.0 Default Value: A10
9	PTFP_CACHE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Caching Type NONE=None - Do not cache PRIV=Private - Used Based PUBL=Public - Common Usage ROLE=Role - Security Based Default Value: NONE
10	PTFP_CACHE_TIME	Number(5,0)	INTEGER NOT NULL	Minutes to Cache
11	PTFP_OPR_AUTH_TYPE	Character(3)	VARCHAR2(3) NOT NULL	User Authentication Type ALL=All Requests ANO=Anonymous Requests NON=Default Authentication Default Value: NON
12	PTFP_OPR_ID	Character(100)	VARCHAR2(100) NOT NULL	User ID
13	PTFP_OPR_PWD	Character(100)	VARCHAR2(100) NOT NULL	Password
14	PTFP_SEC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Security Type PUBL=Public Access RT=Real Time Security SECR=Select Security Access Default Value: PUBL
15	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION). Prompt Table: PSOPERATION
16	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN). Prompt Table: PSPRDMDEFN
17	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). Prompt Table: PSMSGNODEDEFN
18	PUBLISHTIMESTAMP	DateTime(26)	TIMESTAMP	DateTime of Last Feed Publish
19	PTFP_FEED_TEMPLATE	Character(2)	VARCHAR2(2) NOT NULL	Feed Template N=No Y=Yes Default Value: N
20	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
21	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
22	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.
23	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.