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 |