SQL20 Output: the ‘FileDate’ field contains time data. However, it should only contain a data (it's the date of the CLEVER run)

[dax-westerman]

Questions

1. Location of FileDate field
2. Preferred format for date (e.g., mm/dd/yyyy)?

[dax-westerman]

In reviewing the file output in src\step4\cleverRules.py, I am seeing a misalignment between the header fields

Example of header creation

print(
    "label|snippetID|term|sta3n|TIUdocumentSID|TIUstandardTitle|visitSID|referenceDateTime|PatientSID|targetClass|targetSubClass|termID|NoteAndSnipOffset|snippet|OpCode",
    file=fout_pos,
)

Example of output generation

sum_out = (
            label[0]
            + "|"
            + cid
            + "|"
            + longseq
            + "|"
            ....
            + "|"
            + snippet
            + "|"
            + upcode
        )

It looks like fields might be misaligned.

position	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14
Header Row	label	snippetID	term	sta3n	TIUdocumentSID	TIUstandardTitle	visitSID	referenceDateTime	PatientSID	targetClass	targetSubClass	termID	NoteAndSnipOffset	snippet	OpCode
Fields built for "sum_out"	label[0]	cid	longseq	tterm	pid	nid	ntype	time	year	tclass	tsclass	noffset	termid	snippet	upcode

[dax-westerman]

Issue moved to VA. Left open in case of other potential issues in this code base.

[dax-westerman]

Moved to VA