McDewey

Rule Name: Update the DateTimeStamp for Dynamic reco Description: When a record in a Dynamic table is updated value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cur currentTime (INTO DateTimeStamp); 2.3.242.2 fkdevice (FI-3645) Type: guid (Null OK) Default Value: NULL Remarks: Reserved for future use; References the current active device 2.3.242.3 fknumplan (FI-3644) Type: guid (Unique, Cascade Delete, Not Modifiable) Remarks: References Intercom pattern in NumPlan table 2.3.242.4 pkid (FI-3643) Type: guid (Unique, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.242.5 versionstamp (FI-3647) Type: string [47] (Null OK) Default Value: 0000000000-c7a6c673-7479-46b0-839e-014d3d093963 Remarks: New guid plus seconds past midnight 1970 are concatenated Uniqueness: No multicolumn uniqueness constraints 2.3.243 ipmalineinfo (TI-244) Description: IPMA relationship between two lines for two users Fields: 2.3.243.1 fkenduser (FI-1764) Type: guid (Cascade Delete) Remarks: Asst? 2.3.243.2 fknumplan (FI-1765) Type: guid (Cascade Delete) 2.3.243.3 ikipmalineinfo (FI-1767) Type: guid (Null OK) Remarks: Manager's line 2.3.243.4 isprimary (FI-1766) Type: bool Default Value: FALSE 2.3.243.5 lineindex (FI-1768)