Product: | IGF - Financial Aid |
---|---|
Description: | View containing the Loan Key level tags |
Implementation/DBA Data: | APPS.IGF_SL_COD_LOANKEY_V |
SELECT DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, TO_CHAR(LOAN_PER_BEGIN_DATE
, 'YYYY-MM-DD') LOAN_PER_BEGIN_DATE
, TO_CHAR(LOAN_PER_END_DATE
, 'YYYY-MM-DD') LOAN_PER_END_DATE
, TO_CHAR(ACAD_YR_BEGIN_DATE
, 'YYYY-MM-DD') ACAD_YR_BEGIN_DATE
, TO_CHAR(ACAD_YR_END_DATE
, 'YYYY-MM-DD') ACAD_YR_END_DATE
, PNOTE_PRINT_IND
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, GRADE_LEVEL_CODE
FROM IGF_SL_LOR_LOC_ALL GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, ACAD_YR_BEGIN_DATE
, ACAD_YR_END_DATE
, PNOTE_PRINT_IND
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, GRADE_LEVEL_CODE