[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFBV_STUDENT_AUTHORIZATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFBV_STUDENT_AUTHORIZATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base 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_DATE | 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 | ||
| MINIMUM_HOURLY_RATE | NUMBER | (12) | Minimum Hourly rate of payment for the fund. | |
| MAXIMUM_HOURLY_RATE | NUMBER | (12) | Maximum Hourly rate of payment for the fund. | |
| THRESHOLD_PERCENTAGE | 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_PERCENTAGE | NUMBER | (5) | The percentage of Fund amount that is paid by the Government | |
| SALARY_BASED | VARCHAR2 | (1) | Indicator identifying whether the fund payment is in Hourly rates or as a Salary to the student. | |
| ACCEPTED_AMOUNT | 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 | |
| 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 |
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_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
FROM APPS.IGFBV_STUDENT_AUTHORIZATIONS;
APPS
IGF_SE_AUTH
APPS.IGFBV_STUDENT_AUTHORIZATIONS is not referenced by any database object
|
|
|
|