[Home] [Help] [Dependency Information]
Object Name: | IGSBV_STUDENT_PROGRAM_ATTEMPTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_STUDENT_PROGRAM_ATTEMPTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity describes a student's attempt at studying a particular course offered by the university.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
PROGRAM_CODE | 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. |
CALENDAR_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_CODE | VARCHAR2 | (10) | Yes | The location, typically a campus, from which 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_INDICATOR | 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_DATE | DATE | Date on which the student commenced the current program for the first time. See element 328 higher education student data collection documentation 1997, DETYA. | ||
PROGRAM_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 , EXPULSION , GOODSTAND, PROBATION , SHOWCASUSE, SUSPENSION or, UNDCONSID . | |
DERIVED_ATTENDANCE_TYPE | VARCHAR2 | (2) | Displays the institution-defined derived attendance type for testament's program attempt. Typically the value will be the code for full-time or the code for part-time. | |
DERIVED_ATTENDANCE_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, off campus study. | |
PROVISIONAL_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether the student's admission and enrollment in the program is provisional. Setting the checkbox indicates that the program candidature is provisional. The indicator is maintained manually. |
DISCONTINUED_DATE | DATE | Effective date on which the student's program attempt was discontinued. | ||
DISCONTINUATION_REASON_CODE | VARCHAR2 | (10) | Identifies the primary reason behind the discontinuation of the student's program attempt. | |
LAPSED_DATE | 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. | |
EXAM_LOCATION_CODE | 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_YEAR | NUMBER | (4) | Year that the student is expected to have completed all program requirements providing the current rate of progress is maintained. | |
DERIVED_COMPLETION_PERIOD | VARCHAR2 | (1) | Period or part of the year, at which time the student is expected to have completed all program requirements, provided they maintain their current rate of progress. | |
NOMINATED_COMPLETION_YEAR | NUMBER | (4) | Year that the student considers they will have completed all program requirements. The student also nominates the expected period completion. | |
NOMINATED_COMPLETION_PERIOD | VARCHAR2 | (30) | Period, or part of the year, at that time the student considers they will have completed all program requirements. The student also nominates the year of expected program completion. | |
RULE_CHECK_INDICATOR | 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_INDICATOR | 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_DATE | DATE | Describes the date of the last complete rule check of the student's enrolment. | ||
PUBLISH_OUTCOMES_INDICATOR | 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. |
PROGRAM_RQRMNT_COMPLETE_IND | VARCHAR2 | (1) | Yes | Indicator that signifies the system has detected that the student program attempt is complete. |
PROGRAM_RQRMNTS_COMPLETE_DATE | DATE | The dates upon those 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_INDICATOR | 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_CATEGORY | 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_CATEGORY | 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_INDICATOR | 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_DATE | DATE | Date on which 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_PROGRAM_CODE | 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. | |
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 | |
IGS_PR_CLASS_STD_ID | NUMBER | (15) | Class Standing Override | |
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 primary program type associated with the program type. Valid value can be "Manual" or "System" | |
CATALOG_CALENDAR_TYPE | VARCHAR2 | (10) | Calendar type for the catalogue. | |
CATALOG_SEQUENCE_NUM | NUMBER | (6) | Sequence number of the program attempt catalogue. | |
KEY_PROGRAM | VARCHAR2 | (1) | Y/N Value | |
OVERRIDE_COMPLETION_DATE | DATE | Override Completion Date | ||
MANUAL_OVR_CMPL_DATE_INDICATOR | 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' | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Describes the person number for a person id |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title of program code |
_LA:PROG_ATTEMPT_STAT_DESC | CHAR | (70) | Description of Program attempt status | |
_LA:PROGRESSION_STATUS_DESC | CHAR | (67) | Description of Progression status | |
_LA:PRIMARY_PROG_TY_SRC_DESC | CHAR | (71) | Description of Primary Program type source | |
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 | |
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
, PROGRAM_CODE
, VERSION_NUMBER
, CALENDAR_TYPE
, LOCATION_CODE
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COO_ID
, STUDENT_CONFIRMED_INDICATOR
, COMMENCEMENT_DATE
, PROGRAM_ATTEMPT_STATUS
, PROGRESSION_STATUS
, DERIVED_ATTENDANCE_TYPE
, DERIVED_ATTENDANCE_MODE
, PROVISIONAL_INDICATOR
, DISCONTINUED_DATE
, DISCONTINUATION_REASON_CODE
, LAPSED_DATE
, FUNDING_SOURCE
, EXAM_LOCATION_CODE
, DERIVED_COMPLETION_YEAR
, DERIVED_COMPLETION_PERIOD
, NOMINATED_COMPLETION_YEAR
, NOMINATED_COMPLETION_PERIOD
, RULE_CHECK_INDICATOR
, WAIVE_OPTION_CHECK_INDICATOR
, LAST_RULE_CHECK_DATE
, PUBLISH_OUTCOMES_INDICATOR
, PROGRAM_RQRMNT_COMPLETE_IND
, PROGRAM_RQRMNTS_COMPLETE_DATE
, S_COMPLETED_SOURCE_TYPE
, OVERRIDE_TIME_LIMITATION
, ADVANCED_STANDING_INDICATOR
, FEE_CATEGORY
, CORRESPONDENCE_CATEGORY
, SELF_HELP_GROUP_INDICATOR
, LOGICAL_DELETE_DATE
, ADM_ADMISSION_APPL_NUMBER
, ADM_NOMINATED_PROGRAM_CODE
, ADM_SEQUENCE_NUMBER
, LAST_DATE_OF_ATTENDANCE
, DROPPED_BY
, IGS_PR_CLASS_STD_ID
, PRIMARY_PROGRAM_TYPE
, PRIMARY_PROG_TYPE_SOURCE
, CATALOG_CALENDAR_TYPE
, CATALOG_SEQUENCE_NUM
, KEY_PROGRAM
, OVERRIDE_COMPLETION_DATE
, MANUAL_OVR_CMPL_DATE_INDICATOR
, PERSON_NUMBER
, PROGRAM_TITLE
, _LA:PROG_ATTEMPT_STAT_DESC
, _LA:PROGRESSION_STATUS_DESC
, _LA:PRIMARY_PROG_TY_SRC_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, FUTURE_DATED_TRANS_FLAG
FROM APPS.IGSBV_STUDENT_PROGRAM_ATTEMPTS;
APPS.IGSBV_STUDENT_PROGRAM_ATTEMPTS is not referenced by any database object
|
|
|