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

Product:	IGF - Financial Aid
Description:	Base view for the entity that holds Student Work Authorizations
Implementation/DBA Data:	APPS.IGFBV_STUDENT_AUTHORIZATIONS

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
, SEAUT.MIN_HR_RATE
, SEAUT.MAX_HR_RATE
, SEAUT.THRESHOLD_PERCT
, SEAUT.THRESHOLD_VALUE
, SEAUT.GOVT_SHARE_PERCT
, SEAUT.SALARY_BASED
, SEAUT.ACCEPTED_AMNT
, SEAUT.AW_CAL_TYPE
, SEAUT.AW_SEQUENCE_NUMBER
, SEAUT.LD_CAL_TYPE
, SEAUT.LD_SEQUENCE_NUMBER
, 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
FROM IGF_SE_AUTH SEAUT 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_DATE
ENTRY_DATE
MINIMUM_HOURLY_RATE
MAXIMUM_HOURLY_RATE
THRESHOLD_PERCENTAGE
THRESHOLD_VALUE
GOVT_SHARE_PERCENTAGE
SALARY_BASED
ACCEPTED_AMOUNT
AWARD_CALENDAR_TYPE
AWARD_YEAR_SEQUENCE_NUMBER
LOAD_CALENDAR_TYPE
LOAD_SEQUENCE_NUMBER
AUTHORIZATION_ID
PERSON_ID
FUND_ID
SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE