[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_SS_APPL_TYP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_SS_APPL_TYP |
Subobject Name: | |
Status: | VALID |
IGS_AD_SS_APPL_TYP holds Self Service Admission Application Type details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_SS_APPL_TYP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADMISSION_APPLICATION_TYPE |
IGS_AD_SS_APPL_TYP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ADMISSION_CAT
S_ADMISSION_PROCESS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADMISSION_APPLICATION_TYPE | VARCHAR2 | (30) | Yes | This column stores the admission application types for admission applications created from the self service |
DESCRIPTION | VARCHAR2 | (60) | Description of the Admission Application Type | |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Admission Category of the Admission Application Type |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Yes | System Admission Process Type of the Admission Category of Admission Application type |
CONFIGURABILITY_FUNC_NAME | VARCHAR2 | (30) | Configurability Function Name attached to the Admission Application Type | |
APPLICATION_FEE_AMOUNT | NUMBER | (13) | Application Fee Amount attached to the application type | |
GL_REV_ACCT_CCID | NUMBER | (15) | General Ledger Revenue Account Code Identifier | |
GL_CASH_ACCT_CCID | NUMBER | (15) | General Ledger Cash Account Code Identifier | |
REV_ACCOUNT_CODE | VARCHAR2 | (40) | User Defined Revenue Account Code | |
CASH_ACCOUNT_CODE | VARCHAR2 | (40) | User Defined Cash Account Code | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Admission Application Type Closed Indicator |
CREATED_BY | NUMBER | (15) | Yes | WHO column |
CREATION_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | WHO column | |
SYSTEM_DEFAULT | VARCHAR2 | (1) | Indicates whether this application type is the system default. | |
ENROLL_DEPOSIT_AMOUNT | NUMBER | (13) | Enrollment Deposit Amount | |
ENROLL_DEPOSIT_LEVEL | VARCHAR2 | (30) | Enrollment Deposit Level | |
USE_IN_APPL_SELF_SRVC | VARCHAR2 | (1) | Specifies whether the application type should be displayed to the user in applicant self service or not | |
CRT_REV_INSTR | VARCHAR2 | (600) | Create and Review Instruction | |
SUBMIT_INSTR | VARCHAR2 | (600) | Submit Application Instruction | |
SUBMIT_ERR_INSTR | VARCHAR2 | (600) | Submit Error Instruction |
Cut, paste (and edit) the following text to query this object:
SELECT ADMISSION_APPLICATION_TYPE
, DESCRIPTION
, ADMISSION_CAT
, S_ADMISSION_PROCESS_TYPE
, CONFIGURABILITY_FUNC_NAME
, APPLICATION_FEE_AMOUNT
, GL_REV_ACCT_CCID
, GL_CASH_ACCT_CCID
, REV_ACCOUNT_CODE
, CASH_ACCOUNT_CODE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SYSTEM_DEFAULT
, ENROLL_DEPOSIT_AMOUNT
, ENROLL_DEPOSIT_LEVEL
, USE_IN_APPL_SELF_SRVC
, CRT_REV_INSTR
, SUBMIT_INSTR
, SUBMIT_ERR_INSTR
FROM IGS.IGS_AD_SS_APPL_TYP;
IGS.IGS_AD_SS_APPL_TYP does not reference any database object
IGS.IGS_AD_SS_APPL_TYP is referenced by following:
|
|
|