[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_PAT_OF_STUDY |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_PAT_OF_STUDY |
Subobject Name: | |
Status: | VALID |
This entity describes a pattern of study, which applies to a program offering.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_PAT_OF_STUDY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COURSE_CD
VERSION_NUMBER CAL_TYPE SEQUENCE_NUMBER |
IGS_PS_PAT_OF_STUDY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_CD |
IGS_PS_PAT_OF_STUDY_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADMISSION_CAL_TYPE |
IGS_PS_PAT_OF_STUDY_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTENDANCE_MODE |
IGS_PS_PAT_OF_STUDY_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTENDANCE_TYPE |
IGS_PS_PAT_OF_STUDY_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADMISSION_CAT |
IGS_PS_PAT_OF_STUDY_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
APRVD_CI_SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code to that the pattern applies. |
VERSION_NUMBER | NUMBER | (3) | Yes | Describes the program version number to that the pattern applies. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the academic calendar type to that the pattern applies. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Allows uniqueness of different patterns of study for a single program offering. |
LOCATION_CD | VARCHAR2 | (10) | Location code to that the pattern of study applies. If a location is specified, the applicability of the pattern of study is restricted to program attempts with a matching location. | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Attendance mode to that the pattern of study applies. If an attendance mode is specified, the applicability of the pattern of study is restricted to program attempts with a matching attendance mode. | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Attendance type to that the pattern of study applies. If an attendance type is specified, the applicability of the pattern of study is restricted to program attempts with a matching attendance type. | |
UNIT_SET_CD | VARCHAR2 | (10) | Code of the unit set to that the pattern of study applies. If a unit set is specified, the applicability of the pattern of study is restricted to students enrolled in the same unit set within the program. | |
ADMISSION_CAL_TYPE | VARCHAR2 | (10) | Admission calendar type to that the pattern of study applies. If a calendar type is specified, the applicability of the pattern of study is restricted to students admitted to the program via an instance of the specified calendar type. | |
ADMISSION_CAT | VARCHAR2 | (10) | Code of the admission category to that the pattern of study applies. If an admission category is specified, the applicability of the pattern of study is restricted to students with the same program admission category. | |
APRVD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Describes the latest instance of the program offering academic calendar to that the pattern of study applies. If pre-enrollment is being performed for a later academic calendar, then the pattern of study is not applied. | |
NUMBER_OF_PERIODS | NUMBER | (2) | Yes | Number of academic periods or academic years in that students are pre-enrolled each time the pre-enrollment process is run . |
ALWAYS_PRE_ENROL_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether or not pre-enrollment in pattern of study units should always occur. When the checkbox is set ticked , unit pre-enrollment always takes place, regardless of the student's progress in the program. |
ACAD_PERD_UNIT_SET | VARCHAR2 | (1) | Academic Period within Unit Set | |
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
, CAL_TYPE
, SEQUENCE_NUMBER
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, UNIT_SET_CD
, ADMISSION_CAL_TYPE
, ADMISSION_CAT
, APRVD_CI_SEQUENCE_NUMBER
, NUMBER_OF_PERIODS
, ALWAYS_PRE_ENROL_IND
, ACAD_PERD_UNIT_SET
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_PAT_OF_STUDY;
IGS.IGS_PS_PAT_OF_STUDY does not reference any database object
IGS.IGS_PS_PAT_OF_STUDY is referenced by following:
|
|
|