Product: | IGF - Financial Aid |
---|---|
Description: | View used for reporting the Student tag in the outbound XML for Pell |
Implementation/DBA Data: | APPS.IGF_GR_REP_STDNT_V |
SELECT TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT
, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT
, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT
, BASE_ID
, S_SSN
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_DATE_OF_BIRTH
, S_LAST_NAME
, S_CHG_SSN
, DRIVER_LIC_STATE
, DRIVER_LIC_NUMBER
, TO_CHAR( S_CHG_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_CHG_DATE_OF_BIRTH
, FIRST_NAME
, MIDDLE_NAME
, S_CHG_LAST_NAME
, CITZN_STATUS_CODE
, NOTE_MESSAGE
, PERMT_ADDR_FOREIGN_FLAG
, ADDR_TYPE_CODE
, TRIM(PERMT_ADDR_LINE_1)
, TRIM(PERMT_ADDR_LINE_2)
, TRIM(PERMT_ADDR_LINE_3)
, TRIM(PERMT_ADDR_CITY)
, TRIM(PERMT_ADDR_STATE_CODE)
, TRIM(PERMT_ADDR_POST_CODE)
, TRIM(PERMT_ADDR_COUNTY)
, TRIM(PERMT_ADDR_COUNTRY)
, TRIM(PHONE_NUMBER_1)
, TRIM(EMAIL_ADDRESS)
FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, S_SSN
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, S_LAST_NAME
, S_CHG_SSN
, DRIVER_LIC_STATE
, DRIVER_LIC_NUMBER
, TO_CHAR( S_CHG_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, FIRST_NAME
, MIDDLE_NAME
, S_CHG_LAST_NAME
, CITZN_STATUS_CODE
, NOTE_MESSAGE
, PERMT_ADDR_FOREIGN_FLAG
, ADDR_TYPE_CODE
, TRIM(PERMT_ADDR_LINE_1)
, TRIM(PERMT_ADDR_LINE_2)
, TRIM(PERMT_ADDR_LINE_3)
, TRIM(PERMT_ADDR_CITY)
, TRIM(PERMT_ADDR_STATE_CODE)
, TRIM(PERMT_ADDR_POST_CODE)
, TRIM(PERMT_ADDR_COUNTY)
, TRIM(PERMT_ADDR_COUNTRY)
, TRIM(PHONE_NUMBER_1)
, TRIM(EMAIL_ADDRESS)