[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | ACT assessment details of persons with Reporting Year, Test Date and Test Type |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PEA. PE_PERSON_ID PERSON_IDENTIFIER
, ACTAS.REPORTING_YEAR REPORTING_YEAR
, ACTAS.ACT_IDENTIFIER ACT_IDENTIFIER
, ACTAS.TEST_TYPE TEST_TYPE
, ACTAS.TEST_DATE_TXT TEST_DATE_TXT
, ACTAS.ACT_BATCH_ID ACT_BATCH_ID
, ACTAS.INTERFACE_TRANSFER_DATE INTERFACE_TRANSFER_DATE
, ACTAS.LAST_NAME LAST_NAME
, ACTAS.FIRST_NAME FIRST_NAME
, ACTAS.MIDDLE_INITIAL MIDDLE_INITIAL
, ACTAS.GENDER GENDER
, ACTAS.DATE_OF_BIRTH_TXT DATE_OF_BIRTH_TXT
, ACTAS.STREET_ADDRESS STREET_ADDRESS
, ACTAS.CITY CITY
, ACTAS.STATE_CODE STATE_CODE
, ACTAS.STATE_ABBREVIATION STATE_ABBREVIATION
, ACTAS.ZIP_CODE ZIP_CODE
, ACTAS.HOME_PHONE HOME_PHONE
, ACTAS.GRADE_LEVEL GRADE_LEVEL
, ACTAS.HIGH_SCHOOL_CODE HIGH_SCHOOL_CODE
, ACTAS.HIGH_SCHOOL_AVERAGE HIGH_SCHOOL_AVERAGE
, ACTAS.HIGH_SCHOOL_GRADUATION HIGH_SCHOOL_GRADUATION
, ACTAS.CORRECTED_REPORT_IND CORRECTED_REPORT_INDICATOR
, ACTAS.SUM_OF_SCALE_SCORES SUM_OF_SCALE_SCORES
, ACTAS.COLLEGE_CHOICE COLLEGE_CHOICE
, ACTAS.COLLEGE_CODE COLLEGE_CODE
, ACTAS.LOCAL_IDENTIFIER LOCAL_IDENTIFIER
, ACTAS.RELEASE RELEASE
, ACTAS.NORMS_TYPE NORMS_TYPE
, ACTAS.CREATED_BY CREATED_BY
, ACTAS.CREATION_DATE CREATION_DATE
, ACTAS.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_AD_ACT_ASSESSMENTS ACTAS
, IGS_PE_ALT_PERS_ID PEA
WHERE DECODE(SUBSTR(ACTAS.ACT_IDENTIFIER
, 1
, 1)
, '-'
, SUBSTR(ACTAS.ACT_IDENTIFIER
, 2)
, ACTAS.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+)
AND PEA.PERSON_ID_TYPE(+) = 'ACTID' WITH READ ONLY