[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_SC_ATTEMPT_H_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AS_SC_ATTEMPT_H_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_AS_SC_ATTEMPT_H_ALL describes history of changes to student program attempt.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AS_SC_ATTEMPT_H_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
COURSE_CD
HIST_START_DT
|
| IGS_AS_SC_ATTEMPT_H_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COURSE_ATTEMPT_STATUS
|
| IGS_AS_SC_ATTEMPT_H_ALL_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUNDING_SOURCE
|
| IGS_AS_SC_ATTEMPT_H_ALL_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOCATION_CD
|
| IGS_AS_SC_ATTEMPT_H_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATTENDANCE_MODE
|
| IGS_AS_SC_ATTEMPT_H_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATTENDANCE_TYPE
|
| IGS_AS_SC_ATTEMPT_H_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CORRESPONDENCE_CAT
|
| IGS_AS_SC_ATTEMPT_H_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COURSE_CD
VERSION_NUMBER
CAL_TYPE
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
|
| IGS_AS_SC_ATTEMPT_H_ALL_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DISCONTINUATION_REASON_CD
|
| IGS_AS_SC_ATTEMPT_H_ALL_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FEE_CAT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Describes the ID that uniquely identifies a person |
| COURSE_CD | VARCHAR2 | (6) | Yes | Describes the course code. DEET element reference 307. |
| HIST_START_DT | DATE | Yes | The effective start date and time of the history record. | |
| HIST_END_DT | DATE | Yes | The effective end date and time of the history record. | |
| HIST_WHO | NUMBER | (15) | Yes | The Oracle username of the person who created the history record. |
| VERSION_NUMBER | NUMBER | (3) | Uniquely identifies each version of a course. | |
| CAL_TYPE | VARCHAR2 | (10) | The name of the calendar type in which the course is offered. It is usual for award courses to be offered in the standard academic calendar. | |
| LOCATION_CD | VARCHAR2 | (10) | Describes the location of the student course attempt | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Describes the code which identifies the mode of attendance by which the student undertook the course attempt. DEET element reference 329. | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Describes the code which identifies whether the student was classified as being a full-time or part-time student, based on their student load in the reference year, for the program attempt. DEET element reference 330. | |
| STUDENT_CONFIRMED_IND | VARCHAR2 | (1) | Indicates and specifies if a commencing student has confirmed their intention to enroll. Selecting the checkbox ticked changes the program status from unconfirm to inactive or enrolled and inserts the program commencement date. | |
| COMMENCEMENT_DT | DATE | Describes the date in which the student commenced the current program attempt. DEET element reference 328. | ||
| COURSE_ATTEMPT_STATUS | VARCHAR2 | (10) | Describes the status for the duration of the student program attempt history | |
| PROGRESSION_STATUS | VARCHAR2 | (10) | The progression status of the student program attempt. The value will be one of exclusion student is currently excluded, expulsion student has been expelled, goodstand student is in good sttanding, probation student is on probation, show cause student is eligible to show cause against progression outcomes, suspension student is currently suspended or, unconsid student has progression outcomes under consideration-. | |
| DERIVED_ATT_TYPE | VARCHAR2 | (2) | Displays the institution-defined derived attendance type for the student's course attempt. Typically the value will be F full time or P part-time. Institution-defined attendance types are mapped to element 330 of the higher education student data collection 1997, DETYA. | |
| DERIVED_ATT_MODE | VARCHAR2 | (2) | Displays the institution-defined derived attendance mode for the student's program attempt. Typically the value will be either N On Campus all units studied on campus, F off Campus all unitsstudied off campus or Multi-modal a mixture of on campus and off campus study. Modes are mapped to element 329 of the higher education student data collection 1997, DETYA. | |
| PROVISIONAL_IND | VARCHAR2 | (1) | Indicates and specifies if the student's admission and enrollment in the course is provisional. Setting the checkbox ticked indicates that the course candidature is provisional. The indicator is maintained manually. | |
| DISCONTINUED_DT | DATE | Describes the discontinuation date for the duration of the student course attempt history | ||
| DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Describes the discontinuation reason for the duration of the student program attempt history | |
| LAPSED_DT | DATE | Describes the date that the student program attempt was lapsed | ||
| FUNDING_SOURCE | VARCHAR2 | (10) | Describes the funding source for the duration of the student program attempt history | |
| FS_DESCRIPTION | VARCHAR2 | (60) | Funding source description | |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | The code of an examination center nominated by the student as their default examination location. This location is overridden if the student nominates a different location for a specific unit. | |
| ELO_DESCRIPTION | VARCHAR2 | (60) | Examination location description | |
| DERIVED_COMPLETION_YR | NUMBER | (4) | The year that the student is expected to have completed all course requirements providing the current rate of progress is maintained. If a value exists in theaAdmissions sub system it will be copied to this field by the pre-enrollment process. | |
| DERIVED_COMPLETION_PERD | VARCHAR2 | (1) | The period, or part of the year, that time the student is expected to have completed all course requirements provided they maintain their current rate of progress. | |
| NOMINATED_COMPLETION_YR | NUMBER | (4) | The year that the student considers they will have completed all course requirements. The student also nominates the expected period summer, mid-year or end of year of program completion. | |
| NOMINATED_COMPLETION_PERD | VARCHAR2 | (30) | The period, or part of the year, at which time the student considers they will have completed all course requirements. The allowable values are summer, MID -Mid-year- or end -end of year-. The student also nominates the year of expected course completion. | |
| RULE_CHECK_IND | VARCHAR2 | (1) | Indicates and specifies if the system will check the student's academic record for program completion. Selecting the indicator ticked causes the system to check program completion rules. De-selecting the indicator blank turns off system checking and the student's program completion status must be assessed manually. | |
| WAIVE_OPTION_CHECK_IND | VARCHAR2 | (1) | Indicates and specifies if any warnings applied as a result of forced element program offering option checks are waived. Checks are made of the student's location attendance mode and attendance type. Selecting the checkbox ticked waives the warnings. | |
| LAST_RULE_CHECK_DT | DATE | Describes the date of the last complete rule check of the student's enrollment | ||
| PUBLISH_OUTCOMES_IND | VARCHAR2 | (1) | Indicates and specifies if the student is to have their results published in the press and or on public notice boards. The indicator defaults to Y ticked. De-selecting the indicator suppresses publication of results except in a formal certificate of results or academic transcript. | |
| COURSE_RQRMNT_COMPLETE_IND | VARCHAR2 | (1) | Describes whether the system has detected the student's program requirements to be complete. If set, the student would be picked up by the graduation sub-system, gain academic organisational unit AOU approval and set the program attempt status to complete. | |
| COURSE_RQRMNTS_COMPLETE_DT | DATE | The date upon that program requirements were deemed to have been completed. | ||
| S_COMPLETED_SOURCE_TYPE | VARCHAR2 | (10) | Describes whether completion of course requirements was detected by the system following evaluation of rules, or set manually | |
| OVERRIDE_TIME_LIMITATION | NUMBER | (4) | Describes the time limitation for the duration of the student program attempt history | |
| ADVANCED_STANDING_IND | VARCHAR2 | (1) | Indicates and specifies if or not the student has been granted an amount of advanced standing which contributes towards the satisfaction o program requirements. Details of any approved and granted advanced standing are maintained in the advanced standing details form, ADVF4200. | |
| FEE_CAT | VARCHAR2 | (10) | Describes the category for the duration of the student program attempt history | |
| FC_DESCRIPTION | VARCHAR2 | (60) | Describes fee category | |
| CORRESPONDENCE_CAT | VARCHAR2 | (10) | The correspondence category applicable to the student's program attempt. Correspondence categories are used to define the set of system generated and non-system originated correspondence items which will be sent to the student. | |
| CC_DESCRIPTION | VARCHAR2 | (60) | Correspondence category description | |
| SELF_HELP_GROUP_IND | VARCHAR2 | (1) | Indicates and specifies if the student wishes to participate in a self-help group for their enrolled program attempt. Setting the checkbox ticked includes the student in the self-help group. De-selecting the checkbox removes the student from the self-help group listing. | |
| ADM_ADMISSION_APPL_NUMBER | NUMBER | (2) | Describes the admissions application number which resulted in the student program attempt | |
| ADM_NOMINATED_COURSE_CD | VARCHAR2 | (6) | Describes the admissions program code that results in the student program attempt | |
| ADM_SEQUENCE_NUMBER | NUMBER | (6) | Describes the admissions application sequence number which resulted in the student program attempt | |
| 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. | |
| LAST_DATE_OF_ATTENDANCE | DATE | Last date when the student attended | ||
| DROPPED_BY | VARCHAR2 | (30) | Person type of who dropped or discontinued the last Enrolled Unit | |
| PRIMARY_PROGRAM_TYPE | VARCHAR2 | (10) | Type of the program attempt. The value can be PRIMARY or SECONDARY | |
| PRIMARY_PROG_TYPE_SOURCE | VARCHAR2 | (10) | How the program type associated with the program type. Valid value can be "Manual" or "System" | |
| CATALOG_CAL_TYPE | VARCHAR2 | (10) | Calendar type for the catalogue. | |
| CATALOG_SEQ_NUM | NUMBER | (6) | Sequence number of the program attempt catalogue. | |
| KEY_PROGRAM | VARCHAR2 | (1) | Key Program Y/N Value | |
| OVERRIDE_CMPL_DT | DATE | Override Completion Date | ||
| MANUAL_OVR_CMPL_DT_IND | VARCHAR2 | (1) | Manual override completion date indicator. Possible values 'Y' and 'N'. If this column has a value of 'Y' then the completion date is overridden. Default value should be 'N' | |
| COO_ID | NUMBER | (7) | Course Offering Option ID | |
| IGS_PR_CLASS_STD_ID | NUMBER | (15) | Class Standing ID |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, STUDENT_CONFIRMED_IND
, COMMENCEMENT_DT
, COURSE_ATTEMPT_STATUS
, PROGRESSION_STATUS
, DERIVED_ATT_TYPE
, DERIVED_ATT_MODE
, PROVISIONAL_IND
, DISCONTINUED_DT
, DISCONTINUATION_REASON_CD
, LAPSED_DT
, FUNDING_SOURCE
, FS_DESCRIPTION
, EXAM_LOCATION_CD
, ELO_DESCRIPTION
, DERIVED_COMPLETION_YR
, DERIVED_COMPLETION_PERD
, NOMINATED_COMPLETION_YR
, NOMINATED_COMPLETION_PERD
, RULE_CHECK_IND
, WAIVE_OPTION_CHECK_IND
, LAST_RULE_CHECK_DT
, PUBLISH_OUTCOMES_IND
, COURSE_RQRMNT_COMPLETE_IND
, COURSE_RQRMNTS_COMPLETE_DT
, S_COMPLETED_SOURCE_TYPE
, OVERRIDE_TIME_LIMITATION
, ADVANCED_STANDING_IND
, FEE_CAT
, FC_DESCRIPTION
, CORRESPONDENCE_CAT
, CC_DESCRIPTION
, SELF_HELP_GROUP_IND
, ADM_ADMISSION_APPL_NUMBER
, ADM_NOMINATED_COURSE_CD
, ADM_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, LAST_DATE_OF_ATTENDANCE
, DROPPED_BY
, PRIMARY_PROGRAM_TYPE
, PRIMARY_PROG_TYPE_SOURCE
, CATALOG_CAL_TYPE
, CATALOG_SEQ_NUM
, KEY_PROGRAM
, OVERRIDE_CMPL_DT
, MANUAL_OVR_CMPL_DT_IND
, COO_ID
, IGS_PR_CLASS_STD_ID
FROM IGS.IGS_AS_SC_ATTEMPT_H_ALL;
IGS.IGS_AS_SC_ATTEMPT_H_ALL does not reference any database object
IGS.IGS_AS_SC_ATTEMPT_H_ALL is referenced by following:
APPS
IGS_AS_SC_ATTEMPT_H_ALL
|
|
|
|