[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_VST_HIST_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_VST_HIST_INT |
Subobject Name: | |
Status: | VALID |
Contains the visit history/port of entry information for each person to be imported into IGS_PE_VISIT_HISTRY.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Visit History
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_VST_HIST_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_VISIT_HISTRY_ID |
IGS_PE_VST_HIST_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
IGS_PE_VST_HIST_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_VST_HIST_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_VISA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_VISIT_HISTRY_ID | NUMBER | (15) | Yes | A Unique Identifier |
PORT_OF_ENTRY | VARCHAR2 | (30) | Yes | Port that person entered country from |
CNTRY_ENTRY_FORM_NUM | VARCHAR2 | (30) | Yes | Form Number that is issued to enter country |
INTERFACE_VISA_ID | NUMBER | (15) | Yes | Interface Visa ID |
VISIT_START_DATE | DATE | Yes | Date entered into country | |
VISIT_END_DATE | DATE | Date that the visit ended | ||
REMARKS | VARCHAR2 | (500) | Remarks on port of entry | |
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_PORT_OF_ENTRY | VARCHAR2 | (30) | Duplicate Port of Entry | |
DUP_CNTRY_ENTRY_FORM_NUM | VARCHAR2 | (30) | Duplicate Country Entry Form Number | |
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 | |
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_VISIT_HISTRY_ID
, PORT_OF_ENTRY
, CNTRY_ENTRY_FORM_NUM
, INTERFACE_VISA_ID
, VISIT_START_DATE
, VISIT_END_DATE
, REMARKS
, 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_PORT_OF_ENTRY
, DUP_CNTRY_ENTRY_FORM_NUM
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, INTERFACE_RUN_ID
FROM IGS.IGS_PE_VST_HIST_INT;
IGS.IGS_PE_VST_HIST_INT does not reference any database object
IGS.IGS_PE_VST_HIST_INT is referenced by following:
|
|
|