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_AS_DOCPROC_STUP

Object Details

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

Contains institutional setup of options governing general Document Request Processing

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_DOCPROC_STUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TPSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TPSET_ID	NUMBER	(15)	Yes	Sequence Generated Column
LIFETIME_TRANS_FEE_IND	VARCHAR2	(1)	Yes	Allow Life Time Transcript Fee paid Indicator
PROVIDE_TRANSCRIPT_IND	VARCHAR2	(1)	Yes	Indicates whether the Transcript request is allowed or not
TRANS_REQUEST_IF_HOLD_IND	VARCHAR2	(1)	Yes	Do not allow Transcript to be requested if Transcript Hold exists indicator DEFAULT ?N?
ALL_ACAD_HIST_IN_ONE_DOC_IND	VARCHAR2	(1)	Yes	Indicates whether all academic history should be included in one transcript.
HOLD_DELIV_IND	VARCHAR2	(1)	Yes	Allow Transcript to be requested if Transcript Hold exists but hold delivery of document until Hold clears Indicator Default ?N?
ALLOW_ENROLL_CERT_IND	VARCHAR2	(1)	Yes	Indicates whether the Enrollment certification is allowed or not
BILL_ME_LATER_IND	VARCHAR2	(1)	Yes	Bill Me later Indicator
EDI_CAPABLE_IND	VARCHAR2	(1)	Yes	Indicates whether the institute is capable of delivering by EDI or Not
ALWAYS_SEND_DOCS_VIA_EDI	VARCHAR2	(1)	Yes	Always send documents via EDI to those institutions designated EDI partners
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
PROVIDE_DUPLICATE_DOC_IND	VARCHAR2	(1)		If not checked on setup form, all "Duplicate" processing is disabled. Default value is "N"
ADMINISTRATOR_ID	VARCHAR2	(100)		User ID to whom admin notifications are to be sent
CHARGE_DOCUMENT_FEE_IND	VARCHAR2	(1)		Charge Document Fee Indicator
CHARGE_DELIVERY_FEE_IND	VARCHAR2	(1)		Charge Delivery Fee Indicator

Query Text

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


SELECT TPSET_ID
,      LIFETIME_TRANS_FEE_IND
,      PROVIDE_TRANSCRIPT_IND
,      TRANS_REQUEST_IF_HOLD_IND
,      ALL_ACAD_HIST_IN_ONE_DOC_IND
,      HOLD_DELIV_IND
,      ALLOW_ENROLL_CERT_IND
,      BILL_ME_LATER_IND
,      EDI_CAPABLE_IND
,      ALWAYS_SEND_DOCS_VIA_EDI
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROVIDE_DUPLICATE_DOC_IND
,      ADMINISTRATOR_ID
,      CHARGE_DOCUMENT_FEE_IND
,      CHARGE_DELIVERY_FEE_IND
FROM IGS.IGS_AS_DOCPROC_STUP;

Dependencies

[top of page]

IGS.IGS_AS_DOCPROC_STUP does not reference any database object

IGS.IGS_AS_DOCPROC_STUP is referenced by following:

APPS: IGS_AS_DOCPROC_STUP