[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_STUDENT_AUTHORIZATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_STUDENT_AUTHORIZATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Student Work Authorizations
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTIVE_FLAG | VARCHAR2 | (1) | Yes | ACTIVE or INACTIVE, to indicate which authorization id is active |
| FIRST_NAME | VARCHAR2 | (150) | Yes | First Name of the student |
| LAST_NAME | VARCHAR2 | (150) | Yes | Last Name of the student |
| ADDRESS_LINE_1 | VARCHAR2 | (240) | Yes | Address attribute of the student |
| ADDRESS_LINE_2 | VARCHAR2 | (240) | Address attribute of the student | |
| ADDRESS_LINE_3 | VARCHAR2 | (240) | Address attribute of the student | |
| ADDRESS_LINE_4 | VARCHAR2 | (240) | Address attribute of the student | |
| CITY | VARCHAR2 | (60) | City of residence of the student address | |
| STATE | VARCHAR2 | (240) | State of residence of the student address | |
| PROVINCE | VARCHAR2 | (60) | Province of residence of the student address | |
| COUNTY | VARCHAR2 | (60) | County of residence of the student address | |
| COUNTRY | VARCHAR2 | (60) | Yes | Country of residence of the student address |
| SEX | VARCHAR2 | (30) | Gender description of the student. | |
| BIRTH_DATE | DATE | Yes | Date of birth of the student | |
| SSN | VARCHAR2 | (20) | Yes | Social Security Number of the Student. |
| MARITAL_STATUS | VARCHAR2 | (30) | Yes | Marital Status description of the student, required for Tax purposes. |
| VISA_TYPE | VARCHAR2 | (10) | Type of visa held by the student | |
| VISA_CATEGORY | VARCHAR2 | (1) | Category of visa held by the student | |
| VISA_NUMBER | VARCHAR2 | (30) | Student's visa number | |
| VISA_EXPIRY_DT | DATE | Expiry date of the visa held by the student | ||
| ENTRY_DATE | DATE | Date of entry of the student in the country through the given visa | ||
| MIN_HR_RATE | VARCHAR2 | (0) | No longer used. | |
| MAX_HR_RATE | VARCHAR2 | (0) | No longer used. | |
| THRESHOLD_PERCT | NUMBER | (5) | Threshold Percentage beyond which, if the paid amount percentage in term of accepted amount for that term exceeds, a notification should be sent. This is set at the Fund level. | |
| THRESHOLD_VALUE | NUMBER | (12) | Threshold value beyond which, if the paid amount percentage in term of accepted amount for that term exceeds, a notification should be sent. | |
| GOVT_SHARE_PERCT | VARCHAR2 | (0) | No longer used. | |
| SALARY_BASED | VARCHAR2 | (0) | No longer used. | |
| ACCEPTED_AMNT | NUMBER | Yes | Amount accepted by the student for the Fund and for the term. | |
| AWARD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar Type for Award Calendar |
| AWARD_YEAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique Sequence Number for Award Calendar |
| LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Calendar Type for Load Calendar | |
| LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Unique Identifier for Load Calendar | |
| AWARD_YEAR | VARCHAR2 | (10) | Awarding Year | |
| LOAD_CALENDAR | VARCHAR2 | (10) | Load Calendar | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
| FUND_CODE | VARCHAR2 | (30) | Yes | Fund Code |
| FUND_DESCRIPTION | VARCHAR2 | (80) | Fund Code Description | |
| AUTHORIZATION_ID | NUMBER | (15) | Yes | Authorization Identifier |
| PERSON_ID | NUMBER | (15) | Yes | Unique Person Identifier |
| FUND_ID | NUMBER | (15) | Yes | Unique fund identifier received by the student for which the authorization is being sent. |
| SEQUENCE_NUMBER | NUMBER | (15) | Yes | Unique Identifier for a record. |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| AWARD_ID | NUMBER | (15) | Holds the award identifier of the fund awarded to the student. Foreign key to the student awards table | |
| AUTHORIZATION_DATE | DATE | Holds the authorization date of the Award. | ||
| NOTIFICATION_DATE | DATE | Date on which Notification was sent. A Notification is sent when the student's paid amount for the award increases the threshold as set for the Fund. |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.IGFFV_STUDENT_AUTHORIZATIONS;
APPS
HZ_PARTIES
IGF_AW_FUND_MAST_ALL
IGF_SE_AUTH
IGS_CA_INST_ALL
APPS.IGFFV_STUDENT_AUTHORIZATIONS is not referenced by any database object
|
|
|
|