RUN_CNTL_SRS_SY

(SQL Table)
Index Back

Calendar Synchronization

SUJ--Changed the prompt record at TASK_TYPE to only prompt for Resource Management Tasks

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_FS.OPRID

Prompt Table: OPRID_VW2

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 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
5 RS_CALSYNC_ALL Character(1) VARCHAR2(1) NOT NULL Sync All Calendars

Y/N Table Edit

6 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category

Prompt Table: RS_TASK_RS_VW

7 CALENDAR_SYSTEM Character(1) VARCHAR2(1) NOT NULL Calendaring System Name
L=Lotus Notes
O=Outlook
8 NAMESPACE Character(80) VARCHAR2(80) NOT NULL Outlook NameSpace
9 RS_PROFILE Character(40) VARCHAR2(40) NOT NULL Outlook Profile
10 FOLDER_NAME Character(80) VARCHAR2(80) NOT NULL Calendar Folder Name
11 RS_NOTESPASSWORD Character(80) VARCHAR2(80) NOT NULL Notes Password
12 RS_NOTESUSERNAME Character(80) VARCHAR2(80) NOT NULL Notes User Name
13 RS_NOTESSERVER Character(80) VARCHAR2(80) NOT NULL Notes Server Name
14 RS_LOGFILENAME Character(80) VARCHAR2(80) NOT NULL Log File Name
15 RS_TRACE_TYPE Character(3) VARCHAR2(3) NOT NULL Log Trace
FUL=Full
OFF=Off
ON=On