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