Table Detail Report

AUTH_ITEM_ORDER_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Item Order Relationship History
Definition: Stores information about the history of an authorization item/order relationship.
Table Type: ACTIVITY





Column Detail - AUTH_ITEM_ORDER_R_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.
AUTHORIZATION_ITEM_ID DOUBLE N Unique generated number that identifies a single row on the Authorization_Item table.
AUTH_ITEM_ORDER_RELTN_ID DOUBLE N Unique generated number that identifiers a single row on the AUTH_ITEM_ORDER_RELTN table to which this history row is associated.
AUTH_ITEM_ORDER_R_HIST_ID DOUBLE N Unique generated number that identifiers a single row on the AUTH_ITEM_ORDER_R_HIST table.
AUTH_USED_CNT DOUBLE N The number of the item's authorized units that were used for the order.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CREATE_DT_TM DATETIME Y The date and time the record was created
CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the Authorization Item/ Order Relationship table.
ORDER_ID DOUBLE N Unique generated number that identifies a single row on the ORDERS table.
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.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y ** 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 - AUTH_ITEM_ORDER_R_HIST


Child Column in AUTH_ITEM_ORDER_R_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTH_ITEM_ORDER_RELTN_ID AUTH_ITEM_ORDER_RELTN AUTH_ITEM_ORDER_RELTN_ID
ORDER_ID ORDERS ORDER_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


AUTH_MANAGEMENT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Management History
Definition: Used for tracking history of changes to authorization management.
Table Type: ACTIVITY





Column Detail - AUTH_MANAGEMENT_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.
AUTHORIZATION_MANAGEMENT_ID DOUBLE N Unique generated number that identifies the row on the AUTHORIZATION_MANAGEMENT table that is being tracked for history.
AUTH_MANAGEMENT_HIST_ID DOUBLE N PRIMARY KEY
BENEFIT_MAX_NBR DOUBLE N Defines the maximum number allowed for a specific service type or group of service types that are relevant for the purposes of monitoring the authorization within a given time frame which is typically a calendar year.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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.
REIMBURSEMENT_RATE_PCT DOUBLE N Defines the percentage of the gross charge amount that should be decremented from the number originally authorized.
THRESHOLD_DT_TM DATETIME Y Defines the date at which an end user is to be notified that the patient is close to reaching the end of the time period for which the original authorization is effective.
THRESHOLD_NBR DOUBLE N Defines the number of remaining days, visits, dollars, or units that when reached shall trigger a timely notice to an end user that the patient is close to exhausting the original authorized value.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME N More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row.
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 - AUTH_MANAGEMENT_HIST


Child Column in AUTH_MANAGEMENT_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_MANAGEMENT_ID AUTHORIZATION_MANAGEMENT AUTHORIZATION_MANAGEMENT_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


AUTH_REFERRAL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Referral Relationship
Definition: Stores information about a relationship between an authorization and a referral.
Table Type: ACTIVITY





Column Detail - AUTH_REFERRAL_RELTN


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 Y 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 Y The person who caused the active_status_cd to be set or change.
AUTHORIZATION_ID DOUBLE Y Uniquely identifies the related row on the Authorization table.
AUTH_REFERRAL_RELTN_ID DOUBLE N A system generated number to uniquely identify a row on the AUTH_REFERRAL_RELTN table.
REFERRAL_ID DOUBLE Y Unique generated number that identifies a single row on the Referral 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 - AUTH_REFERRAL_RELTN


Child Column in AUTH_REFERRAL_RELTN(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
REFERRAL_ID REFERRAL REFERRAL_ID




Parent Column in AUTH_REFERRAL_RELTN (PK) Child Table Name Child Column Name
Children: AUTH_REFERRAL_RELTN_ID AUTH_REFERRAL_RELTN_HIST AUTH_REFERRAL_RELTN_ID


AUTH_REFERRAL_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Referral Relationship History
Definition: Stores history information for a relationship between an authorization and a referral.
Table Type: ACTIVITY





Column Detail - AUTH_REFERRAL_RELTN_HIST


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 Y 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 Y The person who caused the active_status_cd to be set or change.
AUTHORIZATION_ID DOUBLE Y Uniquely identifies the related row on the authorization table.
AUTH_REFERRAL_RELTN_HIST_ID DOUBLE N A system generated number used to uniquely identify a row on the AUTH_REFERRAL_RELTN_HIST table.
AUTH_REFERRAL_RELTN_ID DOUBLE Y A system generated number to uniquely identify a row on the AUTH_REFERRAL_RELTN table.
CHANGE_BIT DOUBLE Y Identifies which columns have had a change.
PM_HIST_TRACKING_ID DOUBLE Y This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
REFERRAL_ID DOUBLE Y Uniquely identifies the related referral
TRACKING_BIT DOUBLE Y Identifies which columns are being tracked for history.
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 - AUTH_REFERRAL_RELTN_HIST


Child Column in AUTH_REFERRAL_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
AUTH_REFERRAL_RELTN_ID AUTH_REFERRAL_RELTN AUTH_REFERRAL_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID
REFERRAL_ID REFERRAL REFERRAL_ID


AUTH_SCH_EVENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Schedule Event Relationship
Definition: Stores information about a relationship between an authorization and a schedule event.
Table Type: ACTIVITY





Column Detail - AUTH_SCH_EVENT_RELTN


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.
AUTHORIZATION_ID DOUBLE N Unique system generated number that identifies a single row on the AUTHORIZATION table to which the schedule event is related.
AUTH_SCH_EVENT_RELTN_ID DOUBLE N Unique system generated number that identifies a single row on the AUTH_SCH_EVENT_RELTN table.
SCH_EVENT_ID DOUBLE N Unique system generated number that identifies a single row on the SCH_EVENT 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 - AUTH_SCH_EVENT_RELTN


Child Column in AUTH_SCH_EVENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID




Parent Column in AUTH_SCH_EVENT_RELTN (PK) Child Table Name Child Column Name
Children: AUTH_SCH_EVENT_RELTN_ID AUTH_SCH_EVENT_RELTN_HIST AUTH_SCH_EVENT_RELTN_ID