Symphony Claims PTD
Symphony Claims PTD delivers Patient Transactional Data (PTD), which contain claims and a detailed description of all claim activity, with restatements when claims are completed/closed. Different types of claims include:
- Surgical
- Diagnosis
- Market Prescription
- Nonmarket Prescription
- Procedures
This information is used to understand market activity for disease states and to set guidance for different aspects of pharmaceutical business, for example, market potential and targeting.
| Nitro Table | symphony_claims_demographic_ods__c | symphony_claims_diagnonsis_code_ods__c | symphony_claims_diagnonsis_ods__c | symphony_claims_market_rx_ods__c | symphony_claims_patient_ods__c | symphony_claims_plan_ods__c | symphony_claims_procedure_code_ods__c | symphony_claims_procedure_ods__c | symphony_claims_product_ods__c | symphony_claims_reject_code_ods__c | symphony_claims_surgical_code_ods__c | symphony_claims_surgical_ods__c | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Nitro Table Fields | Address__V | Diagnosis_code__v | Claim_id__v | Claim_Status__V | Patient_Id__V | Admin_Name__V | Procedure_code__v | Attending_Practitioner_Id__V | Bb_Usc_Code__V | Reject_Code__V | Surgical_code__v | Claim_id__v |
|
| City__V | Diagnosis_description__v | Claim_type__v | Concomitant_Flag__V | Patient_birth_year__v | Admin_Type__V | Procedure_description__v | Charge_Amount__V | Bb_Usc_Name__V | Reject_description__v | Surgical_description__v | Claim_type__v | ||
| Dea_Number__V |
|
Diagnosis_code__v | Copay_30__V | Patient_gender__v | National_Insurer_Name__V |
|
Claim_Id__V | Bgi__V |
|
|
Patient_Id__V |
|
|
| First_Name__V | Diagnosis_Type_Code__v | Daw_Code__V | Patient_zip3__v | National_Type__V | Claim_Line_Item__V | Drug_Form__V | Place_of_Service__V | ||||||
| Last_Name__V |
|
Patinet_id__v | Days_Supply__V | patient_state__v | Organization_Name__V |
|
Claim_Type__V | Drug_Generic_Name__V |
|
|
Plan_Type__V |
|
|
| Me_Number__V | Practitioner_Id__V | Days_Till_Next_Fill__V | Organization_Type__V | Drug_Id__V | Drug_Id__V | Practitioner_Id__V | |||||||
| No_Contact_Flag__V |
|
Practitioner_role_code__v | Drug_Id__V |
|
Payment_Type__V |
|
Operating_Practitioner_Id__V | Drug_Name__V |
|
|
Practitioner_type_code__v |
|
|
| Npi__V | service_date__v | Group_Numeric__V | Plan_Id__V | Ordering_Practitioner_Id__V | Drug_Strength__V | Surgical_procedure_code__v | |||||||
| Opt_Out_Ind__V |
|
|
New_To_Product__V |
|
Plan_Name__V |
|
Patient_Id__V | Manufacturer__V |
|
|
|
||
| Physician_Id__V | Patient_Id__V | Plan_Subtype__V | Place_Of_Service__V | Ndc11__V | |||||||||
| Practitioner_Id__V |
|
|
Patient_Out_Of_Pocket__V |
|
Plan_Type__V |
|
Plan_Type__V | Package_Description__V |
|
|
|
||
| Specialty_Code__V | Patient_Pay__V | Plan_Type_Description__V | Practitioner_Id__V | Package_Size__V | |||||||||
| Specialty_Description__V |
|
|
Pharmacy_Zip3__V |
|
Regional_Name__V |
|
Practitioner_Role_Code__V | Year of Ndc_Start_Date__V |
|
|
|
|
|
| State__V | Plan_Id__V | Regional_Type__V | Procedure_Code__V | ||||||||||
| Year of Opt_Out_Date__V |
|
|
Plan_Pay__V |
|
|
|
Referring_Practitioner_Id__V |
|
|
|
|
||
| Zip__V | Practitioner_Id__V | Rendering_Practitioner_Id__V | |||||||||||
| Claim_Id__V |
|
|
Ptd_Final_Claim__V |
|
|
|
Units_Administered__V |
|
|
|
|
||
| Quantity__V | Year of Procedure_Date__V | ||||||||||||
|
|
|
Refill_Athrz__V |
|
|
|
|
|
|
|
||||
| Refill_Code__V | |||||||||||||
|
|
|
Reject_Code__V |
|
|
|
|
|
|
|
||||
| Reversal_Lag__V | |||||||||||||
|
|
|
Rx_Numeric__V |
|
|
|
|
|
|
|
||||
| Secondary_Group_Numeric__V | |||||||||||||
|
|
|
Secondary_Plan_Id__V |
|
|
|
|
|
|
|
|
|||
| Secondary_Plan_Pay__V | |||||||||||||
|
|
|
Sequence_Numeric__V |
|
|
|
|
|
|
|
|
|||
| Source_Of_Business__V | |||||||||||||
|
|
|
Year of Rx_Fill_Date__V |
|
|
|
|
|
|
|
|
|
