[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_FAC_TASK_TYP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_FAC_TASK_TYP |
Subobject Name: | |
Status: | VALID |
This table stores Faculty Task types and corresponding default workloads
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_FAC_TASK_TYP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FACULTY_TASK_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FACULTY_TASK_TYPE | VARCHAR2 | (30) | Yes | Institution defined Faculty Task Type |
DESCRIPTION | VARCHAR2 | (80) | Yes | Description of Faculty Task Type |
DEPT_BUDGET_CD | VARCHAR2 | (30) | Department Budget Code | |
DEFAULT_WL | NUMBER | (6) | Yes | Default Workload for the given Faculty Task Type |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
CLOSED_IND | VARCHAR2 | (1) | Closed Indicator, indicates the faculty task type is closed or not. Once the faculty task type is closed then corresponding faculty task type is not displayed in LOV of forms and not considered for processing. |
Cut, paste (and edit) the following text to query this object:
SELECT FACULTY_TASK_TYPE
, DESCRIPTION
, DEPT_BUDGET_CD
, DEFAULT_WL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CLOSED_IND
FROM IGS.IGS_PS_FAC_TASK_TYP;
IGS.IGS_PS_FAC_TASK_TYP does not reference any database object
IGS.IGS_PS_FAC_TASK_TYP is referenced by following:
|
|
|