[Home] [Help] [Dependency Information]
Object Name: | IGSBV_STUDENT_UNIT_TRANSFERS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_STUDENT_UNIT_TRANSFERS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view describes the link between two units that were involved in a program transfer
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_IDENTIFIER | NUMBER | (15) | Yes | This view describes the ID code that uniquely identifies a person |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for the person |
PERSON_NAME | VARCHAR2 | (360) | Yes | Full Name of the person. |
PROGRAM_CODE | VARCHAR2 | (6) | Yes | The program code that the student program attempt record has been transferred "to" |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | The title or full name of the program that the student program attempt record has been transferred "to" |
TRANSFER_PROGRAM_CODE | VARCHAR2 | (6) | Yes | The program code that the student program attempt record has been transferred "from" |
TRANSFER_PROGRAM_TITLE | VARCHAR2 | (90) | Yes | The title or full name of the program that the student program attempt record has been transferred "from" |
TRANSFER_DATE | DATE | Yes | The date on which the unit was transferred to the new program attempt record | |
UNIT_CODE | VARCHAR2 | (10) | Yes | The code used to identify a unit that has been included in a program |
UNIT_TITLE | VARCHAR2 | (90) | Yes | The title of the unit |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Name of the teaching calendar within the university |
CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance |
UNIT_SECTION_ID | NUMBER | (7) | Yes | Unique Identifier for a unit offering option. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_IDENTIFIER
, PERSON_NUMBER
, PERSON_NAME
, PROGRAM_CODE
, PROGRAM_TITLE
, TRANSFER_PROGRAM_CODE
, TRANSFER_PROGRAM_TITLE
, TRANSFER_DATE
, UNIT_CODE
, UNIT_TITLE
, CALENDAR_TYPE
, CAL_INST_SEQUENCE_NUMBER
, UNIT_SECTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_STUDENT_UNIT_TRANSFERS;
APPS.IGSBV_STUDENT_UNIT_TRANSFERS is not referenced by any database object
|
|
|