View: IGF_SE_AUTH_V

Product:	IGF - Financial Aid
Description:	The entity contains the authorization details sent to the interface layer. This entity also at the same time has the history or inactive authorization records. At one line only one authorization record can remain active.
Implementation/DBA Data:	APPS.IGF_SE_AUTH_V

View Text

SELECT DISTINCT SAI.AUTHORIZATION_DATE AUTH_DATE
, SAI.ROWID
, SAI.SEQUENCE_NO
, SAI.AUTH_ID
, SAI.FLAG
, SAI.PERSON_ID
, SAI.FIRST_NAME
, SAI.LAST_NAME
, SAI.ADDRESS1
, SAI.ADDRESS2
, SAI.ADDRESS3
, SAI.ADDRESS4
, SAI.CITY
, SAI.STATE
, SAI.PROVINCE
, SAI.COUNTY
, SAI.COUNTRY
, SAI.SEX
, SAI.BIRTH_DT
, SAI.SSN_NO
, SAI.MARITAL_STATUS
, SAI.VISA_TYPE
, SAI.VISA_CATEGORY
, SAI.VISA_NUMBER
, SAI.VISA_EXPIRY_DT
, SAI.ENTRY_DATE
, SAI.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION
, NULL
, NULL
, SAI.THRESHOLD_PERCT
, SAI.THRESHOLD_VALUE
, NULL
, NULL
, SAI.ACCEPTED_AMNT
, SAI.AW_CAL_TYPE
, SAI.AW_SEQUENCE_NUMBER
, CA1.ALTERNATE_CODE AW_ALTERNATE_CODE
, CA1.START_DT AW_START_DATE
, CA1.END_DT AW_END_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, SAI.CREATED_BY
, SAI.CREATION_DATE
, SAI.LAST_UPDATED_BY
, SAI.LAST_UPDATE_DATE
, SAI.LAST_UPDATE_LOGIN
, SAI.REQUEST_ID
, SAI.PROGRAM_APPLICATION_ID
, SAI.PROGRAM_ID
, SAI.PROGRAM_UPDATE_DATE
, IGF_SL_LAR_CREATION.GET_LOAN_START_DT(AWD.AWARD_ID)
, IGF_SL_LAR_CREATION.GET_LOAN_END_DT(AWD.AWARD_ID)
, SAI.AUTHORIZATION_DATE
, SAI.NOTIFICATION_DATE
, SAI.AWARD_ID
FROM IGF_SE_AUTH SAI
, IGS_CA_INST CA1
, IGF_AW_FUND_MAST FM
, IGF_AW_AWARD_ALL AWD
WHERE AWD.AWARD_ID = SAI.AWARD_ID
AND CA1.CAL_TYPE = SAI.AW_CAL_TYPE
AND CA1.SEQUENCE_NUMBER = SAI.AW_SEQUENCE_NUMBER
AND FM.FUND_ID = SAI.FUND_ID

Columns