[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_STUDENT_PROGRAM_ATTEMPTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_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. |
| 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_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. | ||
| 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 the student'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, or multi-modal. | |
| PROVISIONAL_INDICATOR | 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_DATE | DATE | Effective date on that 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 that 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 - Summer, Mid-year or End of Year of program completion. | |
| NOMINATED_COMPLETION_PERIOD | VARCHAR2 | (30) | Period, or part of the year, at which 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 which program requirement 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 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_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 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 |
| CALENDAR_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of Calendar Type |
| LOCATION_CODE_DESC | VARCHAR2 | (60) | Yes | Description of location code |
| ATTENDANCE_MODE_DESC | VARCHAR2 | (60) | Yes | Description of attendance mode |
| ATTENDANCE_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of attendance mode |
| DERIVED_ATTENDANCE_MODE_DESC | VARCHAR2 | (60) | Description of derived attendance mode | |
| DERIVED_ATTENDANCE_TYPE_DESC | VARCHAR2 | (60) | Description of derived Attendance type | |
| CORRESPONDENCE_CAT_DESC | VARCHAR2 | (60) | Description of Correspondence category | |
| CATALOG_CAL_TYPE_DESC | VARCHAR2 | (30) | Description of Catalog Calendar type | |
| DISCONT_REASON_CODE_DESC | VARCHAR2 | (60) | Description of Reason Code | |
| COMPLETION_PERIOD_DESC | VARCHAR2 | (80) | Description of Completion period | |
| FEE_CATEGORY_DESC | VARCHAR2 | (60) | Description of Fee Category | |
| FUNDING_SOURCE_DESC | VARCHAR2 | (60) | Description of Funding Source | |
| EXAM_LOCATION_CODE_DESC | VARCHAR2 | (60) | Description of Examination Location code | |
| CLASS_STANDING | VARCHAR2 | (50) | Class Standing | |
| _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 | |
| _DF | CHAR | (33) | Descriptive Flex Field | |
| 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
, CAL_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
, CALENDAR_TYPE_DESC
, LOCATION_CODE_DESC
, ATTENDANCE_MODE_DESC
, ATTENDANCE_TYPE_DESC
, DERIVED_ATTENDANCE_MODE_DESC
, DERIVED_ATTENDANCE_TYPE_DESC
, CORRESPONDENCE_CAT_DESC
, CATALOG_CAL_TYPE_DESC
, DISCONT_REASON_CODE_DESC
, COMPLETION_PERIOD_DESC
, FEE_CATEGORY_DESC
, FUNDING_SOURCE_DESC
, EXAM_LOCATION_CODE_DESC
, CLASS_STANDING
, _LA:PROG_ATTEMPT_STAT_DESC
, _LA:PROGRESSION_STATUS_DESC
, _LA:PRIMARY_PROG_TY_SRC_DESC
, _DF
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, FUTURE_DATED_TRANS_FLAG
FROM APPS.IGSFV_STUDENT_PROGRAM_ATTEMPTS;
APPS
HZ_PARTIES
IGS_AD_LOCATION_ALL
IGS_CA_INST_ALL
IGS_CA_TYPE
IGS_CO_CAT
IGS_EN_ATD_MODE_ALL
IGS_EN_ATD_TYPE_ALL
IGS_EN_DCNT_REASONCD_ALL
IGS_EN_NOM_CMPL_PRD
IGS_EN_STDNT_PS_ATT_ALL
IGS_FI_FEE_CAT_ALL
IGS_FI_FUND_SRC_ALL
IGS_PR_CLASS_STD
IGS_PS_VER_ALL
APPS.IGSFV_STUDENT_PROGRAM_ATTEMPTS is not referenced by any database object
|
|
|
|