Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PlanClaimStatus
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PlanID | INTEGER | ? | MANDATORY | FK - From PlanClaim |
| PolicyNumber | CHARACTER(20) | MANDATORY | FK - From PlanClaim | |
| ClaimSID | INTEGER | ? | MANDATORY | FK - From PlanClaim |
| StatusCount | INTEGER | 0 | MANDATORY | System generated count for each planclaim |
| ReportType | CHAR(3) | OPTIONAL | MH9: Must be 4, 5, 10, or 11 | |
| StatusSource | CHARACTER(5) | OPTIONAL | "WebMD" or Payer ID | |
| StatusDateStamp | CHARACTER(14) | OPTIONAL | PS7/WS3/CE3: Process Datestamp | |
| StatusCategory | CHARACTER(5) | OPTIONAL | PS6: Status Category Code | |
| ClaimStatus | CHARACTER(10) | OPTIONAL | WS7/PS8: Claim Status | |
| AmountPaid | DECIMAL(10,2) | OPTIONAL | PS9 (RPT10&11) | |
| PayerClaimID | CHARACTER(30) | OPTIONAL | Payer Reference Number for Claim | |
| ErrorFieldData | CHARACTER(80) | OPTIONAL | CE7/PS14: Data in Error | |
| ErrorField | CHARACTER(14 | OPTIONAL | CE8: Error Field | |
| ErrorFieldName | CHARACTER(30) | OPTIONAL | CE9: Field Name | |
| ErrorSequence | INTEGER | 0 | OPTIONAL | |
| ErrorMessage | CHARACTER(255) | OPTIONAL | CE11/PS15: Error/Status Message | |
| ErrorRejectReason | CHARACTER(10) | OPTIONAL | CE12: Reject Reason Code | |
| ErrorLevel | CHARACTER(2) | OPTIONAL | CE13: Error Level (1 or 2) | |
| SplitClaim | INTEGER | 0 | OPTIONAL | PS20: Split Claim Indicator |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| FileArchiveSID | INTEGER | ? | OPTIONAL | FK - from Medman.EMCReportFile table |
| ClearinghouseFileRef | CHAR(30) | OPTIONAL | CI5: File tracking number assigned by the clearinghouse | |
| ClearinghouseClaimRef | CHAR(20) | OPTIONAL | CI6: Claim ID assigned by the clearinghouse | |
| DueDate | DATE | OPTIONAL | RI13:Request for information due date (RPT10&11) | |
| PayerPhone | CHAR(15) | OPTIONAL | RI17:Payer Phone Number (RPT10&11) | |
| PayerContact | CHAR(60) | OPTIONAL | RI18:Payer Contact (RPT10&11) | |
| PayerAddress1 | CHAR(55) | OPTIONAL | RI19:Payer Response Address 1 (RPT10&11) | |
| PayerAddress2 | CHAR(55) | OPTIONAL | RI20:Payer Response Address 2 (RPT10&11) | |
| PayerCity | CHAR(30) | OPTIONAL | RI21:Payer Response City (RPT10&11) | |
| PayerState | CHAR(2) | OPTIONAL | RI22:Payer Response State Code (RPT10&11) | |
| PayerZip | CHAR(15) | OPTIONAL | RI23:Payer Response Postal Code (RPT10&11) | |
| PayerFileID | CHAR(25) | OPTIONAL | RI16:File ID from the payer's report. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PlanClaim | PlanClaimStatus.PlanID = PlanClaim.PlanID and PlanClaimStatus.PolicyNumber = PlanClaim.PolicyNumber and PlanClaimStatus.ClaimSID = PlanClaim.ClaimSID |
CASCADE if PlanClaimStatus exists |
| Child Table | Join Phrase | When deleting PlanClaimStatus record... |
|---|