[Home] [Help] [Dependency Information]
Object Name: | IGSBV_SPECIAL_PERMISSIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_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 |
INSTRUCTOR_PERSON_IDENTIFIER | NUMBER | (15) | Yes | Person ID of the Instructor who has to approve the Special permission request |
UNIT_SECTION_ID | NUMBER | (6) | Yes | Unit section ID, which the student is attempting |
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
, INSTRUCTOR_PERSON_IDENTIFIER
, UNIT_SECTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_SPECIAL_PERMISSIONS;
APPS.IGSBV_SPECIAL_PERMISSIONS is not referenced by any database object
|
|
|