Table Detail Report

AUTHORIZATION_MANAGEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Management
Definition: Maintains content necessary for managing an Authorization
Table Type: ACTIVITY





Column Detail - AUTHORIZATION_MANAGEMENT


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 generated number that identifiers a single row on the AUTHORIZATION table to which this Authorization Management Information applies.
AUTHORIZATION_MANAGEMENT_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.
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.
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 - AUTHORIZATION_MANAGEMENT


Child Column in AUTHORIZATION_MANAGEMENT(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID




Parent Column in AUTHORIZATION_MANAGEMENT (PK) Child Table Name Child Column Name
Children: AUTHORIZATION_MANAGEMENT_ID AUTH_MANAGEMENT_HIST AUTHORIZATION_MANAGEMENT_ID


AUTH_CODE_VALUE_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Code Value Relationship History
Definition: Used for tracking history of changes to authorization code value relationship.
Table Type: ACTIVITY





Column Detail - AUTH_CODE_VALUE_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_CODE_VALUE_R_ID DOUBLE N Unique generated number that identifies the row on the AUTHORIZATION_CODE_VALUE_R table that is being tracked for history.
AUTH_CODE_VALUE_R_HIST_ID DOUBLE N PRIMARY KEY
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CODE_SET DOUBLE N This is a code set that can have multiple code values for one Authorization.
CODE_VALUE DOUBLE N This is the code value from the given code set that allows multiple values to define the Authorization.
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.
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 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 - AUTH_CODE_VALUE_R_HIST


Child Column in AUTH_CODE_VALUE_R_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_CODE_VALUE_R_ID AUTHORIZATION_CODE_VALUE_R AUTHORIZATION_CODE_VALUE_R_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


AUTH_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: AUTHORIZATION DETAIL
Definition: Store detail information related to an authorization/referral
Table Type: ACTIVITY





Column Detail - AUTH_DETAIL


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.
AUTHORIZATION_ID DOUBLE N Parent (foreign) key to authorization table
AUTH_COMPANY VARCHAR(100) Y Authorizing company
AUTH_CONTACT VARCHAR(100) Y Authorization contact
AUTH_DETAIL_ID DOUBLE N Unique key for the auth_detail record
AUTH_DT_TM DATETIME Y OBSOLETE. The date and time at which insurance company approval was obtained for services being rendered to a patient. This column is deprecated in favor of AUTHORIZATION.AUTH_OBTAINED_DT_TM.
AUTH_PHONE_NUM VARCHAR(100) Y The phone number called to obtain the authorization details
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.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
LONG_TEXT_ID DOUBLE N Foreign key to long_text table
PLAN_CONTACT_ID DOUBLE N Foreign key to plan_contact record to identify the plan contact used for the auth_detail info
PRSNL_ID DOUBLE N The id of the person who obtained the detail auth info
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 - AUTH_DETAIL


Child Column in AUTH_DETAIL(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in AUTH_DETAIL (PK) Child Table Name Child Column Name
Children: AUTH_DETAIL_ID AUTH_DETAIL_HIST AUTH_DETAIL_ID


AUTH_DETAIL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: AUTHORIZATION DETAIL HISTORY
Definition: Store detailed history information related to an authorization/referral
Table Type: ACTIVITY





Column Detail - AUTH_DETAIL_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 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.
AUTHORIZATION_ID DOUBLE N Parent (foreign) key to AUTHORIZATION table
AUTH_COMPANY VARCHAR(100) Y This is the company that generates the auth numbers
AUTH_CONTACT VARCHAR(100) Y Free-text person or organization that is contacted during the authorization process.
AUTH_DETAIL_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the AUTH_DETAIL_HIST table.
AUTH_DETAIL_ID DOUBLE N A pointer to the main table that this row is a history of.
AUTH_DT_TM DATETIME Y The date/time the authorization was granted
AUTH_PHONE_NUM VARCHAR(100) Y The phone number called to obtain the authorization details
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
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.
LONG_TEXT_ID DOUBLE N Foreign key to the LONG_TEXT table.
PLAN_CONTACT_ID DOUBLE N Foreign key to plan_contact record to identify the plan contact used for the auth_detail info
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.
PRSNL_ID DOUBLE N The id of the person who obtained the detail auth info
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_DETAIL_HIST


Child Column in AUTH_DETAIL_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTH_DETAIL_ID AUTH_DETAIL AUTH_DETAIL_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


AUTH_ITEM_ORDER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Item Order Relationship
Definition: Stores information about a relationship between an authorization item and an order.
Table Type: ACTIVITY





Column Detail - AUTH_ITEM_ORDER_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_ITEM_ID DOUBLE N Uniquely identifies the related authorization item.
AUTH_ITEM_ORDER_RELTN_ID DOUBLE N Uniquely identifies information about a relationship between an authorization item and an order
AUTH_USED_CNT DOUBLE N The number of the item's authorized units that were used for the order.
CREATE_DT_TM DATETIME N The date and time the record was created
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
ORDER_ID DOUBLE N Uniquely identifies the related row on the orders 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_ITEM_ORDER_RELTN


Child Column in AUTH_ITEM_ORDER_RELTN(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ITEM_ID AUTHORIZATION_ITEM AUTHORIZATION_ITEM_ID
ORDER_ID ORDERS ORDER_ID




Parent Column in AUTH_ITEM_ORDER_RELTN (PK) Child Table Name Child Column Name
Children: AUTH_ITEM_ORDER_RELTN_ID AUTH_ITEM_ORDER_R_HIST AUTH_ITEM_ORDER_RELTN_ID