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

VIEW: APPS.IGSFV_ACADEMIC_CATALOGS

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

View Type

A Business Intelligence System view


This entity contains information about the academic catalog of a person.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_NUMBER VARCHAR2 (30) Yes Unique identification number for a person.
EFFECTIVE_START_DATE DATE

Start date that the statistics details are effective
EFFECTIVE_END_DATE DATE

End date after which the statistics details are not effective
IN_STATE_TUITION VARCHAR2 (1)
Flag indicates whether the person is in state tuition
TUITION_START_DATE DATE

Tuition start date
TUITION_END_DATE DATE

Tuition end date
MATRICULATION_ALTERNATE_CODE VARCHAR2 (10)
Alternate identifier for calendar type.
MATRICULATION_CALENDAR_TYPE VARCHAR2 (10)
Calendar Type for Matriculation Term
MATRICULATION_SEQUENCE_NUMBER NUMBER (6)
Sequence Number for Matriculation Term
MATRICULATION_START_DATE DATE

Start date for Matriculation Term
MATRICULATION_END_DATE DATE

End date for Matriculation Term.
INITIAL_ALTERNATE_CODE VARCHAR2 (10)
Alternate identifier for calendar type.
INITIAL_CALENDAR_TYPE VARCHAR2 (10)
Calendar Type for Initial Admittance Term
INITIAL_SEQUENCE_NUMBER NUMBER (6)
Sequence Number for Initial Admittance Term
INITIAL_START_DATE DATE

Start date for Initial Admittance Term.
INITIAL_END_DATE DATE

End date for Initial Admittance Term.
RECENT_ALTERNATE_CODE VARCHAR2 (10)
Alternate identifier for calendar type.
RECENT_CALENDAR_TYPE VARCHAR2 (10)
Calendar Type for Most Recent Admittance Term
RECENT_SEQUENCE_NUMBER NUMBER (6)
Sequence Number for Most Recent Admittance Term
RECENT_START_DATE DATE

Start date for Most Recent Admittance Term.
RECENT_END_DATE DATE

End date for Most Recent Admittance Term.
CATALOG_ALTERNATE_CODE VARCHAR2 (10)
Alternate identifier for calendar type.
CATALOG_CALENDAR_TYPE VARCHAR2 (10)
Calendar Type for Catalog Year
CATALOG_SEQUENCE_NUMBER NUMBER (6)
Sequence Number for Catalog Year
CATALOG_START_DATE DATE

Start date for Catalog Year
CATALOG_END_DATE DATE

End date for Catalog Year.
_LA:FURTHER_EDUCATION CHAR (65)
Further education code meaning
_LA:RELIGION CHAR (57)
Religion code meaning.
_LA:SOCIAL_ECONOMIC CHAR (61)
Social economic code meaning.
_DF CHAR (28)
Descriptive flexfield.
PERSON_ID NUMBER (15) Yes Unique Person Identifier
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT PERSON_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      IN_STATE_TUITION
,      TUITION_START_DATE
,      TUITION_END_DATE
,      MATRICULATION_ALTERNATE_CODE
,      MATRICULATION_CALENDAR_TYPE
,      MATRICULATION_SEQUENCE_NUMBER
,      MATRICULATION_START_DATE
,      MATRICULATION_END_DATE
,      INITIAL_ALTERNATE_CODE
,      INITIAL_CALENDAR_TYPE
,      INITIAL_SEQUENCE_NUMBER
,      INITIAL_START_DATE
,      INITIAL_END_DATE
,      RECENT_ALTERNATE_CODE
,      RECENT_CALENDAR_TYPE
,      RECENT_SEQUENCE_NUMBER
,      RECENT_START_DATE
,      RECENT_END_DATE
,      CATALOG_ALTERNATE_CODE
,      CATALOG_CALENDAR_TYPE
,      CATALOG_SEQUENCE_NUMBER
,      CATALOG_START_DATE
,      CATALOG_END_DATE
,      _LA:FURTHER_EDUCATION
,      _LA:RELIGION
,      _LA:SOCIAL_ECONOMIC
,      _DF
,      PERSON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ACADEMIC_CATALOGS;

Dependencies

[top of page]

APPS.IGSFV_ACADEMIC_CATALOGS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_CA_INST_ALL
SynonymIGS_PE_STAT_DETAILS

APPS.IGSFV_ACADEMIC_CATALOGS is not referenced by any database object