AUTHORIZATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores authorization/referral information
Definition: Stores information that indicates special authorizations for particular visits or procedures under a health plan's coverage
Table Type: ACTIVITY





Column Detail - AUTHORIZATION


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.
ADMISSION_BEG_DT_TM DATETIME Y The beginning of the admission period.
ADMISSION_END_DT_TM DATETIME Y The end of the admission period.
APPEAL_REASON VARCHAR(100) Y The reason an authorization/referral was appealed.
AUTHORIZATION_ID DOUBLE N This is the primary key.
AUTH_CNT DOUBLE N The number of visits, days, or treatments that are authorized by the carrier for payment.
AUTH_CNT_TIME DOUBLE N The time the count was authorized.
AUTH_CNT_TIME_CD DOUBLE N This code defines the authorized, numbered period of time in AUTH_CNT_TIME (HSD05)
AUTH_CNT_UNIT DOUBLE N The units that the authorization count is stored as.
AUTH_CNT_UNIT_CD DOUBLE N This code defines the authorized unit value in AUTH_CNT_UNIT (HSD03).
AUTH_EXPIRE_DT_TM DATETIME Y System computed value based on AUTH_CNT and ADMIT_DT_TM.
AUTH_ID DOUBLE N Due to packet passivity constraints, this field is marked for rev8 removal. Old primary key. Obsolete column.
AUTH_NBR VARCHAR(50) Y Auth number, contract code, or cert number (depends on auth codeset).
AUTH_OBTAINED_DT_TM DATETIME Y The Date on which the insurance company was obtained for approval of services being rendered to a patient.
AUTH_QUAL_CD DOUBLE N A qualifier to define both the Number Authorized and the Number Authorized Remaining fields.
AUTH_REMAIN_CNT DOUBLE N The remaining number of visits, days or treatments that are authorized by the carrier for payment.
AUTH_REQUIRED_CD DOUBLE N A Y/N field that indicates whether or not the insurance company must be contacted for approval prior to services being rendered.
AUTH_SCHEDULED_CNT DOUBLE Y The number of visits authorized by the carrier for payment that have been scheduled.
AUTH_TRANS_STATE_FLAG DOUBLE N The AUTH_TRANS_STATE_FLAG provides information on the current state of a registration conversation's authorization transaction. The valid values for EDI_FLAG are:0 - N/A, 1 - In Process, 2 - Current, 3 - Previous, 4 - Error, 5 - Resubmit
AUTH_TYPE_CD DOUBLE N Type of authorization. Authorization, Pre-cert for inpatient stay, or contract code.
AUTH_USED_CNT DOUBLE Y The number of visits, days, treatments, or the amount authorized by the carrier for payment that has been used.
AUTH_USED_MANUAL_ADJ_CNT DOUBLE Y The manual adjustment for the used number of visits, days, treatments, or the amount authorized by the carrier for payment that were captured as part of a different encounter or by an external system. For example, if not all of the authorizations were used at the same facility, the manual adjustment will contain the number used at a different facility.
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.
BNFT_TYPE_CD DOUBLE N Some authorizations will have a meaningful relation to a benefit type.
CERT_COMPANY VARCHAR(100) Y Due to packet passivity constraints, this field is marked for rev8 removal. Old, obsolete column.
CERT_NBR VARCHAR(50) Y Due to packet passivity constraints, this field is marked for rev8 removal. Old obsolete column.
CERT_PRSNL_ID DOUBLE N *NOT USED*. Obsolete.
CERT_STATUS_CD DOUBLE N Reflects status of an authorization or precertification.
CERT_TYPE_CD DOUBLE N Certification Type Code (UM02). Identifies the type of certification.
COMMENT_ID DOUBLE N Comment Identifier which is stored on the LONG_TEXT table.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DELAY_REASON_CD DOUBLE N Delay Reason Code (UMO10). Identifies the reason for the delay.
DELAY_REASON_COMMENT_ID DOUBLE N The comment identifier for free text stored on the long_text table which represents comments for the delay reason.
DESCRIPTION VARCHAR(200) Y Describes the authorization or referral.
DISCHARGE_DT_TM DATETIME Y Authorization discharge date & time (DTP01 = 096).
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
FACILITY_CD DOUBLE N Facility code for service (NM101 = FA)
HEALTH_PLAN_ID DOUBLE N Contains the related Health Plan for this authorization row.
INTERCHANGE_ID DOUBLE N Unique service authorization transaction identifier.
LAST_UPDATE_DT_TM DATETIME Y Date/time of last update to record
MODEL_UPDT_CNT DOUBLE Y The update count used to recognize update conflicts on the authorization model. Set to 0 on insert. Incremented by 1 on any update to a table in the authorization model.
MODEL_UPDT_DT_TM DATETIME Y The date and time a row within the authorization model was last inserted or updated.
PAYER_AUTH_STATUS_CD DOUBLE N Indicates the status of the payer authorization.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROVIDER_PRSNL_ID DOUBLE N The provider's personnel id (NM101 = SJ).
REFERENCE_NBR_TXT VARCHAR(100) Y The reference number for the authorization. Stored in a text format.
REJECT_REASON_CD DOUBLE N Rejection Reason Code (HCR03). Identifies the reason for the rejection.
SERVICE_BEG_DT_TM DATETIME Y Authorization beginning service date & time (DTP01 = 472).
SERVICE_END_DT_TM DATETIME Y Authorization ending service date & time (DTP01 = 472).
SERVICE_TYPE_CD DOUBLE N Marked to delete as of Rev8. Old and obsolete.
SURGICAL_DT_TM DATETIME Y Authorization surgical date & time (DTP01 = 456).
TAXONOMY_ID DOUBLE N The taxonomy code used in the authorization transaction
TOTAL_SERVICE_NBR DOUBLE Y Marked for delete in Rev8. Old and obsolete.
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.
X12PROVIDER_CD DOUBLE N Identifies the Provider's Role (PRV01).
X12SERVICE_TYPE_CD DOUBLE N Identifies the Service Type Code (UM03).



Relationship Detail - AUTHORIZATION


Child Column in AUTHORIZATION(FK) Parent Table Name Parent Column Name
Parents: INTERCHANGE_ID EEM_TRANSACTION TRANSACTION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
COMMENT_ID LONG_TEXT LONG_TEXT_ID
DELAY_REASON_COMMENT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
TAXONOMY_ID PROVIDER_TAXONOMY TAXONOMY_ID
PROVIDER_PRSNL_ID PRSNL PERSON_ID




Parent Column in AUTHORIZATION (PK) Child Table Name Child Column Name
Children: AUTHORIZATION_ID AUTHORIZATION_CODE_VALUE_R AUTHORIZATION_ID
AUTHORIZATION_HIST AUTHORIZATION_ID
AUTHORIZATION_ITEM AUTHORIZATION_ID
AUTHORIZATION_MANAGEMENT AUTHORIZATION_ID
AUTH_DETAIL AUTHORIZATION_ID
AUTH_REFERRAL_RELTN AUTHORIZATION_ID
AUTH_REFERRAL_RELTN_HIST AUTHORIZATION_ID
AUTH_SCH_EVENT_RELTN AUTHORIZATION_ID
AUTH_SCH_EVENT_RELTN_HIST AUTHORIZATION_ID
ENCNTR_PLAN_AUTH_R AUTHORIZATION_ID
ENCNTR_PLAN_AUTH_R_HIST AUTHORIZATION_ID
PERSON_PLAN_AUTH_R AUTHORIZATION_ID
PERSON_PLAN_AUTH_R_HIST AUTHORIZATION_ID
PM_HIST_TRACKING AUTHORIZATION_ID
REFERRAL_P_PLAN_AUTH_R AUTHORIZATION_ID
SCH_PEND_ENCNTR_AUTH_RELTN AUTHORIZATION_ID


AUTHORIZATION_CODE_VALUE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Code Value Relationship
Definition: Provides a method for multiple code values to define an Authorization
Table Type: ACTIVITY





Column Detail - AUTHORIZATION_CODE_VALUE_R


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 PRIMARY KEY
AUTHORIZATION_ID DOUBLE N Unique generated number that identifiers a single row on the AUTHORIZATION table to which this Code Value descriptor applies.
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.
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.
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 - AUTHORIZATION_CODE_VALUE_R


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




Parent Column in AUTHORIZATION_CODE_VALUE_R (PK) Child Table Name Child Column Name
Children: AUTHORIZATION_CODE_VALUE_R_ID AUTH_CODE_VALUE_R_HIST AUTHORIZATION_CODE_VALUE_R_ID


AUTHORIZATION_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization History
Definition: Contains historical records for the authorization table.
Table Type: ACTIVITY





Column Detail - AUTHORIZATION_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.
ADMISSION_BEG_DT_TM DATETIME Y The beginning of the admission period.
ADMISSION_END_DT_TM DATETIME Y The end of the admission period.
APPEAL_REASON VARCHAR(100) Y The reason an authorization/referral was appealed.
AUTHORIZATION_HIST_ID DOUBLE N Contains history records from the Authorization table.
AUTHORIZATION_ID DOUBLE N Uniquely identifies the record to which this history is related
AUTH_CNT DOUBLE N The number of visits, days, or treatments that are authorized by the carrier for payment.
AUTH_CNT_TIME DOUBLE N The time the count was authorized.
AUTH_CNT_TIME_CD DOUBLE N This code defines the authorized, numbered period of time in AUTH_CNT_TIME (HSD05)
AUTH_CNT_UNIT DOUBLE N The units that the authorization count is stored as.
AUTH_CNT_UNIT_CD DOUBLE N This code defines the authorized unit value in AUTH_CNT_UNIT (HSD03).
AUTH_EXPIRE_DT_TM DATETIME Y System computed value based on AUTH_CNT and ADMIT_DT_TM.
AUTH_ID DOUBLE N Due to packet passivity constraints, this field is marked for rev8 removal. Old primary key. Obsolete column.
AUTH_NBR VARCHAR(50) Y Auth number, contract code, or cert number (depends on auth codeset).
AUTH_OBTAINED_DT_TM DATETIME Y The Date on which the insurance company was obtained for approval of services being rendered to a patient.
AUTH_QUAL_CD DOUBLE N A qualifier to define both the Number Authorized and the Number Authorized Remaining fields.
AUTH_REMAIN_CNT DOUBLE N The remaining number of visits, days or treatments that are authorized by the carrier for payment.
AUTH_REQUIRED_CD DOUBLE N A Y/N field that indicates whether or not the insurance company must be contacted for approval prior to services being rendered.
AUTH_SCHEDULED_CNT DOUBLE Y The number of visits authorized by the carrier for payment that have been scheduled.
AUTH_TRANS_STATE_FLAG DOUBLE N The AUTH_TRANS_STATE_FLAG provides information on the current state of a registration conversation's authorization transaction. The valid values for EDI_FLAG are:0 - N/A, 1 - In Process, 2 - Current, 3 - Previous, 4 - Error, 5 - Resubmit
AUTH_TYPE_CD DOUBLE N Type of authorization. Authorization, Pre-cert for inpatient stay, or contract code.
AUTH_USED_CNT DOUBLE Y The number of visits, days, treatments, or the amount authorized by the carrier for payment that has been used.
AUTH_USED_MANUAL_ADJ_CNT DOUBLE Y The manual adjustment for the used number of visits, days, treatments, or the amount authorized by the carrier for payment that were captured as part of a different encounter or by an external system. For example, if not all of the authorizations were used at the same facility, the manual adjustment will contain the number used at a different facility.
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.
BNFT_TYPE_CD DOUBLE N Some authorizations will have a meaningful relation to a benefit type.
CERT_COMPANY VARCHAR(100) Y Due to packet passivity constraints, this field is marked for rev8 removal. Old, obsolete column.
CERT_NBR VARCHAR(50) Y Due to packet passivity constraints, this field is marked for rev8 removal. Old obsolete column.
CERT_PRSNL_ID DOUBLE N *NOT USED*. Obsolete.
CERT_STATUS_CD DOUBLE N Reflects status of an authorization or precertification.
CERT_TYPE_CD DOUBLE N Certification Type Code (UM02). Identifies the type of certification.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COMMENT_ID DOUBLE N Comment Identifier which is stored on the LONG_TEXT table.
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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DELAY_REASON_CD DOUBLE N Delay Reason Code (UMO10). Identifies the reason for the delay.
DELAY_REASON_COMMENT_ID DOUBLE N The comment identifier for free text stored on the long_text table which represents comments for the delay reason.
DESCRIPTION VARCHAR(200) Y Describes the authorization or referral.
DISCHARGE_DT_TM DATETIME Y Authorization discharge date & time (DTP01 = 096).
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
FACILITY_CD DOUBLE N Facility code for service (NM101 = FA)
HEALTH_PLAN_ID DOUBLE N Contains the related Health Plan for this authorization row.
INTERCHANGE_ID DOUBLE N Unique service authorization transaction identifier.
LAST_UPDATE_DT_TM DATETIME Y Date/time of last update to record
PAYER_AUTH_STATUS_CD DOUBLE N Indicates the status of the payer authorization.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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.
PROVIDER_PRSNL_ID DOUBLE N The provider's personnel id (NM101 = SJ).
REFERENCE_NBR_TXT VARCHAR(100) Y The reference number for the authorization. Stored in a text format.
REJECT_REASON_CD DOUBLE N Rejection Reason Code (HCR03). Identifies the reason for the rejection.
SERVICE_BEG_DT_TM DATETIME Y Authorization beginning service date & time (DTP01 = 472).
SERVICE_END_DT_TM DATETIME Y Authorization ending service date & time (DTP01 = 472).
SERVICE_TYPE_CD DOUBLE N Marked to delete as of Rev8. Old and obsolete.
SURGICAL_DT_TM DATETIME Y Authorization surgical date & time (DTP01 = 456).
TAXONOMY_ID DOUBLE N The taxonomy code used in the authorization transaction
TOTAL_SERVICE_NBR DOUBLE Y Marked for delete in Rev8. Old and obsolete.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y 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.
X12PROVIDER_CD DOUBLE N Identifies the Provider's Role (PRV01).
X12SERVICE_TYPE_CD DOUBLE N Identifies the Service Type Code (UM03).



Relationship Detail - AUTHORIZATION_HIST


Child Column in AUTHORIZATION_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


AUTHORIZATION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Item
Definition: Stores information about an item (i.e. order) associated to an authorization.
Table Type: ACTIVITY





Column Detail - AUTHORIZATION_ITEM


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 identifies a single row on the AUTHORIZATION table to which this authorization item is associated.
AUTHORIZATION_ITEM_ID DOUBLE N Unique generated number that identifies a single row on the AUTHORIZATION_ITEM table.
AUTH_CNT DOUBLE N The number of visits, days, or treatments that are authorized by the carrier for payment.
AUTH_REMAIN_CNT DOUBLE N The remaining number of units for the item that are authorized by the carrier for payment.
AUTH_USED_CNT DOUBLE N The number of units for the item authorized by the carrier for payment that has been used.
AUTH_USED_MANUAL_ADJ_CNT DOUBLE N The manual adjustment for the used number of units that were captured as part of a different encounter or by an external system . For example, if not all of the authorizations were used at the same facility, the manual adjustment will contain the number used at a different facility.
ORDER_CATALOG_CD DOUBLE N The coded value for the order catalog for the order associated with this authorization item.
ORDER_SYNONYM_ID DOUBLE N Id of the synonym for the order associated with this authorization item.
THRESHOLD_NBR DOUBLE N The remaining number of 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. 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 - AUTHORIZATION_ITEM


Child Column in AUTHORIZATION_ITEM(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ID AUTHORIZATION AUTHORIZATION_ID
ORDER_CATALOG_CD ORDER_CATALOG CATALOG_CD
ORDER_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in AUTHORIZATION_ITEM (PK) Child Table Name Child Column Name
Children: AUTHORIZATION_ITEM_ID AUTHORIZATION_ITEM_HIST AUTHORIZATION_ITEM_ID
AUTH_ITEM_ORDER_RELTN AUTHORIZATION_ITEM_ID


AUTHORIZATION_ITEM_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Authorization Item History
Definition: Stores information about the history an item (i.e order) associated to an authorization
Table Type: ACTIVITY





Column Detail - AUTHORIZATION_ITEM_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_HIST_ID DOUBLE N Unique generated number that identifies a single row on the AUTHORIZATION_ITEM_HIST table.
AUTHORIZATION_ITEM_ID DOUBLE N Unique generated number that identifiers a single row on the AUTHORIZATION_ITEM table to which this authorization item is associated.
AUTH_CNT DOUBLE N The number of visits, days, or treatments that are authorized by the carrier for payment.
AUTH_REMAIN_CNT DOUBLE N The remaining number of units for the item that are authorized by the carrier for payment.
AUTH_USED_CNT DOUBLE N The number of units for the item authorized by the carrier for payment that has been used.
AUTH_USED_MANUAL_ADJ_CNT DOUBLE N The manual adjustment for the used number of units that were captured as part of a different encounter or by an external system . For example, if not all of the authorizations were used at the same facility, the manual adjustment will contain the number used at a different facility.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ORDER_CATALOG_CD DOUBLE N The coded vlaue for the order catalog for the order associated with this authorization item.
ORDER_SYNONYM_ID DOUBLE N Id of the synonym for the order associated with this authorization item.
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.
THRESHOLD_NBR DOUBLE N The remaining number of 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 ** 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 - AUTHORIZATION_ITEM_HIST


Child Column in AUTHORIZATION_ITEM_HIST(FK) Parent Table Name Parent Column Name
Parents: AUTHORIZATION_ITEM_ID AUTHORIZATION_ITEM AUTHORIZATION_ITEM_ID
ORDER_CATALOG_CD ORDER_CATALOG CATALOG_CD
ORDER_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID