[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AS_SUA_REFERENCE_CODES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_AS_SUA_REFERENCE_CODES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Student Unit Attempt Reference Codes
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NAME | VARCHAR2 | (360) | Yes | Name of this party |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
PROGRAM_CODE | VARCHAR2 | (6) | Yes | Program ID - part of foreign key to SUA |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title or full name of the program. |
UNIT_CODE | VARCHAR2 | (10) | Yes | Code used to identify the unit |
UNIT_TITLE | VARCHAR2 | (90) | Yes | Title of the unit. |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Type of teaching calendar within the institution. For example, SEM-1, YR-LONG. |
CALENDAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Uniquely identifies the calendar instance. |
CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description for the Calendar Instance | |
REFERENCE_CODE_TYPE | VARCHAR2 | (10) | Yes | The reference code type |
REFERENCE_CODE | VARCHAR2 | (30) | Yes | The reference code applied to the student unit attempt |
APPLIED_PROGRAM_CODE | VARCHAR2 | (6) | Yes | The program code under which the reference code is saved. |
APPLIED_PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title or full name of the program. |
PERSON_ID | NUMBER | (15) | Yes | Unique identification for this party. |
UNIT_VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
PROGRAM_VERSION_NUMBER | NUMBER | (3) | Yes | Number signifying the version of the program for that the student enrolls. |
REFERENCE_CODE_ID | NUMBER | (10) | Yes | Reference Code ID - foreign key to reference code |
CREATED_BY | NUMBER | (15) | Yes | Created By -Standard Who Column |
CREATION_DATE | DATE | Yes | Creation Date -Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By -Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date Standard Who Column | |
UOO_ID | NUMBER | (7) | Yes | Unit Offering Option ID - part of foreign key to SUA |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NAME
, PERSON_NUMBER
, PROGRAM_CODE
, PROGRAM_TITLE
, UNIT_CODE
, UNIT_TITLE
, CALENDAR_TYPE
, CALENDAR_SEQUENCE_NUMBER
, CALENDAR_DESCRIPTION
, REFERENCE_CODE_TYPE
, REFERENCE_CODE
, APPLIED_PROGRAM_CODE
, APPLIED_PROGRAM_TITLE
, PERSON_ID
, UNIT_VERSION_NUMBER
, PROGRAM_VERSION_NUMBER
, REFERENCE_CODE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, UOO_ID
FROM APPS.IGSFV_AS_SUA_REFERENCE_CODES;
APPS.IGSFV_AS_SUA_REFERENCE_CODES is not referenced by any database object
|
|
|