eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_PE_STAT_DETAILS

Object Details

Object Name:	IGS_PE_STAT_DETAILS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PE_STAT_DETAILS
Subobject Name:
Status:	VALID

IGS_PE_STAT_DETAILS describes the statistics details of a person.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PE_STAT_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Unique Person Identifier for the Statistics Records
PERSON_PROFILE_ID	NUMBER	(15)		(OBSOLETE)Unique identifier of statistics details
EFFECTIVE_START_DATE	DATE			Start date from that the statistics details are effective
EFFECTIVE_END_DATE	DATE			End date after which the statistics details are not effective
RELIGION_ID	NUMBER	(15)		OBSOLETED. Identifier of the religion
CRIMINAL_CONVICT	VARCHAR2	(1)		Flag indicates whether the person is criminal convict or not(Obsolete)
ACAD_DISMISSAL	VARCHAR2	(1)		Academic dismissal(Obsolete)
NON_ACAD_DISMISSAL	VARCHAR2	(1)		Non academic dismissal(Obsolete)
COUNTRY_CD3	VARCHAR2	(10)		Country code 3(Obsolete)
STATE_OF_RESIDENCE	VARCHAR2	(30)		State of residence(Obsolete)
RESID_STAT_ID	NUMBER	(15)		OBSOLETE. State of residence state identifier
SOCIO_ECO_ID	NUMBER	(15)		OBSOLETED. Socio economic identifier
NEXT_TO_KIN	VARCHAR2	(30)		Next to kin
IN_STATE_TUITION	VARCHAR2	(1)		Flag indicates whether the person is in state tuition
TUITION_ST_DATE	DATE			Tuition start date
TUITION_END_DATE	DATE			Tuition end date
FURTHER_EDUCATION_ID	NUMBER	(15)		OBSOLETED. Further education identifier
MATR_CAL_TYPE	VARCHAR2	(10)		Calendar Type for Matriculation Term
MATR_SEQUENCE_NUMBER	NUMBER	(6)		Sequence Number for Matriculation Term
INIT_CAL_TYPE	VARCHAR2	(10)		Calendar Type for Initial Admittance Term
INIT_SEQUENCE_NUMBER	NUMBER	(6)		Sequence Number for Initial Admittance Term
RECENT_CAL_TYPE	VARCHAR2	(10)		Calendar Type for Most Recent Admittance Term
RECENT_SEQUENCE_NUMBER	NUMBER	(6)		Sequence Number for Most Recent Admittance Term
CATALOG_CAL_TYPE	VARCHAR2	(10)		Calendar Type for Catalog Year
CATALOG_SEQUENCE_NUMBER	NUMBER	(6)		Sequence Number for Catalog Year
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)		Request Identifier of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program Application Identifier of the last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program Identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last Update Date of the concurrent program
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE1	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE2	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE3	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE4	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE5	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE6	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE7	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE8	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE9	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE10	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE11	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE12	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE13	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE14	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE15	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE16	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE17	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE18	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE19	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
ATTRIBUTE20	VARCHAR2	(150)		Standard attribute columns meant for descriptive flex fields
FURTHER_EDUCATION_CD	VARCHAR2	(30)		Further education code
RELIGION_CD	VARCHAR2	(30)		Religion code
SOCIO_ECO_CD	VARCHAR2	(30)		Social economic code.
BIRTH_CNTRY_RESN_CODE	VARCHAR2	(30)		Stores the birth country reason if the country of birth is US or US Territory

Query Text

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


SELECT PERSON_ID
,      PERSON_PROFILE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RELIGION_ID
,      CRIMINAL_CONVICT
,      ACAD_DISMISSAL
,      NON_ACAD_DISMISSAL
,      COUNTRY_CD3
,      STATE_OF_RESIDENCE
,      RESID_STAT_ID
,      SOCIO_ECO_ID
,      NEXT_TO_KIN
,      IN_STATE_TUITION
,      TUITION_ST_DATE
,      TUITION_END_DATE
,      FURTHER_EDUCATION_ID
,      MATR_CAL_TYPE
,      MATR_SEQUENCE_NUMBER
,      INIT_CAL_TYPE
,      INIT_SEQUENCE_NUMBER
,      RECENT_CAL_TYPE
,      RECENT_SEQUENCE_NUMBER
,      CATALOG_CAL_TYPE
,      CATALOG_SEQUENCE_NUMBER
,      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
,      FURTHER_EDUCATION_CD
,      RELIGION_CD
,      SOCIO_ECO_CD
,      BIRTH_CNTRY_RESN_CODE
FROM IGS.IGS_PE_STAT_DETAILS;

Dependencies

[top of page]

IGS.IGS_PE_STAT_DETAILS does not reference any database object

IGS.IGS_PE_STAT_DETAILS is referenced by following:

APPS: IGS_PE_STAT_DETAILS