Table Detail Report

RVC_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Comment
Definition: Stores free text comments for various solution domains.
Table Type: ACTIVITY





Column Detail - RVC_COMMENT


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.
COMMENT_TEXT LONGTEXT Y The Free Text Comment.
COMMENT_TYPE_CD DOUBLE N The comment type is the code set value which identifies the specific type of comment for the comment row (i.e., general, delay reason, etc.)
COMMENT_TYPE_CLASS_CD DOUBLE N Comment type class is used to categorize comments into general entity groups (i.e., person, encounter, encounterauthorization, etc.)
CREATE_DT_TM DATETIME N The date and time that the comment was created.
CREATE_PRSNL_ID DOUBLE N The user responsible for creating the comment.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the comment row is related.
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this comment row is related (i.e., person, encounter, authorization, etc.)
RVC_COMMENT_ID DOUBLE N Uniquely identifies a revenue cycle comment.
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 - RVC_COMMENT


Child Column in RVC_COMMENT(FK) Parent Table Name Parent Column Name
Parents: CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in RVC_COMMENT (PK) Child Table Name Child Column Name
Children: RVC_COMMENT_ID RVC_COMMENT_HIST RVC_COMMENT_ID


RVC_COMMENT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Comment History
Definition: Stores history for free text comments for various solution domains.
Table Type: ACTIVITY





Column Detail - RVC_COMMENT_HIST


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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COMMENT_TEXT LONGTEXT Y The Free Text Comment.
COMMENT_TYPE_CD DOUBLE N The comment type is the code set value which identifies the specific type of comment for the comment row (i.e., general, delay reason, etc.)
COMMENT_TYPE_CLASS_CD DOUBLE N Comment type class is used to categorize comments into general entity groups (i.e., person, encounter, encounterauthorization, etc.)
CREATE_DT_TM DATETIME N The date and time that the comment was created.
CREATE_PRSNL_ID DOUBLE N The user responsible for creating the comment.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the comment row is related.
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this comment row is related (i.e., person, encounter, authorization, etc.)
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
RVC_COMMENT_HIST_ID DOUBLE N Stores the history of free text comments for various solution domains.
RVC_COMMENT_ID DOUBLE N Uniquely identifies a revenue cycle comment.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME N ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
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 - RVC_COMMENT_HIST


Child Column in RVC_COMMENT_HIST(FK) Parent Table Name Parent Column Name
Parents: PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
RVC_COMMENT_ID RVC_COMMENT RVC_COMMENT_ID


TRANS_ADMIT_NOTIFY_ALT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Admission Notification Alternate
Definition: The transaction admission notification alternate table stores an alternate/secondary patient admission notification transaction that is submitted to payers by the admission facility.
Table Type: ACTIVITY





Column Detail - TRANS_ADMIT_NOTIFY_ALT


Column Name Type Null? Definition
PM_POST_DOC_ID DOUBLE N Unique generated number that identifies each Person Management post document.
REPORT_QUEUE_ID DOUBLE N Unique generated number that identifies a specific report on the report queue table. Matches up with the output_handle_id field.
TRANSACTION_ADMIT_NOTIFY_ID DOUBLE N Unique generated number that identifies a single row on the TRANS_ADMIT_NOTIFY table.
TRANSMISSION_STATUS_CD DOUBLE N The current transmission status of the report.
TRANSMIT_DT_TM DATETIME Y The next valid time that the report can be transmitted based on time scheme criteria.
TRANS_ADMIT_NOTIFY_ALT_ID DOUBLE N Unique generated number that identifies a single row on the transaction_admit_notify_alt 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 - TRANS_ADMIT_NOTIFY_ALT


Child Column in TRANS_ADMIT_NOTIFY_ALT(FK) Parent Table Name Parent Column Name
Parents: PM_POST_DOC_ID PM_POST_DOC PM_POST_DOC_ID
REPORT_QUEUE_ID REPORT_QUEUE OUTPUT_HANDLE_ID
TRANSACTION_ADMIT_NOTIFY_ID TRANSACTION_ADMIT_NOTIFY TRANSACTION_ADMIT_NOTIFY_ID


ZIP_DEFAULT



Column Section Top of Page


Table-level Detail

Description: Zip Default
Definition: Zip code defaults table.
Table Type: REFERENCE





Column Detail - ZIP_DEFAULT


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.
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.
CITY VARCHAR(40) Y Name of the City.
CITY_CD DOUBLE N The code value for the city.
COUNTY VARCHAR(40) Y Name of the county.
COUNTY_CD DOUBLE N Code value for the county.
COUNTY_FIPS VARCHAR(5) Y The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. The first two digits are the FIPS state code and the last three are the county code within the state or possession.
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.
PREFERRED_TYPE VARCHAR(1) Y The preferred type of zip code.
PREFIX VARCHAR(10) Y Phone number prefix.
STATE VARCHAR(40) Y Two letter abbreviation for a state.
STATE_CD DOUBLE N Code value for a state.
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.
ZIPCODE VARCHAR(10) Y The postal code used to identify a geographical region.
ZIP_DEFAULT_ID DOUBLE N Primary key for this table.
ZIP_PRIMARY_IND DOUBLE Y Primary indicator.