[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_PS_ATT_CH_OPT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_PS_ATT_CH_OPT_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Identifier. |
| 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. |
| COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA. |
| VERSION_NUMBER | NUMBER | (3) | Yes | A number signifying the version of the course in which the student enrols. |
| COURSE_ATTEMPT_STATUS | VARCHAR2 | (30) | The student course attempt status is a system derived value and wil lbe one of the following: UNCONFIRMED, INACTIVE, ENROLLED, DISCONTINUED,INTERMITTED, LAPSED or COMPLETED. Under certain circumstances a course may also have been DELETED. | |
| FULL_NAME | VARCHAR2 | (450) | The concatenated name of the person's first , middle and last name. | |
| SEX | VARCHAR2 | (30) | This gives the code for sex of the person. | |
| SEX_MEANING | VARCHAR2 | (80) | This field describes the meaning of the sex code . for example M-male so on. | |
| BIRTH_DT | DATE | This field gives the date of birth for the person. | ||
| API_PERSON_ID | VARCHAR2 | (20) | This field gives the alternate ID for a person with the given person ID. | |
| DECEASED_IND | VARCHAR2 | (1) | This is an indicator which specifies wether the person is alive or deceased.It is checked to indicate a deceased person. | |
| ENCUMBERED_IND | VARCHAR2 | (4000) | This is an indicator which specifies wether the student is having any fee holds or not. By checking it the student record will be checked for fee holds. | |
| COURSE_TITLE | VARCHAR2 | (90) | Yes | The title or full name of the course. DETYA element 308. |
| COURSE_CD_VERSION | VARCHAR2 | (47) | A number signifying the version of the course in which the student enrols. | |
| COO_ID | NUMBER | (7) | Yes | A unique number which references the particular course offering option. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | 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) | Yes | The location, typically a campus, from where the student's course is offered. |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | The institution-defined attendance modes in which the course is offered. Institution-defined attendance modes may include, forexample, N -On Campus , F -Off Campus and M- Multi-modal .See also Element 329 Higher Education Student Data CollectionDocumentation 1997, DETYA.When displayed in the Student Course Attempt Inquiry IINQF1200 this field displays the derived attendance mode and attendance type for ENROLLED courses. |
| 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. See also Element 330 HigherEducation Student Data Collection Documentation 1997, DETYA. |
| COMMENCEMENT_DT | DATE | The date on which the student commenced the current course for the first time. See Element 328 Higher EducationStudent Data Collection Documentation 1997, DETYA. | ||
| DISCONTINUATION_REASON_CD | VARCHAR2 | (10) | Identifies the primary reason behind the discontinuation of 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. | |
| 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. | |
| FEE_CAT | VARCHAR2 | (10) | The fee category applicable to the student's course attempt.Fee categories are used to define the set of fees and charges applicable to a student studying a particular course. | |
| FUNDING_SOURCE | VARCHAR2 | (10) | The Funding Source applicable to the student's course attempt.A majority of students are funded from the Commonwealth operating rant, however an increasing number of students are self-funded or paid for by industry. | |
| RULE_CHECK_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether the system willcheck 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. |
| 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. Details of any approved and granted advanced standing are maintained in the AdvancedStanding Details form, ADVF4200. |
| 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 formal certificate of results or academic transcript. |
| 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. |
| 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-help group. De-selecting the checkbox removes the student from the self-help group listing. |
| DISCONTINUED_DT | DATE | The effective date on which the student's course attempt was discontinued. | ||
| LAPSED_DT | DATE | This field describes the date on which the student course attempt status was changed to lapsed. | ||
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, STUDENT_CONFIRMED_IND
, COURSE_CD
, VERSION_NUMBER
, COURSE_ATTEMPT_STATUS
, FULL_NAME
, SEX
, SEX_MEANING
, BIRTH_DT
, API_PERSON_ID
, DECEASED_IND
, ENCUMBERED_IND
, COURSE_TITLE
, COURSE_CD_VERSION
, COO_ID
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, COMMENCEMENT_DT
, DISCONTINUATION_REASON_CD
, CORRESPONDENCE_CAT
, EXAM_LOCATION_CD
, FEE_CAT
, FUNDING_SOURCE
, RULE_CHECK_IND
, WAIVE_OPTION_CHECK_IND
, ADVANCED_STANDING_IND
, PUBLISH_OUTCOMES_IND
, PROVISIONAL_IND
, SELF_HELP_GROUP_IND
, DISCONTINUED_DT
, LAPSED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_PS_ATT_CH_OPT_V;
APPS
IGS_EN_GEN_003
- show dependent code
IGS_EN_GEN_007
- show dependent code
IGS_EN_STDNT_PS_ATT_SV
IGS_PE_PERSON_V
IGS_PS_VER
APPS.IGS_EN_PS_ATT_CH_OPT_V is not referenced by any database object
|
|
|
|