DS_TAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Directroy Search Tag
Definition: Defines value for the given tag type from DS_TAG_TYPE. Values for TAG_TYPE -region- could be like EAST or WEST.
Table Type: ACTIVITY





Column Detail - DS_TAG


Column Name Type Null? Definition
DS_TAG_ID DOUBLE N PRIMARY KEY
DS_TAG_TYPE_ID DOUBLE N Foreign key relationship value from DS_TAG_TYPE table
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
TAG_TXT VARCHAR(255) N The textual Value of the TAG
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 - DS_TAG


Child Column in DS_TAG(FK) Parent Table Name Parent Column Name
Parents: DS_TAG_TYPE_ID DS_TAG_TYPE DS_TAG_TYPE_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in DS_TAG (PK) Child Table Name Child Column Name
Children: DS_TAG_ID DS_TAG_ENTITY_RELTN DS_TAG_ID


DS_TAG_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Directory Search Tag Provider Relationship
Definition: Associates providers from Millennium PRSNL or HPD_PROVIDER to DS_TAG
Table Type: ACTIVITY





Column Detail - DS_TAG_ENTITY_RELTN


Column Name Type Null? Definition
DS_TAG_ENTITY_RELTN_ID DOUBLE N PRIMARY KEY
DS_TAG_ID DOUBLE N Foreign Key value from the DS_TAG table
PARENT_ENTITY_ID DOUBLE N This is a soft Foreign Key value from either the Millennium PRSNL table, or from the HPD_PROVIDER table. The related table is identifie in the PARENT_ENTITY_NAME field.
PARENT_ENTITY_NAME VARCHAR(30) N Identifies the table ( PRSNL / HPD_PROVIDER) from which the PARENT_ENTITY_ID value comes from.
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 - DS_TAG_ENTITY_RELTN


Child Column in DS_TAG_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: DS_TAG_ID DS_TAG DS_TAG_ID


DS_TAG_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Directory Search Tag Type
Definition: The tag types for Referral Service Directory. Tag Types could be like 'Network', 'EAST' etc¿ to identify providers when referring.
Table Type: ACTIVITY





Column Detail - DS_TAG_TYPE


Column Name Type Null? Definition
DS_TAG_TYPE_ID DOUBLE N PRIMARY KEY
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
TAG_TYPE_TXT VARCHAR(255) N The value of the tag type
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 - DS_TAG_TYPE


Child Column in DS_TAG_TYPE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in DS_TAG_TYPE (PK) Child Table Name Child Column Name
Children: DS_TAG_TYPE_ID DS_TAG DS_TAG_TYPE_ID