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]

VIEW: APPS.IGSFV_PGM_OFR_PAT_ADM_DT

Object Details

Object Name:	IGSFV_PGM_OFR_PAT_ADM_DT
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_PGM_OFR_PAT_ADM_DT
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_CALENDAR_DESC	VARCHAR2	(30)		Description for the Calendar Instance
ADMISSION_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Describes the calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADMISSION_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the calendar sequence number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Describes the admission category of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADMISSION_CATEGORY_DESC	VARCHAR2	(60)	Yes	Description of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
DATE_ALIAS	VARCHAR2	(10)	Yes	Describes the admission date alias that requires further process type, admission category, program offering option restrictions.
DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of an event, that is not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendarcategory. For example Date alias are GOVERNMENT CENSUS DATE, LAST DAY OF LECTURES IN TEACHING PERIOD, and LAST DAY TO WITHDRAW FROM UNIT WITHOUT FAILING.
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number that defines the admission date alias instance that requires further process type, admission category, program offering option restrictions.
_LA:PROCESS_TYPE_MEANING	CHAR	(81)
NOMINATED_PROGRAM_CODE	VARCHAR2	(6)
PROGRAM_TITLE	VARCHAR2	(90)
PROGRAM_VERSION_NUMBER	NUMBER	(3)
ACADEMIC_CLENDAR_DESC	VARCHAR2	(30)
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)
ACADEMIC_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes
LOCATION_CODE	VARCHAR2	(10)
LOCATION_DESC	VARCHAR2	(60)
ATTENDANCE_MODE	VARCHAR2	(2)
ATTENDANCE_MODE_DESC	VARCHAR2	(60)
ATTENDANCE_TYPE	VARCHAR2	(2)
ATTENDANCE_TYPE_DESC	VARCHAR2	(60)
_LA:ROLLOVER_INCL_IND_FLAG	CHAR	(63)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT ADMISSION_CALENDAR_DESC
,      ADMISSION_CALENDAR_TYPE
,      ADMISSION_CI_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESC
,      DATE_ALIAS
,      DATE_ALIAS_DESCRIPTION
,      DAI_SEQUENCE_NUMBER
,      _LA:PROCESS_TYPE_MEANING
,      NOMINATED_PROGRAM_CODE
,      PROGRAM_TITLE
,      PROGRAM_VERSION_NUMBER
,      ACADEMIC_CLENDAR_DESC
,      ACADEMIC_CALENDAR_TYPE
,      ACADEMIC_CI_SEQUENCE_NUMBER
,      LOCATION_CODE
,      LOCATION_DESC
,      ATTENDANCE_MODE
,      ATTENDANCE_MODE_DESC
,      ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESC
,      _LA:ROLLOVER_INCL_IND_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PGM_OFR_PAT_ADM_DT;

Dependencies

[top of page]

APPS.IGSFV_PGM_OFR_PAT_ADM_DT references the following:

APPS: IGS_AD_CAT_ALL; IGS_AD_LOCATION_ALL; IGS_AD_PECRS_OFOP_DT; IGS_CA_DA; IGS_CA_INST_ALL; IGS_EN_ATD_MODE_ALL; IGS_EN_ATD_TYPE_ALL; IGS_PS_VER_ALL

APPS.IGSFV_PGM_OFR_PAT_ADM_DT is not referenced by any database object