VIEW: APPS.IGSFV_AD_ACT_ASSESSMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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