eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PS_ENT_PT_REF_CD

Object Details

Object Name:	IGS_PS_ENT_PT_REF_CD
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PS_ENT_PT_REF_CD
Subobject Name:
Status:	VALID

This entity describes a reference code(s) that relate to the program offering entry point e.g. TAC codes, CRICOS codes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_ENT_PT_REF_CD_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER CAL_TYPE LOCATION_CD ATTENDANCE_MODE ATTENDANCE_TYPE REFERENCE_CD_TYPE SEQUENCE_NUMBER
IGS_PS_ENT_PT_REF_CD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_CD_TYPE
IGS_PS_ENT_PT_REF_CD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COO_ID
IGS_PS_ENT_PT_REF_CD_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_SET_CD US_VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
COURSE_CD	VARCHAR2	(6)	Yes	Code of the program version being offered.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program version being offered.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type for the program offering option.
LOCATION_CD	VARCHAR2	(10)	Yes	Location of the program offering option.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Institution-defined attendance mode. Identifies the mode of attendance by that a student undertakes a program.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Institution-defined attendance type. Identifies whether a student in a program is part-time or full-time for the year.
REFERENCE_CD_TYPE	VARCHAR2	(10)	Yes	Institution-defined reference code type, that defines the use of a program entry point reference code.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the entry point reference code. This is required due to the optional link to the unit set code.
UNIT_SET_CD	VARCHAR2	(10)		Describes the unit set to that the reference code applies.
US_VERSION_NUMBER	NUMBER	(3)		Describes the unit set to that the reference code applies.
REFERENCE_CD	VARCHAR2	(30)	Yes	Program entry point reference code for the program offering option. A program entry point reference code is an alternative code for a program used during the tertiary admission centres admissions process.
COO_ID	NUMBER	(7)	Yes	Unique system identifier for the program offering option.
DESCRIPTION	VARCHAR2	(60)		Description of the reference code. A program entry point reference code is an alternative code for a program used by the tertiary admissions centres during the admissions process.
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      REFERENCE_CD_TYPE
,      SEQUENCE_NUMBER
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      REFERENCE_CD
,      COO_ID
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_ENT_PT_REF_CD;

Dependencies

[top of page]

IGS.IGS_PS_ENT_PT_REF_CD does not reference any database object

IGS.IGS_PS_ENT_PT_REF_CD is referenced by following:

APPS: IGS_PS_ENT_PT_REF_CD