AP_CLAIM_4

Description:

The AP_CLAIM_4 table contains one record for each claim in the managed care system's AP Claims module.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier for the claim record.
2	TOT_ADDL_ADJ	NUMERIC	No
	Stores the total additional adjustments for the claim.
3	AP_CLAIM_IMPORT_SOURCE_C_NAME	VARCHAR	No
	Used to define the type of source a claim is imported from to drive reporting on the different use cases a single workflow type may have. May contain organization-specific values: No Category Entries: Historical System Repricing Source Delegated Payer Clearinghouse Other Internal Source Other External Source
4	SOURCE_GROUP_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
5	SERVICE_DATE_FROM_LINE_YN	VARCHAR	No
	Indicates whether the service date was received at the header level, or was determined based on service lines. May contain organization-specific values: No Category Entries: No Yes
6	NCH_CLAIM_TYPE_C_NAME	VARCHAR	No
	The National Claims History (NCH) code indicating the type of claim submitted. May contain organization-specific values: No Category Entries: Home Health Agency (HHA) claim Non swing bed Skilled Nursing Facility (SNF) claim Swing bed Skilled Nursing Facility (SNF) claim Hospital Outpatient claim Hospice claim Inpatient claim Inpatient Full Encounter claim Local carrier non-durable medical equipment, prosthetics, orthotics, and supplies (DMEPOS) claim Local carrier durable medical equipment, prosthetics, orthotics, and supplies (DMEPOS) claim Durable medical equipment regional carrier (DMERC); non-DMEPOS claim Durable medical equipment regional carrier (DMERC); DMEPOS claim
7	PAID_CLM_FILE_INTEREST_AMT	NUMERIC	No
	The total interest amount from the file for an externally paid claim.
8	PAID_CLM_FILE_PENALTY_AMT	NUMERIC	No
	The total penalty amount from the file for an externally paid claim.