eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_SE_AUTH_V

Product:	IGF - Financial Aid (Obsolete)
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:	Not implemented in this database

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

Name
AUTH_DATE
ROW_ID
SEQUENCE_NO
AUTH_ID
FLAG
PERSON_ID
FIRST_NAME
LAST_NAME
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
STATE
PROVINCE
COUNTY
COUNTRY
SEX_MEANING
BIRTH_DT
SSN_NO
MARITAL_STATUS
VISA_TYPE
VISA_CATEGORY
VISA_NUMBER
VISA_EXPIRY_DT
ENTRY_DATE
FUND_ID
FUND_CODE
DESCRIPTION
MIN_HR_RATE
MAX_HR_RATE
THRESHOLD_PERCT
THRESHOLD_VALUE
GOVT_SHARE_PERCT
SALARY_BASED
ACCEPTED_AMNT
AW_CAL_TYPE
AW_SEQUENCE_NUMBER
AW_ALTERNATE_CODE
AW_START_DATE
AW_END_DATE
LD_CAL_TYPE
LD_SEQUENCE_NUMBER
LD_ALTERNATE_CODE
LD_START_DATE
LD_END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
AUTH_START_DATE
AUTH_END_DATE
AUTHORIZATION_DATE
NOTIFICATION_DATE
AWARD_ID