[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_AD_APP_REQ does not reference any database object
IGS.IGS_AD_APP_REQ is referenced by following:
|
|
|