Subject Area : 142 - Calendar Sync
Subject Area Name Definition
142 - Calendar Sync Tables used to sync the calendar appointments with a device that supports a calendar.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
Physical Name Attribute/Column Name Definition Physical Data Type
pwd Password This space intentionally left blank. varchar(255)
user_name User Name The name of the Application User. nvarchar(4000)
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
email_addr Email Address An email address for the Application User. nvarchar(4000)
delete_date Delete Date The value of a Application User, stored as a date. datetime
cal_item Calendar Item false The main calendar item table for the calender service. This table is populated and maintained by the Calendar Service API. It is not very suitable for database query outside of the API. The calendar item can be a personal or workspace calendar, or an appointment within the calendar. The calendar item can be synched using the iCal format.
Physical Name Attribute/Column Name Definition Physical Data Type
item_type item type item type. varchar(16)
cal_item_id Calendar Item Id The automatically generated primary key of the cal_item table. bigint
create_date create date create date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
etag etag etag. varchar(255)
mdfy_date modify date modify date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
client_create_date client create date client create date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
client_mod_date client modified date client modified date, stored as a long integer to avoid using date time classes that do not handle timezone well. int
display_name display name display name. nvarchar(4000)
item_name item name item name. nvarchar(4000)
intrnl_id Internal Id Internal Id. varchar(255)
last_modf last modification The value of a Calendar Item, stored as a date. int
last_mod_by last modified by last modified by. nvarchar(4000)
needs_reply needs reply Indicates if needs reply. bit
sent sent Indicates if sent. bit
ical_uid ical uid ical uid. varchar(255)
content_encoding content encoding content encoding. varchar(32)
content_language content language content language. varchar(32)
content_length content length The value of a Calendar Item stored as Long. bigint
content_type content type content type. varchar(64)
has_modfs has modifications Indicates if has modifications. bit
cal_content_data_id Calendar Content Data Id A Foreign Key to the Calendar Content Data table. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
modifies_cal_item_id Modifies Calendar Item Id A Foreign Key to the Calendar Item table. bigint
delete_date Delete Date The value of a Calendar Item, stored as a date. datetime
defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id The automatically generated primary key of the defn table. bigint
defn_name Definition Name The name of the Definition. nvarchar(4000)
dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
pim_appt_info PIM Appointment Information false Information about calendar appointment synchronization with external calendars in a Personal Information Manager (PIM) such as a computer or phone calendar system.
Physical Name Attribute/Column Name Definition Physical Data Type
pim_appt_info_id PIM Appointment Information Id The automatically generated primary key of the pim_appt_info table. bigint
extl_id External Id The value of a PIM Appointment Information stored as Long. varchar(255)
chg_key Change Key The value of a PIM Appointment Information, stored as a string. varchar(255)
app_user_id Application User Id A Foreign Key to the Application User table. bigint
cal_item_intrnl_id Calendar Item Internal Id Calendar Item Internal Id. varchar(255)
pim_record_info PIM Record Information false Information about calendar appointment data (such as the workspace and ticket number) synchronization with external calendars in a Personal Information Manager (PIM) such as a computer or phone calendar system.
Physical Name Attribute/Column Name Definition Physical Data Type
pim_record_info_id PIM Record Information Id The automatically generated primary key of the pim_record_info table. bigint
extl_id External Id The value of a PIM Record Information stored as Long. varchar(255)
chg_key Change Key The value of a PIM Record Information, stored as a string. varchar(255)
item_defn_id Item Definition Id A Foreign Key to the Definition table. bigint
item_id Item Id The value of a PIM Record Information stored as Long. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
syncing_job_dtl Syncing Job Detail false A table used to control syncing of Calendar Items with a computer or phone calendar system.
Physical Name Attribute/Column Name Definition Physical Data Type
syncing_job_dtl_id Syncing Job Detail Id The automatically generated primary key of the syncing_job_dtl table. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
last_sync_date Last Sync Date The value of a Syncing Job Detail, stored as a date. datetime
execn_date Execution Date The value of a Syncing Job Detail, stored as a date. datetime