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

VIEW: APPS.IGSFV_AD_APPL_PERSTAT

Object Details
Object Name: IGSFV_AD_APPL_PERSTAT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_AD_APPL_PERSTAT
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERONAL_STATMT_ID NUMBER (15) Yes Unique Application Personal Statement identifier
PERSON_ID NUMBER (15) Yes Person Identifier
PERSON_NUMBER VARCHAR2 (30) Yes
PERSON_NAME VARCHAR2 (450)
ADMISSION_APPLICATION_NUMBER NUMBER (2) Yes Admission Application Number
PERSONAL_STATEMENT_TYPE VARCHAR2 (30) Yes Personal Statement Type attached to application personal statement
PERSONAL_STATEMENT_TYPE_DESC VARCHAR2 (240) Yes Personal Statement Type description
PERSONAL_STATMT_DATE_RECEIVED DATE
Yes Date on which Application Statement was received
CREATED_BY NUMBER (15) Yes WHO column
CREATION_DATE DATE
Yes WHO column
LAST_UPDATED_BY NUMBER (15) Yes WHO column
LAST_UPDATE_DATE DATE
Yes WHO column
Query Text

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


SELECT APPLICATION_PERONAL_STATMT_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      ADMISSION_APPLICATION_NUMBER
,      PERSONAL_STATEMENT_TYPE
,      PERSONAL_STATEMENT_TYPE_DESC
,      PERSONAL_STATMT_DATE_RECEIVED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AD_APPL_PERSTAT;

Dependencies

[top of page]

APPS.IGSFV_AD_APPL_PERSTAT references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymIGS_AD_APPL_PERSTAT
SynonymIGS_AD_PER_STM_TYP

APPS.IGSFV_AD_APPL_PERSTAT is not referenced by any database object