Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ExtAttributeCode
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EACode | CHARACTER(20) | MANDATORY | User set code for the extended attribute. | |
| EADataType | CHARACTER(1) | MANDATORY | User set data type of the extended attribute. | |
| EAFormat | CHARACTER(20) | MANDATORY | User set field format mask for the extended attribute. | |
| EALabel | CHARACTER(80) | OPTIONAL | User set label to display for the extended attribute. | |
| EASource | CHARACTER(1) | OPTIONAL | System entered. Source code. Determines the access level of the field. Field is supported by the lookup types:[DataSource]. Values are defined in the LookupCode table for the above lookup types. | |
| LookupType | CHARACTER(20) | OPTIONAL | Lookup Type (if any) associated to the field. | |
| 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. |
| BillableIndicator | CHARACTER(1) | ? | OPTIONAL | User entered indicator to determine if the code will be used to construct claim form fields. This will allow the code to be used in the insurance billing process. Supported by confirmation lookup type. |
| EAPageType | CHARACTER(14) | OPTIONAL | System supplied extended attribute page type. Examples: Patient Ailment Referral Lab | |
| EASearchType | CHAR(15) | OPTIONAL | User Selected Search Type for Extended Information fields. EASearchTypes are defined in the LookupCode table for the Lookup Type "SearchType". Codes for LookupType "SearchType" are not user definable. Possible Values: Address , Company , Diagnosis , FinanceCenter , Insurance , Person , Procedure , Provider , RefDoctor , ServiceCenter | |
| EASearchField | CHAR(15) | OPTIONAL | User Selected Field for Extended Information pages. EASearchFields are defined by multiple Lookup Types that are determined by the EASearchType. The Lookup Codes are not user definable. | |
| GroupLOINCCode | CHARACTER(10) | OPTIONAL | LOINC Code for the Group the Question is reported under, derived from Valueset: QuestionnaireItemType | |
| QuestionLOINCCode | CHARACTER(10) | OPTIONAL | LOINC Code for the Question, derived from Valueset: QuestionnaireItemType |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting ExtAttributeCode record... |
|---|---|---|
| EAObjectData | EAObjectData.EACode = ExtAttributeCode.EACode | RESTRICT if EAObjectData exists |