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