LastChanged DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 1: Line 1:
{{Data_element
{{Data element
| field_name = LastChanged_DtTm
|field_name=LastChanged_DtTm
| element_description = Last time the record was closed with the "Close - with updates" button
|CCMDB_tab=Top Row
| in_table = L_Log table
|in_table=L_Log table
| data_type = date
|data_type=date
| program_collecting = CC and Med
|program_collecting=Med and CC
| created_raw = Raw
|created_raw=Raw
| data_element_start_date = 2021-01-06
|data_element_start_date=2021-01-06
| data_element_end_date = 2999-12-31
|data_element_end_date=2999-12-31
| data_element_sort_index = 91--
|data_element_sort_index=91
|element_description=Last time the record was closed with the "Close - with updates" button
}}
}}
The field doesn't show anywhere in CCMDB.accdb
The field doesn't show anywhere in CCMDB.accdb



Latest revision as of 22:49, 2021 January 6

Data Element (edit)
Field Name: LastChanged_DtTm
CCMDB Label: not stated
CCMDB tab: Top Row
Table: L_Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 2021-01-06
End Date: 2999-12-31
Sort Index: 91

Last time the record was closed with the "Close - with updates" button

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


The field doesn't show anywhere in CCMDB.accdb

The field can't be edited manually, only by using the "Close - with updates" button (see Close - WITH or NO Updates buttons). If the "Close - No updates" button is used the time is not updated.

See also LastOpened DtTm field.

Log

2021-01-06 - Turns out this was never populated when set up. Will now populate properly

Related articles

Related articles: