[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_STDNT_PS_ATT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_EN_STDNT_PS_ATT_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_EN_STDNT_PS_ATT_ALL describes a student's attempt at studying a particular program offered by the university.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_EN_STDNT_PS_ATT_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
COURSE_CD
|
| IGS_EN_STDNT_PS_ATT_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FUNDING_SOURCE
|
| IGS_EN_STDNT_PS_ATT_ALL_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EXAM_LOCATION_CD
|
| IGS_EN_STDNT_PS_ATT_ALL_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_ID
ADM_ADMISSION_APPL_NUMBER
ADM_NOMINATED_COURSE_CD
ADM_SEQUENCE_NUMBER
|
| IGS_EN_STDNT_PS_ATT_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COURSE_CD
VERSION_NUMBER
CAL_TYPE
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
|
| IGS_EN_STDNT_PS_ATT_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FEE_CAT
|
| IGS_EN_STDNT_PS_ATT_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DISCONTINUATION_REASON_CD
|
| IGS_EN_STDNT_PS_ATT_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DERIVED_ATT_TYPE
|
| IGS_EN_STDNT_PS_ATT_ALL_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DERIVED_ATT_MODE
|
| IGS_EN_STDNT_PS_ATT_ALL_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COO_ID
|
| IGS_EN_STDNT_PS_ATT_ALL_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CORRESPONDENCE_CAT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| COURSE_CD | VARCHAR2 | (6) | Yes | Code used to identify the program for that the student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Number signifying the version of the program for that the student enrolls. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Name of the calendar type for that the program is offered. It is usual for award programs to be offered in the standard academic calendar. |
| LOCATION_CD | VARCHAR2 | (10) | Yes | The location, typically a campus, from that the student's program is offered. |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Institution-defined attendance modes for that the program is offered. Institution-defined attendance modes may include, for example, N - On Campus, F - Off Campus, and M - Multi-modal. |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Institution-defined attendance type for that the program is offered. Institution-defined attendance types may include, for example, F - Full-time and P - Part-time. |
| COO_ID | NUMBER | (7) | Yes | Unique number that references the particular program offering option. |
| STUDENT_CONFIRMED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether a commencing student has confirmed their intention to enroll. Setting the checkbox changes the program status from UNCONFIRM to INACTIVE or ENROLLED and inserts the program commencement date. |
| COMMENCEMENT_DT | DATE | Date on that the student commenced the current program for the first time. See element 328 higher education student data collection documentation 1997, DETYA. | ||
| COURSE_ATTEMPT_STATUS | VARCHAR2 | (30) | Student program attempt status is a system derived value and will be one of the following - UNCONFIRMED, INACTIVE, ENROLLED, DISCONTINUED INTERMITTED, LAPSED, or COMPLETED. Under certain circumstances a program might also have been DELETED. | |
| PROGRESSION_STATUS | VARCHAR2 | (30) | Progression status of the student program attempt. The value will be one of EXCLUSION - student is currently excluded, EXPULSION - student has been expelled, GOODSTAND, SHOWCASUSE, SUSPENSION, UNDCONSID. | |
| DERIVED_ATT_TYPE | VARCHAR2 | (2) | Displays the institution-defined derived attendance type for the student's program attempt. Typically the value will be the code for full-time or the code for part-time. | |
| DERIVED_ATT_MODE | VARCHAR2 | (2) | Displays the institution-defined derived attendance mode for the student's program attempt. Typically the value would signify all units that are studied on campus, a code that signifies units that are taken up off campus, or multi-modal. | |
| PROVISIONAL_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student's admission and enrolment in the program is provisional. Setting the checkbox indicates that the program candidature is provisional. The indicator is maintained manually. |
| DISCONTINUED_DT | DATE | Effective date on that the student's program attempt was discontinued. | ||
| DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Identifies the primary reason behind the discontinuation of the student's program attempt. | |
| LAPSED_DT | DATE | Describes the date for that the student program attempt status was changed to lapsed. | ||
| FUNDING_SOURCE | VARCHAR2 | (10) | Funding Source applicable to the student's program attempt. A majority of students are funded from the Common wealth operating grant, however an increasing number of students are self-funded or paid for by industry. | |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | 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. | |
| DERIVED_COMPLETION_YR | NUMBER | (4) | Year that the student is expected to have completed all program requirements providing the current rate of progress is maintained. If a value exists in the Admissions sub system at the time of offer it is copied into this field by the pre-enrolment process. There afterthe value is maintained by the program progression checking processes. | |
| DERIVED_COMPLETION_PERD | VARCHAR2 | (1) | Period or part of the year, at that time the student is expected to have completed all program requirements provided they maintain their current rate of progress. | |
| NOMINATED_COMPLETION_YR | NUMBER | (4) | Year that the student considers they will have completed all program requirements. The student also nominates the expected period - Summer, Mid-year or End of Year of program completion. | |
| NOMINATED_COMPLETION_PERD | VARCHAR2 | (30) | Period, or part of the year, at that time the student considers they have completed all program requirements. The allowable values are SUMMER, MID, or END. The student also nominates the year of expected program completion. | |
| RULE_CHECK_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the system will check the student's academic record for program completion. Setting the indicator causes the system to check program completion rules. |
| WAIVE_OPTION_CHECK_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether 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. |
| LAST_RULE_CHECK_DT | DATE | Describes the date of the last complete rule check of the student's enrolment. | ||
| PUBLISH_OUTCOMES_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student is to have their results published in the press and or on public notice - boards. The indicator defaults to Y. |
| COURSE_RQRMNT_COMPLETE_IND | VARCHAR2 | (1) | Yes | Indicator that signifies the system has detected that the student program attempt is complete. When the student program attempt status to COMPLETED. |
| 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 program requirements was detected by the system following evaluation of rules, or set manually. | |
| OVERRIDE_TIME_LIMITATION | NUMBER | (4) | *** Future functionality. | |
| ADVANCED_STANDING_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether or not the student has been granted an amount of advanced standing that contributes towards the satisfaction of program requirements. |
| FEE_CAT | VARCHAR2 | (10) | Fee category applicable to the student's program attempt. Fee categories are used to define the set of fees and charges applicable to a student studying a particular program. | |
| CORRESPONDENCE_CAT | VARCHAR2 | (10) | 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 that will be sent to the student. | |
| SELF_HELP_GROUP_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student wants to participate in a self-help group for their enrolled program attempt. Setting the checkbox includes the student in the self-help group. |
| LOGICAL_DELETE_DT | DATE | Date on that the student's program attempt was logically deleted. | ||
| ADM_ADMISSION_APPL_NUMBER | NUMBER | (2) | Describes the admissions application number that resulted in the student program attempt. | |
| ADM_NOMINATED_COURSE_CD | VARCHAR2 | (6) | Describes the admissions program code that resulted in the student program attempt. | |
| ADM_SEQUENCE_NUMBER | NUMBER | (6) | Describes the admissions application sequence number that resulted in the student program attempt. | |
| IGS_PR_CLASS_STD_ID | NUMBER | (15) | Class Standing Override | |
| 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 | |
| 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 | |
| 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) | 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' | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Standard DFF Column | |
| FUTURE_DATED_TRANS_FLAG | VARCHAR2 | (1) | Yes | Future dated transfer flag |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COO_ID
, 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
, EXAM_LOCATION_CD
, 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
, CORRESPONDENCE_CAT
, SELF_HELP_GROUP_IND
, LOGICAL_DELETE_DT
, ADM_ADMISSION_APPL_NUMBER
, ADM_NOMINATED_COURSE_CD
, ADM_SEQUENCE_NUMBER
, IGS_PR_CLASS_STD_ID
, LAST_DATE_OF_ATTENDANCE
, DROPPED_BY
, 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
, PRIMARY_PROGRAM_TYPE
, PRIMARY_PROG_TYPE_SOURCE
, CATALOG_CAL_TYPE
, CATALOG_SEQ_NUM
, KEY_PROGRAM
, OVERRIDE_CMPL_DT
, MANUAL_OVR_CMPL_DT_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, FUTURE_DATED_TRANS_FLAG
FROM IGS.IGS_EN_STDNT_PS_ATT_ALL;
IGS.IGS_EN_STDNT_PS_ATT_ALL does not reference any database object
IGS.IGS_EN_STDNT_PS_ATT_ALL is referenced by following:
APPS
IGS_EN_STDNT_PS_ATT_ALL
|
|
|
|