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 |