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

VIEW: APPS.IGSFV_PR_STDNT_PR_OU

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

View Type

A Business Intelligence System view


Describes Student Progression Rule Check


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_NAME VARCHAR2 (360) Yes Describes the person name.
PERSON_NUMBER VARCHAR2 (30) Yes Describes the person number.
PROGRAM_TITLE VARCHAR2 (90) Yes Describes the program title which the Progression is being measured in.
PROGRAM_CODE VARCHAR2 (6) Yes Describes the program which the Progression is being measured in.
PRG_CAL_TYPE VARCHAR2 (10)
Describes the Progression Calendar Type.
PRG_CI_SEQUENCE_NUMBER NUMBER (6)
Describes the Progression Calendar Instance Sequence Number.
PROGRESSION_CALENDAR VARCHAR2 (30)
Describes the Calendar Instance which the Progression Rule is being tested in.
RULE_CHECK_DT DATE

Describes the date the Progression Rule Check was made.
PROGRESSION_RULE_CAT VARCHAR2 (10)
Describes the Progression Rule Category.
RULE_CATEGORY_DESCRIPTION VARCHAR2 (60)
Describes the Progression Rule Category of the rule which was tested.
PROGRESSION_OUTCOME_TYPE VARCHAR2 (10)
Describes the Progression Outcome Type.
OUTCOME_DESCRIPTION VARCHAR2 (60)
Describes the Progression Rule Outcome of the rule which was tested.
DURATION NUMBER (3)
Describes the Duration of the outcome as a number of periods.
DURATION_TYPE VARCHAR2 (10)
Describes the Duration Type of the outcome.
DECISION_STATUS VARCHAR2 (10) Yes Describes the Decision Status for this Outcome.
DECISION_DT DATE

Describes the date a Decision was made for this Outcome.
DECISION_ORG_UNIT_CD VARCHAR2 (30)
Describes the Organizational Unit who made the decision for this Outcome.
DECISION_OU_START_DT DATE

Describes the Start Date of the Organizational Unit who made the decision for this Outcome.
DECISION_ORG_UNIT_NAME VARCHAR2 (360)
Describes the name of the Decision Organizational Unit.
APPLIED_DT DATE

Describes the date this Outcome was Applied.
EXPIRY_DT DATE

Describes the date this Outcome was Expires.
SHOW_CAUSE_EXPIRY_DT DATE

Describes the Expiration Date of the Show Cause period.
SHOW_CAUSE_DT DATE

Describes the Date the Student made a Show Cause.
SHOW_CAUSE_OUTCOME_DT DATE

Describes the Date an Outcome was determined for a Student Show Cause.
SHOW_CAUSE_OUTCOME_TYPE VARCHAR2 (10)
Describes the Outcome determined for a Student Show Cause.
SHOW_CAUSE_COMMENTS VARCHAR2 (2000)
Describes the Comments related to a Student Show Cause.
APPEAL_EXPIRY_DT DATE

Describes the Expiration Date of the Appeal period.
APPEAL_DT DATE

Describes the Date the Student made an Appeal.
APPEAL_OUTCOME_DT DATE

Describes the Date an Outcome was determined for a Student Appeal.
APPEAL_OUTCOME_TYPE VARCHAR2 (10)
Describes the Outcome determined for a Student Appeal.
APPEAL_COMMENTS VARCHAR2 (2000)
Describes the Comments related to a Student Appeal.
ENCMB_COURSE_GROUP_CD VARCHAR2 (10)
Describes the Program Group Code to be used for any hold effects.
COURSE_GROUP_DESCRIPTION VARCHAR2 (60)
Describes the Program Group Code to be used for any hold effects.
RESTRICTED_ENROLMENT_CP NUMBER (6)
Describes the Restricted Enrollment Credit Points to be used for any hold effects.
RESTRICTED_ATTENDANCE_TYPE VARCHAR2 (2)
Describes the Restricted Attendance Type to be used for any hold effects.
ATTENDANCE_TYPE_DESCRIPTION VARCHAR2 (60)
Describes the Restricted Attendance Type to be used for any hold effects.
COMMENTS VARCHAR2 (2000)
Describes the Comments related to this Student Progression Outcome.
SEQUENCE_NUMBER NUMBER (6) Yes Describes the Student Progression Outcome Sequence Number.
PERSON_ID NUMBER (15) Yes Describes the ID that uniquely identifies a person.
PRA_SEQUENCE_NUMBER NUMBER (6)
Describes the Progression Rule Application Sequence Number.
PRO_PRA_SEQUENCE_NUMBER NUMBER (6)
Describes the Progression Rule Application Sequence Number from the Progression Rule Outcome.
PRO_SEQUENCE_NUMBER NUMBER (6)
Describes the Progression Rule Outcome Sequence Number.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT PERSON_NAME
,      PERSON_NUMBER
,      PROGRAM_TITLE
,      PROGRAM_CODE
,      PRG_CAL_TYPE
,      PRG_CI_SEQUENCE_NUMBER
,      PROGRESSION_CALENDAR
,      RULE_CHECK_DT
,      PROGRESSION_RULE_CAT
,      RULE_CATEGORY_DESCRIPTION
,      PROGRESSION_OUTCOME_TYPE
,      OUTCOME_DESCRIPTION
,      DURATION
,      DURATION_TYPE
,      DECISION_STATUS
,      DECISION_DT
,      DECISION_ORG_UNIT_CD
,      DECISION_OU_START_DT
,      DECISION_ORG_UNIT_NAME
,      APPLIED_DT
,      EXPIRY_DT
,      SHOW_CAUSE_EXPIRY_DT
,      SHOW_CAUSE_DT
,      SHOW_CAUSE_OUTCOME_DT
,      SHOW_CAUSE_OUTCOME_TYPE
,      SHOW_CAUSE_COMMENTS
,      APPEAL_EXPIRY_DT
,      APPEAL_DT
,      APPEAL_OUTCOME_DT
,      APPEAL_OUTCOME_TYPE
,      APPEAL_COMMENTS
,      ENCMB_COURSE_GROUP_CD
,      COURSE_GROUP_DESCRIPTION
,      RESTRICTED_ENROLMENT_CP
,      RESTRICTED_ATTENDANCE_TYPE
,      ATTENDANCE_TYPE_DESCRIPTION
,      COMMENTS
,      SEQUENCE_NUMBER
,      PERSON_ID
,      PRA_SEQUENCE_NUMBER
,      PRO_PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PR_STDNT_PR_OU;

Dependencies

[top of page]

APPS.IGSFV_PR_STDNT_PR_OU references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_CA_INST_ALL
SynonymIGS_EN_ATD_TYPE_ALL
SynonymIGS_EN_STDNT_PS_ATT_ALL
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PR_OU_TYPE_ALL
SynonymIGS_PR_RU_CAT
SynonymIGS_PR_STDNT_PR_OU_ALL
SynonymIGS_PS_GRP_ALL
SynonymIGS_PS_VER_ALL

APPS.IGSFV_PR_STDNT_PR_OU is not referenced by any database object