[Home] [Help]
[Dependency Information]
[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;
APPS
HZ_PARTIES
IGS_PS_UNIT_OFR_OPT
APPS
IGS_PS_UNIT_OFR_OPT_PKG
- show dependent code
IGS_PS_UNIT_OFR_OPT_PKG
- show dependent code
|
|
|
|