[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_CDT_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_CDT_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_RE_CDT_HIST_ALL describes the history of a candidature. The histories are stored with an effective start and end date during that the details apply.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_CDT_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
SEQUENCE_NUMBER HIST_START_DT |
IGS_RE_CDT_HIST_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
SCA_COURSE_CD |
IGS_RE_CDT_HIST_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
ACAI_ADMISSION_APPL_NUMBER ACAI_NOMINATED_COURSE_CD ACAI_SEQUENCE_NUMBER |
IGS_RE_CDT_HIST_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GOVT_TYPE_OF_ACTIVITY_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Describes the candidate person identification number |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes a unique sequence number used to differentiate between different candidatures, where a student has more than one. |
HIST_START_DT | DATE | Yes | The effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | The effective end date and /time of the history record. | |
HIST_WHO | NUMBER | (15) | Yes | The 'updated by' person at the time of the history |
SCA_COURSE_CD | VARCHAR2 | (6) | Describes the student program attempt program code within that the research is being performed. This link is populated when a student is pre-enrolled in a new program attempt. | |
ACAI_ADMISSION_APPL_NUMBER | NUMBER | (2) | Describes the admissions application number from that the candidature originated. | |
ACAI_NOMINATED_COURSE_CD | VARCHAR2 | (6) | Describes the admissions nominated program code from that the candidature originated. | |
ACAI_SEQUENCE_NUMBER | NUMBER | (6) | Describes the admissions application sequence number that resulted in the candidature. | |
ATTENDANCE_PERCENTAGE | NUMBER | (5) | Describes the attendance percentage value of the student. For example, a part time student can have a 30% attendance. | |
GOVT_TYPE_OF_ACTIVITY_CD | VARCHAR2 | (10) | Describes the government code describing the type of research activity that is being performed by the candidate. | |
MAX_SUBMISSION_DT | DATE | Describes the latest date a thesis can be submitted. This date, if selected, will override the value derived by the system. | ||
MIN_SUBMISSION_DT | DATE | Describes the earliest date a thesis can be submitted. This date, if selected, will override the value derived by the system. | ||
RESEARCH_TOPIC | VARCHAR2 | (2000) | Describes the broad research topic of the candidature. More detailed descriptions are entered against the thesis details. | |
INDUSTRY_LINKS | VARCHAR2 | (2000) | Describes any industries associated with the thesis | |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, SEQUENCE_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, SCA_COURSE_CD
, ACAI_ADMISSION_APPL_NUMBER
, ACAI_NOMINATED_COURSE_CD
, ACAI_SEQUENCE_NUMBER
, ATTENDANCE_PERCENTAGE
, GOVT_TYPE_OF_ACTIVITY_CD
, MAX_SUBMISSION_DT
, MIN_SUBMISSION_DT
, RESEARCH_TOPIC
, INDUSTRY_LINKS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_RE_CDT_HIST_ALL;
IGS.IGS_RE_CDT_HIST_ALL does not reference any database object
IGS.IGS_RE_CDT_HIST_ALL is referenced by following:
|
|
|