A specific point within a 24 hour period at which an event has or will occur. Use the TIMESTAMP data type to keep the most ACTIVITY START TIME ACTIVITY TM precise time to the millisecond, including OPERATING TIME OPERATING TM time zone. If the portion of importance is START TIME TIME OF START Time TIME timestamp the time, use the Time class word. If the STORE CLOSE TIME TIME STORE CLOSE date exact time is relevant, use the STORE OPEN TIME TM STORE OPEN and Timestamp class. In order to remove CURRENT_TIME TM ambiguity, use qualifier words. The class word should not be used by itself. The combination of date and time used to CREATE TIMESTAMP CREATE TS capture a specific date and point in time. END TIME STAMP END TS This class is primarily used for audit TS ENTRY ENTRY TS Timestamp TS timestamp column purposes. The abbreviated class LAST UPDATE TIMESTAMP LAST UPDATE TS word suffix must not be used by itself and MODIFIED TIME STAMP MODIFY TS requires the use of one or more qualifier TIME STAMP FOR INCIDENT INCIDENT TS words. TS or TIMESTAMP
Time TIME timestamp A specific point within a 24 hour period at which an event has or will occur. Use the TIMESTAMP data type to keep the most precise time to the millisecond, including time zone. If the portion of importance is the time, use the Time class word. If the date and exact time is relevant, use the Timestamp class. In order to remove ambiguity, use qualifier words. The class word should not be used by itself. ACTIVITY START TIME OPERATING TIME START TIME STORE CLOSE TIME STORE OPEN TIME CURRENT_TIME ACTIVITY TM OPERATING TM TIME OF START TIME STORE CLOSE TM STORE OPEN TM Timestamp TS timestamp The combination of date and time used to capture a specific date and point in time. This class is primarily used for audit column purposes. The abbreviated class word suffix must not be used by itself and requires the use of one or more qualifier words. CREATE TS END TS ENTRY TS LAST UPDATE TS MODIFY TS INCIDENT TS CREATE TIMESTAMP END TIME STAMP TS ENTRY LAST UPDATE TIMESTAMP MODIFIED TIME STAMP TIME STAMP FOR INCIDENT TS or TIMESTAMP
STD-07092501.4.0.docx