PIM_PREFERENCES (SQL Table)	Index Back
PIM Preference Page PIM Preference Page which the admin can define PIM Preferences

PIM_PREFERENCES

(SQL Table)

PIM Preference Page

PIM Preference Page which the admin can define PIM Preferences

Related Language Record: PIM_PREF_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIM_PREF_ID Character(10) VARCHAR2(10) NOT NULL Used by PIM Preference

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 CONTACT_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Prompt Table: PIM_CTCT_RL_VW

4 CALENDAR_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Prompt Table: PIM_CAL_RL_VW

5 TASK_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Prompt Table: PIM_TASK_RL_VW

6 EMAIL_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

7 CONTACT_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

8 CONTACT_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

9 CONTACT_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

10 CALENDER_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

11 CALENDER_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

12 CALENDER_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

13 CAL_INDEP_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit
Default Value: N

14 CALENDER_DELETE_ST Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
C=Completed
I=In Process
P=Pending
R=Re-Scheduled
S=Scheduled
U=Unassigned
X=Cancelled
Default Value: C

15 TASK_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

16 TASK_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

17 TASK_INDEP_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit
Default Value: N

18 SUPPORT_REASSIGN Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

19 SUPPORT_REASSIGN_C Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

20 TASK_DELETE_ST Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
C=Completed
I=In Process
P=Pending
R=Re-Scheduled
S=Scheduled
U=Unassigned
X=Cancelled
Default Value: C

21 TASK_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

22 EMAIL_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

23 EMAIL_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

24 EMAIL_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

25 CONTACT_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

26 TASK_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

27 CALENDER_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

28 PHONE_EXT Character(4) VARCHAR2(4) NOT NULL This field is used to store the phone extension prefix for the Infosync PIM preference.

29 CM_PURP_TYPE_ADDR Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 38
Prompt Table: PIM_ADDR_TY_VW

30 CM_PURP_TYPE_PHON Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 43
Prompt Table: PIM_PHONE_TY_VW

31 DEBUG Character(1) VARCHAR2(1) NOT NULL Used to display debug messages from the application.
Y/N Table Edit

32 PIM_TASK_NODATE_FG Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit
Default Value: N

33 CONSUMER_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Prompt Table: PIM_CTCT_RL_VW

34 CONSUMER_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

35 CONSUMER_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

36 CONSUMER_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

37 CONSUMER_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

38 CONSUMER_ENABLE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

39 WORKER_ROLE Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Prompt Table: PIM_CTCT_RL_VW

40 WORKER_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

41 WORKER_UPDATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

42 WORKER_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

43 WORKER_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

44 WORKER_ENABLE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

45 WORKER_HOME_ADDR Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit
Default Value: Y

46 PIM_COMPANY_ADD Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

47 PIM_BUS_TYPE_ADDR Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 32
Prompt Table: PIM_ADDR_TYP_VW

48 PIM_HOME_TYPE_ADDR Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 35
Prompt Table: PIM_ADDR_TYP_VW

49 PIM_CAL_PRIVATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

50 PIM_TASK_PRIVATE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

51 PIM_CAL_PRIV_TXT Character(254) VARCHAR2(254) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

52 PIM_TASK_PRIV_TXT Character(254) VARCHAR2(254) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

53 PIM_APP_TYPE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
D=Server - Domino
E=Server - Exchange
O=Client - Domino
X=Client - Exchange

54 PIA_MACHINE_NAME Character(30) VARCHAR2(30) NOT NULL This field is used in PIM Preferences to indicate the server name where web service is running.

55 EXCHANGE_SERVER Character(80) VARCHAR2(80) NOT NULL This field is used in PIM Preferences for User Export

56 PIM_PRIMARY_ADDR Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
B=Business Address Type
H=Home Address Type
O=Other Address Type
Default Value: B

57 PIM_MAIL_DOMAIN Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

58 PIM_HOME_TYPE_PHON Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 15
Prompt Table: PIM_PHON_TYP_VW

59 PIM_BUS_TYPE_PHON Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: 11
Prompt Table: PIM_PHON_TYP_VW

60 PIM_ADDR_BK_SERVER Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

61 PIM_ADDR_BK_NAME Character(30) VARCHAR2(30) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

62 PIM_ADDR_BK_NAME_P Character(10) VARCHAR2(10) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

63 PIM_ADDR_BK_NAME_S Character(10) VARCHAR2(10) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

64 PIM_CMPY_SEPARATOR Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Default Value: ;

65 MULTIPLE_COMPANY Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Configuration
Y/N Table Edit

66 PIM_PIA_URI Character(254) VARCHAR2(254) NOT NULL This field is used in PIM to define the URI. This is the partial URL from which is generated the 360 degree URL so it can be accessed from Outlook or Notes.

67 PIM_PIA_PORTAL Character(30) VARCHAR2(30) NOT NULL This field is used in PIM to define the portal. This used to generate the 360 degree URL so it can be accessed from Outlook or Notes.

68 PIM_PIA_NODE Character(10) VARCHAR2(10) NOT NULL This field is used in PIM to define the URI. This is the partial URL from which is generated the 360 degree URL so it can be accessed from Outlook or Notes.

69 CONTACT_360_LNK Character(1) VARCHAR2(1) NOT NULL 360-Degree View link
Y/N Table Edit

70 CONSUMER_360_LNK Character(1) VARCHAR2(1) NOT NULL Consumer 360 Degree View Link
Y/N Table Edit

71 WORKER_360_LNK Character(1) VARCHAR2(1) NOT NULL This field is used as hyperlink to Worker 360 Degree View.
Y/N Table Edit

72 ADD_CONS_CONT_LIST Character(1) VARCHAR2(1) NOT NULL Add Consumer to My Contact List.
Y/N Table Edit

73 ADD_CONT_CONT_LIST Character(1) VARCHAR2(1) NOT NULL Add Contact to My Contact List.
Y/N Table Edit

74 ADD_WORK_CONT_LIST Character(1) VARCHAR2(1) NOT NULL Add a Worker to My Contact List.
Y/N Table Edit
Default Value: N

75 DEL_CONS_CONT_LIST Character(1) VARCHAR2(1) NOT NULL This is the remove consumer from my contact list field.
Y/N Table Edit

76 DEL_CONT_CONT_LIST Character(1) VARCHAR2(1) NOT NULL This is the remove contact from my contact list field.
Y/N Table Edit

77 DEL_WORK_CONT_LIST Character(1) VARCHAR2(1) NOT NULL This is the remove worker from my contact list field.
Y/N Table Edit

78 PIM_TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Type on PIM Task
Prompt Table: PIM_TSK_TYPE_VW

79 PIM_ANNIV_TYPE Character(18) VARCHAR2(18) NOT NULL Anniversary Type on PIM Calendar
Prompt Table: PIM_TSK_TYPE_VW

80 PIM_APPT_TYPE Character(18) VARCHAR2(18) NOT NULL Appointment Type on PIM Calendar
Prompt Table: PIM_CAL_TYPE_VW

81 PIM_EVENT_TYPE Character(18) VARCHAR2(18) NOT NULL All Day Event Type on PIM Calendar
Prompt Table: PIM_TSK_TYPE_VW

82 PIM_MEETING_TYPE Character(18) VARCHAR2(18) NOT NULL Meeting Type on PIM Calendar
Prompt Table: PIM_CAL_TYPE_VW

83 PIM_REMINDER_TYPE Character(18) VARCHAR2(18) NOT NULL Reminder Type on PIM Calendar
Prompt Table: PIM_CAL_TYPE_VW

84 PIM_CAL_TYPE Character(18) VARCHAR2(18) NOT NULL Task Type on PIM Calendar
Prompt Table: RB_TSK_TYPE_VW

85 PIM_CAL_TYPE_NO_TM Character(18) VARCHAR2(18) NOT NULL Task Type on PIM Calendar
Prompt Table: RB_TSK_TYPE_VW

86 PIM_TASK_NOTE_SYNC Character(1) VARCHAR2(1) NOT NULL Options to sync Task Notes
C=Concatenate
L=Most Recent

87 PIM_CAL_NOTE_SYNC Character(1) VARCHAR2(1) NOT NULL Options to sync Task Notes
C=Concatenate
L=Most Recent

88 PIM_TASK_BEG_DELI Character(50) VARCHAR2(50) NOT NULL adding note's begin delimiter

89 PIM_TASK_END_DELI Character(50) VARCHAR2(50) NOT NULL adding note's begin delimiter

90 PIM_CAL_BEG_DELI Character(50) VARCHAR2(50) NOT NULL adding note's begin delimiter

91 PIM_CAL_END_DELI Character(50) VARCHAR2(50) NOT NULL adding note's begin delimiter

92 PIM_COMPANY_DELETE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCES to check if invalid companies are wiped out.

93 EMAIL_ENABLE Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for PIM Email Configuration
Y/N Table Edit

94 EMAIL_CATEGORY Character(20) VARCHAR2(20) NOT NULL Used by PIM_PREFERENCE for PIM Configuration

95 LINK_LEAD_SW Character(1) VARCHAR2(1) NOT NULL Field used by PIM as an option to link Leads in Email Synch Feature
Y/N Table Edit

96 LINK_OPPY_SW Character(1) VARCHAR2(1) NOT NULL Field used by PIM as an option to link Opportunities in Email Synch Feature
Y/N Table Edit

97 LINK_CASE_SW Character(1) VARCHAR2(1) NOT NULL Field used by PIM as an option to link Cases in Email Synch Feature
Y/N Table Edit

98 LINK_SVCO_SW Character(1) VARCHAR2(1) NOT NULL Field used by PIM as an option to link Service Orders in Email Synch Feature
Y/N Table Edit

99 LINK_CLRP_SW Character(1) VARCHAR2(1) NOT NULL Field used by PIM as an option to link Call Report in Email Synch Feature
Y/N Table Edit

100 PIM_TSK_SUMM_SW Character(1) VARCHAR2(1) NOT NULL This field is used as an option on PIM Preferences to summarize tasks.
Y/N Table Edit

101 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

102 PIM_TSK_SUBJECT Character(60) VARCHAR2(60) NOT NULL This field is used on PIM Preferences. It hold summarized task subject

103 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

104 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
Prompt Table: RB_TSK_TYPE

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

106 PIM_USER_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used by PIM to enter user group and extract it into the PIM Export file.

107 CNSMR_DUP_ALLOW_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferecnes to indicate whether system should add potential duplicates or not
Y/N Table Edit

108 CNSMR_DUP_CATEGORY Character(20) VARCHAR2(20) NOT NULL Field used on PIM Preferences to hold the category value for contacts that were added with potential duplicate.

109 CNSMR_DUP_EMAIL_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to indicate whether user should be notified if a duplicate contact was encoutered
Y/N Table Edit

110 CNSMR_DUP_MERGE_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to indicate if system should request a merge if potential duplicates are allowed to be added
Y/N Table Edit

111 CNSMR_DUP_NOTIFY Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to hold values for notification method.
B=Email and Worklist
E=Email
N=None
W=Worklist

112 CNSMR_DUP_UPD_SW Character(1) VARCHAR2(1) NOT NULL Field is used by PIM Preferences to determine whether the system can update duplicate contacts.
Y/N Table Edit

113 CNTCT_DUP_ALLOW_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferecnes to indicate whether system should add potential duplicates or not
Y/N Table Edit

114 CNTCT_DUP_CATEGORY Character(20) VARCHAR2(20) NOT NULL Field used on PIM Preferences to hold the category value for contacts that were added with potential duplicate.

115 CNTCT_DUP_EMAIL_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to indicate whether user should be notified if a duplicate contact was encoutered
Y/N Table Edit

116 CNTCT_DUP_MERGE_SW Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to indicate if system should request a merge if potential duplicates are allowed to be added
Y/N Table Edit

117 CNTCT_DUP_NOTIFY Character(1) VARCHAR2(1) NOT NULL Field used on PIM Preferences to hold values for notification method.
B=Email and Worklist
E=Email
N=None
W=Worklist

118 CNTCT_DUP_UPD_SW Character(1) VARCHAR2(1) NOT NULL Field is used by PIM Preferences to determine whether the system can update duplicate contacts.
Y/N Table Edit

119 EMAIL_ADDR_SENDER Long Character CLOB This is the senders email address field.

120 FUTURE_APPT Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for sync current and future appointment only
Y/N Table Edit
Default Value: N

121 FUTURE_TSK Character(1) VARCHAR2(1) NOT NULL Used by PIM_PREFERENCE for sync current and future task only
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIM_PREF_ID	Character(10)	VARCHAR2(10) NOT NULL	Used by PIM Preference
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	CONTACT_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Prompt Table: PIM_CTCT_RL_VW
4	CALENDAR_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Prompt Table: PIM_CAL_RL_VW
5	TASK_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Prompt Table: PIM_TASK_RL_VW
6	EMAIL_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
7	CONTACT_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
8	CONTACT_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
9	CONTACT_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
10	CALENDER_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
11	CALENDER_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
12	CALENDER_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
13	CAL_INDEP_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit Default Value: N
14	CALENDER_DELETE_ST	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration C=Completed I=In Process P=Pending R=Re-Scheduled S=Scheduled U=Unassigned X=Cancelled Default Value: C
15	TASK_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
16	TASK_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
17	TASK_INDEP_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit Default Value: N
18	SUPPORT_REASSIGN	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
19	SUPPORT_REASSIGN_C	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
20	TASK_DELETE_ST	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration C=Completed I=In Process P=Pending R=Re-Scheduled S=Scheduled U=Unassigned X=Cancelled Default Value: C
21	TASK_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
22	EMAIL_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
23	EMAIL_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
24	EMAIL_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
25	CONTACT_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
26	TASK_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
27	CALENDER_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
28	PHONE_EXT	Character(4)	VARCHAR2(4) NOT NULL	This field is used to store the phone extension prefix for the Infosync PIM preference.
29	CM_PURP_TYPE_ADDR	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 38 Prompt Table: PIM_ADDR_TY_VW
30	CM_PURP_TYPE_PHON	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 43 Prompt Table: PIM_PHONE_TY_VW
31	DEBUG	Character(1)	VARCHAR2(1) NOT NULL	Used to display debug messages from the application. Y/N Table Edit
32	PIM_TASK_NODATE_FG	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit Default Value: N
33	CONSUMER_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Prompt Table: PIM_CTCT_RL_VW
34	CONSUMER_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
35	CONSUMER_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
36	CONSUMER_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
37	CONSUMER_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
38	CONSUMER_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
39	WORKER_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Prompt Table: PIM_CTCT_RL_VW
40	WORKER_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
41	WORKER_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
42	WORKER_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
43	WORKER_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
44	WORKER_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
45	WORKER_HOME_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit Default Value: Y
46	PIM_COMPANY_ADD	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
47	PIM_BUS_TYPE_ADDR	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 32 Prompt Table: PIM_ADDR_TYP_VW
48	PIM_HOME_TYPE_ADDR	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 35 Prompt Table: PIM_ADDR_TYP_VW
49	PIM_CAL_PRIVATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
50	PIM_TASK_PRIVATE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
51	PIM_CAL_PRIV_TXT	Character(254)	VARCHAR2(254) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
52	PIM_TASK_PRIV_TXT	Character(254)	VARCHAR2(254) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
53	PIM_APP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration D=Server - Domino E=Server - Exchange O=Client - Domino X=Client - Exchange
54	PIA_MACHINE_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is used in PIM Preferences to indicate the server name where web service is running.
55	EXCHANGE_SERVER	Character(80)	VARCHAR2(80) NOT NULL	This field is used in PIM Preferences for User Export
56	PIM_PRIMARY_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration B=Business Address Type H=Home Address Type O=Other Address Type Default Value: B
57	PIM_MAIL_DOMAIN	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
58	PIM_HOME_TYPE_PHON	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 15 Prompt Table: PIM_PHON_TYP_VW
59	PIM_BUS_TYPE_PHON	Number(6,0)	INTEGER NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: 11 Prompt Table: PIM_PHON_TYP_VW
60	PIM_ADDR_BK_SERVER	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
61	PIM_ADDR_BK_NAME	Character(30)	VARCHAR2(30) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
62	PIM_ADDR_BK_NAME_P	Character(10)	VARCHAR2(10) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
63	PIM_ADDR_BK_NAME_S	Character(10)	VARCHAR2(10) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
64	PIM_CMPY_SEPARATOR	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Default Value: ;
65	MULTIPLE_COMPANY	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration Y/N Table Edit
66	PIM_PIA_URI	Character(254)	VARCHAR2(254) NOT NULL	This field is used in PIM to define the URI. This is the partial URL from which is generated the 360 degree URL so it can be accessed from Outlook or Notes.
67	PIM_PIA_PORTAL	Character(30)	VARCHAR2(30) NOT NULL	This field is used in PIM to define the portal. This used to generate the 360 degree URL so it can be accessed from Outlook or Notes.
68	PIM_PIA_NODE	Character(10)	VARCHAR2(10) NOT NULL	This field is used in PIM to define the URI. This is the partial URL from which is generated the 360 degree URL so it can be accessed from Outlook or Notes.
69	CONTACT_360_LNK	Character(1)	VARCHAR2(1) NOT NULL	360-Degree View link Y/N Table Edit
70	CONSUMER_360_LNK	Character(1)	VARCHAR2(1) NOT NULL	Consumer 360 Degree View Link Y/N Table Edit
71	WORKER_360_LNK	Character(1)	VARCHAR2(1) NOT NULL	This field is used as hyperlink to Worker 360 Degree View. Y/N Table Edit
72	ADD_CONS_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	Add Consumer to My Contact List. Y/N Table Edit
73	ADD_CONT_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	Add Contact to My Contact List. Y/N Table Edit
74	ADD_WORK_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	Add a Worker to My Contact List. Y/N Table Edit Default Value: N
75	DEL_CONS_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	This is the remove consumer from my contact list field. Y/N Table Edit
76	DEL_CONT_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	This is the remove contact from my contact list field. Y/N Table Edit
77	DEL_WORK_CONT_LIST	Character(1)	VARCHAR2(1) NOT NULL	This is the remove worker from my contact list field. Y/N Table Edit
78	PIM_TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Type on PIM Task Prompt Table: PIM_TSK_TYPE_VW
79	PIM_ANNIV_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Anniversary Type on PIM Calendar Prompt Table: PIM_TSK_TYPE_VW
80	PIM_APPT_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Appointment Type on PIM Calendar Prompt Table: PIM_CAL_TYPE_VW
81	PIM_EVENT_TYPE	Character(18)	VARCHAR2(18) NOT NULL	All Day Event Type on PIM Calendar Prompt Table: PIM_TSK_TYPE_VW
82	PIM_MEETING_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Meeting Type on PIM Calendar Prompt Table: PIM_CAL_TYPE_VW
83	PIM_REMINDER_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Reminder Type on PIM Calendar Prompt Table: PIM_CAL_TYPE_VW
84	PIM_CAL_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Type on PIM Calendar Prompt Table: RB_TSK_TYPE_VW
85	PIM_CAL_TYPE_NO_TM	Character(18)	VARCHAR2(18) NOT NULL	Task Type on PIM Calendar Prompt Table: RB_TSK_TYPE_VW
86	PIM_TASK_NOTE_SYNC	Character(1)	VARCHAR2(1) NOT NULL	Options to sync Task Notes C=Concatenate L=Most Recent
87	PIM_CAL_NOTE_SYNC	Character(1)	VARCHAR2(1) NOT NULL	Options to sync Task Notes C=Concatenate L=Most Recent
88	PIM_TASK_BEG_DELI	Character(50)	VARCHAR2(50) NOT NULL	adding note's begin delimiter
89	PIM_TASK_END_DELI	Character(50)	VARCHAR2(50) NOT NULL	adding note's begin delimiter
90	PIM_CAL_BEG_DELI	Character(50)	VARCHAR2(50) NOT NULL	adding note's begin delimiter
91	PIM_CAL_END_DELI	Character(50)	VARCHAR2(50) NOT NULL	adding note's begin delimiter
92	PIM_COMPANY_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCES to check if invalid companies are wiped out.
93	EMAIL_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for PIM Email Configuration Y/N Table Edit
94	EMAIL_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Used by PIM_PREFERENCE for PIM Configuration
95	LINK_LEAD_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used by PIM as an option to link Leads in Email Synch Feature Y/N Table Edit
96	LINK_OPPY_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used by PIM as an option to link Opportunities in Email Synch Feature Y/N Table Edit
97	LINK_CASE_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used by PIM as an option to link Cases in Email Synch Feature Y/N Table Edit
98	LINK_SVCO_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used by PIM as an option to link Service Orders in Email Synch Feature Y/N Table Edit
99	LINK_CLRP_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used by PIM as an option to link Call Report in Email Synch Feature Y/N Table Edit
100	PIM_TSK_SUMM_SW	Character(1)	VARCHAR2(1) NOT NULL	This field is used as an option on PIM Preferences to summarize tasks. Y/N Table Edit
101	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
102	PIM_TSK_SUBJECT	Character(60)	VARCHAR2(60) NOT NULL	This field is used on PIM Preferences. It hold summarized task subject
103	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
104	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 Prompt Table: RB_TSK_TYPE
105	PIM_TSK_PRIORITY	Character(4)	VARCHAR2(4) NOT NULL	Task Priority indicator for Task. Used in Task Management. Prompt Table: RB_TSK_PRTY_VW
106	PIM_USER_GROUP	Character(30)	VARCHAR2(30) NOT NULL	This field is used by PIM to enter user group and extract it into the PIM Export file.
107	CNSMR_DUP_ALLOW_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferecnes to indicate whether system should add potential duplicates or not Y/N Table Edit
108	CNSMR_DUP_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Field used on PIM Preferences to hold the category value for contacts that were added with potential duplicate.
109	CNSMR_DUP_EMAIL_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to indicate whether user should be notified if a duplicate contact was encoutered Y/N Table Edit
110	CNSMR_DUP_MERGE_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to indicate if system should request a merge if potential duplicates are allowed to be added Y/N Table Edit
111	CNSMR_DUP_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to hold values for notification method. B=Email and Worklist E=Email N=None W=Worklist
112	CNSMR_DUP_UPD_SW	Character(1)	VARCHAR2(1) NOT NULL	Field is used by PIM Preferences to determine whether the system can update duplicate contacts. Y/N Table Edit
113	CNTCT_DUP_ALLOW_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferecnes to indicate whether system should add potential duplicates or not Y/N Table Edit
114	CNTCT_DUP_CATEGORY	Character(20)	VARCHAR2(20) NOT NULL	Field used on PIM Preferences to hold the category value for contacts that were added with potential duplicate.
115	CNTCT_DUP_EMAIL_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to indicate whether user should be notified if a duplicate contact was encoutered Y/N Table Edit
116	CNTCT_DUP_MERGE_SW	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to indicate if system should request a merge if potential duplicates are allowed to be added Y/N Table Edit
117	CNTCT_DUP_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Field used on PIM Preferences to hold values for notification method. B=Email and Worklist E=Email N=None W=Worklist
118	CNTCT_DUP_UPD_SW	Character(1)	VARCHAR2(1) NOT NULL	Field is used by PIM Preferences to determine whether the system can update duplicate contacts. Y/N Table Edit
119	EMAIL_ADDR_SENDER	Long Character	CLOB	This is the senders email address field.
120	FUTURE_APPT	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for sync current and future appointment only Y/N Table Edit Default Value: N
121	FUTURE_TSK	Character(1)	VARCHAR2(1) NOT NULL	Used by PIM_PREFERENCE for sync current and future task only Y/N Table Edit Default Value: N
122	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
123	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
124	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
125	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
126	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.
127	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time