QAD 2017 Enterprise Edition > User Guides > System Administration > Database Management > Setting Up Multiple Time Zones > UTC and Transactions Outside Domains
  
UTC and Transactions Outside Domains
Any transactions you perform before you log into a domain are recorded in Universal Time, Coordinated (UTC).
UTC was formerly known as Greenwich Mean Time (GMT), and uses a 24-hour system of time notation, where “1:00 am” in UTC is expressed as 0100. The use of UTC time ensures that administrators can easily compare times and dates across multiple time zones.
Any transactions that are not tied to a particular domain are also recorded in UTC; for example, session master, user monitor, user logon date, license violation, and product registration record updates.
The following table lists the database tables and programs that timestamp updates in UTC:

Functions that Use UTC
 
Table
Date Field
Time Field
Programs
sess_mstr
sess_date
sess_time
Web program that sets/resets context when launching (mfwb02.p)
Session Context Manager (mfsessmg.p)
Appserver Session Manager Program (mfsemstr.p)
Login program to check the user ID and starting session context (mflg01.p)
usr_mstr
usr_last_date
usr_last_time
User Inquiry (mguriq.p)
Force Password Change Utility (utfrcpsw.p)
User password library (mgurlib.p)
User Maintenance (mgurmt.p)
User Password Maintenance (mgurmtp.p)
Session Initialization Procedure Library (mfinitpl.p)
usr_logon_date
usr_logon_time
mon_mstr
mon_login_date
mon_login_time
Displayed Sorted License Monitor Output (lvmoninq.i)
User Count and Licensing (lvgenpl.p)
User Monitor Inquiry (lvmon.p)
mon_date_start
mon_time_start
mon_idle_time
cnt_mstr
cnt_date
cnt_time
User Count and Licensing (lvgenpl.p)
User Count (lvcount.p)
Lock Session and Monitor Records (lvlock.p
lvr_det
lvr_date
lvr_time
Summary License Violation Report (lvlvsrp.p)
Detailed License Violation Report (lvlvdrp.p)
User Count and Licensing (lvgenpl.p)
pin_mstr
pin_inst_date
pin_inst_time
Dialog for Entering PIN Numbers (lvpin.p)
License Registration (lvreg.p)
Licensed Application Report (lvlarrpa.p)
pin_aud_date
pin_aud_ddate
pin_mod_date
pex_mstr
pex_inst_date
pex_inst_time
Dialog for Entering PIN Numbers (lvpin.p)
License Registration (lvreg.p)
Licensed Application Report (lvlarrpa.p)
pex_aud_date
pex_aud_ddate
pex_mod_date
hwm_det
hwm_date
hwm_time
Summary License Violation Report (lvlvsrp.p)
User Count and Licensing (lvgenpl.p)
uslh_hist
uslh_hist
uslh_time
Session Initialization Procedure Library (mfinitpl.p)
Appserver for the API Procedure Library (mfaspl.p)
Logon Attempt Report (mgurpsrp.p)
lua_det
lua_in_date
lua_in_time
User Count and Licensing (lvgenpl.p)
License Violation Delete/Archive (lvldup.p)
 
lua_out_date
lua_out_time
usg_det
usg_date