704.001 (906)    INDEX (.11)

Name Value
FILE 704.001
NAME PK
DESCRIPTION
This index is used to quickly find all users that have been granted 
special access to an item by item ID.
SHORT DESCRIPTION Uniqueness Index for Key 'A' of File #704.001
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE LOOKUP & SORTING
ROOT TYPE INDEX FILE
ROOT FILE 704.001
SET LOGIC S ^MDC(704.001,"PK",$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.001
    FIELD:   .01
    MAXIMUM LENGTH:   38
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   704.001
    FIELD:   .02
    MAXIMUM LENGTH:   30
KILL LOGIC K ^MDC(704.001,"PK",$E(X(1),1,38),$E(X(2),1,30),DA)
KILL ENTIRE INDEX CODE K ^MDC(704.001,"PK")