[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_TYPE_GRP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_TYPE_GRP |
Subobject Name: | |
Status: | VALID |
This table describes a program grouping of program types relating to the way DEET funds (approved EFTSU) programs. E.g. Higher Degree by Research, Higher Degree by Coursework, Other Postgraduate Other - Other, Other - Enabling, Non-award and OL program type groups are used for executive statistics reporting.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_TYPE_GRP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | COURSE_TYPE_GROUP_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_TYPE_GROUP_CD | VARCHAR2 | (10) | Yes | Unique code for an institution-defined grouping of program types. Program type groups are aggregations of program types used for internal estimations of census date enrollment statistics. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the program type group. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE_TYPE_GROUP_CD
, DESCRIPTION
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_TYPE_GRP;
IGS.IGS_PS_TYPE_GRP does not reference any database object
IGS.IGS_PS_TYPE_GRP is referenced by following:
|
|
|