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

TABLE: IGS.IGS_SS_APPL_PERSTAT

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


Staging table for Personal Statements for Application in SS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SS_APPL_PERSTAT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSS_PERSTAT_ID
IGS_SS_APPL_PERSTAT_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnPERSL_STAT_TYPE
ColumnSS_ADM_APPL_ID
Columns
Name Datatype Length Mandatory Comments
SS_PERSTAT_ID NUMBER (15) Yes Personal Statement Identifier
PERSON_ID NUMBER (15)
Person Identifier
SS_ADM_APPL_ID NUMBER (15)
Self Service Admission Application Identifier
ADMISSION_APPLICATION_TYPE VARCHAR2 (30)
Admission Application Type
PERSL_STAT_TYPE VARCHAR2 (30)
Personal Statement Type
DATE_RECEIVED DATE

Date Received
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
ATTACH_EXISTS VARCHAR2 (1)
Indicates whether attachment exists
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
Query Text

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


SELECT SS_PERSTAT_ID
,      PERSON_ID
,      SS_ADM_APPL_ID
,      ADMISSION_APPLICATION_TYPE
,      PERSL_STAT_TYPE
,      DATE_RECEIVED
,      CREATED_BY
,      CREATION_DATE
,      ATTACH_EXISTS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_SS_APPL_PERSTAT;

Dependencies

[top of page]

IGS.IGS_SS_APPL_PERSTAT does not reference any database object

IGS.IGS_SS_APPL_PERSTAT is referenced by following:

SchemaAPPS
SynonymIGS_SS_APPL_PERSTAT