[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_TYPE_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_TYPE_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_TYPE_HIST_ALL describes the history of changes for a program type.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_TYPE_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COURSE_TYPE
HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COURSE_TYPE | VARCHAR2 | (10) | Yes | Describes the type of programs offered by the university. Program type is an element defined by DEET. However, the system is not limited to the DEET list. DEET element reference310. For example, 01 Higher Doctorate, 20 Diploma. |
HIST_START_DT | DATE | Yes | Effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | Effective end date and time of the history record. | |
HIST_WHO | NUMBER | (15) | Yes | Updated by person at the time of the history. |
DESCRIPTION | VARCHAR2 | (60) | Description of the institution-defined program type. | |
GOVT_COURSE_TYPE | NUMBER | (2) | Unique code for the government program type to that the institution-defined program type is mapped. | |
AWARD_COURSE_IND | VARCHAR2 | (1) | Indicator that specifies if the program award is open or closed. | |
COURSE_TYPE_GROUP_CD | VARCHAR2 | (10) | 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. | |
TAC_COURSE_LEVEL | VARCHAR2 | (4) | Program level for the program type, as recognized by the Tertiary Admissions Centre. | |
RESEARCH_TYPE_IND | VARCHAR2 | (1) | Indicator that specifies if the program is of research type or not. | |
CLOSED_IND | VARCHAR2 | (1) | 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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
PRIMARY_AUTO_SELECT | VARCHAR2 | (1) | Primary Auto Select Y/N Field, Default 'Y' | |
FIN_AID_PROGRAM_TYPE | VARCHAR2 | (30) | A program type that is used by Financial Aid. |
Cut, paste (and edit) the following text to query this object:
SELECT COURSE_TYPE
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, DESCRIPTION
, GOVT_COURSE_TYPE
, AWARD_COURSE_IND
, COURSE_TYPE_GROUP_CD
, TAC_COURSE_LEVEL
, RESEARCH_TYPE_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, PRIMARY_AUTO_SELECT
, FIN_AID_PROGRAM_TYPE
FROM IGS.IGS_PS_TYPE_HIST_ALL;
IGS.IGS_PS_TYPE_HIST_ALL does not reference any database object
IGS.IGS_PS_TYPE_HIST_ALL is referenced by following:
|
|
|