[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_OFR_PAT_APCOOD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_OFR_PAT_APCOOD_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. It also describes the relationship between admission periods, admission process types and admission categories.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_CD | VARCHAR2 | (6) | Yes | The unique identifier for a course being offered. |
VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the course being offered. There can only be one version of a course with a system status of ACTIVE and an unset EXPIRY DATE. |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | The academic calendar type in which the course is offered. A calendar type is the institution-defined name of a type of calendar used within the organisation. |
LOCATION_CD | VARCHAR2 | (10) | Yes | This field is the location name or code. The location represents a geographical location and may be used to indicate where courses and units can be offered. |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | The mode of attendance of the course offering pattern. |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | The attendance type of the course offering pattern. |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | This field describes the calendar type relating to the admission period |
ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field describes the sequence number which uniquely identifies the admission period calander instance. |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | This field describes the admission category that applies to this admission period. |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Yes | This field describes the system admission process type that applies to this admission period. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE_CD
, VERSION_NUMBER
, ACAD_CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ADMISSION_CAT
, S_ADMISSION_PROCESS_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_OFR_PAT_APCOOD_V;
|
|
|