[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SCAH_EFFECTIVE_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SCAH_EFFECTIVE_H_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|