Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Procedure
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ProcedureCode | CHARACTER(10) | MANDATORY | Procedure code which represents a procedure performed. User entered. | |
| Class | CHARACTER(6) | MANDATORY | User selected procedure class code. Procedure class codes are defined in the LookupCode table for the lookup type 'ProcedureClass'. Codes for the lookup type 'ProcedureClass' are user definable. | |
| Description | CHARACTER(60) | MANDATORY | Description for the procedure code. User entered. | |
| Sex | CHARACTER(1) | Gender_Class | MANDATORY | User selected sex. Sex codes are defined in the LookupCode table for the lookup type 'GenderClass'. Codes for the lookup type 'GenderClass' are not user definable. Acceptable values are (M)ale only, (F)emale only, or (B)oth. |
| Visit | CHARACTER(1) | MANDATORY | The visit flag indicates if the procedure must be part of an encounter with the provider. Possible values are (Y)es or (N)o. | |
| UBCode | CHARACTER(6) | OPTIONAL | UB Code for the procedure code. User selected. | |
| TOSCode | CHARACTER(3) | MANDATORY | Type of service code for the procedure. User selected. | |
| DepartmentCode | CHARACTER(3) | OPTIONAL | Department code for the procedure. User selected. | |
| CertNumber | CHARACTER(3) | OPTIONAL | User entered certification number for the procedure. Certification numbers are defined in the LookupCode table for the lookup type 'CertNumber'. Codes for the lookup type 'CertNumber' are not user definable. Certification numbers are stored as character. | |
| PostMethod | CHARACTER(2) | MANDATORY | User selected post method. Acceptable values are (S)tandard, (A)nesthesia, (E)nteral, (P)arenteral, (M)onthly Rental, (D)aily Rental, (O)xygen, (T)ime, or (I)nventory Units. | |
| PostFactor | DECIMAL(10,2) | OPTIONAL | Post factor which adjusts amount of charge for the procedure. User entered. | |
| EMCBillable | CHARACTER(1) | MANDATORY | EMC billable indicator is set to (Y)es if the procedure code may be billed electronically, (N)o otherwise. | |
| Justification | CHARACTER(1) | OPTIONAL | Justification indicator is set to (Y)es if the procedure code may be billed but requres justification, (N)o otherwise. | |
| CollapseMode | CHARACTER(2) | OPTIONAL | System defined. User entered collapse mode. Validated by the mentioned lookup type. Field is supported by the lookup types:[ProcCollapseMode]. Values are defined in the LookupCode table for the above lookup types. | |
| UBSortPriority | CHARACTER(1) | OPTIONAL | User entered sort priority for the procedure. Valid values are 1 - 9 and stored as character. | |
| GLSubAcct | CHARACTER(3) | OPTIONAL | User entered general ledger sub account number. The sub-account is 3 characters. | |
| Taxable | CHARACTER(1) | N | MANDATORY | User enters taxable code to indicate the procedure code is taxable. Taxable codes are defined in the LookupCode table for the lookup type 'Confirmation'. Codes for the lookup type 'Confirmation' are not user definable. Acceptable values are (Y)es and (N)o. |
| ValidateDiagStatus | CHARACTER(1) | MANDATORY | System defined. User set mode of procedure/diagnosis validation. Field is supported by the lookup types:[ProcDiagValidate]. Values are defined in the LookupCode table for the above lookup types. | |
| PlanRejectStatus | CHARACTER(1) | MANDATORY | User set mode which determines the status of insurance plan rejections. Possible values are: (A) - Active , (I) - Inactive Codes are validated by the lookup type ProcPlanReject. | |
| Keywords | CHARACTER(60) | OPTIONAL | User entered keywords which may be used to locate a procedure code. | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the procedure code. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| 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. |
| BillingClass | CHARACTER(6) | OPTIONAL | User entered. The billing class of the procedure will determine how the procedure is handled during the billing process. Field is supported by the lookup types:[ProcBillingClass]. Values are defined in the LookupCode table for the above lookup types. | |
| EAPageSID | INTEGER | ? | OPTIONAL | System generated identifier. Use the General Sequence to obtain the SID. |
| ConcurrencyExempt | LOGICAL | Logical_False | OPTIONAL | When PostMethod is 'A', and ConcurrencyExempt is N, Anesthesia concurrency numbers are tracked. |
| MUQualifyingVisit | LOGICAL | Logical_False | OPTIONAL | Marks the procedure as indicating a face to face visit i.e. MU qualifying visit. |
| VisitType | CHAR(4) | Set_To_Empty_String | OPTIONAL | System defined. Field is supported by the lookup types:[ProcedureVisitType]. Values are defined in the LookupCode table for the above lookup types. |
| UDSQualifyingVisit | LOGICAL | OPTIONAL | UDS Qualifying Visit flag. | |
| StartDate | DATE | OPTIONAL | Date the procedure became effective. | |
| EndDate | DATE | OPTIONAL | Date the procedure is no longer effective. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Department | Procedure.DepartmentCode = Department.DepartmentCode | RESTRICT if Procedure exists |
| Child Table | Join Phrase | When deleting Procedure record... |
|---|---|---|
| DocumentInterpretation | DocumentInterpretation.ProcedureCode = Procedure.ProcedureCode | SET NULL if DocumentInterpretation exists |
| PatientOMOrderLineItem | PatientOMOrderLineItem.ProcedureCode = Procedure.ProcedureCode | RESTRICT if PatientOMOrderLineItem exists |
| PatientVacDose | PatientVacDose.ChargeProcedureCode = Procedure.ProcedureCode | SET NULL if PatientVacDose exists |
| Vaccine | Vaccine.DefaultProcedureCode = Procedure.ProcedureCode | SET NULL if Vaccine exists |
| WorkersCompProcedure | WorkersCompProcedure.ProcedureCode = Procedure.ProcedureCode | RESTRICT if WorkersCompProcedure exists |
| ReferralTreatmentResult | ReferralTreatmentResult.TreatmentCode = Procedure.ProcedureCode | RESTRICT if ReferralTreatmentResult exists |
| ReferralTreatmentPlan | ReferralTreatmentPlan.TreatmentCode = Procedure.ProcedureCode | RESTRICT if ReferralTreatmentPlan exists |
| AilmentProcedure | AilmentProcedure.ProcedureCode = Procedure.ProcedureCode | RESTRICT if AilmentProcedure exists |
| ProcedureEvent | ProcedureEvent.ProcedureCode = Procedure.ProcedureCode | RESTRICT if ProcedureEvent exists |