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

VIEW: APPS.IGSBV_PGM_OFR_PAT_ADM_PERD

Object Details
Object Name: IGSBV_PGM_OFR_PAT_ADM_PERD
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_PGM_OFR_PAT_ADM_PERD
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 relating to the admission period.
ADMISSION_CI_SEQUENCE_NUMBER NUMBER (6) Yes Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CATEGORY VARCHAR2 (10) Yes Describes the admission category that the admission period is restricted to.
_LA:PROCESS_TYPE_MEANING CHAR (81)
NOMINATED_PROGRAM_CODE VARCHAR2 (6) Yes
PROGRAM_VERSION_NUMBER NUMBER (3) Yes
ACADEMIC_CALENDAR_TYPE VARCHAR2 (10) Yes
ACADEMIC_CI_SEQUENCE_NUMBER NUMBER (6) Yes
LOCATION_CODE VARCHAR2 (10)
ATTENDANCE_MODE VARCHAR2 (2)
ATTENDANCE_TYPE VARCHAR2 (2)
_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_TYPE
,      ADMISSION_CI_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      _LA:PROCESS_TYPE_MEANING
,      NOMINATED_PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      ACADEMIC_CALENDAR_TYPE
,      ACADEMIC_CI_SEQUENCE_NUMBER
,      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_PERD;

Dependencies

[top of page]

APPS.IGSBV_PGM_OFR_PAT_ADM_PERD references the following:

SchemaAPPS
SynonymIGS_AD_PRD_PS_OF_OPT

APPS.IGSBV_PGM_OFR_PAT_ADM_PERD is not referenced by any database object