Table Detail Report
SELECTED_RX_FORMULARY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Selected RX Formulary |
Definition: | This table stores a reference to the last manually selected prescription formulary to be used for a patient. A patient can have either a prescription plan or prescription system formulary but not both. |
Table Type: | ACTIVITY |
Column Detail - SELECTED_RX_FORMULARY
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 | 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. |
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. |
PERSON_ID | DOUBLE | N | The unique identifier of the patient for the selected formulary or plan. |
PERSON_RX_PLAN_RELTN_ID | DOUBLE | N | The unique identifier of the last manually selected prescription plan. This attribute will be 0 if the patient has a selected system formulary instead of a prescription plan. |
SELECTED_RX_FORMULARY_ID | DOUBLE | N | This is the value of the unique primary identifier of the Selected_RX_Formulary table. It is an internal system assigned number. |
SYSTEM_RX_FORMULARY_ID | DOUBLE | N | The unique identifier of the last manually selected system formulary. This attribute will be 0 if the patient has a prescription plan instead of a selected system formulary. |
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 - SELECTED_RX_FORMULARY
Child Column in SELECTED_RX_FORMULARY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
PERSON_RX_PLAN_RELTN_ID | PERSON_RX_PLAN_RELTN | PERSON_RX_PLAN_RELTN_ID | |
SYSTEM_RX_FORMULARY_ID | SYSTEM_RX_FORMULARY | SYSTEM_RX_FORMULARY_ID |
SYSTEM_RX_FORMULARY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | System Prescription Formulary |
Definition: | This table contains RX formularies that can be assigned to a patient. They would typically be used when a patient does not have a prescription plan. |
Table Type: | REFERENCE |
Column Detail - SYSTEM_RX_FORMULARY
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 | 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. |
BENEFIT_SET_NAME | VARCHAR(255) | N | This is the name of the formulary benefit set. |
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. |
FB_BENEFIT_SET_UID | VARCHAR(255) | N | This is the UID of the formulary benefit set that is stored in the Formulary Benefit table in the Formulary and Benefits application that is housed outside of Millennium. |
PRIORITY_SEQ | DOUBLE | N | This is used to prioritize the system formularies if there is more than one. |
SYSTEM_RX_FORMULARY_ID | DOUBLE | N | The unique primary identifier of the System_RX_Formulary table. It is an internal system assigned number. |
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 - SYSTEM_RX_FORMULARY
Parent Column in SYSTEM_RX_FORMULARY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SYSTEM_RX_FORMULARY_ID | SELECTED_RX_FORMULARY | SYSTEM_RX_FORMULARY_ID |
TRANSACTION_ADDRESS_VERIFY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Transaction Address Verify |
Definition: | Stores information to track addresss verification transaction history for a person. |
Table Type: | ACTIVITY |
Column Detail - TRANSACTION_ADDRESS_VERIFY
Column Name | Type | Null? | Definition |
---|---|---|---|
PERSON_ID | DOUBLE | N | Unique identifier to the person table for the person whose address was submitted for verification. |
REPLY_DT_TM | DATETIME | Y | The date and time the address verification transaction response was received inbound. |
REQUEST_LONG_TEXT_ID | DOUBLE | N | Unique identifier of the long text table for storing the outbound request message |
RESPONSE_LONG_TEXT_ID | DOUBLE | N | Unique identifier of the long text table for storing the inbound response message |
SENT_DT_TM | DATETIME | N | The date and time the address verification transaction was sent outbound. If an error occurred, it is the date and time the transaction was attempted |
SUBMITTER_PRSNL_ID | DOUBLE | N | Unique identifier of the personnel that submitted the transaction outbound. |
TRANSACTION_ADDRESS_VERIFY_ID | DOUBLE | N | Unique generated number that identifies a single row on the TRANSACTION_ADDRESS_VERIFY table. |
TRANSACTION_SOURCE_IDENT | VARCHAR(50) | Y | The unique identifier of the transaction as assigned by Transaction Services. Links the transaction between a Millennium domain and Transaction Services. |
TRANSACTION_STATUS_CD | DOUBLE | N | The high level status of the transaction. |
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 - TRANSACTION_ADDRESS_VERIFY
Child Column in TRANSACTION_ADDRESS_VERIFY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REQUEST_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
RESPONSE_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SUBMITTER_PRSNL_ID | PRSNL | PERSON_ID |
TRANSACTION_ADMIT_ERROR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Admission Transaction Notification Error |
Definition: | The table stores information to track admission notification error history for patients. |
Table Type: | ACTIVITY |
Column Detail - TRANSACTION_ADMIT_ERROR
Column Name | Type | Null? | Definition |
---|---|---|---|
ERROR_LOCATION_CD | DOUBLE | N | The location code describes where the error occurred while processing the eligibility transaction. |
FOLLOW_UP_ACTION_CD | DOUBLE | N | This code instructs the recipient of the admission notification response about what action needs to be taken. |
LONG_TEXT_ID | DOUBLE | N | This is the identifier of the long_text table row containing the error's text message. |
REJECT_REASON_CD | DOUBLE | N | This code defines the reason why the transaction was unable to be processed successfully. |
TRANSACTION_ADMIT_ERROR_ID | DOUBLE | N | Admission Notification transaction error history data |
TRANSACTION_ADMIT_NOTIFY_ID | DOUBLE | N | Uniquely identifies the related transaction admission notification. |
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 - TRANSACTION_ADMIT_ERROR
Child Column in TRANSACTION_ADMIT_ERROR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
TRANSACTION_ADMIT_NOTIFY_ID | TRANSACTION_ADMIT_NOTIFY | TRANSACTION_ADMIT_NOTIFY_ID |
TRANSACTION_ADMIT_NOTIFY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Transaction Admission Notification |
Definition: | This table stores information to track admission notification history for patients. |
Table Type: | ACTIVITY |
Column Detail - TRANSACTION_ADMIT_NOTIFY
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIN_REF_NUM | VARCHAR(50) | Y | An additional reference number returned by the payer for the notification. Different payers will return this number under different scenarios. |
ADMIT_DT_TM | DATETIME | Y | The date and time of the patient's admission that was sent to the payer. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related encounter. If populated, admission notification was submitted as part of the given encounter. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Uniquely identifies the related relationship between encounter and health plan for which the admission notification transaction was submitted. |
NOTIFY_RECEIPT_NUM | VARCHAR(50) | Y | An additional reference number returned by the payer for the notification. Different payers will return this number under different scenarios. |
NOTIFY_STATUS_CD | DOUBLE | N | The payer specified status of the notification. Returned by the payer that was notified of the admission. |
ORGANIZATION_ID | DOUBLE | N | The facility organization that admitted the patient. Identifying information for the facility that was sent to the payer. |
PAYER_ID | DOUBLE | N | Uniquely identifies the related organization for the payer to whom this transaction was submitted. |
PERSON_ID | DOUBLE | N | Uniquely identifies the patient whose admission notification was submitted to the payer via this transaction. |
REPLY_DT_TM | DATETIME | Y | The date and time the admission notification transaction response was received inbound. |
REVIEW_IDENT_NUM | VARCHAR(50) | Y | The primary reference number returned by the payer for the notification. Different payers will return this number under different scenarios. |
SENT_DT_TM | DATETIME | Y | The date and time the admission notification transaction was sent outbound. |
SUBMITTER_PRSNL_ID | DOUBLE | N | Uniquely identifies the personnel that submitted the transaction outbound. |
TRANSACTION_ADMIT_NOTIFY_ID | DOUBLE | N | Uniquely identifies information used to track admission notification history for patients. |
TRANSACTION_SOURCE_IDENT | VARCHAR(50) | N | The transaction identifier assigned by transaction services. Used to retrieve the transaction status and response details. |
TRANSACTION_STATUS_CD | DOUBLE | N | The high level status of the transaction. |
TRANS_SUB_STATUS_CD | DOUBLE | N | The optionally provided detail about the status of the transaction. |
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 - TRANSACTION_ADMIT_NOTIFY
Child Column in TRANSACTION_ADMIT_NOTIFY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_PLAN_RELTN_ID | ENCNTR_PLAN_RELTN | ENCNTR_PLAN_RELTN_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PAYER_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SUBMITTER_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in TRANSACTION_ADMIT_NOTIFY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TRANSACTION_ADMIT_NOTIFY_ID | TRANSACTION_ADMIT_ERROR | TRANSACTION_ADMIT_NOTIFY_ID |
TRANS_ADMIT_NOTIFY_ALT | TRANSACTION_ADMIT_NOTIFY_ID |