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_GE_REF_CD_TYPE_ALL

Object Details

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

IGS_GE_REF_CD_TYPE_ALL describes the types of reference codes that are applied to the program offering options, for example, TAC, CRICOS, IVRS.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GE_REF_CD_TYPE_ALL_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	REFERENCE_CD_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_CD_TYPE	VARCHAR2	(10)	Yes	The name of an institution-defined reference code type. Each referencecode is assigned a reference code type, which defines its use in thesystem. For example, IVRS CODE.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes the reference code type
SELF_SERVICE_FLAG	VARCHAR2	(1)		The reference code type used in self service modules.
S_REFERENCE_CD_TYPE	VARCHAR2	(30)	Yes	The system-defined reference code type assigned to the institution-defined reference code type. This code defines system functionality.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the reference code type is open or closed. Selecting the checkbox to 'closed' prevents use of the reference code type in new or modified records.
PROGRAM_OFFERING_OPTION_FLAG	VARCHAR2	(1)		The reference Code type applicable at Program offering option level.
UNIT_FLAG	VARCHAR2	(1)		The reference code type applicable at unit level.
UNIT_SECTION_FLAG	VARCHAR2	(1)		The reference code type applicable at unit section level.
UNIT_SECTION_OCCURRENCE_FLAG	VARCHAR2	(1)		The reference code type applicable at unit section occurence level.
PROGRAM_FLAG	VARCHAR2	(1)		The reference code type applicable at program level.
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
MANDATORY_FLAG	VARCHAR2	(1)		This field indicates if the reference code type is mandatory for all the applicable levels selected i.e. program, program offering option, unit, unit section and unit section occurrence
RESTRICTED_FLAG	VARCHAR2	(1)		This flag indicates whether reference codes need to be set up for the reference code type or whether the user can add in the reference code directly in the reference code form within PSP.

Query Text

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


SELECT REFERENCE_CD_TYPE
,      DESCRIPTION
,      SELF_SERVICE_FLAG
,      S_REFERENCE_CD_TYPE
,      CLOSED_IND
,      PROGRAM_OFFERING_OPTION_FLAG
,      UNIT_FLAG
,      UNIT_SECTION_FLAG
,      UNIT_SECTION_OCCURRENCE_FLAG
,      PROGRAM_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      MANDATORY_FLAG
,      RESTRICTED_FLAG
FROM IGS.IGS_GE_REF_CD_TYPE_ALL;

Dependencies

[top of page]

IGS.IGS_GE_REF_CD_TYPE_ALL does not reference any database object

IGS.IGS_GE_REF_CD_TYPE_ALL is referenced by following:

APPS: IGS_GE_REF_CD_TYPE_ALL