[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_VISA_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_VISA_INT |
Subobject Name: | |
Status: | VALID |
Contains the visa information for each person to be imported into IGS_PE_VISA .
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Visa
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_VISA_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_VISA_ID |
IGS_PE_VISA_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_PE_VISA_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_VISA_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_VISA_ID | NUMBER | (15) | Yes | A unique identifier |
INTERFACE_ID | NUMBER | (15) | Yes | Interface ID |
VISA_TYPE | VARCHAR2 | (30) | Yes | Visa Type that the person has |
VISA_NUMBER | VARCHAR2 | (30) | Yes | Number on Visa |
VISA_ISSUE_DATE | DATE | Yes | Date visa was issued | |
VISA_EXPIRY_DATE | DATE | Yes | Date visa expires | |
VISA_CATEGORY | VARCHAR2 | (30) | Category type associated to J Visa Types | |
VISA_ISSUING_POST | VARCHAR2 | (30) | Visa post issued | |
PASSPORT_ID | NUMBER | (15) | Passport that is associated to the Visa. | |
AGENT_ORG_UNIT_CD | VARCHAR2 | (30) | International Agent Org Unit Code | |
AGENT_PERSON_ID | NUMBER | (15) | Person ID of the Agent | |
AGENT_CONTACT_NAME | VARCHAR2 | (80) | Agents contact name | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Context Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard Attribute Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard Attribute Column | |
MATCH_IND | VARCHAR2 | (2) | 18- Match occurred and imported values,19- Match exists and retained values,20- Requires review, 21-Match reviewed and to be imported,22- Match reviewed and do not import,23- Match to be reviewed,11- No match | |
STATUS | VARCHAR2 | (1) | Yes | 1-Completed ,2-Pending |
ERROR_CODE | VARCHAR2 | (30) | error code | |
DUP_VISA_ID | NUMBER | (15) | Duplicate Visa ID | |
REQUEST_ID | NUMBER | (15) | Standard Who Column for concurrent program | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column for concurrent program | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column for concurrent program | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column for concurrent program | ||
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 | |
VISA_ISSUING_COUNTRY | VARCHAR2 | (30) | Country Code where the visa was issued. Valid values are from lookup type 'PER_US_COUNTRY_CODE'. | |
INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the logic in the import process, and should not be populated by the user. |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_VISA_ID
, INTERFACE_ID
, VISA_TYPE
, VISA_NUMBER
, VISA_ISSUE_DATE
, VISA_EXPIRY_DATE
, VISA_CATEGORY
, VISA_ISSUING_POST
, PASSPORT_ID
, AGENT_ORG_UNIT_CD
, AGENT_PERSON_ID
, AGENT_CONTACT_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, MATCH_IND
, STATUS
, ERROR_CODE
, DUP_VISA_ID
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, VISA_ISSUING_COUNTRY
, INTERFACE_RUN_ID
FROM IGS.IGS_PE_VISA_INT;
IGS.IGS_PE_VISA_INT does not reference any database object
IGS.IGS_PE_VISA_INT is referenced by following:
|
|
|