[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_OFR_PAT_CRSVRSN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_OFR_PAT_CRSVRSN_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 program being offered |
VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the program being offered. There can only be one version of a program with a system status of active and an unset expiry date. |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | The academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization. |
ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The unique identifier for the academic calendar instance |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the calendar type relating to the admission period |
ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the sequence number that uniquely identifies the admission period calendar instance |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Describes the admission category that applies to this admission period |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Yes | 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
, ACAD_CI_SEQUENCE_NUMBER
, 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_CRSVRSN_V;
APPS.IGS_PS_OFR_PAT_CRSVRSN_V is not referenced by any database object
|
|
|