Product: | IGF - Financial Aid |
---|---|
Description: | View used for reporting the various Direct Loan tags in the outbound XML for Direct Loan |
Implementation/DBA Data: | APPS.IGF_SL_COD_REP_V |
SELECT REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, AWARD_ID
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, DOCUMENT_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, NOTE_MESSAGE
, FULL_RESP_CODE
, ORIGINATION_ID
, LOAN_NUMBER LOAN_NUMBER_TXT
, SUBSTR(LOAN_NUMBER
, LENGTH(LOAN_NUMBER)-2
, LENGTH(LOAN_NUMBER)) FIN_AWD_NUM
, LOAN_TYPE
, LOAN_AMT_ACCEPTED
, 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
, TO_CHAR(ORIG_BATCH_DATE
, 'YYYY-MM-DD') ORIG_BATCH_DATE
, PNOTE_PRINT_IND
, S_DEPNCY_STATUS
, S_DEFAULT_STATUS
, UNSUB_ELIG_FOR_HEAL
, DISCLOSURE_PRINT_IND
, UNSUB_ELIG_FOR_DEPNT
, ORIG_FEE_PERCT
, LOAN_STATUS
, LOAN_CHG_STATUS
, GRADE_LEVEL_CODE
, P_SSN
, P_LAST_NAME
, P_FIRST_NAME
, SUBSTR(TRIM(P_MIDDLE_NAME)
, 1
, 1) P_MIDDLE_INITIAL
, TO_CHAR(B_CHG_BIRTH_DATE
, 'YYYY-MM-DD') B_CHG_BIRTH_DATE
, B_CHG_SSN
, B_CHG_LAST_NAME
, P_PERMT_ADDR1
, P_PERMT_ADDR2
, P_PERMT_CITY
, P_PERMT_STATE
, P_PERMT_ZIP
, P_PERMT_PHONE
, P_EMAIL_ADDR
, TO_CHAR(P_DATE_OF_BIRTH
, 'YYYY-MM-DD') P_DATE_OF_BIRTH
, P_LICENSE_NUM
, P_LICENSE_STATE
, P_CITIZENSHIP_STATUS
, P_ALIEN_REG_NUM
, P_DEFAULT_STATUS
, B_PERMT_COUNTRY
, B_PERMT_COUNTY
, P_FOREIGN_POSTAL_CODE
, P_STATE_OF_LEGAL_RES
FROM IGF_SL_LOR_LOC_ALL