Table Detail Report
PREFDIR_DESCRIPTION
Column Section | Top of Page |
Table-level Detail
Description: | Preference directory description. |
Definition: | Detailed information about the preference entry. More like a help file for the entry. |
Table Type: | REFERENCE |
Column Detail - PREFDIR_DESCRIPTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ENTRY_ID | DOUBLE | N | Entry id that we are setting a description for. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VALUE | VARCHAR(2000) | N | Normalized attribute values |
VALUE_UPPER | VARCHAR(255) | N | An upper case version of the value is stored for string comparison purposes for an equality search. |
PREFDIR_DISPLAYNAME
Column Section | Top of Page |
Table-level Detail
Description: | Preference directory display name. |
Definition: | Longer and more descriptive name for the preference entry |
Table Type: | REFERENCE |
Column Detail - PREFDIR_DISPLAYNAME
Column Name | Type | Null? | Definition |
---|---|---|---|
ENTRY_ID | DOUBLE | N | The entry id that the display name is specified for. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VALUE | VARCHAR(1024) | N | Normalized attribute values |
VALUE_UPPER | VARCHAR(255) | N | An upper case version of the value is stored for string comparison purposes for an equality search. |
PREFDIR_ENTRY
Column Section | Top of Page |
Table-level Detail
Description: | Preference directory entry |
Definition: | Short name for the preference entry. |
Table Type: | REFERENCE |
Column Detail - PREFDIR_ENTRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ENTRY_ID | DOUBLE | N | The entry id that the short name is specified for. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VALUE | VARCHAR(1024) | N | Normalized attribute values |
VALUE_UPPER | VARCHAR(255) | N | An upper case version of the value is stored for string comparison purposes for an equality search. |
PREFDIR_ENTRYDATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Preference directory entry data. |
Definition: | The entry data table holds information about a preference entry. This table is used to obtain the entry_id for a preference entry and to support multiple levels of search. In a hierarchical format, the search scope can be the node itself, all entries one level beneath the node or all entries below the node. The parent and the child table are included in the entry table since all the other attributes are dependent on the entry_id. |
Table Type: | REFERENCE |
Column Detail - PREFDIR_ENTRYDATA
Column Name | Type | Null? | Definition |
---|---|---|---|
DIST_NAME | VARCHAR(2000) | N | A bottom to top hierarchical naming structure that identifies an entry uniquely from another. |
DIST_NAME_SHORT | VARCHAR(255) | Y | Short version of dist_name for building indexes on this field. |
ENTRY_DATA | VARCHAR(2000) | Y | Data associated to the dist_name. These entries are stored in a attribute:value format. |
ENTRY_ID | DOUBLE | N | Unique id for each row in the table |
PARENT_ID | DOUBLE | N | In hierarchical structure, this id is used to identify the parent of the entry_id |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PREFDIR_ENTRYDATA
Parent Column in PREFDIR_ENTRYDATA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENTRY_ID | PREFDIR_ACL | ENTRY_ID |
PREFDIR_MULTIVALUE | ENTRY_ID |
PREFDIR_GROUP
Column Section | Top of Page |
Table-level Detail
Description: | Preference directory groups. |
Definition: | A 'Group' is a term used to collect items that belong to a common theme. A group could contain groups (sub groups) or entries (leaf elements). A group can be a high level component such as flowsheet or a sub group under flowsheet such as flowsheet fonts where size, type and styles can be defined. |
Table Type: | REFERENCE |
Column Detail - PREFDIR_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ENTRY_ID | DOUBLE | N | Entry id that we are setting a group for. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VALUE | VARCHAR(1024) | N | Normalized attribute values |
VALUE_UPPER | VARCHAR(255) | N | An upper case version of the value is stored for string comparison purposes for an equality search. |