RBP_CLND_VW (SQL View)	Index Back
Calendar Header Information This is view that captures the calendar header information such as the subject, start date, end date, repeat pattern etc.

RBP_CLND_VW

(SQL View)

Calendar Header Information

This is view that captures the calendar header information such as the subject, start date, end date, repeat pattern etc.

SELECT A.PERSON_ID_ASSIGNEE , A.TASK_ASGN_STATUS , C.OPRID , B.TASK_ID , ' ' , B.DESCR60 , B.DESCRLONG , ' ' , ' ' , B.TASK_TYPE , B.TASK_STATUS , %Dttm(B.START_DATE,B.START_TIME) , %Dttm(B.END_DATE,B.END_TIME) , B.START_DATE , B.START_TIME , B.END_DATE , B.END_TIME , B.RBP_ORIG_MTG_DTTM , B.PIM_MEETING_GUID , B.TIMEZONE , B.TASK_LOCATION , B.PERSON_ID_OWNER , B.PRIVATE_FLG , B.PARENT_TASK_ID , B.REMINDER_DURATION , B.REMINDER_UNITS , B.REPEAT_TYPE , B.REPEAT_DAY_FREQ , B.REPEAT_WEEK_FREQ , B.SUN , B.MON , B.TUES , B.WED , B.THURS , B.FRI , B.SAT , B.REPEAT_MNTH_FREQ , B.REPEAT_BY_DATE , B.REPEAT_BY_DAY , B.START_FROM_END_FLG , B.REPEAT_YEAR_FREQ , B.REPEAT_YEAR_MNTH , B.REPEAT_MOVE_OPTION , B.REPEAT_MAX_OCCUR , B.REPEAT_END_DATE , %subrec(RB_AUDIT_SBR, B) FROM PS_RB_TSK_ASGN A , PS_RB_TSK B , PSOPRALIAS C , PS_RBP_USERS D WHERE A.TASK_ID = B.TASK_ID AND A.PERSON_ID_ASSIGNEE = C.PERSON_ID AND C.OPRID = D.OPRID AND B.TASK_TYPE IN ('MEETING', 'APPOINTMENT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

2 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
ACPT=Accepted
CMPL=Completed
DCLN=Declined
OPEN=Assigned

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

5 OPRID_ADMIN Character(30) VARCHAR2(30) NOT NULL Admin User ID

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

7 DESCRLONG Long Character CLOB Long Description

8 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

9 EMAILADDR Character(70) VARCHAR2(70) NOT NULL This is the email address field.

10 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

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

12 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime

13 ENDDATETIME DateTime(26) TIMESTAMP End Datetime

14 START_DATE Date(10) DATE Start Date for Gen Standing PO

15 START_TIME Time(15) TIMESTAMP Start of Shift

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

17 END_TIME Time(15) TIMESTAMP End of Shift

18 RBP_ORIG_MTG_DTTM DateTime(26) TIMESTAMP Original meeting start datetime. Use this to concatenate the Original Start Date and Original Start Time of CRM calendar entry.

19 PIM_MEETING_GUID Character(254) VARCHAR2(254) NOT NULL This field stores the MeetingLinkingGUID from Intellisync EA software

20 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

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

22 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

23 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

24 PARENT_TASK_ID Number(15,0) DECIMAL(15) NOT NULL Parent Task of an existing Task. Used by Mobile Task Management.

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

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

27 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

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

29 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

30 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

31 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

32 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

33 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

34 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

35 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

36 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

37 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

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

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

40 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

41 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

42 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

43 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

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

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

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_ASSIGNEE	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	TASK_ASGN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Assignment Status. Used by Task Management. ACPT=Accepted CMPL=Completed DCLN=Declined OPEN=Assigned
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
5	OPRID_ADMIN	Character(30)	VARCHAR2(30) NOT NULL	Admin User ID
6	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Task Subject
7	DESCRLONG	Long Character	CLOB	Long Description
8	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
9	EMAILADDR	Character(70)	VARCHAR2(70) NOT NULL	This is the email address field.
10	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"
11	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open Default Value: OPEN
12	STARTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
13	ENDDATETIME	DateTime(26)	TIMESTAMP	End Datetime
14	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
15	START_TIME	Time(15)	TIMESTAMP	Start of Shift
16	END_DATE	Date(10)	DATE	End date field to store an end date.
17	END_TIME	Time(15)	TIMESTAMP	End of Shift
18	RBP_ORIG_MTG_DTTM	DateTime(26)	TIMESTAMP	Original meeting start datetime. Use this to concatenate the Original Start Date and Original Start Time of CRM calendar entry.
19	PIM_MEETING_GUID	Character(254)	VARCHAR2(254) NOT NULL	This field stores the MeetingLinkingGUID from Intellisync EA software
20	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
21	TASK_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Task Location. Used by Task Management.
22	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
23	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
24	PARENT_TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	Parent Task of an existing Task. Used by Mobile Task Management.
25	REMINDER_DURATION	Number(6,0)	INTEGER NOT NULL	Reminder Duration. Used by Task Management.
26	REMINDER_UNITS	Character(4)	VARCHAR2(4) NOT NULL	Reminder Units. Used by Task Management. DAYS=Days HOUR=Hours MINS=Minutes
27	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
28	REPEAT_DAY_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Frequency - Daily. Used by Task Management. Default Value: 1
29	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
30	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
31	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
32	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
33	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
34	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
35	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
36	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
37	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
38	REPEAT_BY_DATE	Character(4)	VARCHAR2(4) NOT NULL	Repeat by Date. Used by Task Management.
39	REPEAT_BY_DAY	Character(4)	VARCHAR2(4) NOT NULL	Repeat by day. Used by Task Management.
40	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
41	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
42	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
43	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
44	REPEAT_MAX_OCCUR	Number(4,0)	SMALLINT NOT NULL	Maximum repeat occurances. Used by Task Management.
45	REPEAT_END_DATE	Date(10)	DATE	Repeat end date. Used by Task Management.
46	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
47	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
48	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
49	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
50	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.
51	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time