Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_REP_PELL_V |
SELECT TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, AWARD_ID
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, AWARD_AMT
, NOTE_MESSAGE
, COA_AMT
, LOW_TUTION_FEE
, DECODE(INCARC_FLAG
, 'Y'
, 'TRUE'
, 'F'
, 'FALSE') INCARC_FLAG
, VER_STATUS_CODE
, TO_CHAR( ENROLLMENT_DATE
, 'YYYY-MM-DD') ENROLLMENT_DATE
, SEC_EFC_CODE
FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, AWARD_ID
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, AWARD_AMT
, NOTE_MESSAGE
, COA_AMT
, LOW_TUTION_FEE
, DECODE(INCARC_FLAG
, 'Y'
, 'TRUE'
, 'F'
, 'FALSE')
, VER_STATUS_CODE
, TO_CHAR( ENROLLMENT_DATE
, 'YYYY-MM-DD')
, SEC_EFC_CODE