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

TABLE: IGS.IGS_DA_OUT_UNT_EN

Object Details
Object Name: IGS_DA_OUT_UNT_EN
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_DA_OUT_UNT_EN
Subobject Name:
Status: VALID


Storage for the outgoing Enrollment units for the student in the Degree Audit Request --Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_DA_OUT_UNT_EN_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPERSON_ID
ColumnUNIT_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Identifies the parent request for data in the table.
PERSON_ID NUMBER (15) Yes Identifies student selected in the request
UNIT_SEQ_NUM NUMBER
Yes Sequence number associated with each student unit attempt for the student in the request.
HOME_INST_ID VARCHAR2 (30)
Identifies an institution as the local institution for students selected by the request.
HOME_INST_ALT_ID VARCHAR2 (20)
Provides an alternate institution identifier for the local institution.
UNIT_INSITUTION_ID VARCHAR2 (30)
Indicates institution where unit attempt is taken.
ALT_INSTITUTION_ID VARCHAR2 (20)
Provides an alternate identifier for the institution where unit attempt is taken.
TEACHING_PERIOD VARCHAR2 (30)
Indicates teaching period in which unit attempt is taken.
UNIT_CODE VARCHAR2 (10)
Indicates unit code of attempted unit.
UNIT_VERSION NUMBER (3)
Indicates version of unit code for attempted unit
ORGANIZATIONAL_UNIT VARCHAR2 (30)
Indicates organizational unit responsible for the unit code/version.
LOCATION VARCHAR2 (10)
Indicates location where the unit code/version is taught.
UNIT_CLASS VARCHAR2 (10)
Indicates code associated with the unit code/version which usually corresponds to "section number" in legacy information.
UNIT_INTERNAL_PROG_LVL VARCHAR2 (10)
Indicates internal program level associated with unit code/version.
UNIT_LEVEL VARCHAR2 (4)
Indicates unit level associated with unit code/version.
UNIT_TITLE VARCHAR2 (90)
Indicates title of unit code/version.
UNIT_SUBTITLE VARCHAR2 (90)
Indicates subtitle of the unit code/version or unit class.
SHORT_TITLE VARCHAR2 (40)
Indicates short title of unit code/version.
UNIT_ATTEMPT_STATUS VARCHAR2 (30)
Indicates student unit attempt status.
FINALIZED_GRADE_IND VARCHAR2 (1)
Indicates whether grade is final or not
UNIT_GRADE VARCHAR2 (5)
Indicates grade for student unit attempt.
UNIT_MARK NUMBER (6)
Indicates mark for student unit attempt
GRADING_SCHEMA VARCHAR2 (10)
Indicates grading scheme associated with grade or mark for the student unit attempt.
GRADING_SCHEMA_VERS NUMBER (3)
Version of the grading schema
TRANSL_UNIT_GRADE VARCHAR2 (5)
Indicates the translated grade when a grade is translated between grading schemas.
TRANSL_GRADE_SCHEMA VARCHAR2 (10)
Indicates grading schema into which original grade is translated.
TRANSL_GRADE_SCHEMA_VER NUMBER (3)
Indicates version of grading schema into which original grade is translated.
UNIT_CREDIT_SIGN VARCHAR2 (1)
Indicates whether credit for the student unit attempt is positive or negative NULL for positive, "-" for negative
UNIT_CREDIT_PTS NUMBER (9)
Indicates maximum number of credits allowed to be earned - set at system level
ACHIEVABLE_CRED_PTS NUMBER (6)
Indicates maximum number of credits allowed to be earned - set at system level
UNIT_PTS_EARN_ACHIEVED NUMBER (9)
Indicates number of credits the student earns after satisfactory/unsatisfactory completion of the class
LECT_CREDIT_PTS NUMBER (6)
Indicates number of lecture credit points associated with the unit code/version
LAB_CREDIT_PTS NUMBER (6)
Indicates number of lab credit points associated with the unit code/version
CONTIN_EDU_UNITS NUMBER (6)
Indicates number of continuing education credits associated with unit code/version
OTHER_CREDIT_PTS NUMBER (6)
Indicates number of user-defined credits associated with unit code/version
EQUIV_FULL_STUDENT_UNIT NUMBER (7)
Indicates number of equivalent full-time student credits (government reporting information) associated with the unit code/version
OVERRIDE_EFTSU NUMBER (7)
Indicates overridden number of equivalent full-time student credits associated with the student unit attempt
REPEAT_IND VARCHAR2 (1)
Indicates whether unit code/version can be repeated. Y indicates YES, N indicates NO.
REP_MAX_TIMES_CRED NUMBER (3)
Indicates maximum number of times unit code/version can be repeated
REP_MAX_CRD_PTS NUMBER (5)
Indicates maximum number of credit points for which unit code/version can be repeated.
REP_MAX_CRD_PTS_PERIOD NUMBER (5)
Indicates maximum number of credit points for which unit code/version can be repeated within one teaching period
REP_MAX_TIMES_PERIOD NUMBER (3)
Indicates maximum number of times unit code/version can be repeated in one period
AWARD_PROG_IND VARCHAR2 (1)
Indicates whether the unit can count toward program award requirements.
BASIC_UNIT_DET1 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 1
BASIC_UNIT_DET2 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute2
BASIC_UNIT_DET3 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 3
BASIC_UNIT_DET4 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 4
BASIC_UNIT_DET5 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 5
BASIC_UNIT_DET6 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 6
BASIC_UNIT_DET7 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 7
BASIC_UNIT_DET8 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 8
BASIC_UNIT_DET9 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 9
BASIC_UNIT_DET10 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute10
BASIC_UNIT_DET11 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 11
BASIC_UNIT_DET12 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 12
BASIC_UNIT_DET13 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 13
BASIC_UNIT_DET14 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 14
BASIC_UNIT_DET15 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 15
BASIC_UNIT_DET16 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 16
BASIC_UNIT_DET17 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 17
BASIC_UNIT_DET18 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 18
BASIC_UNIT_DET19 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 19
BASIC_UNIT_DET20 VARCHAR2 (150)
Basic Unit DetailsScreen DFF Attribute 20
UNIT_SEC_DET1 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 1
UNIT_SEC_DET2 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 2
UNIT_SEC_DET3 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 3
UNIT_SEC_DET4 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 4
UNIT_SEC_DET5 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 5
UNIT_SEC_DET6 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 6
UNIT_SEC_DET7 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 7
UNIT_SEC_DET8 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 8
UNIT_SEC_DET9 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 9
UNIT_SEC_DET10 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 10
UNIT_SEC_DET11 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 11
UNIT_SEC_DET12 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 12
UNIT_SEC_DET13 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 13
UNIT_SEC_DET14 VARCHAR2 (150)
Basic Unit Section DetailsScreen DFF Attribute 14
UNIT_SEC_DET15 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 15
UNIT_SEC_DET16 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 16
UNIT_SEC_DET17 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 17
UNIT_SEC_DET18 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 18
UNIT_SEC_DET19 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 19
UNIT_SEC_DET20 VARCHAR2 (150)
Basic Unit Section Details Screen DFF Attribute 20
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
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 BATCH_ID
,      PERSON_ID
,      UNIT_SEQ_NUM
,      HOME_INST_ID
,      HOME_INST_ALT_ID
,      UNIT_INSITUTION_ID
,      ALT_INSTITUTION_ID
,      TEACHING_PERIOD
,      UNIT_CODE
,      UNIT_VERSION
,      ORGANIZATIONAL_UNIT
,      LOCATION
,      UNIT_CLASS
,      UNIT_INTERNAL_PROG_LVL
,      UNIT_LEVEL
,      UNIT_TITLE
,      UNIT_SUBTITLE
,      SHORT_TITLE
,      UNIT_ATTEMPT_STATUS
,      FINALIZED_GRADE_IND
,      UNIT_GRADE
,      UNIT_MARK
,      GRADING_SCHEMA
,      GRADING_SCHEMA_VERS
,      TRANSL_UNIT_GRADE
,      TRANSL_GRADE_SCHEMA
,      TRANSL_GRADE_SCHEMA_VER
,      UNIT_CREDIT_SIGN
,      UNIT_CREDIT_PTS
,      ACHIEVABLE_CRED_PTS
,      UNIT_PTS_EARN_ACHIEVED
,      LECT_CREDIT_PTS
,      LAB_CREDIT_PTS
,      CONTIN_EDU_UNITS
,      OTHER_CREDIT_PTS
,      EQUIV_FULL_STUDENT_UNIT
,      OVERRIDE_EFTSU
,      REPEAT_IND
,      REP_MAX_TIMES_CRED
,      REP_MAX_CRD_PTS
,      REP_MAX_CRD_PTS_PERIOD
,      REP_MAX_TIMES_PERIOD
,      AWARD_PROG_IND
,      BASIC_UNIT_DET1
,      BASIC_UNIT_DET2
,      BASIC_UNIT_DET3
,      BASIC_UNIT_DET4
,      BASIC_UNIT_DET5
,      BASIC_UNIT_DET6
,      BASIC_UNIT_DET7
,      BASIC_UNIT_DET8
,      BASIC_UNIT_DET9
,      BASIC_UNIT_DET10
,      BASIC_UNIT_DET11
,      BASIC_UNIT_DET12
,      BASIC_UNIT_DET13
,      BASIC_UNIT_DET14
,      BASIC_UNIT_DET15
,      BASIC_UNIT_DET16
,      BASIC_UNIT_DET17
,      BASIC_UNIT_DET18
,      BASIC_UNIT_DET19
,      BASIC_UNIT_DET20
,      UNIT_SEC_DET1
,      UNIT_SEC_DET2
,      UNIT_SEC_DET3
,      UNIT_SEC_DET4
,      UNIT_SEC_DET5
,      UNIT_SEC_DET6
,      UNIT_SEC_DET7
,      UNIT_SEC_DET8
,      UNIT_SEC_DET9
,      UNIT_SEC_DET10
,      UNIT_SEC_DET11
,      UNIT_SEC_DET12
,      UNIT_SEC_DET13
,      UNIT_SEC_DET14
,      UNIT_SEC_DET15
,      UNIT_SEC_DET16
,      UNIT_SEC_DET17
,      UNIT_SEC_DET18
,      UNIT_SEC_DET19
,      UNIT_SEC_DET20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_UNT_EN;

Dependencies

[top of page]

IGS.IGS_DA_OUT_UNT_EN does not reference any database object

IGS.IGS_DA_OUT_UNT_EN is referenced by following:

SchemaAPPS
SynonymIGS_DA_OUT_UNT_EN