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.