Table Detail Report

PM_SCH_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search filter.
Definition: Search filter.
Table Type: REFERENCE





Column Detail - PM_SCH_FILTER


Column Name Type Null? Definition
DATA_TYPE_FLAG DOUBLE N Date type.
DISPLAY VARCHAR(100) Y Display value
HIDDEN_IND DOUBLE Y Hidden.
MEANING VARCHAR(12) Y Meaning.
OPTIONS VARCHAR(100) Y Options.
REQUIRED_IND DOUBLE Y Required indicator.
SCENARIO DOUBLE Y Scenario.
SEQUENCE DOUBLE Y Order.
SETUP_ID DOUBLE N Setup ID.
VALUE VARCHAR(100) Y Value.



Relationship Detail - PM_SCH_FILTER


Child Column in PM_SCH_FILTER(FK) Parent Table Name Parent Column Name
Parents: SETUP_ID PM_SCH_SETUP SETUP_ID


PM_SCH_LIMIT



Column Section Top of Page


Table-level Detail

Description: Search Limit.
Definition: Search Limit.
Table Type: REFERENCE





Column Detail - PM_SCH_LIMIT


Column Name Type Null? Definition
DATE_FLAG DOUBLE N Flag that determines which date to use in as a limit.
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter type class is used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). The values in this codeset all have Cerner defined meanings.
NUM_DAYS DOUBLE N Number of Days.
SETUP_ID DOUBLE N Setup ID.


PM_SCH_LIMIT_CODE_VALUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Management Search Limit Code Value Relationship
Definition: Contains the search limit for specific code values.
Table Type: ACTIVITY





Column Detail - PM_SCH_LIMIT_CODE_VALUE_R


Column Name Type Null? Definition
LIMIT_CD DOUBLE Y Code value to be limited.
PM_SCH_LIMIT_CODE_VALUE_R_ID DOUBLE N A system generated number used to uniquely identify a row on the PM_SCH_LIMIT_CODE_VALUE_R table.
SETUP_ID DOUBLE Y Uniquely identifies the related row on the PM_SHC_SETUP table.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PM_SCH_LIMIT_CODE_VALUE_R


Child Column in PM_SCH_LIMIT_CODE_VALUE_R(FK) Parent Table Name Parent Column Name
Parents: SETUP_ID PM_SCH_SETUP SETUP_ID


PM_SCH_PREFERENCES



Column Section Top of Page


Table-level Detail

Description: Search preferences.
Definition: Search preferences.
Table Type: REFERENCE





Column Detail - PM_SCH_PREFERENCES


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N Application number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREFERENCES VARCHAR(200) Y Preferences.
STYLE_FLAG DOUBLE N Style.
TASK_NUMBER DOUBLE N The task_number of the application that created the transaction row.


PM_SCH_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search results.
Definition: Search results.
Table Type: REFERENCE





Column Detail - PM_SCH_RESULT


Column Name Type Null? Definition
DATA_TYPE_FLAG DOUBLE N Data type of this column.
DISPLAY VARCHAR(100) Y Display value
FORMAT VARCHAR(100) Y Formatting to apply to this column.
MEANING VARCHAR(12) Y Meaning.
OPTIONS VARCHAR(100) Y Options.
SCENARIO DOUBLE Y Scenario.
SEQUENCE DOUBLE Y Order.
SETUP_ID DOUBLE N Setup ID.
SORT_FLAG DOUBLE Y Sorted.



Relationship Detail - PM_SCH_RESULT


Child Column in PM_SCH_RESULT(FK) Parent Table Name Parent Column Name
Parents: SETUP_ID PM_SCH_SETUP SETUP_ID