RIM_TASK_VW (SQL View)	Index Back
RIM Task Detail Table Holds all the RIM Task Detail Information. Used by Task Management for RIM.

RIM_TASK_VW

(SQL View)

RIM Task Detail Table

Holds all the RIM Task Detail Information. Used by Task Management for RIM.

SELECT TSK.TASK_ID , TSK.DESCR60 , TSK.TASK_TYPE , TSK.TASK_STATUS , TSK.TASK_PRIORITY , TSK.START_DATE , TSK.START_TIME , TSK.END_DATE , TSK.END_TIME , TSK.TIMEZONE , TSK.TASK_LOCATION , TSK.PERSON_ID_OWNER , TSK.PRIVATE_FLG ,TSK.PARENT_TASK_ID , TSK.REMINDER_DURATION , TSK.REMINDER_UNITS , TSK.APPLICATION_USAGE , TSK.REPEAT_TYPE , TSK.REPEAT_DAY_FREQ , TSK.REPEAT_WEEK_FREQ , TSK.SUN , TSK.MON , TSK.TUES , TSK.WED , TSK.THURS , TSK.FRI , TSK.SAT , TSK.REPEAT_MNTH_FREQ , TSK.REPEAT_BY_DATE , TSK.REPEAT_BY_DAY , TSK.START_FROM_END_FLG , TSK.REPEAT_YEAR_FREQ , TSK.REPEAT_YEAR_MNTH , TSK.REPEAT_MOVE_OPTION , TSK.REPEAT_MAX_OCCUR , TSK.REPEAT_END_DATE , %subrec(RB_AUDIT_SBR, TSK) FROM PS_RB_TSK TSK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.
Default Value: 999999999999

2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Task Subject

3 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"
Prompt Table: RB_TSK_TYPE

4 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open
Default Value: OPEN

5 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.
Prompt Table: RB_TSK_PRTY_VW

6 START_DATE Date(10) DATE Start Date

7 START_TIME Time(15) TIMESTAMP Start Time

8 END_DATE Date(10) DATE End date field to store an end date.

9 END_TIME Time(15) TIMESTAMP End Time

10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

11 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.

12 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RB_WORKER_SRCH

13 PRIVATE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate the Task is Private. Used by Task Management.
Y/N Table Edit
Default Value: N

14 PARENT_TASK_ID Number(15,0) DECIMAL(15) NOT NULL Parent Task of an existing Task. Used by Mobile Task Management.
Prompt Table: RB_TSK

15 REMINDER_DURATION Number(6,0) INTEGER NOT NULL Reminder Duration. Used by Task Management.

16 REMINDER_UNITS Character(4) VARCHAR2(4) NOT NULL Reminder Units. Used by Task Management.
DAYS=Days
HOUR=Hours
MINS=Minutes

17 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
ALL=All Applications
CHMG=Change Management
EVNT=Marketing Events
FLDS=Field Service
HIED=Higher Education
HLPD=HelpDesk
HRHD=HR Helpdesk
LEAD=Lead
OPPY=Opportunity
PIM=Personal Information Mgmt
RSP=Strategic Planning
SALS=Sales
SUPP=Support
Default Value: ALL

18 REPEAT_TYPE Character(4) VARCHAR2(4) NOT NULL Repeat Type. Used by Task Management.
CUST=Custom
DAIL=Daily
MNTH=Monthly
NONE=Does Not Repeat
WEEK=Weekly
YEAR=Yearly
Default Value: NONE

19 REPEAT_DAY_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency - Daily. Used by Task Management.
Default Value: 1

20 REPEAT_WEEK_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency repeat weekly. Used by Task Management.
1=Every 01 Week
10=Every 10 Weeks
11=Every 11 Weeks
12=Every 12 Weeks
2=Every 02 Weeks
3=Every 03 Weeks
4=Every 04 Weeks
5=Every 05 Weeks
6=Every 06 Weeks
7=Every 07 Weeks
8=Every 08 Weeks
9=Every 09 Weeks
Default Value: 1

21 SUN Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit
Default Value: N

22 MON Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit
Default Value: N

23 TUES Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit
Default Value: N

24 WED Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit
Default Value: N

25 THURS Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit
Default Value: N

26 FRI Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit
Default Value: N

27 SAT Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit
Default Value: N

28 REPEAT_MNTH_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency, repeat monthly. Used by Task Management.
1=Every 01 Month
10=Every 10 Months
11=Every 11 Months
12=Every 12 Months
13=Every 13 Months
14=Every 14 Months
15=Every 15 Months
16=Every 16 Months
17=Every 17 Months
18=Every 18 Months
2=Every 02 Months
3=Every 03 Months
4=Every 04 Months
5=Every 05 Months
6=Every 06 Months
7=Every 07 Months
8=Every 08 Months
9=Every 09 Months
Default Value: 1

29 REPEAT_BY_DATE Character(4) VARCHAR2(4) NOT NULL Repeat by Date. Used by Task Management.

30 REPEAT_BY_DAY Character(4) VARCHAR2(4) NOT NULL Repeat by day. Used by Task Management.

31 START_FROM_END_FLG Character(1) VARCHAR2(1) NOT NULL Count fro end of month. Used by Task Management.
Y/N Table Edit
Default Value: N

32 REPEAT_YEAR_FREQ Character(4) VARCHAR2(4) NOT NULL Repeat Yearly frequency. Used by Task Management.
1=Every 01 Year
10=Every 10 Years
2=Every 02 Years
3=Every 03 Years
4=Every 04 Years
5=Every 05 Years
6=Every 06 Years
7=Every 07 Years
8=Every 08 Years
9=Every 09 Years
Default Value: 1

33 REPEAT_YEAR_MNTH Character(4) VARCHAR2(4) NOT NULL Repeat Year - Month. Used by Task Management.
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

34 REPEAT_MOVE_OPTION Character(4) VARCHAR2(4) NOT NULL Move option if the repeat task occures on weekend. Used by Task Management.
DELE=Don't Create Task
DONT=Don't Move
NEXT=Move to Next Work Day
PREV=Move to Previous Work Day
Default Value: DONT

35 REPEAT_MAX_OCCUR Number(4,0) SMALLINT NOT NULL Maximum repeat occurances. Used by Task Management.

36 REPEAT_END_DATE Date(10) DATE Repeat end date. Used by Task Management.

37 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

38 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

39 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

40 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

41 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

42 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management. Default Value: 999999999999
2	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Task Subject
3	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type" Prompt Table: RB_TSK_TYPE
4	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN
5	TASK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management. Prompt Table: RB_TSK_PRTY_VW
6	START_DATE	Date(10)	DATE	Start Date
7	START_TIME	Time(15)	TIMESTAMP	Start Time
8	END_DATE	Date(10)	DATE	End date field to store an end date.
9	END_TIME	Time(15)	TIMESTAMP	End Time
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
11	TASK_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Task Location. Used by Task Management.
12	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RB_WORKER_SRCH
13	PRIVATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate the Task is Private. Used by Task Management. Y/N Table Edit Default Value: N
14	PARENT_TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	Parent Task of an existing Task. Used by Mobile Task Management. Prompt Table: RB_TSK
15	REMINDER_DURATION	Number(6,0)	INTEGER NOT NULL	Reminder Duration. Used by Task Management.
16	REMINDER_UNITS	Character(4)	VARCHAR2(4) NOT NULL	Reminder Units. Used by Task Management. DAYS=Days HOUR=Hours MINS=Minutes
17	APPLICATION_USAGE	Character(4)	VARCHAR2(4) NOT NULL	Application Usage. Holds the info about the application. ALL=All Applications CHMG=Change Management EVNT=Marketing Events FLDS=Field Service HIED=Higher Education HLPD=HelpDesk HRHD=HR Helpdesk LEAD=Lead OPPY=Opportunity PIM=Personal Information Mgmt RSP=Strategic Planning SALS=Sales SUPP=Support Default Value: ALL
18	REPEAT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Repeat Type. Used by Task Management. CUST=Custom DAIL=Daily MNTH=Monthly NONE=Does Not Repeat WEEK=Weekly YEAR=Yearly Default Value: NONE
19	REPEAT_DAY_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Frequency - Daily. Used by Task Management. Default Value: 1
20	REPEAT_WEEK_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Frequency repeat weekly. Used by Task Management. 1=Every 01 Week 10=Every 10 Weeks 11=Every 11 Weeks 12=Every 12 Weeks 2=Every 02 Weeks 3=Every 03 Weeks 4=Every 04 Weeks 5=Every 05 Weeks 6=Every 06 Weeks 7=Every 07 Weeks 8=Every 08 Weeks 9=Every 09 Weeks Default Value: 1
21	SUN	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Sunday Y/N Table Edit Default Value: N
22	MON	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Monday Y/N Table Edit Default Value: N
23	TUES	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Tuesday. Y/N Table Edit Default Value: N
24	WED	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Wednesday. Y/N Table Edit Default Value: N
25	THURS	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Thursday. Y/N Table Edit Default Value: N
26	FRI	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Friday. Y/N Table Edit Default Value: N
27	SAT	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag for providing the Start and End Time for Saturday. Y/N Table Edit Default Value: N
28	REPEAT_MNTH_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Frequency, repeat monthly. Used by Task Management. 1=Every 01 Month 10=Every 10 Months 11=Every 11 Months 12=Every 12 Months 13=Every 13 Months 14=Every 14 Months 15=Every 15 Months 16=Every 16 Months 17=Every 17 Months 18=Every 18 Months 2=Every 02 Months 3=Every 03 Months 4=Every 04 Months 5=Every 05 Months 6=Every 06 Months 7=Every 07 Months 8=Every 08 Months 9=Every 09 Months Default Value: 1
29	REPEAT_BY_DATE	Character(4)	VARCHAR2(4) NOT NULL	Repeat by Date. Used by Task Management.
30	REPEAT_BY_DAY	Character(4)	VARCHAR2(4) NOT NULL	Repeat by day. Used by Task Management.
31	START_FROM_END_FLG	Character(1)	VARCHAR2(1) NOT NULL	Count fro end of month. Used by Task Management. Y/N Table Edit Default Value: N
32	REPEAT_YEAR_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Repeat Yearly frequency. Used by Task Management. 1=Every 01 Year 10=Every 10 Years 2=Every 02 Years 3=Every 03 Years 4=Every 04 Years 5=Every 05 Years 6=Every 06 Years 7=Every 07 Years 8=Every 08 Years 9=Every 09 Years Default Value: 1
33	REPEAT_YEAR_MNTH	Character(4)	VARCHAR2(4) NOT NULL	Repeat Year - Month. Used by Task Management. 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
34	REPEAT_MOVE_OPTION	Character(4)	VARCHAR2(4) NOT NULL	Move option if the repeat task occures on weekend. Used by Task Management. DELE=Don't Create Task DONT=Don't Move NEXT=Move to Next Work Day PREV=Move to Previous Work Day Default Value: DONT
35	REPEAT_MAX_OCCUR	Number(4,0)	SMALLINT NOT NULL	Maximum repeat occurances. Used by Task Management.
36	REPEAT_END_DATE	Date(10)	DATE	Repeat end date. Used by Task Management.
37	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
38	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
39	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
40	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
41	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
42	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time