| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTAI_LIST_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
|
| 2 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
|
| 3 |
PTAI_LABEL |
Character(100) |
VARCHAR2(100) NOT NULL |
Action Items - Label
|
| 4 |
PTAI_DESCRLONG |
Long Character |
CLOB |
Action Items - Long Description
|
| 5 |
PTAI_NOTIFY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
When this option is on, item assignments get email notification after process is success/error/no success.
This field is used only for process type action items.
A=Automatically Send Email
N=Do Nothing - No Email Sent
P=Prompt User to Send Email
|
| 6 |
PTAI_AGRENDERTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Guide type - Vertical or Horizontal
HOGP=Horizontal
NONS=Non Optimized Non Sequential
NOSP=Non Optimized Sequential
SNNO=Simple Navigation NonOptimized
SNOP=Simple Navigation Optimized
VNSP=Vertical Non Sequential
VSGP=Vertical Sequential
Default Value: NONS
|
| 7 |
PTAI_RESTARTAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart Activity Guide on revisit
Y/N Table Edit
Default Value: N
|
| 8 |
PTAI_SUOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Unit of Work
Y/N Table Edit
Default Value: N
|
| 9 |
PTAI_ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Item Active Flag
N=Display Inactive Lists
Y=Display Active Lists
Y/N Table Edit
|
| 10 |
CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Datetime
|
| 11 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 12 |
LAST_UPDATE_DTTM |
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.
|
| 13 |
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.
|
| 14 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 15 |
PTAI_IS_TMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Template
N=No
Y=Yes
|
| 16 |
PTAI_PARENT_TMPL |
Character(31) |
VARCHAR2(31) NOT NULL |
Template ID
|
| 17 |
PTAI_LIST_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Status
CA=Cancelled
CP=Complete
IP=In Progress
|
| 18 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
|
| 19 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
|
| 20 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
|
| 21 |
APPCLASSMETHOD |
Character(60) |
VARCHAR2(60) NOT NULL |
Application Class Method Name
|
| 22 |
PTAI_INST_PKGROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Package Name
|
| 23 |
PTAI_INST_QUALPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
|
| 24 |
PTAI_INST_CLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
|
| 25 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 26 |
PTAI_REOPEN_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Item Reopen
N=No
Y=Yes
|
| 27 |
PTAI_PGLT_EXCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Include In My List Pagelet
N=No
Y=Yes
|
| 28 |
PTAI_FIELD1_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 1
|
| 29 |
PTAI_FIELD2_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 2
|
| 30 |
PTAI_FIELD3_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 3
|
| 31 |
PTAI_FIELD4_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 4
|
| 32 |
PTAI_FIELD5_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 5
|
| 33 |
PTAI_FIELD6_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 1
|
| 34 |
PTAI_FIELD7_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 2
|
| 35 |
PTAI_FIELD8_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 3
|
| 36 |
PTAI_FIELD9_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 4
|
| 37 |
PTAI_FIELD10_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Label 5
|
| 38 |
PTAI_PGLT_EXIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pagelet Exit
N=No
Y=Yes
|
| 39 |
PTAI_PREPROC_METH |
Character(60) |
VARCHAR2(60) NOT NULL |
Pre Process Method
|
| 40 |
PTAI_PGLT_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pagelet Save
N=No
Y=Yes
|
| 41 |
PTAI_INST_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance Processing
N=No
Y=Yes
|
| 42 |
PTAI_PBVISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pagelet Progress Bar Visible
Y/N Table Edit
Default Value: Y
|
| 43 |
PTAI_START_DT |
Date(10) |
DATE |
Start Date
|
| 44 |
PTAI_DUE_DATE |
Date(10) |
DATE |
Action Items - Due Date
|
| 45 |
PTAI_GPDS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity Guide Datasource ID
Default Value: PTAI_ACTIVITYGUIDE
|
| 46 |
PTAI_SINGLECOMPAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Guide is a single component
Y/N Table Edit
Default Value: N
|
| 47 |
PTAI_FIXEDSIDEPNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Side panel fixed
Y/N Table Edit
Default Value: Y
|
| 48 |
PTAI_SHOWFLNOTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Notifications
Y/N Table Edit
Default Value: Y
|
| 49 |
PTAI_QUESTIONNAIRE |
Character(1) |
VARCHAR2(1) NOT NULL |
When this option is checked, Questionnaire tab will be displayed to tag questions with AG and Action Items.
Y/N Table Edit
Default Value: N
|
| 50 |
PTAI_SYSTEM_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Option to mark the AG template as System delivered data.
Y/N Table Edit
Default Value: N
|
| 51 |
STYLESHEETNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Style Sheet Name (see PSSTYLSHEETDEFN).
|
| 52 |
PTAI_CTX_DISP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Context Data Display Option
F=Fixed
M=Modal
P=Popup
Default Value: F
|
| 53 |
PTAI_CTX_PKGROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Package Name
|
| 54 |
PTAI_CTX_QUALPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
|
| 55 |
PTAI_CTX_CLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Class name
|
| 56 |
PTAI_CTX_METHOD |
Character(60) |
VARCHAR2(60) NOT NULL |
Application Class Method Name
|
| 57 |
PTAI_GENLNGINST |
Character(1) |
VARCHAR2(1) NOT NULL |
Lang Instances
Y/N Table Edit
Default Value: N
|
| 58 |
PTAI_HIDESTEPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Steps
Y/N Table Edit
Default Value: N
|
| 59 |
PTAI_END_DTTM |
DateTime(26) |
TIMESTAMP |
End DateTime
|
| 60 |
PTAI_ESTM_DUR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Estimate Duration
|
| 61 |
PTAI_ACTL_DUR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Elapsed Duration
|