123 (81)    INDEX (.11)

Name Value
FILE 123
NAME AE
DESCRIPTION
This cross reference is used for services to see all consults by service,
OE/RR status and Date of Request.
SHORT DESCRIPTION Index by SERVICE, STATUS, DATE OF REQUEST
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE SORTING ONLY
ROOT TYPE INDEX FILE
ROOT FILE 123
SET LOGIC S ^GMR(123,"AE",$E(X(1),1,5),$E(X(2),1,5),$E(X(3),1,20),DA)=""
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   123
    FIELD:   1
    MAXIMUM LENGTH:   5
    COLLATION:   forwards
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   123
    FIELD:   8
    MAXIMUM LENGTH:   5
    COLLATION:   forwards
  • ORDER NUMBER:   3
    SUBSCRIPT NUMBER:   3
    TYPE OF VALUE:   FIELD
    FILE:   123
    FIELD:   3
    TRANSFORM FOR STORAGE:   S X=9999999-X
    MAXIMUM LENGTH:   20
    COLLATION:   forwards
KILL LOGIC K ^GMR(123,"AE",$E(X(1),1,5),$E(X(2),1,5),$E(X(3),1,20),DA)
KILL ENTIRE INDEX CODE K ^GMR(123,"AE")