[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_OUT_SPCL_REQ |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_DA_OUT_SPCL_REQ |
Subobject Name: | |
Status: | VALID |
IGS_DA_OUT_SPCL_REQ stores outgoing special requirement details for students selected in the request. --Obsolete
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_DA_OUT_SPCL_REQ_U1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
BATCH_ID
PERSON_ID SPEC_REQ_SEQ_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | Unique ID for a request | |
PERSON_ID | NUMBER | (15) | Yes | Unique identifier for a person |
SPEC_REQ_SEQ_NUM | NUMBER | Yes | Sequence number associated with each special requirement of the student program attempts for the student in the request. | |
SPECIAL_REQUIREMENT | VARCHAR2 | (10) | Identifies code associated with each special requirement of the student program attempts for the student in the request. | |
TERM_PERIOD | VARCHAR2 | (10) | Derived teaching period which is associated with the date the special requirement is completed. This represents the term where the special requirement completion will be applied. | |
SPECIAL_REQ_EXPIRE_DATE | DATE | Date the special requirements applicability toward program requirements will expire. | ||
SPECIAL_REQ_REF | VARCHAR2 | (10) | User-defined reference code value. | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | 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 BATCH_ID
, PERSON_ID
, SPEC_REQ_SEQ_NUM
, SPECIAL_REQUIREMENT
, TERM_PERIOD
, SPECIAL_REQ_EXPIRE_DATE
, SPECIAL_REQ_REF
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_SPCL_REQ;
IGS.IGS_DA_OUT_SPCL_REQ does not reference any database object
IGS.IGS_DA_OUT_SPCL_REQ is referenced by following:
|
|
|