McDewey

Type: bool Default Value: TRUE 2.3.87.6 lowsourcefiledatetime (FI-5146) Type: long 2.3.87.7 pkid (FI-5141) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. 2.3.87.8 tkuserlocale (FI-5144) Type: enum (Indexed) Remarks: reference to TypeUserLocale Uniqueness: fkcustomannouncement + tkuserlocale is unique. (MFI-126) 2.3.88 customer (TI-21052) Description: Used for HCS-SA to differenciate the customers in the DB Fields: 2.3.88.1 createtime (FI-28271) Type: long (Not Modifiable) Default Value: 0 Remarks: UTC time of creation Rule (RI-2382): Type: Active (Insert) Rule Name: Update createTime for Customer records Description: When a Customer Record is created, set the Test Condition: ON INSERT INTO Customer: LET currentTim (INTO createTime); Rule (RI-2382): Type: Active (Insert) This field is modified by this rule. Rule Name: Update createTime for Customer records Description: When a Customer Record is created, set the Test Condition: ON INSERT INTO Customer: LET currentTim (INTO createTime); 2.3.88.2 lastaudittime (FI-28272) Type: long Default Value: 0 Remarks: UTC time of last Audit 2.3.88.3 name (FI-28270)