231.7 (871)    INDEX (.11)

Name Value
FILE 231.7
NAME AC
DESCRIPTION
This cross reference supports constructing a list of currently active 
staff for a particular role.
 
For this record level cross reference, the kill logic should always be 
executed when any value changes.  The set logic is then executed 
conditionally, allowing the cross reference to hold only active values.
SHORT DESCRIPTION SITE,AREA,ROLE,IEN if the entry is active
TYPE REGULAR
EXECUTION RECORD
ACTIVITY IR
USE SORTING ONLY
ROOT TYPE INDEX FILE
ROOT FILE 231.7
SET LOGIC S ^EDPB(231.7,"AC",X(1),X(2),X(3),DA)=""
SET CONDITION CODE S X='X2(4)
CROSS-REFERENCE VALUES
  • ORDER NUMBER:   1
    SUBSCRIPT NUMBER:   1
    TYPE OF VALUE:   FIELD
    FILE:   231.7
    FIELD:   .02
    COLLATION:   forwards
  • ORDER NUMBER:   2
    SUBSCRIPT NUMBER:   2
    TYPE OF VALUE:   FIELD
    FILE:   231.7
    FIELD:   .03
    COLLATION:   forwards
  • ORDER NUMBER:   3
    SUBSCRIPT NUMBER:   3
    TYPE OF VALUE:   FIELD
    FILE:   231.7
    FIELD:   .06
    COLLATION:   forwards
  • ORDER NUMBER:   4
    TYPE OF VALUE:   FIELD
    FILE:   231.7
    FIELD:   .04
    COLLATION:   forwards
KILL LOGIC K ^EDPB(231.7,"AC",X(1),X(2),X(3),DA)
KILL ENTIRE INDEX CODE K ^EDPB(231.7,"AC")