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

VIEW: APPS.IGS_EN_SCA_V

Object Details
Object Name: IGS_EN_SCA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_EN_SCA_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view would be used in the form


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
row_id
ORG_ID NUMBER (15)
Org id
PERSON_ID NUMBER (15) Yes person id
COURSE_CD VARCHAR2 (6) Yes course cd
VERSION_NUMBER NUMBER (3) Yes version number
CAL_TYPE VARCHAR2 (10) Yes cal type
LOCATION_CD VARCHAR2 (10) Yes location code
ATTENDANCE_MODE VARCHAR2 (2) Yes alternate mode
ATTENDANCE_TYPE VARCHAR2 (2) Yes attendance type
COO_ID NUMBER (7) Yes coo_id
STUDENT_CONFIRMED_IND VARCHAR2 (1) Yes Student confirmed indicator
COMMENCEMENT_DT DATE

Commencement Date
COURSE_ATTEMPT_STATUS VARCHAR2 (30)
Course attempt status
CAS_MEANING VARCHAR2 (80)
cas meaning
PROGRESSION_STATUS VARCHAR2 (30)
progression status
DERIVED_ATT_TYPE VARCHAR2 (2)
derived attendance type
DERIVED_ATT_MODE VARCHAR2 (2)
Derived attendance Mode
PROVISIONAL_IND VARCHAR2 (1) Yes Provisional Indicator
DISCONTINUED_DT DATE

Discontinued date
DISCONTINUATION_REASON_CD VARCHAR2 (10)
Discontinuation reason code
LAPSED_DT DATE

lapsed date
FUNDING_SOURCE VARCHAR2 (10)
finding source
EXAM_LOCATION_CD VARCHAR2 (10)
examination location code
DERIVED_COMPLETION_YR NUMBER (4)
derived completion date
DERIVED_COMPLETION_PERD VARCHAR2 (1)
derived completion period
NOMINATED_COMPLETION_YR NUMBER (4)
nominated completion year
NOMINATED_COMPLETION_PERD VARCHAR2 (30)
Nomination Completion period
RULE_CHECK_IND VARCHAR2 (1) Yes Rule check indicator
WAIVE_OPTION_CHECK_IND VARCHAR2 (1) Yes Waive option check indicator
LAST_RULE_CHECK_DT DATE

Last rule check date
PUBLISH_OUTCOMES_IND VARCHAR2 (1) Yes Publish outcomes indicator
COURSE_RQRMNT_COMPLETE_IND VARCHAR2 (1) Yes Course requirment complete indicator
COURSE_RQRMNTS_COMPLETE_DT DATE

Course requirment competion date
S_COMPLETED_SOURCE_TYPE VARCHAR2 (10)
completed source type
OVERRIDE_TIME_LIMITATION NUMBER (4)
Override time limitation
ADVANCED_STANDING_IND VARCHAR2 (1) Yes Advanced standing indicator
FEE_CAT VARCHAR2 (10)
Fee category
CORRESPONDENCE_CAT VARCHAR2 (10)
Correspondence category
SELF_HELP_GROUP_IND VARCHAR2 (1) Yes Self help group Indicator
LOGICAL_DELETE_DT DATE

Logical delete
ADM_ADMISSION_APPL_NUMBER NUMBER (2)
Adm Admission application Number
ADM_NOMINATED_COURSE_CD VARCHAR2 (6)
Adm nominated course
ADM_SEQUENCE_NUMBER NUMBER (6)
Adm sequence number
LAST_DATE_OF_ATTENDANCE DATE

Last date of attendance
DROPPED_BY VARCHAR2 (30)
Dropped By
IGS_PR_CLASS_STD_ID NUMBER (15)
IGgs_pr_Class_std_id
CREATED_BY NUMBER (15) Yes Standard Who columns
CREATION_DATE DATE
Yes Standard Who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard Who columns
LAST_UPDATE_DATE DATE
Yes Standard Who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who columns
REQUEST_ID NUMBER (15)
Request id
PROGRAM_APPLICATION_ID NUMBER (15)
program application id
PROGRAM_ID NUMBER (15)
program id
PROGRAM_UPDATE_DATE DATE

program update date
PRIMARY_PROGRAM_TYPE VARCHAR2 (10)
primary program type
PRIMARY_PROG_TYPE_SOURCE VARCHAR2 (10)
primary program type source
PRM_PRG_SOURCE_MEANING VARCHAR2 (80)
Primary Program type Source meaning
CATALOG_CAL_TYPE VARCHAR2 (10)
catalog cal type
CATALOG_SEQ_NUM NUMBER (6)
catalog sequence number
CATALOG VARCHAR2 (30)
catalog
COURSE_TYPE VARCHAR2 (10) Yes course type
TITLE VARCHAR2 (90) Yes title
KEY_PROGRAM VARCHAR2 (1)
key program
OVERRIDE_CMPL_DT DATE

Override Completion Date
MANUAL_OVR_CMPL_DT_IND VARCHAR2 (1)
Manual override completion date indicator
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Descriptive Flex Field Column.
ATTRIBUTE1 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE2 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE3 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE4 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE5 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE6 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE7 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE8 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE9 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE10 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE11 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE12 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE13 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE14 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE15 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE16 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE17 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE18 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE19 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
ATTRIBUTE20 VARCHAR2 (150)
Standard Descriptive Flex Field Column.
FUTURE_DATED_TRANS_FLAG VARCHAR2 (1) Yes Future dated transfer flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ORG_ID
,      PERSON_ID
,      COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      COO_ID
,      STUDENT_CONFIRMED_IND
,      COMMENCEMENT_DT
,      COURSE_ATTEMPT_STATUS
,      CAS_MEANING
,      PROGRESSION_STATUS
,      DERIVED_ATT_TYPE
,      DERIVED_ATT_MODE
,      PROVISIONAL_IND
,      DISCONTINUED_DT
,      DISCONTINUATION_REASON_CD
,      LAPSED_DT
,      FUNDING_SOURCE
,      EXAM_LOCATION_CD
,      DERIVED_COMPLETION_YR
,      DERIVED_COMPLETION_PERD
,      NOMINATED_COMPLETION_YR
,      NOMINATED_COMPLETION_PERD
,      RULE_CHECK_IND
,      WAIVE_OPTION_CHECK_IND
,      LAST_RULE_CHECK_DT
,      PUBLISH_OUTCOMES_IND
,      COURSE_RQRMNT_COMPLETE_IND
,      COURSE_RQRMNTS_COMPLETE_DT
,      S_COMPLETED_SOURCE_TYPE
,      OVERRIDE_TIME_LIMITATION
,      ADVANCED_STANDING_IND
,      FEE_CAT
,      CORRESPONDENCE_CAT
,      SELF_HELP_GROUP_IND
,      LOGICAL_DELETE_DT
,      ADM_ADMISSION_APPL_NUMBER
,      ADM_NOMINATED_COURSE_CD
,      ADM_SEQUENCE_NUMBER
,      LAST_DATE_OF_ATTENDANCE
,      DROPPED_BY
,      IGS_PR_CLASS_STD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRIMARY_PROGRAM_TYPE
,      PRIMARY_PROG_TYPE_SOURCE
,      PRM_PRG_SOURCE_MEANING
,      CATALOG_CAL_TYPE
,      CATALOG_SEQ_NUM
,      CATALOG
,      COURSE_TYPE
,      TITLE
,      KEY_PROGRAM
,      OVERRIDE_CMPL_DT
,      MANUAL_OVR_CMPL_DT_IND
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      FUTURE_DATED_TRANS_FLAG
FROM APPS.IGS_EN_SCA_V;

Dependencies

[top of page]

APPS.IGS_EN_SCA_V references the following:

SchemaAPPS
ViewIGS_CA_INST
ViewIGS_EN_STDNT_PS_ATT_SV
ViewIGS_LOOKUP_VALUES
ViewIGS_PS_VER
APPS.IGS_EN_SCA_V is referenced by following:

SchemaAPPS
Package BodyIGS_AS_PROD_DOC - show dependent code
Package BodyIGS_EN_GEN_010 - show dependent code
Package BodyIGS_EN_IVR_PUB - show dependent code
Package BodyIGS_EN_SUA_LGCY_PUB - show dependent code
Package BodyIGS_PR_CLASS_RANK - show dependent code
PL/SQL PackageIGS_PR_CLASS_RANK - show dependent code
Package BodyIGS_PT_GEN_PKG - show dependent code