[Home] [Help] [Dependency Information]
Object Name: | IGSBV_STUDENT_PROGRAM_TERMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_STUDENT_PROGRAM_TERMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view lists program attempt attributes based on Term Calendar.
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 |
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 |
ACADEMIC_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar Type of the Student Program Attempt for this Term |
TERM_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Term Calendar Type for which Student Program Attempt changes are being captured |
TERM_CAL_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the calendar instance for which Student Program Attempt changes are being captured |
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 |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Nominated Attendance Mode of the Student Program Attempt for this Term |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Nominated Attendance Type of the Student Program Attempt for this Term |
FEE_CATEGORY | VARCHAR2 | (10) | Fee Category of the Student Program Attempt for this Term | |
COO_ID | NUMBER | (7) | Yes | Program 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 | |
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
, PROGRAM_CODE
, PROGRAM_VERSION
, ACADEMIC_CALENDAR_TYPE
, TERM_CALENDAR_TYPE
, TERM_CAL_SEQUENCE_NUMBER
, KEY_PROGRAM_FLAG
, _LA:KEY_PROGRAM_FLAG_DESC
, LOCATION_CODE
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, FEE_CATEGORY
, COO_ID
, CLASS_STANDING_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_STUDENT_PROGRAM_TERMS;
APPS.IGSBV_STUDENT_PROGRAM_TERMS is not referenced by any database object
|
|
|