123.02 (112)    INDEX (.11)

Name Value
FILE 123.02
NAME AC
DESCRIPTION
This index will be built using the ACTIVITY (field #1), ACTUAL DATE/TIME
OF ACTIVITY (field #2) and the REMOTE DATE/TIME OF FILING (field #.25).
This index will be used to prevent an activity from being filed more than
once, in case of re-transmission of the activity from the remote site.
SHORT DESCRIPTION Index on activity, actual date of activity and remote date of activity
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE SORTING ONLY
ROOT TYPE INDEX FILE
ROOT FILE 123.02
SET LOGIC S ^GMR(123,DA(1),40,"AC",$E(X(1),1,3),$E(X(2),1,17),$E(X(3),1,17),DA)=""
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   123.02
    FIELD:   1
    MAXIMUM LENGTH:   3
    COLLATION:   forwards
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   123.02
    FIELD:   .25
    MAXIMUM LENGTH:   17
    COLLATION:   forwards
  • ORDER NUMBER:   3
    SUBSCRIPT NUMBER:   3
    TYPE OF VALUE:   FIELD
    FILE:   123.02
    FIELD:   2
    MAXIMUM LENGTH:   17
    COLLATION:   forwards
KILL LOGIC K ^GMR(123,DA(1),40,"AC",$E(X(1),1,3),$E(X(2),1,17),$E(X(3),1,17),DA)
KILL ENTIRE INDEX CODE K ^GMR(123,DA(1),40,"AC")