PREFDIR_ACL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Preference Access Control List
Definition: Table that stores the access control information for a preference entry.
Table Type: REFERENCE





Column Detail - PREFDIR_ACL


Column Name Type Null? Definition
ENTRY_ID DOUBLE N This is the id that uniquely identifies a preference in the prefdir_entrydata table.
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 String containing the type of preference context (consumers for e.g. users, positions) whose access must be controlled.
VALUE_UPPER VARCHAR(255) N Contains the uppercase version of value for sorting purposes.



Relationship Detail - PREFDIR_ACL


Child Column in PREFDIR_ACL(FK) Parent Table Name Parent Column Name
Parents: ENTRY_ID PREFDIR_ENTRYDATA ENTRY_ID


PREFDIR_ALIAS



Column Section Top of Page


Table-level Detail

Description: Preference directory aliases.
Definition: A reference attribute to create aliases. For instance, vital signs can use the all results flowsheet preferences entries since they are both possibly implemented by the same component.
Table Type: REFERENCE





Column Detail - PREFDIR_ALIAS


Column Name Type Null? Definition
ENTRY_ID DOUBLE N Entry id that we are aliasing.
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_ALLOWEDVALUES



Column Section Top of Page


Table-level Detail

Description: Preference directory allowed values.
Definition: This table holds the possible values associated to a preference entry. The preference service management application restricts values to this set when adding or modifying values.
Table Type: REFERENCE





Column Detail - PREFDIR_ALLOWEDVALUES


Column Name Type Null? Definition
ENTRY_ID DOUBLE N Entry id that we are setting allowed values 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_CONTEXT



Column Section Top of Page


Table-level Detail

Description: Preference directory context.
Definition: A 'context' is a term used to identify the level at which preferences are being defined. Examples of a context are Users, Positions, Locations, Default (System/Org wide) etc. Contexts are defined by application architects.
Table Type: REFERENCE





Column Detail - PREFDIR_CONTEXT


Column Name Type Null? Definition
ENTRY_ID DOUBLE N Entry id that we are setting a context 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(64) N Normalized attribute values
VALUE_UPPER VARCHAR(64) N An upper case version of the value is stored for string comparison purposes for an equality search.


PREFDIR_DESCENDANT



Column Section Top of Page


Table-level Detail

Description: Preference directory descendants.
Definition: The purpose of the descendant table is to support the subtree search feature of the preference service. For each entry with a unique id this table contains the unique identifiers of the descendant entries. For every entry in the directory, a row exists in this table for each of its ancestors including itself. The size of the table depends on the depth of each entry.
Table Type: REFERENCE





Column Detail - PREFDIR_DESCENDANT


Column Name Type Null? Definition
ANCESTOR_ID DOUBLE N Parent entry that the 'descendant' is related to.
DESCENDANT_ID DOUBLE N Child entry that the ancestor is related to.
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.