View: IGF_SL_COD_LOANKEY_V

Product:	IGF - Financial Aid
Description:	View containing the Loan Key level tags
Implementation/DBA Data:	APPS.IGF_SL_COD_LOANKEY_V

View Text

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

Columns