Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Holds a person's Immunization Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT IM.ROWID ROW_ID
, IM.IMMU_DETAILS_ID
, IM.PERSON_ID
, IM.IMMUNIZATION_CODE
, C1.MEANING IMMUNIZATION_M
, IM.STATUS_CODE
, C2.MEANING STATUS_M
, IM.START_DATE
, IM.END_DATE
, IM.CREATED_BY
, IM.CREATION_DATE
, IM.LAST_UPDATED_BY
, IM.LAST_UPDATE_DATE
, IM.LAST_UPDATE_LOGIN
, IM.ATTRIBUTE_CATEGORY
, IM.ATTRIBUTE1
, IM.ATTRIBUTE2
, IM.ATTRIBUTE3
, IM.ATTRIBUTE4
, IM.ATTRIBUTE5
, IM.ATTRIBUTE6
, IM.ATTRIBUTE7
, IM.ATTRIBUTE8
, IM.ATTRIBUTE9
, IM.ATTRIBUTE10
, IM.ATTRIBUTE11
, IM.ATTRIBUTE12
, IM.ATTRIBUTE13
, IM.ATTRIBUTE14
, IM.ATTRIBUTE15
, IM.ATTRIBUTE16
, IM.ATTRIBUTE17
, IM.ATTRIBUTE18
, IM.ATTRIBUTE19
, IM.ATTRIBUTE20
FROM IGS_PE_IMMU_DTLS IM
, IGS_LOOKUP_VALUES C1
, IGS_LOOKUP_VALUES C2
WHERE IM.IMMUNIZATION_CODE = C1.LOOKUP_CODE
AND IM.STATUS_CODE = C2.LOOKUP_CODE
AND C1.LOOKUP_TYPE = 'PE_IMM_TYPE'
AND C2.LOOKUP_TYPE = 'PE_IMM_STATUS'