[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_NON_ENR_STDOT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_NON_ENR_STDOT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AS_NON_ENR_STDOT_ALL describes an outcome for unit attempt in which student is not enrolled.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_NON_ENR_STDOT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
UNIT_CD VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER |
IGS_AS_NON_ENR_STDOT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
GRADING_SCHEMA_CD
GS_VERSION_NUMBER GRADE |
IGS_AS_NON_ENR_STDOT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
UNIT_CD
VERSION_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER |
IGS_AS_NON_ENR_STDOT_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COURSE_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | The person ID of the student for whom the non-enrolled outcome is entered. Non-enrolled outcomes are typically cases where students with an outcome are manually added to result sheets byassessors. In the majority of cases, the students are not currently enrolled in the unit. They areentered in ASSR5333 for resolution at a later date. |
UNIT_CD | VARCHAR2 | (10) | Yes | The unit code of the unit attempt for which the non-enrolled outcome isentered. Non-enrolled outcomes are typically cases where students with an outcome are manually added to result sheets by assessors. In the majority of cases, the students are not currently enrolled in the unit. They are recorded in ASSR5333 for resolution at a later date. |
VERSION_NUMBER | NUMBER | (3) | Yes | Describes the unit version number in which the student is enrolled |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar instance sequence number |
COURSE_CD | VARCHAR2 | (6) | The program attempt program code of the student for whom the non-enrolled outcome isentered. This field is optional and is normally only used if the relevantprogram attempt is known at the time of enterng the non-enrolled outcome. A non-enrolled outcome can only be entered if the student has at least one program attempt, of any status. | |
LOCATION_CD | VARCHAR2 | (10) | The location code of the location where the unit is being offered. A location code is a institution-defined code of a physical location owned or used by the institution. Each location has alocation type, such as campus, which defines its use in the system. | |
UNIT_MODE | VARCHAR2 | (10) | The unit mode of the unit attempt. A unit mode is a institution defined mode of offering a unit. For example, on-campus, off-campus. A list of values is available. | |
UNIT_CLASS | VARCHAR2 | (10) | The unit class of the unit attempt. A unit class is a institution-defined code that identifies a unit class. A list of values is available. | |
S_GRADE_CREATION_METHOD_TYPE | VARCHAR2 | (30) | Yes | Describes the creation method which was used to load the grade. For example, keying, upload. |
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Describes the creation method which was used to load the grade. For example keying, upload. | |
GS_VERSION_NUMBER | NUMBER | (3) | Describes the version number of the grading schema | |
GRADE | VARCHAR2 | (5) | A code which indicates the student's level of achievement in the unit attempt. A list of values is available. | |
MARK | NUMBER | (6) | A numeric code which indicates the student's level of achievement in the unit attempt. | |
RESOLVED_IND | VARCHAR2 | (1) | An indicator which specifies whether or not the non-enrolled outcome has been resolved, that is attributed to an enrolled student. This indicator provides the means to only report on non-enrolledoutcomes which are still a issue. Setting this indicator ticked means the non-enrolled outcome has been resolved. | |
COMMENTS | VARCHAR2 | (2000) | Any additional information or details about the outcome for a unit attempt in which the student is not enrolled. | |
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 | |
REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record. | |
PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record. | |
PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program. | ||
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, COURSE_CD
, LOCATION_CD
, UNIT_MODE
, UNIT_CLASS
, S_GRADE_CREATION_METHOD_TYPE
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, GRADE
, MARK
, RESOLVED_IND
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
FROM IGS.IGS_AS_NON_ENR_STDOT_ALL;
IGS.IGS_AS_NON_ENR_STDOT_ALL does not reference any database object
IGS.IGS_AS_NON_ENR_STDOT_ALL is referenced by following:
|
|
|