[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_TYPE_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_TYPE_INT |
Subobject Name: | |
Status: | VALID |
Contains the person type for each person to be imported in to IGS_PE_TYP_INSTANCES_ALL
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Person Type
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_TYPE_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_PERSON_TYPE_ID |
IGS_PE_TYPE_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_PE_TYPE_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_TYPE_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_PERSON_TYPE_ID | NUMBER | (15) | Yes | Sequence generated unique Identifier of a Person Type interface record. Sequence IGS_PE_TYPE_INT_S should be used for this. |
INTERFACE_ID | NUMBER | (15) | Yes | Interface ID of the parent record from table IGS_AD_INTERFACE_ALL. |
PERSON_TYPE_CODE | VARCHAR2 | (30) | Yes | Person Type Code. The valid values are as retrieved by the following select statement.SELECT person_type_code FROM igs_pe_person_types WHERE closed_ind = 'N' AND system_type IN ('ADVISOR', 'EVALUATOR', 'EXTERNAL_CONTACT', 'FACULTY', 'STAFF', 'USER_DEFINED') |
START_DATE | DATE | Yes | Start Date of the person type instance. It must not be less then the date of birth (if available) of the person. | |
END_DATE | DATE | End Date of the person type instance.If provided must be greater start date above. | ||
STATUS | VARCHAR2 | (1) | Yes | 1 - Completed, 2 - Pending, 3 - Error, 4 - Warning |
MATCH_IND | VARCHAR2 | (2) | Match IndicatorValid values areSELECT lookup_code,meaning FROM igs_lookup_values WHERE lookup_type = 'IMPORT_MATCH_IND' AND enabled_flag = 'Y' | |
ERROR_CODE | VARCHAR2 | (30) | Error Code | |
DUP_TYPE_INSTANCE_ID | NUMBER | (15) | Type Instance ID of the Duplicate 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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
EMPLMNT_CATEGORY_CODE | VARCHAR2 | (30) | Employment Category of the Person | |
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_PERSON_TYPE_ID
, INTERFACE_ID
, PERSON_TYPE_CODE
, START_DATE
, END_DATE
, STATUS
, MATCH_IND
, ERROR_CODE
, DUP_TYPE_INSTANCE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, EMPLMNT_CATEGORY_CODE
, INTERFACE_RUN_ID
FROM IGS.IGS_PE_TYPE_INT;
IGS.IGS_PE_TYPE_INT does not reference any database object
IGS.IGS_PE_TYPE_INT is referenced by following:
|
|
|