[Home] [Help] [Dependency Information]
Object Name: | IGS_SV_PERSONS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_SV_PERSONS |
Subobject Name: | |
Status: | VALID |
IGS_SV_PERSONS - Table for information on the students that are to be submitted in the request for the batch run.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_SV_PERSONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
PERSON_ID |
IGS_SV_PERSONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
RECORD_NUMBER |
IGS_SV_PERSONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECORD_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (14) | Yes | Batch identifier for the request being run. |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier that is linked to the HZ_PARTIES table. |
RECORD_NUMBER | NUMBER | (20) | Yes | record number in the batch that is being processed. up to 250 records per batch |
FORM_ID | NUMBER | (15) | Yes | Form Identifier that has been entered for the person. |
PRINT_FORM | VARCHAR2 | (1) | Yes | Flag indicating form being requested for reprinting by the user |
PDSO_SEVIS_ID | VARCHAR2 | (11) | SEVIS identifier of the person responsible for the student. | |
RECORD_STATUS | VARCHAR2 | (1) | Yes | The status of the record that is being processed. Update or Create status |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number that is assigned to the person on creaion of person record in HZ_PARTIES |
SEVIS_USER_ID | VARCHAR2 | (11) | The SEVIS Identifier that is assigned to the user upon creation of record processing. | |
ISSUING_REASON | VARCHAR2 | (30) | Reason code for the creation of the user | |
CURR_SESSION_END_DATE | VARCHAR2 | (10) | Current session end date for the student or visitor. | |
NEXT_SESSION_START_DATE | VARCHAR2 | (10) | Next session start date for the student | |
OTHER_REASON | VARCHAR2 | (500) | Other reason for the information that is being sent to SEVIS | |
TRANSFER_FROM_SCHOOL | VARCHAR2 | (500) | School that the student is transferring from | |
EV_CREATE_REASON | VARCHAR2 | (30) | Exchange Visitor creation reason code to be sent to SEVIS | |
EV_FORM_NUMBER | VARCHAR2 | (30) | Form Number for the Exchange Visitor | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
INIT_PRGM_START_DATE | VARCHAR2 | (10) | Initial program start date for a continuing Exchange Visitor. | |
SEVIS_ERROR_CODE | VARCHAR2 | (30) | SEVIS Error code value returned. | |
SEVIS_ERROR_ELEMENT | VARCHAR2 | (500) | SEVIS element that had the error reported back. | |
NO_SHOW_FLAG | VARCHAR2 | (1) | Captures if the person has not reported to college/university even after landing in US | |
STATUS_CODE | VARCHAR2 | (30) | Captures the status of the person e..g. if the EV is in INITIAL status or in ACTIVE | |
LAST_SESSION_FLAG | VARCHAR2 | (1) | Used to indicate that a person is in his last session | |
ADJUDICATED_FLAG | VARCHAR2 | (1) | Used to indicate that a person has been Adjudicated | |
REPRINT_RSN_CODE | VARCHAR2 | (30) | Captures the Reprint Reason | |
REPRINT_REMARKS | VARCHAR2 | (500) | Captures the remarks for the re-Print | |
REMARKS | VARCHAR2 | (500) | To capture the remarks for NON-IMMG | |
PDSO_SEVIS_PERSON_ID | NUMBER | (15) | Person Id of the DSO associated with Student |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PERSON_ID
, RECORD_NUMBER
, FORM_ID
, PRINT_FORM
, PDSO_SEVIS_ID
, RECORD_STATUS
, PERSON_NUMBER
, SEVIS_USER_ID
, ISSUING_REASON
, CURR_SESSION_END_DATE
, NEXT_SESSION_START_DATE
, OTHER_REASON
, TRANSFER_FROM_SCHOOL
, EV_CREATE_REASON
, EV_FORM_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, INIT_PRGM_START_DATE
, SEVIS_ERROR_CODE
, SEVIS_ERROR_ELEMENT
, NO_SHOW_FLAG
, STATUS_CODE
, LAST_SESSION_FLAG
, ADJUDICATED_FLAG
, REPRINT_RSN_CODE
, REPRINT_REMARKS
, REMARKS
, PDSO_SEVIS_PERSON_ID
FROM IGS.IGS_SV_PERSONS;
IGS.IGS_SV_PERSONS does not reference any database object
IGS.IGS_SV_PERSONS is referenced by following:
|
|
|