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

VIEW: APPS.IGSBV_PGM_OFR_PAT_ADM_DT

Object Details
Object Name: IGSBV_PGM_OFR_PAT_ADM_DT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_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_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.
DATE_ALIAS VARCHAR2 (10) Yes Describes the admission date alias that requires further process type, admission category, program offering option restrictions.
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.
APPLICATION_SEQUENCE_NUMBER NUMBER (6) Yes Uniquely defines information in this table.
_LA:PROCESS_TYPE_MEANING CHAR (81)
Describes the system admission process type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
NOMINATED_PROGRAM_CODE VARCHAR2 (6)
Describes the program code of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
PROGRAM_VERSION_NUMBER NUMBER (3)
Describes the program version number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ACADEMIC_CALENDAR_TYPE VARCHAR2 (10)
Describes the program offering calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
LOCATION_CODE VARCHAR2 (10)
Describes the location code of the admission date alias instance that requires further process type ,admission category, program offering option restrictions.
ATTENDANCE_MODE VARCHAR2 (2)
Describes the attendance mode of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ATTENDANCE_TYPE VARCHAR2 (2)
Describes the attendance type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
_LA:ROLLOVER_INCL_IND_FLAG CHAR (63)
Describes whether the admission period override date will be included in the admission calendar rollover process.
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
Query Text

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


SELECT ADMISSION_CALENDAR_TYPE
,      ADMISSION_CI_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      DATE_ALIAS
,      DAI_SEQUENCE_NUMBER
,      APPLICATION_SEQUENCE_NUMBER
,      _LA:PROCESS_TYPE_MEANING
,      NOMINATED_PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      ACADEMIC_CALENDAR_TYPE
,      LOCATION_CODE
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      _LA:ROLLOVER_INCL_IND_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_PGM_OFR_PAT_ADM_DT;

Dependencies

[top of page]

APPS.IGSBV_PGM_OFR_PAT_ADM_DT references the following:

SchemaAPPS
SynonymIGS_AD_PECRS_OFOP_DT

APPS.IGSBV_PGM_OFR_PAT_ADM_DT is not referenced by any database object