AP_CLM_PX_AMBU_CERT_RM
Description:
This table extracts the ambulance certificate condition code(s) sent at the service level for AP Claim service lines.
This data should be accessed by joining to AP_CLM_PX_AMBU_CERT from AP_CLAIM_PROC_IDS on TX_ID and then to this table on TX_ID and LINE=GROUP_LINE. To report on claim service lines related to Cost Sharing Reduction (CSR), instead join through AP_CLAIM_PROC_IDS_CSR on TX_ID.

Primary Key
Column Name Ordinal Position
TX_ID 1
GROUP_LINE 2
VALUE_LINE 3

Column Information
Name Type Discontinued?
1 TX_ID NUMERIC No
The unique ID of the AP Claim procedure transaction.
2 GROUP_LINE INTEGER No
The line number of the associated ambulance certificate condition code(s) in this AP Claim procedure transaction record. Together with TX_ID, this forms the foreign key to the AP_CLM_PX_AMBU_CERT.
3 VALUE_LINE INTEGER No
The line number of one of the multiple ambulance certificate condition code(s) that are associated with the AP Claim procedure transaction records from the AP_CLM_PX_AMBU_CERT table.
4 AMBU_CERT_COND_C_NAME VARCHAR No
Stores an ambulance certificate condition code category ID.
May contain organization-specific values: No
Category Entries:
Patient is confined to a bed or chair
Transportation was to the Nearest Facility
Admitted to a Hospital
Bed Confined Before the Ambulance Service
Bed Confined After the Ambulance Service
Moved by Stretcher
Unconscious or in Shock
Transported in an Emergency Situation
Physically Restrained
Visible Hemorrhaging
Ambulance Service was Medically Necessary