[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_STDNT_PS_ATT_SV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_STDNT_PS_ATT_SV
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains the secured rows in the student program attempt table.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row ID | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier. | |
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled |
| VERSION_NUMBER | NUMBER | (3) | Yes | A number signifying the version of the course in which the student enrolls. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | The name of the calendar type in which the course is offered. |
| LOCATION_CD | VARCHAR2 | (10) | Yes | The name of the calendar type in which the course is offered. |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | The institution-defined attendance modes in which the course isoffered. Institution-defined attendance modes may include, forexample, N -On Campus, F -Off Campus and M -Multi-modal. |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | The institution-defined attendance type in which the course is offered. Institution-defined attendance types may include, forexample, F -Full-time and P-Part-time. |
| COO_ID | NUMBER | (7) | Yes | A unique number which references the particular course offering option. |
| STUDENT_CONFIRMED_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether a commencing student has confirmed their intention to enrol. Setting the checkbox ticked changes the course status from UNCONFIRM to INACTIVE or ENROLLED and inserts the course commencement date. |
| COMMENCEMENT_DT | DATE | The date on which the student commenced the current course for the first time. | ||
| COURSE_ATTEMPT_STATUS | VARCHAR2 | (30) | The student course 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 course may also have been DELETED. | |
| PROGRESSION_STATUS | VARCHAR2 | (30) | The progression status of the student course attempt. The value will be one of EXCLUSION-student is currently excluded ,EXPULSION student has been expelled , GOODSTAND -student is in goodstanding , PROBATION -student is on probation, SHOWCASUSE -student iseligible to show cause against progression outcomes , SUSPENSION-student is currently suspended or, UNDCONSID -student hasprogression 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 the code for full-time or the code for part-time. | |
| DERIVED_ATT_MODE | VARCHAR2 | (2) | Displays the institution-defined derived attendance mode for thestudent's course attempt. Typically the value will be either the codefor 'on' -all units studied on campus , the code for 'off' - all units studied off campus or multi-modal - a mixture of on campus and offcampus study | |
| PROVISIONAL_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the student's admission and enrolment in the course is provisional. Setting the checkbox ticked indicates that the course candidature is provisional. The indicator is maintained manually. |
| DISCONTINUED_DT | DATE | The effective date on which the student's course attempt was discontinued. | ||
| DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Identifies the primary reason behind the discontinuation of the student's course attempt. | |
| LAPSED_DT | DATE | This field describes the date on which the student course attempt status was changed to lapsed. | ||
| FUNDING_SOURCE | VARCHAR2 | (10) | The Funding Source applicable to the student's course attempt. | |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | The code of an examination centre 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) | The year in which the student is expected to have completed all course 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. Thereafter the value is maintained by course progression checking processes. | |
| DERIVED_COMPLETION_PERD | VARCHAR2 | (1) | The period, or part of the year, at which time the student is expectedto have completed all course requirements provided they maintain their current rate of progress. The allowable values are SUMMER, MID-Mid-year or END - End of Year . If a value exists in the Admissionssystem at the time of offer it is copied into this field by the pre-enrolment process. Thereafter the value is maintained by course progression checking processes. | |
| NOMINATED_COMPLETION_YR | NUMBER | (4) | The year in which 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 course 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 valuesare SUMMER, MID-Mid-year or END -End of Year . The student also nominates the year of expected course completion. | |
| RULE_CHECK_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the system will check the student's academic record for course completion. Setting the indicator ticked causes the system to check course completion rules. De-selecting the indicator blank turns off system checking and the student's course completion status must be assessed manually. |
| WAIVE_OPTION_CHECK_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether any warnings applied as a result of forced element course 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 | This field describes the date of the last complete rule check of the student's enrolment. | ||
| PUBLISH_OUTCOMES_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether 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 forma lcertificate of results or academic transcript. |
| COURSE_RQRMNT_COMPLETE_IND | VARCHAR2 | (1) | Yes | An indicator which signifies the system has detected that the student course attempt is complete. When set ticked processes within the Graduation subsystem are run to obtain Academic Organisational Unit AOU approval prior to setting the student course attempt status to COMPLETED. |
| COURSE_RQRMNTS_COMPLETE_DT | DATE | The date upon which course 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) | Future functionality. | |
| ADVANCED_STANDING_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether or not the student has been granted an amount of advanced standing which contributes towards the satisfaction of course requirements. |
| FEE_CAT | VARCHAR2 | (10) | The fee category applicable to the student's course attempt. | |
| CORRESPONDENCE_CAT | VARCHAR2 | (10) | The Correspondence Category applicable to the student's course attempt. Correspondence categories are used to definethe set of system generated and non-system originated correspondence items which will be sent to the student. | |
| SELF_HELP_GROUP_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the student wishes to participate in a self-help group for their enrolled course attempt.Setting the checkbox ticked includes the student in the self-helpgroup. De-selecting the checkbox removes the student from the self-help group listing. |
| LOGICAL_DELETE_DT | DATE | The date on which the student's course attempt was logically deleted. | ||
| ADM_ADMISSION_APPL_NUMBER | NUMBER | (2) | This field describes the admissions application number which resulted in the student course attempt. | |
| ADM_NOMINATED_COURSE_CD | VARCHAR2 | (6) | This field describes the admissions course code which resulted in the student course attempt. | |
| ADM_SEQUENCE_NUMBER | NUMBER | (6) | This field describes the admissions application sequence number which resulted in the student course attempt. | |
| LAST_DATE_OF_ATTENDANCE | DATE | Last Date Of Attendance | ||
| DROPPED_BY | VARCHAR2 | (30) | Dropped By | |
| IGS_PR_CLASS_STD_ID | NUMBER | (15) | Override Class Standing | |
| 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. | ||
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Standard Descriptive Flex Field Column. | |
| FUTURE_DATED_TRANS_FLAG | VARCHAR2 | (1) | Yes | Future dated transfer indicator |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, 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
, LAST_DATE_OF_ATTENDANCE
, DROPPED_BY
, IGS_PR_CLASS_STD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, 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 APPS.IGS_EN_STDNT_PS_ATT_SV;
APPS
IGS_EN_STDNT_PS_ATT_ALL
APPS
IGS_AD_PS_APPL_INST_CDT_CTXT_V
IGS_AS_PROGUGAI_ADI_V
IGS_EN_PE_PRG_CTXT_V
IGS_EN_PS_ATT_CH_OPT_V
IGS_EN_SCA_V
IGS_EN_SPAA_V
IGS_PR_STDNT_PR_OU_V
IGS_PR_STDNT_PS_ATT_V
IGS_PR_STD_PRG_AWD_AIM_V
|
|
|
|