[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_OFR_OPT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_OFR_OPT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_OFR_OPT_ALL describes the available options for each program offering.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_OFR_OPT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COURSE_CD
VERSION_NUMBER CAL_TYPE LOCATION_CD ATTENDANCE_MODE ATTENDANCE_TYPE |
IGS_PS_OFR_OPT_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | COO_ID |
IGS_PS_OFR_OPT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTENDANCE_TYPE |
IGS_PS_OFR_OPT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTENDANCE_MODE |
IGS_PS_OFR_OPT_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENR_OFFICER_PERSON_ID |
IGS_PS_OFR_OPT_ALL_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_CD | VARCHAR2 | (6) | Yes | Code used to identify the program in that the student is enrolled. |
VERSION_NUMBER | NUMBER | (3) | Yes | 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. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Academic calendar type in that the program is offered. For example, ACAD-YR that is standard academic Year. |
LOCATION_CD | VARCHAR2 | (10) | Yes | Location code, or campus, of the program offering option. |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Mode of attendance of the program offering option. |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Attendance type of the program offering option. |
COO_ID | NUMBER | (7) | Yes | Unique number that references the particular program offering option. |
FORCED_LOCATION_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student program attempt location is forced or restricted. |
FORCED_ATT_MODE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student program attempt attendance mode is forced or restricted. |
FORCED_ATT_TYPE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student program attempt attendance type is forced or restricted. |
TIME_LIMITATION | NUMBER | (4) | Time limit in years for completion of the program offering option. Students who exceed this limit can be asked to show cause why they should not be excluded from further enrollment in the program. | |
ENR_OFFICER_PERSON_ID | NUMBER | (15) | The ID of a staff member recognized as the enrollment officer for the program offering option. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute category for descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE16 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE17 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE18 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE19 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
ATTRIBUTE20 | VARCHAR2 | (150) | Attribute for descriptive Flexfield | |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
PROGRAM_LENGTH | NUMBER | (10) | The time frame in which a student is expected to complete the program. | |
PROGRAM_LENGTH_MEASUREMENT | VARCHAR2 | (30) | The measurement used to determine program length. | |
DELETE_FLAG | VARCHAR2 | (1) | This indicator to indicate a record is logically deleted or not. If set to 'Y' the record is logically deleted else not. |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE_CD
, VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COO_ID
, FORCED_LOCATION_IND
, FORCED_ATT_MODE_IND
, FORCED_ATT_TYPE_IND
, TIME_LIMITATION
, ENR_OFFICER_PERSON_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, PROGRAM_LENGTH
, PROGRAM_LENGTH_MEASUREMENT
, DELETE_FLAG
FROM IGS.IGS_PS_OFR_OPT_ALL;
IGS.IGS_PS_OFR_OPT_ALL does not reference any database object
IGS.IGS_PS_OFR_OPT_ALL is referenced by following:
|
|
|