[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_CANDIDATURE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_RE_CANDIDATURE_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ENCUMBERED_IND | VARCHAR2 | (4000) | ||
DECEASED_IND | VARCHAR2 | (1) | ||
API_PERSON_ID | VARCHAR2 | (20) | ||
PERSON_ID | NUMBER | (15) | Yes | This field describes the candidate person ID. |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | |
FULL_NAME | VARCHAR2 | (450) | Full name of the person | |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field describes a unique sequence number used to differentiate between different candidatures, where a student has more than one. |
SCA_COURSE_CD | VARCHAR2 | (6) | This field describes the student course attempt course code within which the research is being performed. This link is populated when a student is pre-enrolled in a new course attempt. | |
ACAI_ADMISSION_APPL_NUMBER | NUMBER | (2) | This field describes the admissions application number from which the candidature originated. | |
ACAI_NOMINATED_COURSE_CD | VARCHAR2 | (6) | This field describes the admissions nominated course code from which the candidature originated. | |
ACAI_SEQUENCE_NUMBER | NUMBER | (6) | This field describes the admissions application sequence number which resulted in the candidature. | |
CAV_COURSE_CD | VARCHAR2 | (6) | This field decribes the course code of the candidature. This will be the admission course application course code or the student course attempt course code. | |
CAV_COURSE_VERSION | VARCHAR2 | (47) | ||
CAV_ADMISSION_APPL_NUMBER | NUMBER | |||
CAV_NOMINATED_COURSE_CD | VARCHAR2 | (6) | ||
CAV_ADM_SEQUENCE_NUMBER | NUMBER | |||
ATTENDANCE_PERCENTAGE | NUMBER | (5) | This field describes the attendance percentage value of the student. eg. A part time student may have a 30% attendance. | |
GOVT_TYPE_OF_ACTIVITY_CD | VARCHAR2 | (10) | This field describes the government code describing the type of research activity which is being performed by the candidate. | |
MAX_SUBMISSION_DT | DATE | This field describes the latest date a thesis can be submitted. This date, if set, will override the value derived by the system. | ||
MIN_SUBMISSION_DT | DATE | This field describes the earliest date a thesis can be submitted. This date, if set, will override the value derived by the system. | ||
DERIVED_MAX_SUBMISSION_DT | DATE | |||
DERIVED_MIN_SUBMISSION_DT | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RESEARCH_TOPIC | VARCHAR2 | (2000) | This field describes the broad research topic of the candidature. More detailed descriptions are recorded against the thesis details. | |
INDUSTRY_LINKS | VARCHAR2 | (2000) | This field describes any industries associated with the thesis. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ENCUMBERED_IND
, DECEASED_IND
, API_PERSON_ID
, PERSON_ID
, PERSON_NUMBER
, FULL_NAME
, SEQUENCE_NUMBER
, SCA_COURSE_CD
, ACAI_ADMISSION_APPL_NUMBER
, ACAI_NOMINATED_COURSE_CD
, ACAI_SEQUENCE_NUMBER
, CAV_COURSE_CD
, CAV_COURSE_VERSION
, CAV_ADMISSION_APPL_NUMBER
, CAV_NOMINATED_COURSE_CD
, CAV_ADM_SEQUENCE_NUMBER
, ATTENDANCE_PERCENTAGE
, GOVT_TYPE_OF_ACTIVITY_CD
, MAX_SUBMISSION_DT
, MIN_SUBMISSION_DT
, DERIVED_MAX_SUBMISSION_DT
, DERIVED_MIN_SUBMISSION_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESEARCH_TOPIC
, INDUSTRY_LINKS
FROM APPS.IGS_RE_CANDIDATURE_V;
APPS.IGS_RE_CANDIDATURE_V is not referenced by any database object
|
|
|