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_AD_APP_REQ

Object Details

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

IGS_AD_APP_REQ holds applicant's application requirements, fee status, and fee type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_APP_REQ_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID ADMISSION_APPL_NUMBER
IGS_AD_APP_REQ_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICANT_FEE_STATUS
IGS_AD_APP_REQ_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REV_ACCOUNT_CD
IGS_AD_APP_REQ_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_ACCOUNT_CD
IGS_AD_APP_REQ_PK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APP_REQ_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APP_REQ_ID	NUMBER	(15)	Yes	Unique identifier for the applicants application requirements id
PERSON_ID	NUMBER	(15)	Yes	Contains the institution-defined number that uniquely identifies a person
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	VARCHAR2	(6)		OBSOLETE. Describes the program code of the program for that the applicant is seeking admission
SEQUENCE_NUMBER	NUMBER	(6)		Describes the sequence number of the application
APPLICANT_FEE_TYPE	NUMBER	(15)	Yes	Stores the name of a fee that the applicant opts for. For example, HECS, GSF, MEDIBANK. A fee type may be assigned as a fee liability of many fee categories.
APPLICANT_FEE_STATUS	NUMBER	(15)	Yes	Describes the applicant's fee status
FEE_DATE	DATE		Yes	Stores the fee payment date
FEE_PAYMENT_METHOD	NUMBER	(15)		Stores the fee payment method
FEE_AMOUNT	NUMBER		Yes	Stores the fee payment amount
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
REFERENCE_NUM	VARCHAR2	(60)		This is used to store the manually recorded transaction reference details
CREDIT_CARD_CODE	VARCHAR2	(30)		No longer used
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)		No longer used
CREDIT_CARD_NUMBER	VARCHAR2	(30)		No longer used
CREDIT_CARD_EXPIRATION_DATE	DATE			No longer used
REV_GL_CCID	NUMBER	(38)		Revenue general ledger code combination identifier
CASH_GL_CCID	NUMBER	(38)		Cash general ledger code combination identifier
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue account code
CASH_ACCOUNT_CD	VARCHAR2	(40)		Cash account code
GL_DATE	DATE			General ledger date
GL_POSTED_DATE	DATE			General ledger posted date
POSTING_CONTROL_ID	NUMBER	(15)		Posting control identifier
CREDIT_CARD_STATUS_CODE	VARCHAR2	(30)		Status of the Credit Card Transaction.
CREDIT_CARD_PAYEE_CD	VARCHAR2	(80)		No longer used
CREDIT_CARD_TANGIBLE_CD	VARCHAR2	(80)		No longer used
TRXN_EXTENSION_ID	NUMBER			Indicates the transaction extension identifier to store the foreign key references to the Oracle payments Payment Extension-Entity

Query Text

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


SELECT APP_REQ_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      APPLICANT_FEE_TYPE
,      APPLICANT_FEE_STATUS
,      FEE_DATE
,      FEE_PAYMENT_METHOD
,      FEE_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REFERENCE_NUM
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      REV_GL_CCID
,      CASH_GL_CCID
,      REV_ACCOUNT_CD
,      CASH_ACCOUNT_CD
,      GL_DATE
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
,      CREDIT_CARD_STATUS_CODE
,      CREDIT_CARD_PAYEE_CD
,      CREDIT_CARD_TANGIBLE_CD
,      TRXN_EXTENSION_ID
FROM IGS.IGS_AD_APP_REQ;

Dependencies

[top of page]

IGS.IGS_AD_APP_REQ does not reference any database object

IGS.IGS_AD_APP_REQ is referenced by following:

APPS: IGS_AD_APP_REQ