[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_ADM_APPL_STG |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_SS_ADM_APPL_STG |
Subobject Name: | |
Status: | VALID |
IGS_SS_ADM_APPL_STG describes admission of applicant to institution
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_SS_ADM_APPL_STG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SS_ADM_APPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SS_ADM_APPL_ID | NUMBER | (15) | Yes | Self Service Admission Application Identifier |
PERSON_ID | NUMBER | (15) | Yes | Person Id |
APPL_DATE | DATE | Application Date | ||
ACAD_CAL_TYPE | VARCHAR2 | (10) | Academic Calendar Type | |
ACAD_CAL_SEQ_NUMBER | NUMBER | (15) | Academic Calendar Sequence Number | |
ADM_CAL_TYPE | VARCHAR2 | (10) | Admission Calendar Type | |
ADM_CAL_SEQ_NUMBER | NUMBER | (15) | Admission Calendar Sequence Number | |
ADMISSION_CAT | VARCHAR2 | (10) | Admission Category | |
S_ADM_PROCESS_TYPE | VARCHAR2 | (10) | System Admission Process Type | |
ENTRY_STATUS | NUMBER | Entry Status - Obsolete | ||
ENTRY_LEVEL | NUMBER | Entry Level - Obsolete | ||
SPCL_GRP_1 | NUMBER | Special Group1 | ||
SPCL_GRP_2 | NUMBER | Special Group2 | ||
APPLY_FOR_FINAID | VARCHAR2 | (1) | Apply for Financial Aid indicator - Obsolete | |
FINAID_APPLY_DATE | DATE | Financial Aid Apply Date - Obsolete | ||
LAST_UPDATE_DATE | DATE | Yes | standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | standard who column |
CREATION_DATE | DATE | Yes | standard who column | |
CREATED_BY | NUMBER | (15) | Yes | standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | standard who column | |
COMMENCEMENT_PERIOD | VARCHAR2 | (21) | Commencement Period | |
ADMISSION_APPLICATION_TYPE | VARCHAR2 | (30) | Application Type | |
ORG_ID | NUMBER | (15) | Org id indicator | |
DESCRIPTION | VARCHAR2 | (60) | Description for Calendar (Admission) | |
APP_SOURCE_ID | NUMBER | (15) | Application Source Identifier | |
APPL_FEE_AMT | NUMBER | Application Fee Amount |
Cut, paste (and edit) the following text to query this object:
SELECT SS_ADM_APPL_ID
, PERSON_ID
, APPL_DATE
, ACAD_CAL_TYPE
, ACAD_CAL_SEQ_NUMBER
, ADM_CAL_TYPE
, ADM_CAL_SEQ_NUMBER
, ADMISSION_CAT
, S_ADM_PROCESS_TYPE
, ENTRY_STATUS
, ENTRY_LEVEL
, SPCL_GRP_1
, SPCL_GRP_2
, APPLY_FOR_FINAID
, FINAID_APPLY_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COMMENCEMENT_PERIOD
, ADMISSION_APPLICATION_TYPE
, ORG_ID
, DESCRIPTION
, APP_SOURCE_ID
, APPL_FEE_AMT
FROM IGS.IGS_SS_ADM_APPL_STG;
IGS.IGS_SS_ADM_APPL_STG does not reference any database object
IGS.IGS_SS_ADM_APPL_STG is referenced by following:
|
|
|