[Home] [Help] [Dependency Information]
Object Name: | IGS_SS_APP_PGM_STG |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_SS_APP_PGM_STG |
Subobject Name: | |
Status: | VALID |
Staging Table for Application Program Instance in SS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_SS_APP_PGM_STG_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SS_ADMAPPL_PGM_ID |
IGS_SS_APP_PGM_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SS_ADM_APPL_ID
PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SS_ADMAPPL_PGM_ID | NUMBER | (15) | Yes | A unique identifier to identify a Self Service Admission Application Program Instance |
SS_ADM_APPL_ID | NUMBER | (15) | Yes | A unique identifier to identify a Self Service Admission Application |
NOMINATED_COURSE_CD | VARCHAR2 | (6) | Program Code | |
CRV_VERSION_NUMBER | NUMBER | (6) | Program Version Number | |
PREFERENCE_NUMBER | NUMBER | (2) | Preference Number | |
UNIT_SET_1 | VARCHAR2 | (10) | Major 1. This columns is OBSOLETE | |
UNIT_SET_1_VER_NUMBER | NUMBER | (3) | Major 1 Version Number. This column is OBSOLETE | |
UNIT_SET_2 | VARCHAR2 | (10) | Major 2.This column is OBSOLETE | |
UNIT_SET_2_VER_NUMBER | NUMBER | (3) | Major 2 Version Number.This column is OBSOLETE | |
SCH_APL_TO_ID | NUMBER | School Applying to Id | ||
LOCATION_CD | VARCHAR2 | (10) | Location Code | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Attendance Type | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Attendance Mode | |
EDU_GOAL_PRIOR_ENROLL | NUMBER | (15) | Educational Goal Prior Enrollment | |
EDU_GOAL_POST_ENROLL | NUMBER | (15) | Educational Goal Post Enroll. This column is OBSOLETE | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flex field qualifier. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
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 | |
TITLE | VARCHAR2 | (90) | Title | |
UNIT_SET1_TITLE | VARCHAR2 | (90) | Major1 Title. This column is OBSOLETE | |
UNIT_SET2_TITLE | VARCHAR2 | (90) | Major2 Title. This columns is OBSOLETE | |
ATTRIBUTE21 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE22 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE23 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE24 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE25 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE26 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE27 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE28 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE29 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE30 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE31 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE32 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE33 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE34 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE35 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE36 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE37 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE38 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE39 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
ATTRIBUTE40 | VARCHAR2 | (150) | Standard Attribute Column. Meant for descriptive flex field. | |
PERSON_ID | NUMBER | (15) | Person Id | |
ORG_ID | NUMBER | (15) | Org Id Indicator | |
FINAL_UNIT_SET_CD | VARCHAR2 | (10) | Final unit set | |
FINAL_UNIT_SET_CD_VER | NUMBER | (3) | Final unit set version number | |
ENTRY_STATUS | NUMBER | Entry Status | ||
ENTRY_LEVEL | NUMBER | Entry Level | ||
APPLY_FOR_FINAID | VARCHAR2 | (1) | Apply for Financial Aid Indicator | |
FINAID_APPLY_DATE | DATE | Financial Aid Apply Date |
Cut, paste (and edit) the following text to query this object:
SELECT SS_ADMAPPL_PGM_ID
, SS_ADM_APPL_ID
, NOMINATED_COURSE_CD
, CRV_VERSION_NUMBER
, PREFERENCE_NUMBER
, UNIT_SET_1
, UNIT_SET_1_VER_NUMBER
, UNIT_SET_2
, UNIT_SET_2_VER_NUMBER
, SCH_APL_TO_ID
, LOCATION_CD
, ATTENDANCE_TYPE
, ATTENDANCE_MODE
, EDU_GOAL_PRIOR_ENROLL
, EDU_GOAL_POST_ENROLL
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TITLE
, UNIT_SET1_TITLE
, UNIT_SET2_TITLE
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE31
, ATTRIBUTE32
, ATTRIBUTE33
, ATTRIBUTE34
, ATTRIBUTE35
, ATTRIBUTE36
, ATTRIBUTE37
, ATTRIBUTE38
, ATTRIBUTE39
, ATTRIBUTE40
, PERSON_ID
, ORG_ID
, FINAL_UNIT_SET_CD
, FINAL_UNIT_SET_CD_VER
, ENTRY_STATUS
, ENTRY_LEVEL
, APPLY_FOR_FINAID
, FINAID_APPLY_DATE
FROM IGS.IGS_SS_APP_PGM_STG;
IGS.IGS_SS_APP_PGM_STG does not reference any database object
IGS.IGS_SS_APP_PGM_STG is referenced by following:
|
|
|