[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_ADM_APPL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_SS_ADM_APPL |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
An Admission Application Online View which stores all admission applications received online.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | ||
ROW_ID | ROWID | (10) | ||
SS_ADM_APPL_ID | NUMBER | (15) | Yes | |
SOURCE_TYPE_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
APPL_STATUS | VARCHAR2 | (30) | Yes | |
APPL_SUBMIT_DATE | DATE | |||
TEACH_PERIOD_SEQ_NUMBER | NUMBER | (15) | Yes | |
TEACH_PERIOD_CAL_TYPE | VARCHAR2 | (10) | Yes | |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | |
ACAD_CAL_SEQ_NUMBER | NUMBER | (15) | Yes | |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | |
ADM_CAL_SEQ_NUMBER | NUMBER | (15) | Yes | |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | |
S_ADM_PROCESS_TYPE | VARCHAR2 | (10) | Yes | |
ALIAS_TYPE | VARCHAR2 | (10) | ||
ALIAS_SURNAME | VARCHAR2 | (30) | ||
ALIAS_GIVEN_NAMES | VARCHAR2 | (40) | ||
ALIAS_TITLE | VARCHAR2 | (10) | ||
PERSON_ID_TYPE | VARCHAR2 | (10) | ||
RESID_STAT_ID | NUMBER | (15) | ||
API_PERSON_ID | VARCHAR2 | (20) | ||
ETHNIC_ORIGIN | VARCHAR2 | (60) | ||
LANGUAGE_CD1 | VARCHAR2 | (4) | ||
LANGUAGE_CD2 | VARCHAR2 | (4) | ||
MARITAL_STATUS | VARCHAR2 | (30) | ||
MARITAL_STATUS_EFFECTIVE_DATE | DATE | |||
COUNTRY_CD1 | VARCHAR2 | (2) | ||
COUNTRY_CD2 | VARCHAR2 | (2) | ||
PLACE_OF_BIRTH | VARCHAR2 | (60) | ||
VISA_TYPE | VARCHAR2 | (20) | ||
VISA_NUMBER | VARCHAR2 | (30) | ||
VISA_ISSUE_DATE | DATE | |||
VISA_EXPIRY_DT | DATE | |||
ENTRY_DATE | DATE | |||
PASSPORT_NUMBER1 | VARCHAR2 | (30) | ||
PASSPORT_EXPIRY_DATE1 | DATE | |||
ACT_NOTE_TYPE_ID | NUMBER | (15) | ||
ACT_NOTE_TEXT | VARCHAR2 | (2000) | ||
WE_NOTE_TYPE_ID | NUMBER | (15) | ||
WE_NOTE_TEXT | VARCHAR2 | (2000) | ||
LEVEL_OF_QUAL | NUMBER | (15) | ||
VETERAN | VARCHAR2 | (1) | ||
DEPENDENT_OF_VETERAN_IND | VARCHAR2 | (1) | ||
DEPENDENT_OF_VETERAN | NUMBER | (15) | ||
DISCLOSURE_IND | VARCHAR2 | (1) | ||
APP_SOURCE_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
STATUS | VARCHAR2 | (30) | Yes | |
ENTRY_STATUS | NUMBER | |||
ENTRY_LEVEL | NUMBER | |||
SCH_APL_TO_ID | NUMBER | |||
SPCL_GRP_1 | NUMBER | |||
SPCL_GRP_2 | NUMBER | |||
COMMON_APP | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, ROW_ID
, SS_ADM_APPL_ID
, SOURCE_TYPE_ID
, PERSON_ID
, APPL_STATUS
, APPL_SUBMIT_DATE
, TEACH_PERIOD_SEQ_NUMBER
, TEACH_PERIOD_CAL_TYPE
, ACAD_CAL_TYPE
, ACAD_CAL_SEQ_NUMBER
, ADM_CAL_TYPE
, ADM_CAL_SEQ_NUMBER
, ADMISSION_CAT
, S_ADM_PROCESS_TYPE
, ALIAS_TYPE
, ALIAS_SURNAME
, ALIAS_GIVEN_NAMES
, ALIAS_TITLE
, PERSON_ID_TYPE
, RESID_STAT_ID
, API_PERSON_ID
, ETHNIC_ORIGIN
, LANGUAGE_CD1
, LANGUAGE_CD2
, MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_DATE
, COUNTRY_CD1
, COUNTRY_CD2
, PLACE_OF_BIRTH
, VISA_TYPE
, VISA_NUMBER
, VISA_ISSUE_DATE
, VISA_EXPIRY_DT
, ENTRY_DATE
, PASSPORT_NUMBER1
, PASSPORT_EXPIRY_DATE1
, ACT_NOTE_TYPE_ID
, ACT_NOTE_TEXT
, WE_NOTE_TYPE_ID
, WE_NOTE_TEXT
, LEVEL_OF_QUAL
, VETERAN
, DEPENDENT_OF_VETERAN_IND
, DEPENDENT_OF_VETERAN
, DISCLOSURE_IND
, APP_SOURCE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, STATUS
, ENTRY_STATUS
, ENTRY_LEVEL
, SCH_APL_TO_ID
, SPCL_GRP_1
, SPCL_GRP_2
, COMMON_APP
FROM APPS.IGS_SS_ADM_APPL;
APPS.IGS_SS_ADM_APPL is not referenced by any database object
|
|
|