VIEW: SSP.SSP_MEDICALS#

Source

View Text - Preformatted

select MEDICAL_ID MEDICAL_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EVIDENCE_DATE EVIDENCE_DATE, EVIDENCE_SOURCE EVIDENCE_SOURCE, ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID, MATERNITY_ID MATERNITY_ID, MEDICAL_TYPE MEDICAL_TYPE, SELF_CERTIFICATE SELF_CERTIFICATE, PREDICTED_FITNESS_DATE PREDICTED_FITNESS_DATE, EVIDENCE_STATUS EVIDENCE_STATUS, EVIDENCE_DETAILS EVIDENCE_DETAILS, ACCEPT_LATE_EVIDENCE_FLAG ACCEPT_LATE_EVIDENCE_FLAG, REASON_FOR_LATE_EVIDENCE REASON_FOR_LATE_EVIDENCE, EVIDENCE_RECEIVED_DATE EVIDENCE_RECEIVED_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EMPLOYER_CONFIRMATION_SENT EMPLOYER_CONFIRMATION_SENT, PARTNER_NAME PARTNER_NAME, PARTNER_NI_NUMBER PARTNER_NI_NUMBER, PARTNER_ADDRESS PARTNER_ADDRESS, PARTNER_EMPLOYER_NAME_ADDRESS PARTNER_EMPLOYER_NAME_ADDRESS, BIRTH_CERTIFICATE_RECEIVED BIRTH_CERTIFICATE_RECEIVED from "SSP"."SSP_MEDICALS"

View Text - HTML Formatted

SELECT MEDICAL_ID MEDICAL_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, EVIDENCE_DATE EVIDENCE_DATE
, EVIDENCE_SOURCE EVIDENCE_SOURCE
, ABSENCE_ATTENDANCE_ID ABSENCE_ATTENDANCE_ID
, MATERNITY_ID MATERNITY_ID
, MEDICAL_TYPE MEDICAL_TYPE
, SELF_CERTIFICATE SELF_CERTIFICATE
, PREDICTED_FITNESS_DATE PREDICTED_FITNESS_DATE
, EVIDENCE_STATUS EVIDENCE_STATUS
, EVIDENCE_DETAILS EVIDENCE_DETAILS
, ACCEPT_LATE_EVIDENCE_FLAG ACCEPT_LATE_EVIDENCE_FLAG
, REASON_FOR_LATE_EVIDENCE REASON_FOR_LATE_EVIDENCE
, EVIDENCE_RECEIVED_DATE EVIDENCE_RECEIVED_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EMPLOYER_CONFIRMATION_SENT EMPLOYER_CONFIRMATION_SENT
, PARTNER_NAME PARTNER_NAME
, PARTNER_NI_NUMBER PARTNER_NI_NUMBER
, PARTNER_ADDRESS PARTNER_ADDRESS
, PARTNER_EMPLOYER_NAME_ADDRESS PARTNER_EMPLOYER_NAME_ADDRESS
, BIRTH_CERTIFICATE_RECEIVED BIRTH_CERTIFICATE_RECEIVED
FROM "SSP"."SSP_MEDICALS"