704.1212 (971)    INDEX (.11)

Name Value
FILE 704.1212
NAME FKE
DESCRIPTION
This will provide a quick index of events that have been audited.
SHORT DESCRIPTION Foreign key for EVENT_ID
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE LOOKUP & SORTING
ROOT TYPE INDEX FILE
ROOT FILE 704.1212
SET LOGIC S ^MDC(704.1212,"FKE",$E(X(1),1,38),$E(X(2),1,30),DA)=""
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   704.1212
    FIELD:   .02
    MAXIMUM LENGTH:   38
    COLLATION:   forwards
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   704.1212
    FIELD:   .03
    MAXIMUM LENGTH:   30
    COLLATION:   forwards
KILL LOGIC K ^MDC(704.1212,"FKE",$E(X(1),1,38),$E(X(2),1,30),DA)
KILL ENTIRE INDEX CODE K ^MDC(704.1212,"FKE")