[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_ADM_APPL_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_SS_ADM_APPL_ALL |
Subobject Name: | |
Status: | VALID |
Stores all the details of the admission applications received online
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_SS_ADM_APPL_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SS_ADM_APPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Operating unit identifier | |
SS_ADM_APPL_ID | NUMBER | (15) | Yes | Online Admission Application Identifier ( SS_ADM_APPL_S ) |
SOURCE_TYPE_ID | NUMBER | (15) | Yes | Admission Application Type |
PERSON_ID | NUMBER | (15) | Yes | Person Id |
APPL_STATUS | VARCHAR2 | (30) | Yes | SAVED/SUBMITTED/TRANSFERRED/ERROR |
STATUS | VARCHAR2 | (30) | Yes | Inserted/Updated/Transferred |
APPL_SUBMIT_DATE | DATE | Application Submission Date | ||
TEACH_PERIOD_SEQ_NUMBER | NUMBER | (15) | Yes | Teaching Period Sequence Number |
TEACH_PERIOD_CAL_TYPE | VARCHAR2 | (10) | Yes | Teaching period calendar type. |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar Type |
ACAD_CAL_SEQ_NUMBER | NUMBER | (15) | Yes | Academic Calendar Sequence Number |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Admission Calendar Type |
ADM_CAL_SEQ_NUMBER | NUMBER | (15) | Yes | Admission Calendar Sequence Number |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Admission Category |
S_ADM_PROCESS_TYPE | VARCHAR2 | (10) | Yes | Admission Process Type |
ALIAS_TYPE | VARCHAR2 | (10) | Alias Type | |
ALIAS_SURNAME | VARCHAR2 | (30) | Alias Surname | |
ALIAS_GIVEN_NAMES | VARCHAR2 | (40) | Alias Given Names | |
ALIAS_TITLE | VARCHAR2 | (10) | Alias Title | |
PERSON_ID_TYPE | VARCHAR2 | (10) | Person Id type. | |
RESID_STAT_ID | NUMBER | (15) | Residency Status Identifier | |
API_PERSON_ID | VARCHAR2 | (20) | Alternate Person Id | |
ETHNIC_ORIGIN | VARCHAR2 | (60) | Ethnic Origin | |
LANGUAGE_CD1 | VARCHAR2 | (4) | Id for Language 1 | |
LANGUAGE_CD2 | VARCHAR2 | (4) | Id for Language 2 | |
MARITAL_STATUS | VARCHAR2 | (30) | Marital Status | |
MARITAL_STATUS_EFFECTIVE_DATE | DATE | Marital Status Effective Date | ||
COUNTRY_CD1 | VARCHAR2 | (2) | Code for country citizenship 1 | |
COUNTRY_CD2 | VARCHAR2 | (2) | Code for country citizenship 2 | |
PLACE_OF_BIRTH | VARCHAR2 | (60) | Place of birth | |
VISA_TYPE | VARCHAR2 | (20) | Type of Visa | |
VISA_NUMBER | VARCHAR2 | (30) | Visa Number - Default value will be 0 | |
VISA_EXPIRY_DT | DATE | Visa expiry date | ||
VISA_ISSUE_DATE | DATE | Visa Issue Date | ||
PASSPORT_NUMBER1 | VARCHAR2 | (30) | Passport Number One | |
PASSPORT_EXPIRY_DATE1 | DATE | Passport Expiry Date One | ||
ENTRY_DATE | DATE | Entry Date | ||
VETERAN | VARCHAR2 | (1) | Veteran | |
DEPENDENT_OF_VETERAN | NUMBER | (15) | Dependent Of Veteran | |
DEPENDENT_OF_VETERAN_IND | VARCHAR2 | (1) | Dependent Of Veteran | |
DISCLOSURE_IND | VARCHAR2 | (1) | Disclosure Indicator (Y/N) | |
LEVEL_OF_QUAL | NUMBER | (15) | Level of qualification | |
APP_SOURCE_ID | NUMBER | (15) | Application Source | |
ACT_NOTE_TYPE_ID | NUMBER | (15) | Note type for activity since last enrolled. | |
ACT_NOTE_TEXT | VARCHAR2 | (2000) | Note text for activity since last enrolled. | |
WE_NOTE_TYPE_ID | NUMBER | (15) | Note type for work experience | |
WE_NOTE_TEXT | VARCHAR2 | (2000) | Note text for work experience | |
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 | |
ENTRY_STATUS | NUMBER | Entry Status | ||
ENTRY_LEVEL | NUMBER | Entry Level | ||
SCH_APL_TO_ID | NUMBER | School Applied to Identifier | ||
SPCL_GRP_1 | NUMBER | Special Group 1 | ||
SPCL_GRP_2 | NUMBER | Special Group 2 | ||
COMMON_APP | VARCHAR2 | (1) | Common Application |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, SS_ADM_APPL_ID
, SOURCE_TYPE_ID
, PERSON_ID
, APPL_STATUS
, 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_EXPIRY_DT
, VISA_ISSUE_DATE
, PASSPORT_NUMBER1
, PASSPORT_EXPIRY_DATE1
, ENTRY_DATE
, VETERAN
, DEPENDENT_OF_VETERAN
, DEPENDENT_OF_VETERAN_IND
, DISCLOSURE_IND
, LEVEL_OF_QUAL
, APP_SOURCE_ID
, ACT_NOTE_TYPE_ID
, ACT_NOTE_TEXT
, WE_NOTE_TYPE_ID
, WE_NOTE_TEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENTRY_STATUS
, ENTRY_LEVEL
, SCH_APL_TO_ID
, SPCL_GRP_1
, SPCL_GRP_2
, COMMON_APP
FROM IGS.IGS_SS_ADM_APPL_ALL;
IGS.IGS_SS_ADM_APPL_ALL does not reference any database object
IGS.IGS_SS_ADM_APPL_ALL is referenced by following:
|
|
|