Table Detail Report
PCS_SCHEDULE_SEGMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PCS Schedule Segment |
Definition: | Contains information about a schedule segment (a block of time). For example, it is used for automatic authorization and clinical validation of lab instruments. The parameters for this may vary by schedule segment. |
Table Type: | REFERENCE |
Column Detail - PCS_SCHEDULE_SEGMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_TYPE_CD | DOUBLE | N | A grouping mechanism within catalog type code. |
BEG_TM_NBR | DOUBLE | N | The begin time of this schedule segment |
DAY_OF_WEEK_BIT | DOUBLE | N | The value that determines the day(s) of the week this schedule segment applies to. |
END_TM_NBR | DOUBLE | N | The end time of this schedule segment |
PCS_SCHEDULE_SEGMENT_ID | DOUBLE | N | The primary key of this table |
SCHEDULE_CD | DOUBLE | N | The schedule that the group of segment rows are linked to. |
SYSTEM_ON_IND | DOUBLE | N | Indicates whether clinical validation and autoverification are in effect for this schedule segment. |
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 - PCS_SCHEDULE_SEGMENT
Parent Column in PCS_SCHEDULE_SEGMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PCS_SCHEDULE_SEGMENT_ID | PCS_SCHEDULE_SEG_HLDY_R | PCS_SCHEDULE_SEGMENT_ID |
PCS_SCHEDULE_SEG_HLDY_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PCS Schedule Segement Holiday |
Definition: | Defines the holiday codes for PCS schedule segments. |
Table Type: | REFERENCE |
Column Detail - PCS_SCHEDULE_SEG_HLDY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
HOLIDAY_DAY_CD | DOUBLE | N | The holiday code related to a schedule segment. |
PCS_SCHEDULE_SEGMENT_ID | DOUBLE | N | Foreign key to table PCS_Schedule_Segment |
PCS_SCHEDULE_SEG_HLDY_ID | DOUBLE | N | Primary key for this 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. |
Relationship Detail - PCS_SCHEDULE_SEG_HLDY_R
Child Column in PCS_SCHEDULE_SEG_HLDY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PCS_SCHEDULE_SEGMENT_ID | PCS_SCHEDULE_SEGMENT | PCS_SCHEDULE_SEGMENT_ID |
PCS_SUB_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the sub criteria used for Clinical Validation |
Definition: | Stores the sub criteria used for Clinical Validation. This table will be used primarily for microbiology clinical validation information. |
Table Type: | REFERENCE |
Column Detail - PCS_SUB_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CRITERIA_ID | DOUBLE | N | Foreign key to the pcs_criteria table. |
CRITERIA_TYPE_CD | DOUBLE | N | Code value of the criteria type. Code set 29161 |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
MAX_VALUE | DOUBLE | N | Maximum value of a range type criteria, which is used when the selected Susceptibility Detail is a numeric type. |
MICRO_TASK_TYPE_CD | DOUBLE | N | Code value for certain type of microbiology criteria (ex: reports, and response). Code set 14929. |
MIN_VALUE | DOUBLE | N | Minimum value of a range type criteria, which is used when the selected Susceptibility Detail is a numeric type. |
PARENT_ENTITY_ID | DOUBLE | N | id number of the selected criteria located on table |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Table name where selected criteria is stored. Valid names include:CODE_VALUE, PRSNL, ORDER_CATALOG, LOCATION, SERVICE_RESOURCE, MIC_GROUP_RESPONSE |
SUB_CRITERIA_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the sub criteria |
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 - PCS_SUB_CRITERIA
Child Column in PCS_SUB_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CRITERIA_ID | PCS_CRITERIA | CRITERIA_ID |
Parent Column in PCS_SUB_CRITERIA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SUB_CRITERIA_ID | PCS_QUALIFYING_CRITERIA | SUB_CRITERIA_ID |
PROFILE_RESOURCE_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Profile Task R/service resource list |
Definition: | Used to store relationships between order catalog items and the service resources that perform the work for the task/assays associated to the order catalog item |
Table Type: | REFERENCE |
Column Detail - PROFILE_RESOURCE_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CATALOG_CD | DOUBLE | N | Store the code value of the order catalog item that is associated with the service resource |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PRIMARY_IND | DOUBLE | Y | Indicates if the service resource will be the primary one for the order catalog item specified and, as such, will be the default service resource to be routed to if all other loading logic fails |
SCRIPT_NAME | VARCHAR(50) | Y | Name of script to be used for loading logic that is required by a site that is not provided for through the calendar logic |
SEQUENCE | DOUBLE | Y | Used to determine the sequence by which service resource will be tested for routing logic. Once the routing server has found a match by sequence, loading will occur and no other service resources will be tested, so the rule is to give the exceptions a lower sequence |
SERVICE_RESOURCE_CD | DOUBLE | N | Used to store the code for the service resource that is related to the order catalog item |
TASK_ASSAY_CD | DOUBLE | N | Used to store the code for the task/assay that is related to the service resource and catalog item |
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 - PROFILE_RESOURCE_LIST
Child Column in PROFILE_RESOURCE_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | PROFILE_TASK_R | CATALOG_CD |
TASK_ASSAY_CD | PROFILE_TASK_R | TASK_ASSAY_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
PROP_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contains the action infomation for PROP orders. |
Definition: | Action information for PROP orders. |
Table Type: | ACTIVITY |
Column Detail - PROP_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Indicates the processing the PathNet Result Order Posting Server will perform. |
PROP_ID | DOUBLE | N | The identifier of the row in the table. |
START_DT_TM | DATETIME | N | The start date and time for the action. |
STATUS_FLAG | DOUBLE | Y | The status of the action flag. |
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 - PROP_ACTION
Parent Column in PROP_ACTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PROP_ID | PROP_ORDER | PROP_ID |