Notes field (L PHI): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
''see [[Notes field]] for the field in [[L_Log table]].
{{Data element
|field_name=Notes
|in_table=L PHI table
|data_type=string
|program_collecting=Med and CC
|created_raw=Raw
|data_element_sort_index=9
|element_description=Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.
}}
''see [[Notes field]] for the field in [[L_Log table]].
 


{{Data_element
| field_name = Notes
| element_description = Notes in L_PHI is used by the data processor to comment on data ad-hoc where needed.
| in_table = L_PHI
| data_type = memo
| program_collecting = Med and CC
| created_raw = Raw
| data_element_sort_index = 9
}}


== Instructions ==
== Instructions ==
**I don't really use this section.
The field was intended to store information about data that should only be in the L_PHI table. Turns out we don't really use it. [[Alias ID collection]] might contain related information.
09:44, 2017 February 7 (CST)
* Pagasa, can you give an idea of what you actually use this for? Ttenbergen 15:30, 2017 February 6 (CST)


[[Category: Data Processing]]
[[Category: Data Processing]]

Latest revision as of 01:44, 2019 January 3

Data Element (edit)
Field Name: Notes
CCMDB Label: not stated
CCMDB tab: not stated
Table: L PHI table
Data type: string
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 9

Notes in L_PHI table is used by the data processor to comment on data ad-hoc where needed.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


see Notes field for the field in L_Log table.


Instructions

The field was intended to store information about data that should only be in the L_PHI table. Turns out we don't really use it. Alias ID collection might contain related information.