[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_CAT_PRC_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_CAT_PRC_DTL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Describes the Enrollment Category Eligibility Validation Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Rowid. | |
ENROLMENT_CAT | VARCHAR2 | (10) | Yes | The Enrollment Category used for eligibility setup. |
ENR_CAT_DESC | VARCHAR2 | (60) | Yes | The description of Enrollment Category used for eligibility setup. |
ENR_METHOD_TYPE | VARCHAR2 | (10) | Yes | The Enrollment Method Type used for eligibility setup. |
ENR_MTYPE_DESC | VARCHAR2 | (60) | Yes | The description of the Enrollment Method Type used for eligibility setup. |
S_STUDENT_COMM_TYPE | VARCHAR2 | (10) | Yes | The Student Commencement Type used for eligibility setup. |
STD_COMM_TYPE_DESC | VARCHAR2 | (80) | Yes | The Student Commencement Type used for eligibility setup. |
PRODUCE_PACKAGE_IND | VARCHAR2 | (0) | Indicator that specifies whether an enrolment package is produced for the selected enrolment category, enrolment method type, and student type combination. The type of package is determinedby the individual students program and correspondence category. Setting the indicator allows an enrolment package to be produced. --Obsolete | |
PERSON_ADD_ALLOW_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether for the selected enrolment category, enrolment method type, and student type combination, it is permissible to add a new student to the database through the enrolment process. Setting the checkbox allows a student to be added to the database. |
COURSE_ADD_ALLOW_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether for the selected Enrolment Category, Enrolment Method Type, and Student Type combination, it is permissible to add a new student program attempt through the enrolment process. Setting the checkbox allows a student program attempt to be added. |
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 | |
CONFIG_MIN_CP_VALDN | VARCHAR2 | (10) | Field to store the configuration of Minimum Credit Point Validation. Can be 'MINCPREACH' or 'DATEALIASREACH' or 'NONE' | |
ENFORCE_DATE_ALIAS | VARCHAR2 | (10) | Date Alias of Enforcement | |
DESCRIPTION | VARCHAR2 | (60) | Description of an event, that is not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendarcategory. For example Date alias are GOVERNMENT CENSUS DATE, LAST DAY OF LECTURES IN TEACHING PERIOD, and LAST DAY TO WITHDRAW FROM UNIT WITHOUT FAILING. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ENROLMENT_CAT
, ENR_CAT_DESC
, ENR_METHOD_TYPE
, ENR_MTYPE_DESC
, S_STUDENT_COMM_TYPE
, STD_COMM_TYPE_DESC
, PRODUCE_PACKAGE_IND
, PERSON_ADD_ALLOW_IND
, COURSE_ADD_ALLOW_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONFIG_MIN_CP_VALDN
, ENFORCE_DATE_ALIAS
, DESCRIPTION
FROM APPS.IGS_EN_CAT_PRC_DTL_V;
APPS.IGS_EN_CAT_PRC_DTL_V is not referenced by any database object
|
|
|