[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_PERD_PS_OF_PAT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AD_PERD_PS_OF_PAT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view describes further breakdown of the program.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the calendar type of the admissiondate alias instance that requires further process type, admissioncategory, program offering option restrictions |
ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the calendar sequence number of the admissiondate alias instance that requires further process type, admissioncategory, program offering option restrictions |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Describes the admission category of the admission date alias instance that requires further process type, admission category, program offering option restrictions |
DT_ALIAS | VARCHAR2 | (10) | Yes | Describes the admission date alias that requires further process type, admission category, program offering option restrictions |
DAI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the sequence number that defines the admission date alias instance that requires further process type, admission category, program offering option restrictions |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Helps uniquely define information in this table |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Select from the LOV the system admission process type that requires a program offering option date over-ride. The set of system admission process types is program, non-award, re-admit, short-adm, and transfer. Not all types are necessarily defined for a particular admission category. | |
COURSE_CD | VARCHAR2 | (6) | Enter or select from the LOV the code of the program that requires an admission period date override | |
VERSION_NUMBER | NUMBER | (3) | Describes the course version number of theadmission date alias instance that requires further process type,admission category, course offering option restrictions. | |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Describes the program offering calendar type of theadmission date alias instance that requires further process type,admission category, course offering option restrictions | |
LOCATION_CD | VARCHAR2 | (10) | This is an optional field. Keying or selecting from the LOV alocation code restricts the admission period override dateto instances of the program at the nominated location. | |
ATTENDANCE_MODE | VARCHAR2 | (2) | This is an optional field. Keying or selecting from the LOV an attendance mode restricts the admission period override date to instances of the course offered in the selected mode. | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | This is an optional field. Keying or selecting from the LOV an attendance type restricts the admission period override date to instances of the course offered in the selected attendance type. | |
ALIAS_VAL | DATE | Select from the LOV a date alias instance to be used as the admission period program offering option date override | ||
ROLLOVER_INCLUSION_IND | VARCHAR2 | (1) | Yes | Describes whether the admission period override date will be included in the admission calendar rollover process |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ADMISSION_CAT
, DT_ALIAS
, DAI_SEQUENCE_NUMBER
, SEQUENCE_NUMBER
, S_ADMISSION_PROCESS_TYPE
, COURSE_CD
, VERSION_NUMBER
, ACAD_CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, ALIAS_VAL
, ROLLOVER_INCLUSION_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_PERD_PS_OF_PAT_V;
|
|
|