Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PlanClaimLineItemData
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PlanID | INTEGER | ? | MANDATORY | FK |
| PolicyNumber | CHARACTER(20) | MANDATORY | FK | |
| ClaimSID | INTEGER | ? | MANDATORY | FK |
| LineItem | INTEGER | 0 | MANDATORY | System generated next sequential line item number for the plan claim. |
| BilledCode | CHARACTER(10) | MANDATORY | Code that the associated claim charges were billed under. | |
| CurrentStatus | CHARACTER(8) | OPTIONAL | Policy claim charge current status. | |
| CollapseMode | CHARACTER(2) | MANDATORY | System defined. User entered Collapse mode code. Field is supported by the lookup types:[FormCollapseMode]. Values are defined in the LookupCode table for the above lookup types. | |
| PerformingProviderID | INTEGER | ? | OPTIONAL | System set attending staff ID for the charges associated with this line item. |
| SupervisingProviderID | INTEGER | ? | OPTIONAL | System set supervising staff ID for the charges associated with this line item. |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | System set amount. |
| AdjAmount | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all adjustments on the charge(s) billed for this line item as of claim generation. |
| AdjErrAmount | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Error Adjustments on the charge(s) billed for this line item as of claim generation. An error adjustment is determined by the Error Correction flag being set to "Y" on the General Ledger Account Code. Used by insurance billing's masterfields. The Error Correction flag is NOT SUPPORTED. |
| AdjTaxAmount | DECIMAL(10,2) | 0 | OPTIONAL | NOT SUPPORTED. |
| ApprovedAmount | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Approved amounts on the charge(s) billed for this line item. Used by insurance billing's masterfields. |
| PatReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Guarantor receipts on the charge(s) billed for this line item as of claim generation. Used by insurance billing's masterfields. |
| InsReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Insurance receipts on the charge(s) billed for this line item as of claim generation. Used by insurance billing's masterfields. |
| TaxAmount | DECIMAL(10,2) | OPTIONAL | NOT SUPPORTED. The sum of all tax amounts on the charge(s) billed for this line item as of claim generation. | |
| FromDate | DATE | OPTIONAL | System set from service date. | |
| ToDate | DATE | OPTIONAL | System set to service date. | |
| PostDate | DATE | OPTIONAL | System set post date. | |
| POSCode | CHARACTER(3) | OPTIONAL | System set pos code. | |
| TOSCode | CHARACTER(3) | OPTIONAL | System set tos code. | |
| Units | DECIMAL(10,2) | OPTIONAL | System set units. | |
| UnitsPlusBase | DECIMAL(10,2) | OPTIONAL | System set anesthesia units plus base. | |
| Duration | INTEGER | 0 | OPTIONAL | System set duration in minutes. |
| ProcedureCode | CHARACTER(10) | OPTIONAL | System set procedure code. | |
| Modifier | CHARACTER(11) | OPTIONAL | System set modifier code. | |
| DiagXref | CHARACTER(10) | OPTIONAL | System set diagnosis cross reference list. | |
| DiagCode | CHARACTER(10) | OPTIONAL | System set diagnosis code. | |
| ClaimDiagNumber | CHARACTER(20) | OPTIONAL | ||
| PerformingProviderCode | CHARACTER(6) | OPTIONAL | System set performing provider code. | |
| PrimaryInsReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Primary Insurance receipts on the charge(s) billed for this line item as of claim generation. Used by insurance billing's masterfields. |
| FamilyPlanning | CHARACTER(1) | OPTIONAL | Indicates if the procedure is due to family planning requirements. Validate through the confirmation lookup type: Possible values: (Y)es (N)o | |
| EPSDT | CHAR(1) | OPTIONAL | Indicates if the procedure is due to screening requirements. Validate through the confirmation lookup type: Possible values: (Y)es (N)o | |
| PerformProviderAltID | CHARACTER(20) | OPTIONAL | Alternate ID of the performing provider for this line item. | |
| UBRevenueCode | CHARACTER(6) | OPTIONAL | System set UB revenue code. | |
| UBRevenueDesc | CHARACTER(60) | OPTIONAL | System set UB revenue code description. | |
| EPSDTReferral | CHAR(2) | OPTIONAL | Records the EPSDT Referral value from charge posting. Validated through the EPSDTRefCode lookup. | |
| ModifierNoCrossRef | CHAR(11) | OPTIONAL | System set modifier codes that aren't cross referenced. | |
| InsReceiptsByPayer | DECIMAL(10,2) | 0 | OPTIONAL | This array holds all the denormalized payers receipts posted to the charge(s) billed for this line item as of claim generation. Primary's will be stored in the first location, secondary in the second, and so on. Used by insurance billing's masterfields. |
| ProcedureCodeDesc | CHAR(100) | Set_To_Empty_String | OPTIONAL | Stores the procedure description for insurance billing's masterfields. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PlanClaimData | PlanClaimLineItemData.PlanID = PlanClaimData.PlanID and PlanClaimLineItemData.PolicyNumber = PlanClaimData.PolicyNumber and PlanClaimLineItemData.ClaimSID = PlanClaimData.ClaimSID |
CASCADE if PlanClaimLineItemData exists |
| PlanClaimLineItem | PlanClaimLineItemData.PlanID = PlanClaimLineItem.PlanID and PlanClaimLineItemData.PolicyNumber = PlanClaimLineItem.PolicyNumber and PlanClaimLineItemData.ClaimSID = PlanClaimLineItem.ClaimSID and PlanClaimLineItemData.LineItem = PlanClaimLineItem.LineItem |
CASCADE if PlanClaimLineItemData exists |
| Child Table | Join Phrase | When deleting PlanClaimLineItemData record... |
|---|