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

VIEW: APPS.IGS_AS_SCAH_EFFECTIVE_H_V

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

View Type

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


This view is used to create effective student course attempt history
records in recognition of backdating commencement and discontinuation
dates.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15)
Person indetifier
COURSE_CD VARCHAR2 (6)
Course code
EFFECTIVE_START_DT DATE

Program effective start date
EFFECTIVE_END_DT DATE

Program effective end date
VERSION_NUMBER NUMBER

Program version number
CAL_TYPE VARCHAR2 (10)
Calendar type
LOCATION_CD VARCHAR2 (10)
Location code
ATTENDANCE_MODE VARCHAR2 (2)
Attendande mode
ATTENDANCE_TYPE VARCHAR2 (2)
Attendande type
STUDENT_CONFIRMED_IND VARCHAR2 (1)
Confirmation indicator
COMMENCEMENT_DT DATE

Program commencement date
COURSE_ATTEMPT_STATUS VARCHAR2 (10)
Program attempt status
DERIVED_ATT_TYPE VARCHAR2 (10)
Derived attendance type
DERIVED_ATT_MODE VARCHAR2 (10)
Derived attendance mode
PROVISIONAL_IND VARCHAR2 (1)
Provisional indicator
DISCONTINUED_DT DATE

Discontinuation date
DISCONTINUATION_REASON_CD VARCHAR2 (10)
Discontinuation reason code
FUNDING_SOURCE VARCHAR2 (10)
Funding source
EXAM_LOCATION_CD VARCHAR2 (10)
Examination location code
DERIVED_COMPLETION_YR NUMBER

Derived completion year
DERIVED_COMPLETION_PERD VARCHAR2 (1)
Derived completion period
NOMINATED_COMPLETION_YR NUMBER

Nominated completion year
NOMINATED_COMPLETION_PERD VARCHAR2 (1)
Nominated completion period
RULE_CHECK_IND VARCHAR2 (1)
Rule check indicator
WAIVE_OPTION_CHECK_IND VARCHAR2 (1)
Waiver option check indicator
LAST_RULE_CHECK_DT DATE

Last rule check date
PUBLISH_OUTCOMES_IND VARCHAR2 (1)
Publish outcomes indicator
COURSE_RQRMNT_COMPLETE_IND VARCHAR2 (1)
Program completion requirement indicator
OVERRIDE_TIME_LIMITATION NUMBER

Override time limitation
ADVANCED_STANDING_IND VARCHAR2 (1)
Advanced standing indicator
FEE_CAT VARCHAR2 (10)
Fee category
CORRESPONDENCE_CAT VARCHAR2 (10)
Correspondence category
SELF_HELP_GROUP_IND VARCHAR2 (1)
Self help group indicator
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PRIMARY_PROGRAM_TYPE VARCHAR2 (10)
Primary Program Type
KEY_PROGRAM VARCHAR2 (1)
Key Program
Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      EFFECTIVE_START_DT
,      EFFECTIVE_END_DT
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      STUDENT_CONFIRMED_IND
,      COMMENCEMENT_DT
,      COURSE_ATTEMPT_STATUS
,      DERIVED_ATT_TYPE
,      DERIVED_ATT_MODE
,      PROVISIONAL_IND
,      DISCONTINUED_DT
,      DISCONTINUATION_REASON_CD
,      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
,      OVERRIDE_TIME_LIMITATION
,      ADVANCED_STANDING_IND
,      FEE_CAT
,      CORRESPONDENCE_CAT
,      SELF_HELP_GROUP_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PRIMARY_PROGRAM_TYPE
,      KEY_PROGRAM
FROM APPS.IGS_AS_SCAH_EFFECTIVE_H_V;

Dependencies

[top of page]

APPS.IGS_AS_SCAH_EFFECTIVE_H_V references the following:

SchemaAPPS
ViewIGS_AS_SCA_H_V
PL/SQL PackageIGS_AU_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GET_SCAEH_DTL - show dependent code
PL/SQL PackageIGS_GE_DATE - show dependent code
PL/SQL PackageIGS_GE_NUMBER - show dependent code
APPS.IGS_AS_SCAH_EFFECTIVE_H_V is referenced by following:

SchemaAPPS
ViewIGS_FI_SCAH_EFFECTIVE_H_CAT_V
Package BodyIGS_FI_VAL_FAS - show dependent code
Package BodyIGS_ST_GEN_004 - show dependent code