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 |