DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_SS_APP_PGM_STG

Object Details
Object Name: IGS_SS_APP_PGM_STG
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_SS_APP_PGM_STG
Subobject Name:
Status: VALID


Staging Table for Application Program Instance in SS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_SS_APP_PGM_STG_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSS_ADMAPPL_PGM_ID
IGS_SS_APP_PGM_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSS_ADM_APPL_ID
ColumnPERSON_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

IGS.IGS_SS_APP_PGM_STG does not reference any database object

IGS.IGS_SS_APP_PGM_STG is referenced by following:

SchemaAPPS
SynonymIGS_SS_APP_PGM_STG