[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_DA_OUT_UNT_AS |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_DA_OUT_UNT_AS
|
| Subobject Name: | |
| Status: | VALID |
IGS_DA_OUT_UNT_AS stores outgoing advanced standing information for students selected in the request. --Obsolete
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_DA_OUT_UNT_AS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
PERSON_ID
UNIT_SEQ_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | Yes | Unique ID for a request | |
| PERSON_ID | NUMBER | (15) | Yes | Unique identifier for a person |
| UNIT_SEQ_NUM | NUMBER | Yes | Sequence number for each unit or unit level for the students selected 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) | Alternate institution id for "local" institution | |
| EXEMPTION_INST_ID | VARCHAR2 | (30) | Id of the institution where the exemption is being given | |
| ALT_INSTITUTION_ID | VARCHAR2 | (20) | Alternate institution code definition for exemption institution. | |
| TERM_PERIOD | VARCHAR2 | (30) | Indicates term to which advanced standing applies. Term can differ from term when source unit was taken at previous institution. | |
| UNIT_CODE | VARCHAR2 | (10) | Indicates unit code assigned as result of transfer evaluation. | |
| UNIT_VERSION | NUMBER | (3) | Indicates version associated with unit code. | |
| ORGANIZATIONAL_UNIT | VARCHAR2 | (30) | Organizational unit responsible for the unit code/version. | |
| UNIT_INTERNAL_PROG_LVL | VARCHAR2 | (10) | Internal program level associated with the unit code/version. | |
| UNIT_LEVEL | VARCHAR2 | (4) | Indicates unit level assigned to unit code at system level. | |
| ADV_STAND_UNIT_LVL | VARCHAR2 | (4) | Advanced standing level associated with the unit level code. This is unit level designated in advanced standing details | |
| UNIT_TITLE | VARCHAR2 | (90) | Title of the unit code/version. | |
| UNIT_LEVEL_DESCRIPTION | VARCHAR2 | (60) | Indicates the description of the unit level. | |
| ADV_STAND_TYPE | VARCHAR2 | (30) | Type of recognition associated with the unit code/version or unit level code. | |
| ADV_STAND_GRANT_STAT | VARCHAR2 | (30) | Status associated with the unit code/version. | |
| ADV_STAND_LVL_GRNT_STATUS | VARCHAR2 | (30) | Status associated with the unit level code. | |
| UNIT_GRADE | VARCHAR2 | (5) | Indicates grade for the advanced standing unit code/version or unit level granted. | |
| GRADING_SCHEMA | VARCHAR2 | (10) | Indicates grading schema associated with grade for the unit code/version or unit level. | |
| GRADING_SCHEMA_VERSION | NUMBER | (3) | Indicates version of the grading schema. | |
| UNIT_CREDIT_SIGN | VARCHAR2 | (1) | Indicates whether advanced standing credits are positive or negative. Null for positive, "-" for negative | |
| UNIT_PTS_EARN_ACHVE | NUMBER | (9) | Indicates number of credits assigned to the unit code/version or unit level as a result of the transfer evaluation | |
| GPA_PTS | NUMBER | Indicates derived grade point average value for unit code/version or unit level. | ||
| QUALITY_PTS_EARNED | NUMBER | Indicates quality points earned for the unit code/version or unit level as a result of the transfer evaluation. This value is used to calculate a grade point average for advanced standing credits. | ||
| ADV_STAND_UNIT_APPR_DATE | DATE | Indicates date the advanced standing unit code/version credit is approved. | ||
| ADV_STAND_UNIT_EXP_DATE | DATE | Indicates date the approved advanced standing unit code/version credit will expire pending some condition or action. | ||
| ADV_STAND_UNIT_GRNT_DATE | DATE | Indicates date the approved advanced standing unit code/version credit is granted as a result of a pending condition or action being satisfied | ||
| ADV_STAND_LVL_APPR_DATE | DATE | Indicates date the advanced standing unit level credit is approved. | ||
| ADV_STAND_LVL_EXP_DATE | DATE | Indicates date the approved advanced standing unit level credit will expire pending some condition or action | ||
| ADV_STAND_LVL_GRANT_DATE | DATE | Indicates date the approved advanced standing unit level credit is granted as a result of a pending condition or action being satisfied. | ||
| SRC_UNIT_INSTITUTION_ID | VARCHAR2 | (30) | Identifies previous institution where source unit was taken. | |
| SRC_ALT_INSTITUTION_ID | VARCHAR2 | (20) | Provides an alternate id for the previous institution where the source unit was taken. | |
| SRC_UNIT_CODE | VARCHAR2 | (10) | Previous institution's code for the unit. | |
| SRC_UNIT_TITLE | VARCHAR2 | (90) | Previous institution's title for the unit. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Column Attribute category | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF Attribute1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute15 | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute16 | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute17 | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute18 | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute19 | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Basic Unit Detail Screen DFF attribute20 | |
| 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 | |
| REPEAT_IND | VARCHAR2 | (1) | Indicates whether unit code/version can be repeated.Y indicates YES, N indicates NO. | |
| REP_MAX_TIMES_CRED | NUMBER | (3) | Maximum number of cumulative times the unit code/version may 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. | |
| 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 |
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
, EXEMPTION_INST_ID
, ALT_INSTITUTION_ID
, TERM_PERIOD
, UNIT_CODE
, UNIT_VERSION
, ORGANIZATIONAL_UNIT
, UNIT_INTERNAL_PROG_LVL
, UNIT_LEVEL
, ADV_STAND_UNIT_LVL
, UNIT_TITLE
, UNIT_LEVEL_DESCRIPTION
, ADV_STAND_TYPE
, ADV_STAND_GRANT_STAT
, ADV_STAND_LVL_GRNT_STATUS
, UNIT_GRADE
, GRADING_SCHEMA
, GRADING_SCHEMA_VERSION
, UNIT_CREDIT_SIGN
, UNIT_PTS_EARN_ACHVE
, GPA_PTS
, QUALITY_PTS_EARNED
, ADV_STAND_UNIT_APPR_DATE
, ADV_STAND_UNIT_EXP_DATE
, ADV_STAND_UNIT_GRNT_DATE
, ADV_STAND_LVL_APPR_DATE
, ADV_STAND_LVL_EXP_DATE
, ADV_STAND_LVL_GRANT_DATE
, SRC_UNIT_INSTITUTION_ID
, SRC_ALT_INSTITUTION_ID
, SRC_UNIT_CODE
, SRC_UNIT_TITLE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LECT_CREDIT_PTS
, LAB_CREDIT_PTS
, CONTIN_EDU_UNITS
, OTHER_CREDIT_PTS
, REPEAT_IND
, REP_MAX_TIMES_CRED
, REP_MAX_CRD_PTS
, REP_MAX_CRD_PTS_PERIOD
, REP_MAX_TIMES_PERIOD
, AWARD_PROG_IND
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_UNT_AS;
IGS.IGS_DA_OUT_UNT_AS does not reference any database object
IGS.IGS_DA_OUT_UNT_AS is referenced by following:
APPS
IGS_DA_OUT_UNT_AS
|
|
|
|