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: IGFFV_STUDENT_AUTHORIZATIONS

Product:	IGF - Financial Aid (Obsolete)
Description:	Full View for the Entity that holds Student Work Authorizations
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SEAUT.FLAG
, SEAUT.FIRST_NAME
, SEAUT.LAST_NAME
, SEAUT.ADDRESS1
, SEAUT.ADDRESS2
, SEAUT.ADDRESS3
, SEAUT.ADDRESS4
, SEAUT.CITY
, SEAUT.STATE
, SEAUT.PROVINCE
, SEAUT.COUNTY
, SEAUT.COUNTRY
, SEAUT.SEX
, SEAUT.BIRTH_DT
, SEAUT.SSN_NO
, SEAUT.MARITAL_STATUS
, SEAUT.VISA_TYPE
, SEAUT.VISA_CATEGORY
, SEAUT.VISA_NUMBER
, SEAUT.VISA_EXPIRY_DT
, SEAUT.ENTRY_DATE
, NULL
, NULL
, SEAUT.THRESHOLD_PERCT
, SEAUT.THRESHOLD_VALUE
, NULL
, NULL
, SEAUT.ACCEPTED_AMNT
, SEAUT.AW_CAL_TYPE
, SEAUT.AW_SEQUENCE_NUMBER
, SEAUT.LD_CAL_TYPE
, SEAUT.LD_SEQUENCE_NUMBER
, AWARD_CI.ALTERNATE_CODE
, LOAD_CI.ALTERNATE_CODE
, HZ.PARTY_NUMBER
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, SEAUT.AUTH_ID
, SEAUT.PERSON_ID
, SEAUT.FUND_ID
, SEAUT.SEQUENCE_NO
, SEAUT.CREATED_BY
, SEAUT.CREATION_DATE
, SEAUT.LAST_UPDATED_BY
, SEAUT.LAST_UPDATE_DATE
, SEAUT.AWARD_ID
, SEAUT.AUTHORIZATION_DATE
, SEAUT.NOTIFICATION_DATE
FROM IGF_SE_AUTH SEAUT
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWARD_CI
, IGS_CA_INST_ALL LOAD_CI
, HZ_PARTIES HZ
WHERE SEAUT.FUND_ID = FMAST.FUND_ID
AND SEAUT.LD_CAL_TYPE = LOAD_CI.CAL_TYPE
AND SEAUT.LD_SEQUENCE_NUMBER = LOAD_CI.SEQUENCE_NUMBER
AND FMAST.CI_CAL_TYPE = AWARD_CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWARD_CI.SEQUENCE_NUMBER
AND HZ.PARTY_ID = SEAUT.PERSON_ID WITH READ ONLY

Columns

Name
ACTIVE_FLAG
FIRST_NAME
LAST_NAME
ADDRESS_LINE_1
ADDRESS_LINE_2
ADDRESS_LINE_3
ADDRESS_LINE_4
CITY
STATE
PROVINCE
COUNTY
COUNTRY
SEX
BIRTH_DATE
SSN
MARITAL_STATUS
VISA_TYPE
VISA_CATEGORY
VISA_NUMBER
VISA_EXPIRY_DT
ENTRY_DATE
MIN_HR_RATE
MAX_HR_RATE
THRESHOLD_PERCT
THRESHOLD_VALUE
GOVT_SHARE_PERCT
SALARY_BASED
ACCEPTED_AMNT
AWARD_CALENDAR_TYPE
AWARD_YEAR_SEQUENCE_NUMBER
LOAD_CALENDAR_TYPE
LOAD_SEQUENCE_NUMBER
AWARD_YEAR
LOAD_CALENDAR
PERSON_NUMBER
FUND_CODE
FUND_DESCRIPTION
AUTHORIZATION_ID
PERSON_ID
FUND_ID
SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
AWARD_ID
AUTHORIZATION_DATE
NOTIFICATION_DATE