[Home] [Help] [Dependency Information]
Object Name: | IGSFV_SPECIAL_PERMISSIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_SPECIAL_PERMISSIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity contains the data about transactions on special permission request submitted by students.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPECIAL_PERM_REQUEST_ID | NUMBER | (15) | Yes | System generated number to uniquely identify the Special permission request transaction |
SUBMISSION_DATE | DATE | Yes | Date of the last transaction, i.e. last date of update of this record | |
AUDIT_THE_UNIT_FLAG | VARCHAR2 | (10) | Yes | Audit this unit, possible values are Y/N, default value is N |
_LA:AUDIT_THE_UNIT_DESC | CHAR | (53) | Description of Audit Unit Indicator | |
APPROVAL_STATUS | VARCHAR2 | (10) | Yes | Approval status of the transaction, possible values is M (Need more Information), D (Deny) or A (Approved). |
REASON_FOR_REQUEST | VARCHAR2 | (4000) | Yes | Reason for the request of the Special permission |
INSTRUCTOR_MORE_INFO | VARCHAR2 | (4000) | More information needed by instructor on Special permission request | |
INSTRUCTOR_DENY_INFO | VARCHAR2 | (4000) | Instructor reason for deny | |
STUDENT_MORE_INFO | VARCHAR2 | (4000) | More information submitted by the student | |
TRANSACTION_TYPE | VARCHAR2 | (30) | Type of the transaction, stores lookup code corresponding to the transaction. | |
_LA:TRANSACTION_TYPE_DESC | CHAR | (71) | Description of the Transaction Type | |
REQUEST_TYPE | VARCHAR2 | (10) | Indicates whether the request is for Special permission or for Audit. | |
STUDENT_PERSON_IDENTIFIER | NUMBER | (15) | Yes | Person ID of the Student |
STUDENT_PERSON_NUMBER | VARCHAR2 | (30) | Yes | Describes the person number for the Student person id |
STUDENT_FULL_NAME | VARCHAR2 | (360) | Yes | Full Name of the Student |
INSTRUCTOR_PERSON_IDENTIFIER | NUMBER | (15) | Yes | Person ID of the Instructor who has to approve the Special permission request |
INSTRUCTOR_PERSON_NUMBER | VARCHAR2 | (30) | Yes | Describes the person number for the instructor person id |
INSTRUCTOR_FULL_NAME | VARCHAR2 | (360) | Yes | Full Name of the Instructor |
UNIT_SECTION_ID | NUMBER | (6) | Yes | Unit section ID, which the student is attempting |
UNIT_CODE | VARCHAR2 | (10) | Yes | Unit code for which the actual enrollment against reservation is created. |
VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar type in that the unit is offered |
CAL_INST_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier for the calendar instance |
LOCATION_CODE | VARCHAR2 | (10) | Yes | Institution-defined location code, typically of a campus, at which a unit offering option is offered. |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Institution-defined code that identifies a unit class |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SPECIAL_PERM_REQUEST_ID
, SUBMISSION_DATE
, AUDIT_THE_UNIT_FLAG
, _LA:AUDIT_THE_UNIT_DESC
, APPROVAL_STATUS
, REASON_FOR_REQUEST
, INSTRUCTOR_MORE_INFO
, INSTRUCTOR_DENY_INFO
, STUDENT_MORE_INFO
, TRANSACTION_TYPE
, _LA:TRANSACTION_TYPE_DESC
, REQUEST_TYPE
, STUDENT_PERSON_IDENTIFIER
, STUDENT_PERSON_NUMBER
, STUDENT_FULL_NAME
, INSTRUCTOR_PERSON_IDENTIFIER
, INSTRUCTOR_PERSON_NUMBER
, INSTRUCTOR_FULL_NAME
, UNIT_SECTION_ID
, UNIT_CODE
, VERSION_NUMBER
, CALENDAR_TYPE
, CAL_INST_SEQUENCE_NUMBER
, LOCATION_CODE
, UNIT_CLASS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_SPECIAL_PERMISSIONS;
APPS.IGSFV_SPECIAL_PERMISSIONS is not referenced by any database object
|
|
|