Skip to main content

input_layer__medical_claim

Medical claim lines exactly as received, before normalization or encounter grouping. Codes, dates and identifiers are in the source's own form. This is the table to query when a downstream value is surprising and you need to see what arrived.

At a glance​

Schemadax_input_layer
Tableinput_layer__medical_claim
LayerInput Layer
Object typeview
Columns148
Grainclaim_id, claim_line_number, data_source
Tagsinput_layer

Columns​

ColumnTypeKeyConstraintsDescription
claim_idvarcharPK——
claim_line_numberintegerPK——
claim_typevarchar——
person_idvarchar——
member_idvarchar——
payervarchar——
planvarchar——
claim_start_datedate——
claim_end_datedate——
claim_line_start_datedate——
claim_line_end_datedate——
admission_datedate——
discharge_datedate——
admit_source_codevarchar——
admit_type_codevarchar——
discharge_disposition_codevarchar——
place_of_service_codevarchar——
bill_type_codevarchar——
drg_code_typevarchar——
drg_codevarchar——
revenue_center_codevarchar——
service_unit_quantitynumber——
hcpcs_codevarchar——
hcpcs_modifier_1varchar——
hcpcs_modifier_2varchar——
hcpcs_modifier_3varchar——
hcpcs_modifier_4varchar——
hcpcs_modifier_5varchar——
rendering_npivarchar——
rendering_tinvarchar——
billing_npivarchar——
billing_tinvarchar——
facility_npivarchar——
paid_datedate——
paid_amountfloat——
allowed_amountfloat——
charge_amountfloat——
coinsurance_amountfloat——
copayment_amountfloat——
deductible_amountfloat——
total_cost_amountfloat——
diagnosis_code_typevarchar——
diagnosis_code_1varchar——
diagnosis_code_2varchar——
diagnosis_code_3varchar——
diagnosis_code_4varchar——
diagnosis_code_5varchar——
diagnosis_code_6varchar——
diagnosis_code_7varchar——
diagnosis_code_8varchar——
diagnosis_code_9varchar——
diagnosis_code_10varchar——
diagnosis_code_11varchar——
diagnosis_code_12varchar——
diagnosis_code_13varchar——
diagnosis_code_14varchar——
diagnosis_code_15varchar——
diagnosis_code_16varchar——
diagnosis_code_17varchar——
diagnosis_code_18varchar——
diagnosis_code_19varchar——
diagnosis_code_20varchar——
diagnosis_code_21varchar——
diagnosis_code_22varchar——
diagnosis_code_23varchar——
diagnosis_code_24varchar——
diagnosis_code_25varchar——
diagnosis_poa_1varchar——
diagnosis_poa_2varchar——
diagnosis_poa_3varchar——
diagnosis_poa_4varchar——
diagnosis_poa_5varchar——
diagnosis_poa_6varchar——
diagnosis_poa_7varchar——
diagnosis_poa_8varchar——
diagnosis_poa_9varchar——
diagnosis_poa_10varchar——
diagnosis_poa_11varchar——
diagnosis_poa_12varchar——
diagnosis_poa_13varchar——
diagnosis_poa_14varchar——
diagnosis_poa_15varchar——
diagnosis_poa_16varchar——
diagnosis_poa_17varchar——
diagnosis_poa_18varchar——
diagnosis_poa_19varchar——
diagnosis_poa_20varchar——
diagnosis_poa_21varchar——
diagnosis_poa_22varchar——
diagnosis_poa_23varchar——
diagnosis_poa_24varchar——
diagnosis_poa_25varchar——
procedure_code_typevarchar——
procedure_code_1varchar——
procedure_code_2varchar——
procedure_code_3varchar——
procedure_code_4varchar——
procedure_code_5varchar——
procedure_code_6varchar——
procedure_code_7varchar——
procedure_code_8varchar——
procedure_code_9varchar——
procedure_code_10varchar——
procedure_code_11varchar——
procedure_code_12varchar——
procedure_code_13varchar——
procedure_code_14varchar——
procedure_code_15varchar——
procedure_code_16varchar——
procedure_code_17varchar——
procedure_code_18varchar——
procedure_code_19varchar——
procedure_code_20varchar——
procedure_code_21varchar——
procedure_code_22varchar——
procedure_code_23varchar——
procedure_code_24varchar——
procedure_code_25varchar——
procedure_date_1date——
procedure_date_2date——
procedure_date_3date——
procedure_date_4date——
procedure_date_5date——
procedure_date_6date——
procedure_date_7date——
procedure_date_8date——
procedure_date_9date——
procedure_date_10date——
procedure_date_11date——
procedure_date_12date——
procedure_date_13date——
procedure_date_14date——
procedure_date_15date——
procedure_date_16date——
procedure_date_17date——
procedure_date_18date——
procedure_date_19date——
procedure_date_20date——
procedure_date_21date——
procedure_date_22date——
procedure_date_23date——
procedure_date_24date——
procedure_date_25date——
in_network_flaginteger——
file_namevarchar——
file_datedate——
ingest_datetimetimestamp——
data_sourcevarcharPK——

Querying​

select *
from dax_input_layer.input_layer__medical_claim
limit 100;
Last updated on