[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_LGCY_THE_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_LGCY_THE_INT |
Subobject Name: | |
Status: | VALID |
Contains Research Thesis information to be imported into the IGS_RE_THESIS_ALL table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Thesis
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_LGCY_THE_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | LEGACY_RE_THE_INT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | Batch Identifier, used to identify the set of records to be processed. |
LEGACY_RE_THE_INT_ID | NUMBER | (15) | Yes | Unique identifier of the Thesis and Thesis Exam record. |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number of the research candidate. |
PROGRAM_CD | VARCHAR2 | (6) | Yes | The program code in which research is being conducted. |
TITLE | VARCHAR2 | (2000) | Yes | 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) | The short title of the thesis. | |
ABBREVIATED_TITLE | VARCHAR2 | (40) | The abbreviated title of the thesis. | |
FINAL_THESIS_RESULT_CD | VARCHAR2 | (10) | Describes the final result that has been allocated to the thesis. This result must be mapped to a system result of type final. | |
EXPECTED_SUBMISSION_DT | DATE | The date that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit. | ||
LIBRARY_LODGEMENT_DT | DATE | Contains the date the research students thesis was lodged in the library. | ||
LIBRARY_CATALOGUE_NUMBER | VARCHAR2 | (300) | 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. | |
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) | General comments. | |
SUBMISSION_DT | DATE | The date that the thesis was submitted for examination. | ||
THESIS_EXAM_TYPE | VARCHAR2 | (10) | The type of examination that is being undertaken. For example, written, performance, oral. Must be an uppercase value. | |
THESIS_PANEL_TYPE | VARCHAR2 | (10) | The type of panel used for the thesis examination. Must be an uppercase value. | |
THESIS_RESULT_CD | VARCHAR2 | (10) | The thesis result that is an outcome of the panel members having provided their recommended results. Must be an uppercase value. | |
IMPORT_STATUS | VARCHAR2 | (1) | Record's Import status. | |
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 | |
REQUEST_ID | NUMBER | (15) | Standard concurrent program who column | |
PROGRAM_ID | NUMBER | (15) | Standard concurrent program who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard concurrent program who column | |
PROGRAM_UPDATE_DATE | DATE | Standard concurrent program who column |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, LEGACY_RE_THE_INT_ID
, PERSON_NUMBER
, PROGRAM_CD
, TITLE
, FINAL_TITLE_IND
, SHORT_TITLE
, ABBREVIATED_TITLE
, FINAL_THESIS_RESULT_CD
, EXPECTED_SUBMISSION_DT
, LIBRARY_LODGEMENT_DT
, LIBRARY_CATALOGUE_NUMBER
, EMBARGO_EXPIRY_DT
, THESIS_FORMAT
, EMBARGO_DETAILS
, THESIS_TOPIC
, CITATION
, COMMENTS
, SUBMISSION_DT
, THESIS_EXAM_TYPE
, THESIS_PANEL_TYPE
, THESIS_RESULT_CD
, IMPORT_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM IGS.IGS_RE_LGCY_THE_INT;
IGS.IGS_RE_LGCY_THE_INT does not reference any database object
IGS.IGS_RE_LGCY_THE_INT is referenced by following:
|
|
|