[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_CRED_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_CRED_INT |
Subobject Name: | |
Status: | VALID |
Contains the credential details records for each person to be imported into IGS_PE_CREDENTIALS.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Credentials
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_CRED_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_CRED_ID |
IGS_PE_CRED_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_PE_CRED_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_CRED_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_CRED_ID | NUMBER | (15) | Yes | A unique identifier to identify each row in this table |
INTERFACE_ID | NUMBER | (15) | Yes | Interface identifier |
CREDENTIAL_TYPE_ID | NUMBER | (15) | Yes | Credential Type Id CREDENTIAL_TYPE_ID that is selected from SELECT CREDENTIAL_TYPE_ID FROM IGS_AD_CRED_TYPES WHERE CLOSED_IND = 'N' |
DATE_RECEIVED | DATE | Date Received It should not be greater than system date | ||
RATING_CODE | VARCHAR2 | (30) | Rating Code, Rating code that is selected from SELECT LOOKUP_CODE FROM IGS_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PE_CRE_RATING' AND NVL(CLOSED_IND, 'N') = 'N' AND ENABLED_FLAG = 'Y' | |
REVIEWER_ID | NUMBER | (15) | Reviewer person id REVIEWER_ID that is selected from SELECT PTI.PERSON_ID FROM IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES PTI WHERE PTI.PERSON_TYPE_CODE = PT.PERSON_TYPE_CODE AND PT.SYSTEM_TYPE = 'STAFF' AND SYSDATE BETWEEN PTI.START_DATE AND NVL(PTI.END_DATE,SYSDATE) | |
REVIEWER_NOTES | VARCHAR2 | (240) | Reviewer Notes | |
RECOMMENDER_NAME | VARCHAR2 | (80) | Recommender Name | |
RECOMMENDER_TITLE | VARCHAR2 | (80) | Recommender Title | |
RECOMMENDER_ORGANIZATION | VARCHAR2 | (80) | Recommender Organization | |
MATCH_IND | VARCHAR2 | (2) | Match indicator for the interface record20 - Match To Be Reviewed For Discrepancy21 - Match reviewed and to be imported22 - Match reviewed and do not import23 - Match reviewed, no discrepancy and retaining existing values | |
ERROR_CODE | VARCHAR2 | (30) | Error Code | |
STATUS | VARCHAR2 | (1) | Yes | Status of the interface record |
DUP_CREDENTIAL_ID | NUMBER | (15) | Duplicate credentials details id, used when the discrepancy rule is set to Review. | |
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 | ||
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. | ||
ERROR_TEXT | VARCHAR2 | (2000) | Error Text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_CRED_ID
, INTERFACE_ID
, CREDENTIAL_TYPE_ID
, DATE_RECEIVED
, RATING_CODE
, REVIEWER_ID
, REVIEWER_NOTES
, RECOMMENDER_NAME
, RECOMMENDER_TITLE
, RECOMMENDER_ORGANIZATION
, MATCH_IND
, ERROR_CODE
, STATUS
, DUP_CREDENTIAL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, INTERFACE_RUN_ID
, ERROR_TEXT
FROM IGS.IGS_PE_CRED_INT;
IGS.IGS_PE_CRED_INT does not reference any database object
IGS.IGS_PE_CRED_INT is referenced by following:
|
|
|