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 | Pointed To By FileMan Files | Pointer To FileMan Files | Fields | Global Variables Directly Accessed | Local Variables | All

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

Names and domains of primary keys, columns and foreign keys. Each represents the relational concept of an attribute, whose essential charactaristics are a name (unique by relation) and a domain. See SQLI_PRIMARY_KEY, SQLI_COLUMN and SQLI_FOREIGN key for more.

Directly Accessed By Routines, Total: 14

Package	Total	Routines
VA FileMan	14	DMSQP3 ^DMSQ("E" DMSQF DMSQF1 DMSQF2 DMSQP DMSQP1 DMSQP2 DMSQP5 DMSQP6 DMSQS DMSQT DMSQU YEAR

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: ^`

Global Variables Directly Accessed

Name	Line Occurrences (* Changed, ! Killed)
^DMSQ("E" - [#1.5216]	.01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2(XREF 1S), 2(XREF 1K), 2(XREF 2S), 2(XREF 2K), 3(XREF 1S), 3(XREF 1K) , 3(XREF 2S), 3(XREF 2K)

Local Variables

Legend:

>>	Not killed explicitly
*	Changed
!	Killed
~	Newed

Name	Field # of Occurrence
>> DA	.01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2(XREF 1S), 2(XREF 1K), 2(XREF 2S), 2(XREF 2K), 3(XREF 1S), 3(XREF 1K) , 3(XREF 2S), 3(XREF 2K)
U	2(XREF 2S), 2(XREF 2K), 3(XREF 2S), 3(XREF 2K)
X	.01+1!, .01(XREF 1S), .01(XREF 1K), 1(XREF 1S), 1(XREF 1K), 2(XREF 1S), 2(XREF 1K), 2(XREF 2S), 2(XREF 2K), 3(XREF 1S) , 3(XREF 1K), 3(XREF 2S), 3(XREF 2K), 4+1!

Info | Desc | Directly Accessed By Routines | Pointed To By FileMan Files | Pointer To FileMan Files | Fields | Global Variables Directly Accessed | Local Variables | All