[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_RES_DTLS_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_RES_DTLS_INT |
Subobject Name: | |
Status: | VALID |
Contains the residency details for each person to be imported into IGS_PE_RES_DTLS_ALL.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Residency
Category: BUSINESS_ENTITY HZ_PERSON
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_RES_DTLS_INT_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_RES_ID |
IGS_PE_RES_DTLS_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_PE_RES_DTLS_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_PE_RES_DTLS_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ID | NUMBER | (15) | Yes | Interface record identifier |
INTERFACE_RES_ID | NUMBER | (15) | Yes | Unique Identifier for the record |
RESIDENCY_STATUS_CD | VARCHAR2 | (30) | Yes | Residency Status code |
RESIDENCY_CLASS_CD | VARCHAR2 | (30) | Yes | Residency Class code |
EVALUATION_DATE | DATE | Yes | Evaluation Date | |
EVALUATOR | VARCHAR2 | (30) | Yes | Evaluation Identifier |
START_DT | DATE | No longer used | ||
END_DT | DATE | No longer used | ||
COMMENTS | VARCHAR2 | (240) | Comments | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
CREATION_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns | |
REQUEST_ID | NUMBER | (15) | Concurrent program standard WHO column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program standard WHO column | |
PROGRAM_ID | NUMBER | (15) | Concurrent program standard WHO column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent program standard WHO column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Stores the context for flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard Attribute Column, meant for descriptive flex field. | |
STATUS | VARCHAR2 | (2) | Yes | Stores the status of the interface record processing. |
MATCH_IND | VARCHAR2 | (2) | Match indicator. The following indicators are used for this process. | |
ERROR_CODE | VARCHAR2 | (30) | Records the error codes for the interface record. | |
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. | ||
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar Type |
SEQUENCE_NUMBER | NUMBER | Yes | Calendar Sequence Number |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, INTERFACE_RES_ID
, RESIDENCY_STATUS_CD
, RESIDENCY_CLASS_CD
, EVALUATION_DATE
, EVALUATOR
, START_DT
, END_DT
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, STATUS
, MATCH_IND
, ERROR_CODE
, INTERFACE_RUN_ID
, CAL_TYPE
, SEQUENCE_NUMBER
FROM IGS.IGS_PE_RES_DTLS_INT;
IGS.IGS_PE_RES_DTLS_INT does not reference any database object
IGS.IGS_PE_RES_DTLS_INT is referenced by following:
|
|
|