DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PE_PERSON_TYPES

Object Details
Object Name: IGS_PE_PERSON_TYPES
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PE_PERSON_TYPES
Subobject Name:
Status: VALID


IGS_PE_PERSON_TYPES is used to capture the different person types. This table is modified to capture the enrollment method type related to self service.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PE_PERSON_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PERSON_TYPE_CODE VARCHAR2 (30) Yes Unique Code for a Person Type.
DESCRIPTION VARCHAR2 (240) Yes Description of a Person Type.
SYSTEM_TYPE VARCHAR2 (30) Yes The System Type associated with a Person Type.
CLOSED_IND VARCHAR2 (1) Yes An Indicator which indicates if the Person Type is closed for further usage.
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
RANK NUMBER (4)
Indicates what is the rank of the person type associated with self service enrollment staff users.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_TYPE_CODE
,      DESCRIPTION
,      SYSTEM_TYPE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RANK
FROM IGS.IGS_PE_PERSON_TYPES;

Dependencies

[top of page]

IGS.IGS_PE_PERSON_TYPES does not reference any database object

IGS.IGS_PE_PERSON_TYPES is referenced by following:

SchemaAPPS
SynonymIGS_PE_PERSON_TYPES