SentDtTm field: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →See also: m |
Ttenbergen (talk | contribs) mNo edit summary |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 2: | Line 2: | ||
| field_name = SentDtTm | | field_name = SentDtTm | ||
| element_description = Time the record was last sent. | | element_description = Time the record was last sent. | ||
| in_table = L_Log | | in_table = L_Log table | ||
| data_type = date | | data_type = date | ||
| program_collecting = Med and CC | | program_collecting = Med and CC | ||
Line 8: | Line 8: | ||
| data_element_sort_index = 6 | | data_element_sort_index = 6 | ||
}} | }} | ||
It is automatically populated during [[sending]]. | It is automatically populated during [[sending]]. | ||
== Data Use == | == Data Use == | ||
Line 26: | Line 19: | ||
* [[LastChanged_DtTm field]] - apparently only in ccmdb_data.mdb, after recordstatus which is in different spot in ccmdb(later) than in cfe(earlier) | * [[LastChanged_DtTm field]] - apparently only in ccmdb_data.mdb, after recordstatus which is in different spot in ccmdb(later) than in cfe(earlier) | ||
[[Category:Sending]] | [[Category:Sending]] | ||
[[Category:AutoTimeStamps]] | [[Category:AutoTimeStamps]] |
Latest revision as of 22:44, 2019 March 9
Data Element (edit) | |
Field Name: | SentDtTm |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | L_Log table |
Data type: | date |
Length: | not stated |
Program: | Med and CC |
Created/Raw: | Raw |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 6 |
Time the record was last sent.
It is automatically populated during sending.
Data Use
Instructions for requesting a batch of data from DSM uses this.
See also
- LastOpened_DtTm field - cfe and ccmdb
- Start_Date field/Start_Time field - cfe
- LastChanged_DtTm field - apparently only in ccmdb_data.mdb, after recordstatus which is in different spot in ccmdb(later) than in cfe(earlier)