Skip to main content

Time Tracking & Scheduling - Key Tables

Full column listings for the 3 key tables in this category.

APPOINTMENT (100 columns)

# Column Type Length Nullable Default
1 APid int NO
2 APunum int YES ((0))
3 APType int YES ((0))
4 APFaultid int YES ((0))
5 APsubject nvarchar 4000 YES
6 APConfirmed bit NO ((0))
7 APStartDate datetime YES
8 APEndDate datetime YES
9 APExchangeStartDate datetime YES
10 APExchangeEndDate datetime YES
11 APExchangeMailBoxFQDN nvarchar 4000 YES
12 APStatus int YES ((0))
13 APAllDayEvent bit NO ((0))
14 APEntryID nvarchar 4000 YES
15 APdeleted bit NO ((0))
16 APMessageStatus int YES ((0))
17 APnote ntext 1073741823 YES
18 APBetweenStart datetime YES
19 APBetweenEnd datetime YES
20 APToList nvarchar -1 YES
21 APCCList nvarchar -1 YES
22 APBCCList nvarchar -1 YES
23 APUserMessageStatus int YES ((0))
24 APReminderMinutes int YES ((0))
25 APReminderStatus int YES ((0))
26 APisTask bit YES ((0))
27 APisPrivate bit YES ((0))
28 APReminderDate datetime YES
29 APNoteBlob varbinary -1 YES
30 APCompleteNote nvarchar -1 YES
31 APCompleteStatus int YES ((-1))
32 APFromCompletedAPID int YES ((0))
33 APCompleteDate datetime YES
34 APCompleteUnum int YES ((-1))
35 APchangeseq int YES ((0))
36 APOffHold bit YES ((1))
37 APExchangeLastModifiedDate datetime YES ((0))
38 APChangeKey nvarchar 4000 YES ('')
39 APChangedInNHD bit YES ((0))
40 APArea int YES ((-1))
41 APSite int YES ((-1))
42 APUser nvarchar 200 YES ('')
43 APMeetingType int YES ((0))
44 apcommisionable bit YES ((0))
45 APInviteSent int YES ((0))
46 APCSPID int YES ((0))
47 apagentstatus int NO ((-1))
48 apnotehtml nvarchar -1 YES
49 apholidayid uniqueidentifier YES
50 apcollectionid uniqueidentifier YES
51 apremindershown bit YES ((0))
52 APIsRecurringMaster bit YES ((0))
53 APIsRecurringChild bit YES ((0))
54 APRecurringMasterID nvarchar 4000 YES
55 apappointmenttype int YES ((0))
56 apcompletenotehtml nvarchar -1 YES
57 APUid int YES ((0))
58 APOnlineMeetingUrl nvarchar 1000 YES ('')
59 APConferenceId nvarchar 30 YES ('')
60 APTollNumber nvarchar 30 YES ('')
61 APOrganizer int YES ((0))
62 APExternalOrganizer bit YES ((0))
63 APiCalUid nvarchar 4000 YES
64 APAttendees nvarchar -1 YES
65 APresourceBookingType int YES ((0))
66 APresourceBookingTimeslot datetime YES ((0))
67 APbookingName nvarchar 255 YES ('')
68 APbookingEmail nvarchar 255 YES ('')
69 APbookingPhonenumber nvarchar 50 YES ('')
70 APOrganizerEmail nvarchar 250 YES ('')
71 apappointmentstatus int YES ((0))
72 apprimaryticketappt bit YES
73 apopenappointmentstatus int YES ((0))
74 apappointmentlocation int YES ((0))
75 aphalorecurringmasterid int YES
76 entity float YES
77 apapprovalstatus int YES
78 apapprovalagent int YES
79 aptechrequestedapproval int YES
80 apapprovalemailreply nvarchar 500 YES
81 apapprovalemailaddr nvarchar 500 YES
82 apapprovalrequestdate datetime YES ((0))
83 apappointmentlocationtext nvarchar 500 YES
84 aplast_modified datetime YES ((0))
85 apother1 int YES ((0))
86 apother2 int YES ((0))
87 apcalendarid nvarchar 1000 YES
88 APteamId int YES
89 APrecurringDesc nvarchar 500 YES
90 APshiftType int YES ((0))
91 APAreaNoteId int YES ((0))
92 APImmutableId bit YES
93 APOldCollectionId uniqueidentifier YES
94 apcreatedby int YES
95 APIsScheduledAppointment bit YES
96 apdatecreated datetime YES ((0))
97 APisactiveshift bit YES
98 APisadhocshift bit YES
99 APactualstart datetime YES ((0))
100 apscheduledforapid int YES

Schedule (32 columns)

# Column Type Length Nullable Default
1 SCHid int NO
2 SCHstartdate datetime YES
3 SCHenddate datetime YES
4 SCHnextcreationdate datetime YES
5 SCHsubject nvarchar 500 YES
6 SCHhours float YES
7 SCHdailyrecurrencepattern int YES
8 SCHdailyrecurrencedays int YES
9 SCHweeklyrecurrenceweeks int YES
10 SCHendafteramount int YES
11 SCHrangeofrecurrence int YES
12 SCHrequesttype int YES
13 SCHrecurrencepattern int YES
14 SCHagentid int YES
15 SCHmonthlyrecurrencepattern int YES
16 SCHyearlyrecurrencepattern int YES
17 SCHmonthlyrecurrencespecificdate int YES
18 SCHmonthlyrecurrencespecificdateinterval int YES
19 SCHmonthlyrecurrencespecificday int YES
20 SCHmonthlyrecurrencespecificdayofweek int YES
21 SCHmonthlyrecurrencespecificdayinterval int YES
22 SCHyearlyrecurrencespecificdate int YES
23 SCHyearlyrecurrencespecificdatemonth int YES
24 SCHyearlyrecurrencespecificdateinterval int YES
25 SCHyearlyrecurrencespecificday int YES
26 SCHyearlyrecurrencespecificdayofweek int YES
27 SCHyearlyrecurrencespecificdaymonth int YES
28 SCHyearlyrecurrencespecificdayinterval int YES
29 SCHtype int YES
30 SCHuniqueid int YES
31 SCHweeklyrecurrencestring nvarchar 250 YES
32 SCHnextrundate datetime YES

Timesheet (5 columns)

# Column Type Length Nullable Default
1 TSid int NO
2 TSunum int NO
3 TSdate datetime NO
4 TSstartdate datetime YES
5 TSenddate datetime YES
Back to top