[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_PASSPORT_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_PASSPORT_INT |
Subobject Name: | |
Status: | VALID |
Contains the passport information for each person to be imported into IGS_PE_PASSPORT.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Passport
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_PASSPORT_IN_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_PASSPORT_ID |
IGS_PE_PASSPORT_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_PE_PASSPORT_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_PASSPORT_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_PASSPORT_ID | NUMBER | (15) | Yes | A unique identifier |
INTERFACE_ID | NUMBER | (15) | Yes | Interface ID |
PASSPORT_NUMBER | VARCHAR2 | (30) | Yes | Passport Number |
PASSPORT_EXPIRY_DATE | DATE | Yes | Date Passport Expires | |
PASSPORT_CNTRY_CODE | VARCHAR2 | (30) | Yes | Passport Country Code |
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_PASSPORT_ID | NUMBER | (15) | Duplicate Passport 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 | |
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_PASSPORT_ID
, INTERFACE_ID
, PASSPORT_NUMBER
, PASSPORT_EXPIRY_DATE
, PASSPORT_CNTRY_CODE
, 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_PASSPORT_ID
, 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_PASSPORT_INT;
IGS.IGS_PE_PASSPORT_INT does not reference any database object
IGS.IGS_PE_PASSPORT_INT is referenced by following:
|
|
|