Table Detail Report

WORKING_VIEW_PERSONITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: WORKING VIEW PERSON ITEM
Definition: Specifies the items for working views that are applicable for a given encounter.
Table Type: ACTIVITY





Column Detail - WORKING_VIEW_PERSONITEM


Column Name Type Null? Definition
INCLUDED_IND DOUBLE N Specifies whether the primitive event set is included on the working view.
LAST_ACTION_DT_TM DATETIME Y The date and time of the last action on the item
PARENT_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event set parents associated to a working view section.
PRIMITIVE_EVENT_SET_NAME VARCHAR(40) N Specifies the primitive event sets associated to a working view section
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.
WORKING_VIEW_PERSONITEM_ID DOUBLE N Sequence generated primary key.
WORKING_VIEW_PERSON_SECT_ID DOUBLE N Foreign key from the Working View Person Sect table.



Relationship Detail - WORKING_VIEW_PERSONITEM


Child Column in WORKING_VIEW_PERSONITEM(FK) Parent Table Name Parent Column Name
Parents: WORKING_VIEW_PERSON_SECT_ID WORKING_VIEW_PERSON_SECT WORKING_VIEW_PERSON_SECT_ID


WORKING_VIEW_PERSON_SECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specifies the definition for working views that are applicable for a given encnt
Definition: Specifies the definition for working views that are applicable for a given encounter.
Table Type: ACTIVITY





Column Detail - WORKING_VIEW_PERSON_SECT


Column Name Type Null? Definition
EVENT_SET_NAME VARCHAR(40) N Specifies the child event sets associated to a working view.
INCLUDED_IND DOUBLE N Specifies whether the event set is included on the working view.
SECTION_TYPE_FLAG DOUBLE N The type of the section (0=event set; 1=IV Drip)
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.
WORKING_VIEW_PERSON_ID DOUBLE N FK from the working_view_person table.
WORKING_VIEW_PERSON_SECT_ID DOUBLE N Primary Key



Relationship Detail - WORKING_VIEW_PERSON_SECT


Child Column in WORKING_VIEW_PERSON_SECT(FK) Parent Table Name Parent Column Name
Parents: WORKING_VIEW_PERSON_ID WORKING_VIEW_PERSON WORKING_VIEW_PERSON_ID




Parent Column in WORKING_VIEW_PERSON_SECT (PK) Child Table Name Child Column Name
Children: WORKING_VIEW_PERSON_SECT_ID WORKING_VIEW_PERSONITEM WORKING_VIEW_PERSON_SECT_ID


WORKING_VIEW_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specifies the default definition for working views.
Definition: Specifies the default definition for working views that are applicable for a given position/location.
Table Type: REFERENCE





Column Detail - WORKING_VIEW_SECTION


Column Name Type Null? Definition
DISPLAY_NAME VARCHAR(40) N The display name of the section
EVENT_SET_NAME VARCHAR(40) N Specifies the child event set name associated to a working view.
FALLOFF_VIEW_MINUTES DOUBLE N ** obsolete ** - this column will no longer be used as of changes made for CR 1-2933021421 - January 2009..Specifies when to remove the event set if it hasn't been documented on within the working view.
INCLUDED_IND DOUBLE N Specifies whether the event set is included on the working view.
REQUIRED_IND DOUBLE N Specifies whether the event set is required (for documentation and can't be removed) on the working view.
SECTION_TYPE_FLAG DOUBLE N The type of the section (0=event set; 1=IV Drip)
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.
WORKING_VIEW_ID DOUBLE N Foreign Key
WORKING_VIEW_SECTION_ID DOUBLE N Primary Key



Relationship Detail - WORKING_VIEW_SECTION


Child Column in WORKING_VIEW_SECTION(FK) Parent Table Name Parent Column Name
Parents: WORKING_VIEW_ID WORKING_VIEW WORKING_VIEW_ID




Parent Column in WORKING_VIEW_SECTION (PK) Child Table Name Child Column Name
Children: WORKING_VIEW_SECTION_ID CNT_WV_SECTION_KEY DCP_WV_SECTION_REF_ID
WORKING_VIEW_ITEM WORKING_VIEW_SECTION_ID