| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTFP_FEED_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Feed ID (see PSFP_FEED).
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 4 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
Default Value: PTPP_OPTIONS.OBJECTOWNERID
|
| 5 |
PTFP_CATEGORY_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Category ID (see PSFP_CATEGORY).
Prompt Table:
PTFP_CATEGORY
|
| 6 |
PTFP_DATATYPE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Data Type (see PSFP_DATATYPE).
Prompt Table:
PTFP_DATATYPE
|
| 7 |
PTFP_FEED_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Feed Format
A10=ATOM 1.0
ORA=OraRSS
R20=RSS 2.0
Default Value: A10
|
| 8 |
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
|
| 9 |
PTFP_CACHE_TIME |
Number(5,0) |
INTEGER NOT NULL |
Minutes to Cache
|
| 10 |
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
|
| 11 |
PTFP_OPR_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
User ID
|
| 12 |
PTFP_OPR_PWD |
Character(100) |
VARCHAR2(100) NOT NULL |
Password
|
| 13 |
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
|
| 14 |
IB_OPERATIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operation (see PSOPERATION).
Prompt Table:
PSOPERATION
|
| 15 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table:
PSPRDMDEFN
|
| 16 |
MSGNODENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table:
PSMSGNODEDEFN
|
| 17 |
PUBLISHTIMESTAMP |
DateTime(26) |
TIMESTAMP |
DateTime of Last Feed Publish
|
| 18 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|
| 19 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 20 |
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.
|
| 21 |
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.
|