STANDARD DATA DICTIONARY #1.5217 -- SQLI_COLUMN FILE 3/24/25 PAGE 1
STORED IN ^DMSQ("C", *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
A set of formatting and physical structure specifications. Each column specification has a column type table element
(SQLI_TABLE_ELEMENT) which contains the relational specifications, name and domain. The column specification contains those
attributes required to locate the value in the global structure, and to project the value to the user.
DD ACCESS: ^
WR ACCESS: ^
DEL ACCESS: ^
LAYGO ACCESS: ^
POINTED TO BY: C_PARENT field (#8) of the SQLI_COLUMN File (#1.5217)
P_COLUMN field (#1) of the SQLI_PRIMARY_KEY File (#1.5218)
F_CLM_ELEMENT field (#2) of the SQLI_FOREIGN_KEY File (#1.5219)
CROSS
REFERENCED BY: C_TABLE_ELEMENT(B), C_PARENT(C), C_FIELD(D), C_OUTPUT_FORMAT(E)
1.5217,.01 C_TABLE_ELEMENT 0;1 POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216) (Required)
Table Element
LAST EDITED: AUG 20, 1996
DESCRIPTION:
IEN of table element.
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5217^B
1)= S ^DMSQ("C","B",$E(X,1,30),DA)=""
2)= K ^DMSQ("C","B",$E(X,1,30),DA)
1.5217,1 C_FILE 0;5 NUMBER
File ID
INPUT TRANSFORM: K:+X'=X!(X>999999999.999999)!(X<1)!(X?.E1"."7N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 999999999.999999, 6 Decimal Digits
DESCRIPTION: FileMan file (or subfile) ID, if column was derived from ^DD.
NULL if column is generated by SQLI.
WRITE AUTHORITY: ^
1.5217,2 C_WIDTH 0;2 NUMBER
Width
INPUT TRANSFORM: K:+X'=X!(X>22)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: AUG 20, 1996
HELP-PROMPT: Type an integer between 1 and 999999999999999
DESCRIPTION: Field width for display This field is estimated by SQLI from evidence in ^DD unless it's specified
with J modifier.
WRITE AUTHORITY: ^
1.5217,3 C_SCALE 0;3 NUMBER
Dec. Pt.
INPUT TRANSFORM: K:+X'=X!(X>9)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 9, 0 Decimal Digits
DESCRIPTION: Number of decimal points to display on output (numeric only). If scale is specified as 0, SQLI
projects column as integer.
WRITE AUTHORITY: ^
1.5217,4 C_FIELD 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999999.9999999)!(X<.001)!(X?.E1"."8N.N) X
LAST EDITED: MAR 11, 1997
HELP-PROMPT: Type a Number between .001 and 9999999.9999999, 7 Decimal Digits
DESCRIPTION:
FileMan field ID from ^DD NULL unless column is derived directly from the data dictionary.
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5217^D^MUMPS
1)= S ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)=""
2)= K ^DMSQ("C","D",$P(^DMSQ("C",DA,0),U,5),X,DA)
Column by FileMan File number, by field number
1.5217,5 C_NOT_NULL 0;7 SET
Req.
'0' FOR Not required;
'1' FOR Required;
LAST EDITED: SEP 26, 1996
DESCRIPTION:
When true (1) value is required, when false (0) not required.
WRITE AUTHORITY: ^
1.5217,6 C_SECURE 0;8 SET
Secure
'0' FOR Not secure;
'1' FOR Secure;
LAST EDITED: SEP 26, 1996
DESCRIPTION: If true, there is a security screen, else not. When this flag is set, vendors should use DBS to
retrieve data.
WRITE AUTHORITY: ^
1.5217,7 C_VIRTUAL 0;9 SET
Virtual
'0' FOR Base column;
'1' FOR Calculated value column;
LAST EDITED: SEP 26, 1996
DESCRIPTION:
If true, the value is computed. Vendors should use DBS to get value.
WRITE AUTHORITY: ^
1.5217,8 C_PARENT 0;10 POINTER TO SQLI_COLUMN FILE (#1.5217)
Parent Column
LAST EDITED: SEP 26, 1996
DESCRIPTION: Column whose physical global structure precedes this column. Used to construct global root. Chain
goes back to ^DIC.
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5217^C
1)= S ^DMSQ("C","C",$E(X,1,30),DA)=""
2)= K ^DMSQ("C","C",$E(X,1,30),DA)
Column by parent column
1.5217,9 C_GLOBAL 1;E1,245 MUMPS
Global
INPUT TRANSFORM: K:$L(X)>245 X D:$D(X) ^DIM
LAST EDITED: SEP 26, 1996
HELP-PROMPT: M global fragment which precedes this element
DESCRIPTION: M global fragment between this column and parent column. Contains node specifier for non-key
columns. Key columns are constructed by SQLI and contain the multiple node specifier or ^DIC root.
WRITE AUTHORITY: ^
1.5217,10 C_PIECE 0;11 NUMBER
Piece
INPUT TRANSFORM: K:+X'=X!(X>99)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 99, 0 Decimal Digits
DESCRIPTION: The piece address of the column in a data string. If the piece address was of form E1,30, this
value is null.
WRITE AUTHORITY: ^
1.5217,11 C_EXTRACT_FROM 0;12 NUMBER
Ext. Frm.
INPUT TRANSFORM: K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 511, 0 Decimal Digits
DESCRIPTION:
First character to be extracted with $EXTRACT NULL unless specified by form E1,30.
WRITE AUTHORITY: ^
1.5217,12 C_EXTRACT_THRU 0;13 NUMBER
Ext. Thru
INPUT TRANSFORM: K:+X'=X!(X>511)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 511, 0 Decimal Digits
DESCRIPTION:
Last character to extract with $E
WRITE AUTHORITY: ^
1.5217,13 C_COMPUTE_EXEC 2;E1,245 MUMPS
Computation
INPUT TRANSFORM: K:$L(X)>245 X D:$D(X) ^DIM
LAST EDITED: SEP 26, 1996
HELP-PROMPT: M code to return value in {V}: machine generated
DESCRIPTION:
Computation execute uses $$GET1^DIQ to return code by default
EXECUTABLE HELP: W ?5,"Enter code to return value in {V}"
WRITE AUTHORITY: ^
1.5217,14 C_FM_EXEC 3;E1,245 MUMPS
FileMan Retrieval Strategy
INPUT TRANSFORM: K:$L(X)>245 X D:$D(X) ^DIM
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Don't enter manually: machine generated.
DESCRIPTION: Standard $$GET1^DIQ code to return value of pointer, variable pointer and computed values, or when
security flag is set
EXECUTABLE HELP: W ?5,"Don't enter this. It should be auto-generated."
WRITE AUTHORITY: ^
1.5217,15 C_POINTER 4;E1,245 MUMPS
Pointer or Set Param
INPUT TRANSFORM: K:$L(X)>245 X D:$D(X) ^DIM
LAST EDITED: SEP 06, 1996
HELP-PROMPT: This is Standard MUMPS code.
DESCRIPTION:
Set translation string for SET, or global root for POINTER
WRITE AUTHORITY: ^
1.5217,16 C_OUTPUT_FORMAT 0;4 POINTER TO SQLI_OUTPUT_FORMAT FILE (#1.5214)
Output Format
LAST EDITED: SEP 26, 1996
DESCRIPTION: IEN of default output format in SQLI_OUTPUT_FORMAT for this column Always present for SET, POINTER
and VARIABLE-POINTER data types
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5217^E
1)= S ^DMSQ("C","E",$E(X,1,30),DA)=""
2)= K ^DMSQ("C","E",$E(X,1,30),DA)
Column by output format
FILES POINTED TO FIELDS
SQLI_COLUMN (#1.5217) C_PARENT (#8)
SQLI_OUTPUT_FORMAT (#1.5214) C_OUTPUT_FORMAT (#16)
SQLI_TABLE_ELEMENT (#1.5216) C_TABLE_ELEMENT (#.01)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):