Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
EAObjectData
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EAObjectSID | INTEGER | ? | MANDATORY | System generated ID for the ordered test. This must be a SID to link to the EA tables. |
| EAPageType | CHARACTER(14) | MANDATORY | Obtain from source object page. This field is programmatically set. | |
| ReferenceDate | CHARACTER(14) | MANDATORY | Obtain from source object page. This field is programmatically set. | |
| EACode | CHARACTER(20) | MANDATORY | FK | |
| DataValue | CHARACTER(20) | OPTIONAL | User entered value for the extended attribute. | |
| 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. |
| SortValue | CHARACTER(20) | OPTIONAL | This field will store the first 20 characters of the data value field for sort and index purposes. | |
| 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 | |
| AnswerLOINCCodeList | CHARACTER(100) | OPTIONAL | LOINC Code for the Answer(s), derived from Valueset: QuestionnaireAnswerCodes. This field may contain multiple values in a comma separated list. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Charge | EAObjectData.EAObjectSID = Charge.ChargeSID | CASCADE if EAObjectData exists |
| Questionnaire | EAObjectData.EAObjectSID = Questionnaire.QuestionnaireSID | CASCADE if EAObjectData exists |
| LabOrderTest | EAObjectData.EAObjectSID = LabOrderTest.LabOrderTestSID | CASCADE if EAObjectData exists |
| Referral | EAObjectData.EAObjectSID = Referral.ReferralSID | CASCADE if EAObjectData exists |
| Person | EAObjectData.EAObjectSID = Person.PersonID | CASCADE if EAObjectData exists |
| Ailment | EAObjectData.EAObjectSID = Ailment.AilmentSID | CASCADE if EAObjectData exists |
| ExtAttributeCode | EAObjectData.EACode = ExtAttributeCode.EACode | RESTRICT if EAObjectData exists |
| Child Table | Join Phrase | When deleting EAObjectData record... |
|---|