[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_SCA_STATUS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_SCA_STATUS_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. |
| TITLE | VARCHAR2 | (60) | The title or full name of the course. DETYA element 308. | |
| SURNAME | VARCHAR2 | (150) | This field gives the first name of the person. | |
| GIVEN_NAMES | VARCHAR2 | (150) | This field gives the last name of a student. | |
| PREFERRED_GIVEN_NAME | VARCHAR2 | (240) | The preferred name of the student. | |
| SEX | VARCHAR2 | (30) | This gives the code for the sex of the person. | |
| BIRTH_DT | DATE | The field for the date of birth of a person. | ||
| EMAIL_ADDR | VARCHAR2 | (2000) | The email-address of the student. | |
| ORACLE_USERNAME | VARCHAR2 | (100) | The username of the user who enters this student record. | |
| STAFF_MEMBER_IND | VARCHAR2 | (4000) | This is an indicator which specifies wether the the person entering this record is a staff member.it is checked to indicate a staff member. | |
| DECEASED_IND | VARCHAR2 | (1) | This is an indicator to specify wether the student is alive or deceased. it is checked to indicate the person is deceased. | |
| CONTEXT_BLOCK_NAME | VARCHAR2 | (455) | This field is a concatenation of the first name,last name of the person. | |
| COURSE_CD | VARCHAR2 | (6) | 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) | A number signifying the version of the course in which the student enrols. | |
| CRS_VERSION | VARCHAR2 | (47) | This field is course code-version number | |
| 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. | |
| LOCATION_CD | VARCHAR2 | (10) | The location, typically a campus, from where the student's course is offered. | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | 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 INQF1200 this field displays the derived attendance mode and attendance type for ENROLLED courses. | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | 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. | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| API_PERSON_ID | VARCHAR2 | (20) | ||
| PRE_NAME_ADJUNCT_MEANING | VARCHAR2 | (80) | ||
| SUFFIX | VARCHAR2 | (30) | ||
| MIDDLE_NAME | VARCHAR2 | (60) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PERSON_NUMBER
, TITLE
, SURNAME
, GIVEN_NAMES
, PREFERRED_GIVEN_NAME
, SEX
, BIRTH_DT
, EMAIL_ADDR
, ORACLE_USERNAME
, STAFF_MEMBER_IND
, DECEASED_IND
, CONTEXT_BLOCK_NAME
, COURSE_CD
, VERSION_NUMBER
, CRS_VERSION
, COURSE_ATTEMPT_STATUS
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, API_PERSON_ID
, PRE_NAME_ADJUNCT_MEANING
, SUFFIX
, MIDDLE_NAME
FROM APPS.IGS_EN_SCA_STATUS_V;
APPS
IGS_EN_GEN_003
- show dependent code
IGS_EN_GEN_007
- show dependent code
IGS_EN_STDNT_PS_ATT
IGS_PE_PERSON_V
APPS.IGS_EN_SCA_STATUS_V is not referenced by any database object
|
|
|
|