Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Directly Accessed By Routines |  Pointer To FileMan Files |  Fields
Print Page as PDF
Global: ^DMSQ("F"

Package: VA FileMan

Global: ^DMSQ("F"


Information

FileMan FileNo FileMan Filename Package
1.5219 SQLI_FOREIGN_KEY VA FileMan

Description

Directly Accessed By Routines, Total: 5

Package Total Routines
VA FileMan 5 DMSQF1    DMSQF2    DMSQP3    DMSQP5    DMSQT    

Pointer To FileMan Files, Total: 3

Package Total FileMan Files
VA FileMan 3 SQLI_COLUMN(#1.5217)[2]    SQLI_TABLE_ELEMENT(#1.5216)[.01]    SQLI_PRIMARY_KEY(#1.5218)[1]    

Fields, Total: 3

Field # Name Loc Type Details
.01 F_TBL_ELEMENT 0;1 POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)
************************REQUIRED FIELD************************
SQLI_TABLE_ELEMENT(#1.5216)

  • LAST EDITED:  AUG 28, 1996
  • DESCRIPTION:  
    IEN of foreign key table element in SQLI_TABLE_ELEMENT
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5219^B
    1)= S ^DMSQ("F","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("F","B",$E(X,1,30),DA)
1 F_PK_ELEMENT 0;2 POINTER TO SQLI_PRIMARY_KEY FILE (#1.5218)
************************REQUIRED FIELD************************
SQLI_PRIMARY_KEY(#1.5218)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    IEN of primary key element in SQLI_PRIMARY_KEY of foreign table
    WRITE AUTHORITY: ^
2 F_CLM_ELEMENT 0;3 POINTER TO SQLI_COLUMN FILE (#1.5217)
************************REQUIRED FIELD************************
SQLI_COLUMN(#1.5217)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    IEN of column of this table in SQLI_COLUMN which matches foreign PK
    WRITE AUTHORITY: ^
Info |  Desc |  Directly Accessed By Routines |  Pointer To FileMan Files |  Fields