Table Detail Report

PREFDIR_MULTIVALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Meta data table for a preference entry
Definition: This table stores meta data about a preference value for an entry. A non zero value indicates the entry can contain more than 1 value.
Table Type: REFERENCE





Column Detail - PREFDIR_MULTIVALUE


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(4) N Value indicating if a preference entry can contain a single value or more than 1 value.
VALUE_UPPER VARCHAR(4) N The upper case version of value for sorting purposes.



Relationship Detail - PREFDIR_MULTIVALUE


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


PREFDIR_POINTER



Column Section Top of Page


Table-level Detail

Description: Preference directory pointers.
Definition: An attribute to connect application and components.
Table Type: REFERENCE





Column Detail - PREFDIR_POINTER


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


PREFDIR_POLICY



Column Section Top of Page


Table-level Detail

Description: Preference directory policy.
Definition: A grammatical expression constructed using tokens from the context, that describes the process in which preferences should be coalesced or collated. Policies are created within the model and the preference service looks up the policy to determine the coalescing sequence.
Table Type: REFERENCE





Column Detail - PREFDIR_POLICY


Column Name Type Null? Definition
ENTRY_ID DOUBLE N Entry id that we are setting a policy 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_ROOT



Column Section Top of Page


Table-level Detail

Description: Preference directory root.
Definition: The root of the data base. Simply serves as the anchor in a hierarchical format.
Table Type: REFERENCE





Column Detail - PREFDIR_ROOT


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


PREFDIR_SOURCE



Column Section Top of Page


Table-level Detail

Description: Preference directory source.
Definition: Attribute containing additional information such as table a context is associated to. Also contains merge information.
Table Type: REFERENCE





Column Detail - PREFDIR_SOURCE


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