PIM_TSK_SUM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
6	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
7	TIMEZONE1	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
8	TIMEZONE2	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
9	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
10	PERSON_ID2	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
11	PIM_TSK_SUMM_SW	Character(1)	VARCHAR2(1) NOT NULL	This field is used as an option on PIM Preferences to summarize tasks.
12	PIM_TSK_SUM_RSLT	Character(3)	VARCHAR2(3) NOT NULL	This field is used on PIM Preferences. It contains the values for Task Summary Result: Task or Calendar. CAL=Calendar TSK=Task
13	PIM_TSK_SUBJECT	Character(60)	VARCHAR2(60) NOT NULL	This field is used on PIM Preferences. It hold summarized task subject
14	PIM_TSK_SUBJECT2	Character(60)	VARCHAR2(60) NOT NULL	This field is used on PIM Preferences. It hold summarized task subject
15	PIM_TSK_TEXT	Character(254)	VARCHAR2(254) NOT NULL	This field is used on PIM Preferences. It hold the value of the first line in the summarized task description
16	PIM_TSK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management.
17	PIM_TSK_PRIORITY2	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management.
18	PIM_TSK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	This field is used on PIM Preferences. It hold the value of the task summary type
19	PIM_TSK_TYPE2	Character(18)	VARCHAR2(18) NOT NULL	This field is used on PIM Preferences. It hold the value of the task summary type
20	TASK_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
21	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
22	EOEC_DATASETNAME	Character(30)	VARCHAR2(30) NOT NULL	The name of one or more rules that will be used to filter a rowset.
23	EOEC_RULENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table Prompt Table: EOEC_MP_RULE
24	SEARCHRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Search Record Name
25	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
26	END_DATE	Date(10)	DATE	End date field to store an end date.
27	END_TIME	Time(15)	TIMESTAMP	End of Shift
28	DATE_FIELD	Date(10)	DATE	Date Field
29	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
30	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management.
31	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"
32	CURRENT_DTTM	DateTime(26)	TIMESTAMP	08/27/01 EGS (CN#PL900-1.0): Added
33	TIME1	Time(15)	TIMESTAMP	This field is used to populate the current time. Common field.
34	DATE_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Date Format (PowerPlay Only) D1=YY/MM/DD D2=MM/DD/YY D3=DDDD,MMMM DD, YYYY M1=YYYY/MMMM M2=MYY M3=MMMM,YYYY M4=MMMM YYYY Q=YYYY "Q" Q W=YYYY/MM/DD Y1=YYYY Y2=YY
35	TIME_FORMAT	Character(2)	VARCHAR2(2) NOT NULL	Time Format 0=12 Hour 1=24 Hour
36	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
37	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
38	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
39	BASE_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
40	TEXT_LONG	Long Character	CLOB	Long Text