[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_RE_THESIS_HIST_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_RE_THESIS_HIST_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_RE_THESIS_HIST_ALL describes the history of statuses of a thesis.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_RE_THESIS_HIST_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
CA_SEQUENCE_NUMBER
SEQUENCE_NUMBER
HIST_START_DT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Describes the person identifier number of the candidate preparing the thesis |
| CA_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the candidature sequence number |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the sequence number allocated to the thesis to give it uniqueness |
| 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 |
| TITLE | VARCHAR2 | (2000) | Describes the title of the research student's thesis | |
| FINAL_TITLE_IND | VARCHAR2 | (1) | Indicates and specifies if the nominated title is the final title for the thesis, or a working title. Selecting the check box indicates the thesis title is final | |
| SHORT_TITLE | VARCHAR2 | (100) | Describes the short title of the thesis | |
| ABBREVIATED_TITLE | VARCHAR2 | (40) | Contains the abbreviated title of the thesis | |
| THESIS_RESULT_CD | VARCHAR2 | (10) | Describes the final result which has been allocated to the thesis. This result must be mapped to a system result of type final | |
| EXPECTED_SUBMISSION_DT | DATE | The date on that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit. | ||
| DATE_OF_LIBRARY_LODGEMENT | DATE | Contains the date the research student's thesis was lodged in the library | ||
| LIBRARY_CATALOGUE_NUMBER | VARCHAR2 | (20) | Contains the library catalogue number of the thesis | |
| EMBARGO_EXPIRY_DT | DATE | The expiry date of any embargo placed on the release of the thesis | ||
| THESIS_FORMAT | VARCHAR2 | (60) | Describes the format of the thesis | |
| LOGICAL_DELETE_DT | DATE | Contains the date the record was logically deleted | ||
| EMBARGO_DETAILS | VARCHAR2 | (2000) | Records the details of any embargo placed on the release of the thesis | |
| THESIS_TOPIC | VARCHAR2 | (2000) | Describes the topic of the thesis | |
| CITATION | VARCHAR2 | (2000) | Contains citation information to be read during a graduation ceremony | |
| COMMENTS | VARCHAR2 | (2000) | Provides any comments about the thesis for the research student | |
| 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
, CA_SEQUENCE_NUMBER
, SEQUENCE_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, TITLE
, FINAL_TITLE_IND
, SHORT_TITLE
, ABBREVIATED_TITLE
, THESIS_RESULT_CD
, EXPECTED_SUBMISSION_DT
, DATE_OF_LIBRARY_LODGEMENT
, LIBRARY_CATALOGUE_NUMBER
, EMBARGO_EXPIRY_DT
, THESIS_FORMAT
, LOGICAL_DELETE_DT
, EMBARGO_DETAILS
, THESIS_TOPIC
, CITATION
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_RE_THESIS_HIST_ALL;
IGS.IGS_RE_THESIS_HIST_ALL does not reference any database object
IGS.IGS_RE_THESIS_HIST_ALL is referenced by following:
APPS
IGS_RE_THESIS_HIST_ALL
|
|
|
|