[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_OFR_OPT_PE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_OFR_OPT_PE_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
UNIT_CD | VARCHAR2 | (10) | Yes | |
VERSION_NUMBER | NUMBER | (3) | Yes | |
CAL_TYPE | VARCHAR2 | (10) | Yes | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
LOCATION_CD | VARCHAR2 | (10) | Yes | |
UNIT_CLASS | VARCHAR2 | (10) | Yes | |
UOO_ID | NUMBER | (7) | Yes | |
PERSON_NUMBER | VARCHAR2 | (30) | ||
IVRS_AVAILABLE_IND | VARCHAR2 | (1) | Yes | |
OFFERED_IND | VARCHAR2 | (1) | Yes | |
GRADING_SCHEMA_PRCDNCE_IND | VARCHAR2 | (1) | Yes | |
UNIT_QUOTA | NUMBER | (6) | ||
UNIT_QUOTA_RESERVED_PLACES | NUMBER | (6) | ||
UNIT_CONTACT | NUMBER | (15) | ||
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | |
GS_VERSION_NUMBER | NUMBER | (3) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
CALL_NUMBER | NUMBER | |||
UNIT_SECTION_STATUS | VARCHAR2 | (30) | ||
UNIT_SECTION_START_DATE | DATE | |||
UNIT_SECTION_END_DATE | DATE | |||
ENROLLMENT_ACTUAL | NUMBER | (6) | ||
WAITLIST_ACTUAL | NUMBER | (6) | ||
STATE_FINANCIAL_AID | VARCHAR2 | (1) | ||
FEDERAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
INSTITUTIONAL_FINANCIAL_AID | VARCHAR2 | (1) | ||
SS_ENROL_IND | VARCHAR2 | (1) | Self Service Enrollment indicator | |
OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | ||
ATTENDANCE_REQUIRED_IND | VARCHAR2 | (1) | ||
RESERVED_SEATING_ALLOWED | VARCHAR2 | (1) | ||
SPECIAL_PERMISSION_IND | VARCHAR2 | (1) | ||
SS_DISPLAY_IND | VARCHAR2 | (1) | ||
DIR_ENROLLMENT | NUMBER | (15) | Direct enrollment | |
ENR_FROM_WLST | NUMBER | (15) | Enrolled from waitlist | |
INQ_NOT_WLST | NUMBER | (15) | Inquired but not waitlist | |
REV_ACCOUNT_CD | VARCHAR2 | (40) | ||
ANON_UNIT_GRADING_IND | VARCHAR2 | (1) | Anonymous Unit Grading Y / N | |
ANON_ASSESS_GRADING_IND | VARCHAR2 | (1) | Anonymous Assessment Item Grading Y / N | |
NON_STD_USEC_IND | VARCHAR2 | (1) | Indicates wether the Unit Section is Standard or Non Standard | |
AUDITABLE_IND | VARCHAR2 | (1) | Indicates if a unit can be audited | |
AUDIT_PERMISSION_IND | VARCHAR2 | (1) | Indicates if permission is required to audit | |
NOT_MULTIPLE_SECTION_FLAG | VARCHAR2 | (1) | Indicating whether this unit section should be excluded from multiple unit section. | |
SUP_UOO_ID | NUMBER | The superior unit section's identifier for this unit section. | ||
RELATION_TYPE | VARCHAR2 | (30) | Indicate whether this unit section is superior,subordinate or none of above. | |
DEFAULT_ENROLL_FLAG | VARCHAR2 | (1) | Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled. | |
ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the unit section is ABORTED. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, PERSON_NUMBER
, IVRS_AVAILABLE_IND
, OFFERED_IND
, GRADING_SCHEMA_PRCDNCE_IND
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, UNIT_CONTACT
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, SS_ENROL_IND
, OWNER_ORG_UNIT_CD
, ATTENDANCE_REQUIRED_IND
, RESERVED_SEATING_ALLOWED
, SPECIAL_PERMISSION_IND
, SS_DISPLAY_IND
, DIR_ENROLLMENT
, ENR_FROM_WLST
, INQ_NOT_WLST
, REV_ACCOUNT_CD
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, NON_STD_USEC_IND
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, NOT_MULTIPLE_SECTION_FLAG
, SUP_UOO_ID
, RELATION_TYPE
, DEFAULT_ENROLL_FLAG
, ABORT_FLAG
FROM APPS.IGS_PS_UNIT_OFR_OPT_PE_V;
|
|
|