# | Name | Location | Type | Details | Index | Description |
---|---|---|---|---|---|---|
.01 | c table element(+) | 0;1 | POINTER | 1.5216 | B | IEN of table element. |
1 | c file | 0;5 | NUMERIC | FileMan file (or subfile) ID, if column was derived from ^DD. NULL if column is generated by SQLI. | ||
2 | c width | 0;2 | NUMERIC | Field width for display This field is estimated by SQLI from evidence in ^DD unless it's specified with J modifier. | ||
3 | c scale | 0;3 | NUMERIC | Number of decimal points to display on output (numeric only). If scale is specified as 0, SQLI projects column as integer. | ||
4 | c field | 0;6 | NUMERIC | FileMan field ID from ^DD NULL unless column is derived directly from the data dictionary. | ||
5 | c not null | 0;7 | SET OF CODES | 0:Not required 1:Required | When true (1) value is required, when false (0) not required. | |
6 | c secure | 0;8 | SET OF CODES | 0:Not secure 1:Secure | If true, there is a security screen, else not. When this flag is set, vendors should use DBS to retrieve data. | |
7 | c virtual | 0;9 | SET OF CODES | 0:Base column 1:Calculated value column | If true, the value is computed. Vendors should use DBS to get value. | |
8 | c parent | 0;10 | POINTER | 1.5217 | C | Column whose physical global structure precedes this column. Used to construct global root. Chain goes back to ^DIC. |
9 | c global | 1;E1,245 | FREE TEXT | 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. | ||
10 | c piece | 0;11 | NUMERIC | The piece address of the column in a data string. If the piece address was of form E1,30, this value is null. | ||
11 | c extract from | 0;12 | NUMERIC | First character to be extracted with $EXTRACT NULL unless specified by form E1,30. | ||
12 | c extract thru | 0;13 | NUMERIC | Last character to extract with $E | ||
13 | c compute exec | 2;E1,245 | FREE TEXT | Computation execute uses $$GET1^DIQ to return code by default | ||
14 | c fm exec | 3;E1,245 | FREE TEXT | Standard $$GET1^DIQ code to return value of pointer, variable pointer and computed values, or when security flag is set | ||
15 | c pointer | 4;E1,245 | FREE TEXT | Set translation string for SET, or global root for POINTER | ||
16 | c output format | 0;4 | POINTER | 1.5214 | E | IEN of default output format in SQLI_OUTPUT_FORMAT for this column Always present for SET, POINTER and VARIABLE-POINTER data types |