RS_EMPL_CAL_OPT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: RS_EMPLCALSYNVW

2 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

3 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
Y/N Table Edit

4 CALENDAR_SYSTEM Character(1) VARCHAR2(1) NOT NULL Calendaring System Name
L=Lotus Notes
O=Outlook

5 NAMESPACE Character(80) VARCHAR2(80) NOT NULL Outlook NameSpace

6 FOLDER_NAME Character(80) VARCHAR2(80) NOT NULL Calendar Folder Name

7 RS_NOTESSERVER Character(80) VARCHAR2(80) NOT NULL Notes Server Name

8 RS_NOTESUSERNAME Character(80) VARCHAR2(80) NOT NULL Notes User Name

9 RS_NOTESPASSWORD Character(80) VARCHAR2(80) NOT NULL Notes Password

10 SYNCH_FLAG Character(1) VARCHAR2(1) NOT NULL Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RS_EMPLCALSYNVW
2	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
3	ENABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag indicates whether this row is enabled or not. Y/N Table Edit
4	CALENDAR_SYSTEM	Character(1)	VARCHAR2(1) NOT NULL	Calendaring System Name L=Lotus Notes O=Outlook
5	NAMESPACE	Character(80)	VARCHAR2(80) NOT NULL	Outlook NameSpace
6	FOLDER_NAME	Character(80)	VARCHAR2(80) NOT NULL	Calendar Folder Name
7	RS_NOTESSERVER	Character(80)	VARCHAR2(80) NOT NULL	Notes Server Name
8	RS_NOTESUSERNAME	Character(80)	VARCHAR2(80) NOT NULL	Notes User Name
9	RS_NOTESPASSWORD	Character(80)	VARCHAR2(80) NOT NULL	Notes Password
10	SYNCH_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot. 0=No Synchronization Required 1=Synchronize a Business Unit 2=Synchronize an Item 3=Synchronize a Storage Location 4=Synchronize a Lot ID 5=Synchronize Item at a Stor Loc
11	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.