FND Design Data [Home] [Help]

View: IGS_PS_UNIT_OFR_OPT_SV

Product: IGS - Student System (Obsolete)
Description: Secured View for the IGS_PS_UNIT_OFR_OPT_ALL table
Implementation/DBA Data: Not implemented in this database
View Text

SELECT ROWID ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, IVRS_AVAILABLE_IND
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, OFFERED_IND
, STATE_FINANCIAL_AID
, GRADING_SCHEMA_PRCDNCE_IND
, FEDERAL_FINANCIAL_AID
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, INSTITUTIONAL_FINANCIAL_AID
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, UNIT_CONTACT
, SS_ENROL_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, 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
FROM IGS_PS_UNIT_OFR_OPT_ALL

Columns

Name
ROW_ID
UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
LOCATION_CD
UNIT_CLASS
UOO_ID
IVRS_AVAILABLE_IND
CALL_NUMBER
UNIT_SECTION_STATUS
UNIT_SECTION_START_DATE
UNIT_SECTION_END_DATE
ENROLLMENT_ACTUAL
WAITLIST_ACTUAL
OFFERED_IND
STATE_FINANCIAL_AID
GRADING_SCHEMA_PRCDNCE_IND
FEDERAL_FINANCIAL_AID
UNIT_QUOTA
UNIT_QUOTA_RESERVED_PLACES
INSTITUTIONAL_FINANCIAL_AID
GRADING_SCHEMA_CD
GS_VERSION_NUMBER
UNIT_CONTACT
SS_ENROL_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
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