SDEC AUDIT REPORT BY DATE (940)    SORT TEMPLATE (.401)

Name Value
NAME SDEC AUDIT REPORT BY DATE
SORT FIELD DATA
  • FILE OR SUBFILE NO.:   409.97
    GET CODE:   S DISX(1)=$P($G(^SDAUDIT(D0,0)),U,2)
    QUERY CONDITION:   I (DISX(1)]]3150100.999999)&(DISX(1)']]3180411.24)
    DESCRIPTION OF SORT:   DATE from JAN 1,2015 to APR 11,2018@24:00
    DATA TYPE FOR SORTING:   DATE/TIME
    FIELD NO.:   1
    FIELD NAME:   DATE
    FROM VALUE INTERNAL:   3150100.999999
    FROM VALUE EXTERNAL:   JAN 1,2015
    FROM VALUE PRINTABLE:   JAN 1,2015
    TO VALUE INTERNAL:   3180411.24
    TO VALUE EXTERNAL:   APR 11,2018@2400
    TO VALUE PRINTABLE:   APR 11,2018@24:00
    CROSS REFERENCE DATA:   ^SDAUDIT("C",^SDAUDIT(^2
  • FILE OR SUBFILE NO.:   409.97
    GET CODE:   S Y(1)=$S($D(^SDAUDIT(D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(2)=X
    QUERY CONDITION:   I DISX(2)'=""
    DESCRIPTION OF SORT:   SCHEDULER not null
    DATA TYPE FOR SORTING:   FREE TEXT
    COMPUTED FIELD CODE:   S Y(1)=$S($D(^SDAUDIT(D0,0)):^(0),1:"") S X=$P($G(^VA(200,+$P(Y(1),U,1),0)),U) I D0>0 S DISX(2)=X
    FIELD NAME:   SCHEDULER
    SORT QUALIFIERS BEFORE FIELD:   ".01
    CROSS REFERENCE DATA:   ^SDAUDIT("B",^SDAUDIT(^2
    POINT TO CROSS REFERENCE:   ^VA(200,"B",
DATE CREATED 2018-03-07 10:24:00
FILE SD Audit Statistics
DATE LAST USED 2019-06-19 00:00:00