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

Package: VA FileMan

Global: ^DMSQ("E"


Information

FileMan FileNo FileMan Filename Package
1.5216 SQLI_TABLE_ELEMENT VA FileMan

Description

Pointed To By FileMan Files, Total: 3

Package Total FileMan Files
VA FileMan 3 SQLI_COLUMN(#1.5217)[.01]    SQLI_FOREIGN_KEY(#1.5219)[.01]    SQLI_PRIMARY_KEY(#1.5218)[.01]    

Pointer To FileMan Files, Total: 2

Package Total FileMan Files
VA FileMan 2 SQLI_DOMAIN(#1.5212)[1]    SQLI_TABLE(#1.5215)[2]    

Fields, Total: 5

Field # Name Loc Type Details
.01 E_NAME 0;1 FREE TEXT
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
  • LAST EDITED:  AUG 20, 1996
  • HELP-PROMPT:  Answer must be 3-30 characters in length.
  • DESCRIPTION:  
    Name of table element. Foreign keys are suffixed _FK or PFK. Primary keys are suffixed _PK.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5216^B
    1)= S ^DMSQ("E","B",$E(X,1,30),DA)=""
    2)= K ^DMSQ("E","B",$E(X,1,30),DA)
1 E_DOMAIN 0;2 POINTER TO SQLI_DOMAIN FILE (#1.5212)
************************REQUIRED FIELD************************
SQLI_DOMAIN(#1.5212)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    IEN of domain in SQLI_DOMAIN
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5216^C
    1)= S ^DMSQ("E","C",$E(X,1,30),DA)=""
    2)= K ^DMSQ("E","C",$E(X,1,30),DA)
2 E_TABLE 0;3 POINTER TO SQLI_TABLE FILE (#1.5215)
************************REQUIRED FIELD************************
SQLI_TABLE(#1.5215)

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    IEN of table in SQLI_TABLE. Required.
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5216^D
    1)= S ^DMSQ("E","D",$E(X,1,30),DA)=""
    2)= K ^DMSQ("E","D",$E(X,1,30),DA)
  • CROSS-REFERENCE:  1.5216^G^MUMPS
    1)= S ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)=""
    2)= K ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)
    Table element by table by name
3 E_TYPE 0;4 SET
************************REQUIRED FIELD************************
  • 'C' FOR Column;
  • 'P' FOR Primary key;
  • 'F' FOR Foreign key;

  • LAST EDITED:  SEP 26, 1996
  • DESCRIPTION:  
    C for column, P for primary key, or F for foreign key
    WRITE AUTHORITY: ^
  • CROSS-REFERENCE:  1.5216^E
    1)= S ^DMSQ("E","E",$E(X,1,30),DA)=""
    2)= K ^DMSQ("E","E",$E(X,1,30),DA)
  • CROSS-REFERENCE:  1.5216^F^MUMPS
    1)= S ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)=""
    2)= K ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)
    Table element by table by type
4 E_COMMENT 0;5 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
  • LAST EDITED:  SEP 26, 1996
  • HELP-PROMPT:  Answer must be 3-60 characters in length.
  • DESCRIPTION:  
    A short description of the element
    WRITE AUTHORITY: ^
Info |  Desc |  Pointed To By FileMan Files |  Pointer To FileMan Files |  Fields