Table Detail Report

PM_SCH_SETUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Search setup.
Definition: Stores information for the setup of PM Search.
Table Type: REFERENCE





Column Detail - PM_SCH_SETUP


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE Y The parent application number.
CUTOFF_MODE_FLAG DOUBLE N This is the mode that the cut off is set to. It is a flag field with 0,1,2,3 as a value. 0-None, 1-Exact Match, 2-Percentage of Top, 3-Simple Percent Gap.
EXACT_MATCH DOUBLE Y A dynamic cutoff that will return exact matches to the query data plus a specified number of additional records.
LIMIT_IND DOUBLE Y An indicator to limit encounter results.
LOCKED_IND DOUBLE Y Indicates whether or not the record is locked.
MAX DOUBLE Y Maximum return set.
MAX_ENCNTR DOUBLE Y Maximum number of Encounters to return.
MAX_MPI_RESULTS_NBR DOUBLE N The maximum results requested to be returned from an external MPI.
OPF_IND DOUBLE Y Indicates if OPF searches are enabled.
OPTIONS VARCHAR(100) Y Stores a string of 1s and 0s which can be parsed to identify specific options. Used in PDS and MPI.
PERCENT_TOP DOUBLE Y A dynamic cutoff that returns all records with a score greater than or equal to a specified percentage of the match score for the highest scored record.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHONETIC_IND DOUBLE Y Indicates if phonetic search will be used.
POSITION_CD DOUBLE N The position_cd of the user the preferences belong to.
SETUP_ID DOUBLE N The primary key of this table.
SIMPLE_PERCENT DOUBLE Y A dynamic cutoff that returns all records until a gap between the match scores of consecutive records is greater than a specified percentage of the match score for the highest scored record.
STYLE_FLAG DOUBLE Y The type of search. 1-Person search, 2-Patient search, 3-Encounter search, 4-Account search, 5-Guarantor search.
TASK_NUMBER DOUBLE Y The task_number of the application that created the transaction row.
THRESHOLD DOUBLE Y The minimum OPF weight that will be displayed in OPF search results.
TITLE VARCHAR(100) Y Stores the title of the search options window. Obsolete.
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.
WILDCARD_IND DOUBLE Y Indicates if assume wildcards option is on.



Relationship Detail - PM_SCH_SETUP


Child Column in PM_SCH_SETUP(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in PM_SCH_SETUP (PK) Child Table Name Child Column Name
Children: SETUP_ID PM_SCH_FILTER SETUP_ID
PM_SCH_LIMIT_CODE_VALUE_R SETUP_ID
PM_SCH_RESULT SETUP_ID


PM_TYPE_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM Type Params
Definition: Stores information for properties of different types of parameters and flags. Only one active, "unended" row should ever exists for a given combination of type_flag, organization_id, type_cd and param_name.
Table Type: REFERENCE





Column Detail - PM_TYPE_PARAMS


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 Y 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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PARAM_NAME VARCHAR(40) N String value used to determine parameter for each type flag, type code and organization id.
PARENT_ROW_NBR DOUBLE N The value of the primary identifier for the parent row on this table to which the row is related.
PM_TYPE_PARAMS_SEQ DOUBLE N PM Type Params Sequence
TYPE_CD DOUBLE N Represents the property name from codeset 28240 or 356 or 17649. This value can be a table column header, a user defined property or a location attribute property. In the future, might contain code values from additional codesets as new parameters are defined for different functional areas.
TYPE_FLAG DOUBLE N An indicator which determines the type of transaction that occurred for each row.
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.
VALUE_CD DOUBLE N Represents the codified value for a parameter. Value could be from multiple codesets based on the type flag and parameter.
VALUE_DT_TM DATETIME Y Represents the date and time for a parameter.
VALUE_NBR DOUBLE Y Represents the constant which is the cdf meaning of the type_cd if the parameter is for secondary alerts. May also represent the number value for the parameter of a different type.
VALUE_STRING VARCHAR(100) Y Represents the type extension on the type_cd code value if the parameter is for a secondary alert. May also contain a string value for a parameter of a different type.



Relationship Detail - PM_TYPE_PARAMS


Child Column in PM_TYPE_PARAMS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


RC_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Parameter
Definition: The RC_PARAMETER table stores information about parameters.
Table Type: REFERENCE





Column Detail - RC_PARAMETER


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.
CREATE_DT_TM DATETIME N Contains the date and time the row was created.
CREATE_PRSNL_ID DOUBLE N Contains the id of the person who created the row
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.
PARM_NAME VARCHAR(100) N Contains the name of the parameter.
PARM_NAME_CD DOUBLE N Codified Parameter Name
PARM_VALUE DOUBLE Y The Real number value of the parameter.
PARM_VALUE_DT_TM DATETIME Y The date and time value of the parameter.
PARM_VALUE_NBR DOUBLE Y The Integer value of the parameter.
PARM_VALUE_TXT VARCHAR(255) Y The text value of the parameter.
PARM_VALUE_TYPE_FLAG DOUBLE N This column is a flag column to indicate the data type of the parameter value - PARM_VALUE_TYPE_FLAG. This will allow us to easily identify which value column to use, especially when values of 0 are used.
RC_PARAMETER_ID DOUBLE N Unique generated number that identifies a single row on the RC_PARAMETER table.
RC_PARAMETER_SET_ID DOUBLE N This is the value of the unique primary identifier of the RC_PARAMETER_SET table. It is an internal system assigned number.
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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 - RC_PARAMETER


Child Column in RC_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: RC_PARAMETER_SET_ID RC_PARAMETER_SET RC_PARAMETER_SET_ID


RC_PARAMETER_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Parameter Set
Definition: The RC_PARAMETER_SET table stores information about parameter sets.
Table Type: REFERENCE





Column Detail - RC_PARAMETER_SET


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.
CREATE_DT_TM DATETIME N Contains the date and time the row was created.
CREATE_PRSNL_ID DOUBLE N Contains the id of the person who created the row.
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.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARM_SET_NAME VARCHAR(100) N Contains the name of the parameter set.
PARM_SET_TYPE_CD DOUBLE N Codified Parameter Set Type
RC_PARAMETER_SET_ID DOUBLE N Unique generated number that identifies a single row on the RC_PARAMETER_SET table.
UPDT_APPLCTX DOUBLE N 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 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. 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 N 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 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. 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 N 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 - RC_PARAMETER_SET


Child Column in RC_PARAMETER_SET(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in RC_PARAMETER_SET (PK) Child Table Name Child Column Name
Children: RC_PARAMETER_SET_ID PM_AUTO_DISCH_PARM_SET_R RC_PARAMETER_SET_ID
PM_RBC_PARM_SET_R RC_PARAMETER_SET_ID
RC_PARAMETER RC_PARAMETER_SET_ID