[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_SS_SCHEDULE_DISP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_SS_SCHEDULE_DISP_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Unique Person identifier |
PROGRAM_CD | VARCHAR2 | (6) | Yes | Program code |
VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the program code |
PROGRAM_TYPE | VARCHAR2 | (10) | Yes | Program type of the program code |
ATTENDANCE_TYPE | VARCHAR2 | (4000) | Attendance type of the program offering | |
ATTENDANCE_TYPE_DESC | VARCHAR2 | (4000) | Attendance type description | |
ATTENDANCE_MODE | VARCHAR2 | (4000) | Attendance mode of the program offering | |
ATTENDANCE_MODE_DESC | VARCHAR2 | (4000) | Attendance mode description | |
LOCATION_CD | VARCHAR2 | (4000) | Location code of the program offering | |
LOCATION_CD_DESC | VARCHAR2 | (4000) | Location code description | |
TERM_CAL_TYPE | VARCHAR2 | (10) | Yes | Term calendar type |
TERM_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Term calendar sequence number |
TERM_DESCRIPTION | VARCHAR2 | (30) | Term calendar instance description | |
TERM_START_DT | DATE | Yes | Term calendar start date | |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Academic calendar type |
ACAD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Academic calendar sequence number |
ACADEMIC_DESCRIPTION | VARCHAR2 | (30) | Academic calendar instance description | |
UNCONFORM_SUA | VARCHAR2 | (1) | Indicator, says whether unconfirmed units exists in the given term calendar | |
APPLIED_MIN_CP | NUMBER | Minimum credit points setup applicable in the given term | ||
APPLIED_MAX_CP | NUMBER | Maximum credit points setup applicable in the given term | ||
INST_ATTENDANCE | VARCHAR2 | (4000) | Institutional attendance type for the given student and term | |
INST_CP | VARCHAR2 | (4000) | Institutional credit points for the given student and term | |
PRIMARY_PRG_TITLE | VARCHAR2 | (4000) | Program or primary program title | |
SECONDARY_PRG_TITLE | VARCHAR2 | (4000) | Concatenated titles of all the secondary programs in the given career | |
YEAR_OF_PROGRAM | VARCHAR2 | (4000) | Current unit set for the given student program attempt | |
PRIMARY_PROGRAM_TYPE | VARCHAR2 | (4000) | Primary program type for the given program attempt |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PROGRAM_CD
, VERSION_NUMBER
, PROGRAM_TYPE
, ATTENDANCE_TYPE
, ATTENDANCE_TYPE_DESC
, ATTENDANCE_MODE
, ATTENDANCE_MODE_DESC
, LOCATION_CD
, LOCATION_CD_DESC
, TERM_CAL_TYPE
, TERM_SEQUENCE_NUMBER
, TERM_DESCRIPTION
, TERM_START_DT
, ACAD_CAL_TYPE
, ACAD_SEQUENCE_NUMBER
, ACADEMIC_DESCRIPTION
, UNCONFORM_SUA
, APPLIED_MIN_CP
, APPLIED_MAX_CP
, INST_ATTENDANCE
, INST_CP
, PRIMARY_PRG_TITLE
, SECONDARY_PRG_TITLE
, YEAR_OF_PROGRAM
, PRIMARY_PROGRAM_TYPE
FROM APPS.IGS_EN_SS_SCHEDULE_DISP_V;
APPS.IGS_EN_SS_SCHEDULE_DISP_V is not referenced by any database object
|
|
|