[Home] [Help] [Dependency Information]
Object Name: | IGSFV_STUDENT_PROGRAM_TERMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_STUDENT_PROGRAM_TERMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERM_RECORD_ID | NUMBER | Yes | System generated number to uniquely identify the Term Record | |
PERSON_IDENTIFIER | NUMBER | (15) | Yes | Student Unique Identifier and foreign key to HZ_PARTIES. This is a sequence generated value |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Describes the Person Number for the Person Identifier |
PERSON_NAME | VARCHAR2 | (360) | Yes | Full Name of the Person |
PROGRAM_CODE | VARCHAR2 | (6) | Yes | Program Code of the Student Program Attempt for which this Term Record applies to |
PROGRAM_VERSION | NUMBER | (3) | Yes | Program Version of the Student Program Attempt for this Term |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title of the Program attempted by the Student |
ACADEMIC_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar Type of the Student Program Attempt for this Term |
ACADEMIC_CALENDAR_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of the Academic Calendar Type |
TERM_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Term Calendar Type for which Student Program Attempt changes are being captured |
TERM_CALENDAR_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of Term Calendar Type |
TERM_CAL_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the Term Calendar instance for which Student Program Attempt changes are being captured |
TEM_CALENDAR_START_DATE | DATE | Yes | Date from which the Term Calendar Instance becomes effective | |
TERM_CALENDAR_END_DATE | DATE | Yes | Date from which the Term Calendar Instance becomes ineffective | |
TERM_CALENDAR_INSTANCE_DESC | VARCHAR2 | (30) | Description of the Term Calendar Instance | |
KEY_PROGRAM_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the Student Program Attempt is the Key Program for this Term. Can have values Y/N |
_LA:KEY_PROGRAM_FLAG_DESC | CHAR | (53) | Key Program Description. Has values Yes/No | |
LOCATION_CODE | VARCHAR2 | (10) | Yes | Location Code of the Student Program Attempt for this Term |
LOCATION_CODE_DESC | VARCHAR2 | (60) | Yes | Description of Location Code |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Nominated Attendance Mode of the Student Program Attempt for this Term |
ATTENDANCE_MODE_DESC | VARCHAR2 | (60) | Yes | Description of Attendance Mode |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Nominated Attendance Type |
ATTENDANCE_TYPE_DESC | VARCHAR2 | (60) | Yes | Description of Attendance Type |
FEE_CATEGORY | VARCHAR2 | (10) | Fee Category of the Student Program Attempt for this Term | |
FEE_CATEGORY_DESC | VARCHAR2 | (60) | Description of the Fee Category | |
COO_ID | NUMBER | (7) | Yes | Course Offering Option Identifier of the Student Program Attempt for this Term |
CLASS_STANDING_IDENTIFIER | NUMBER | (15) | Class Standing Identifier of the Student Program Attempt for this Term | |
CLASS_STANDING_DESC | VARCHAR2 | (50) | Description of the Class Standing | |
_DF | CHAR | (34) | ||
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 TERM_RECORD_ID
, PERSON_IDENTIFIER
, PERSON_NUMBER
, PERSON_NAME
, PROGRAM_CODE
, PROGRAM_VERSION
, PROGRAM_TITLE
, ACADEMIC_CALENDAR_TYPE
, ACADEMIC_CALENDAR_TYPE_DESC
, TERM_CALENDAR_TYPE
, TERM_CALENDAR_TYPE_DESC
, TERM_CAL_SEQUENCE_NUMBER
, TEM_CALENDAR_START_DATE
, TERM_CALENDAR_END_DATE
, TERM_CALENDAR_INSTANCE_DESC
, KEY_PROGRAM_FLAG
, _LA:KEY_PROGRAM_FLAG_DESC
, LOCATION_CODE
, LOCATION_CODE_DESC
, ATTENDANCE_MODE
, ATTENDANCE_MODE_DESC
, ATTENDANCE_TYPE
, ATTENDANCE_TYPE_DESC
, FEE_CATEGORY
, FEE_CATEGORY_DESC
, COO_ID
, CLASS_STANDING_IDENTIFIER
, CLASS_STANDING_DESC
, _DF
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_STUDENT_PROGRAM_TERMS;
APPS.IGSFV_STUDENT_PROGRAM_TERMS is not referenced by any database object
|
|
|