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

VIEW: APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V

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

View Type

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


No longer used


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15)
Person indetifier
COURSE_CD VARCHAR2 (6)
Program 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) Yes 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
F_CAT_REL_CAL_TYP VARCHAR2 (10) Yes The calendar type of the previously assessed fee category
F_CAT_REL_CAL_SEQ_NUM NUMBER (6) Yes The calendar instance of the previously assessed fee category
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
,      F_CAT_REL_CAL_TYP
,      F_CAT_REL_CAL_SEQ_NUM
FROM APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V;

Dependencies

[top of page]

APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V references the following:

SchemaAPPS
ViewIGS_AS_SCAH_EFFECTIVE_H_V
PL/SQL PackageIGS_AU_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GET_SCAEH_DTL - show dependent code
SynonymIGS_FI_F_CAT_CAL_REL
PL/SQL PackageIGS_GE_DATE - show dependent code
PL/SQL PackageIGS_GE_NUMBER - show dependent code

APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V is not referenced by any database object