[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_DA_OUT_PRG |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_DA_OUT_PRG
|
| Subobject Name: | |
| Status: | VALID |
Storage for the outgoing program for the declared and requested information on the Student in the Degree Audit Request. --Obsolete
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_DA_OUT_PRG_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
PERSON_ID
PROG_SEQ_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | Yes | Unique ID for a request | |
| PERSON_ID | NUMBER | (15) | Yes | person_id |
| PROG_SEQ_NUM | NUMBER | Yes | Sequence id which serves as the "parent" program to its associated major(s), minor(s) and track/option(s). | |
| PRM_REQUEST_TYPE | VARCHAR2 | (1) | Yes | Indicates type of program associated with above prog_seq_num, requested program, officially declared program, or combination Values:D (declared), R (requested, non-declared), B (both) |
| PERSON_CATALOG | VARCHAR2 | (30) | Person level catalog for the student of the request. References date associated with either the Person subsystem's matriculation term, first term of admission or most recent term of admission. This date helps identify the effective date(s) of the primary book which contains university-wide policy applicable to student progression and academic decision-making rules Example:T-LOAD-FAL - LOAD-FAL04, 2001-2002, 2002 FALL | |
| GRADUATION_TERM | VARCHAR2 | (10) | Inserted by user hook | |
| ENCODER_SIGNATURE | VARCHAR2 | (30) | Inserted by user hook. | |
| PROGRAM_CODE | VARCHAR2 | (6) | Code for the program requested or students officially declared program. | |
| PROGRAM_VER_NUM | NUMBER | (3) | Version associated with program code. | |
| ORG_UNIT_PROG | VARCHAR2 | (30) | Organizational unit responsible for the program code/version. | |
| PROGRAM_TITLE | VARCHAR2 | (90) | Title of the program code/version. | |
| PROGRAM_CATALOG | VARCHAR2 | (30) | Program level catalog. The program catalog identifies the effective date(s) of the book which contains university-wide policy applicable to the program requested or officially declared program of the student which contains student progression and academic decision-making rules. | |
| PROGRAM_START_DATE | DATE | If the program code/version is an officially declared program, date the students enrollment in the program code/version commences | ||
| LOCATION | VARCHAR2 | (10) | If the program code/version above is an officially declared program, where the program code/version is available for enrollment. | |
| ATTENDANCE_MODE | VARCHAR2 | (2) | If the program code/version above is an officially declared program, attendance mode associated with program code/version and location. | |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | If the program code/version is an officially declared program, attendance type associated with the student's officially declared program code/version, location and attendance mode. | |
| PRIMARY_PROGRAM | VARCHAR2 | (10) | If the program code/version is an officially declared program, indicates whether the officially declared program of the student represents the main program being pursued by the student. Values: Primary, Secondary. | |
| PROGRAM_ATTMPT_STATUS | VARCHAR2 | (30) | If the program code/version is an officially declared program, indicates status of the officially declared program code/version. | |
| NOMIN_COMPL_YEAR | NUMBER | (4) | If the program code/version is an officially declared program, and if the student is nominated for program completion, indicates the year associated with that nomination. | |
| NOMIN_COMPL_PERIOD | VARCHAR2 | (30) | If the program code/version is an officially declared program, indicates the period associated with the nominated completion year if the student has been nominated for program completion. | |
| DERIVED_COMPL_YEAR | NUMBER | (4) | If the program code/version is an officially declared program, indicates a derived completion year the program is to be completed. | |
| DERIVED_COMPL_PERIOD | VARCHAR2 | (1) | If the program code/version is an officially declared program, indicates a derived period to be associated with the derived completion year. | |
| ANTIC_PROG_COMPL_DATE | NUMBER | (5) | If the program code/version is an officially declared program, anticipated date of graduation. | |
| REQMTS_COMPLETE | VARCHAR2 | (1) | If the program code/version is an officially declared program, indicates if all program requirements have been completed. | |
| REQMTS_COMPL_DATE | DATE | If the program code/version is an officially declared program, date all program requirements are completed | ||
| REQMTS_COMPL_SOURCE | VARCHAR2 | (10) | If the program code/version is an officially declared program, source of information determining that all program requirements have been completed. | |
| CUMULATIVE_GPA | NUMBER | (6) | Column Cumulative GPA | |
| CLASS_STANDING | VARCHAR2 | (50) | Student's class standing. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Attribute Category | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 15 | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 16 | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 17 | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 18 | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Basic Program Details Screen DFF Attribute 19 | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Basic Program 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 |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PERSON_ID
, PROG_SEQ_NUM
, PRM_REQUEST_TYPE
, PERSON_CATALOG
, GRADUATION_TERM
, ENCODER_SIGNATURE
, PROGRAM_CODE
, PROGRAM_VER_NUM
, ORG_UNIT_PROG
, PROGRAM_TITLE
, PROGRAM_CATALOG
, PROGRAM_START_DATE
, LOCATION
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, PRIMARY_PROGRAM
, PROGRAM_ATTMPT_STATUS
, NOMIN_COMPL_YEAR
, NOMIN_COMPL_PERIOD
, DERIVED_COMPL_YEAR
, DERIVED_COMPL_PERIOD
, ANTIC_PROG_COMPL_DATE
, REQMTS_COMPLETE
, REQMTS_COMPL_DATE
, REQMTS_COMPL_SOURCE
, CUMULATIVE_GPA
, CLASS_STANDING
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_PRG;
IGS.IGS_DA_OUT_PRG does not reference any database object
IGS.IGS_DA_OUT_PRG is referenced by following:
APPS
IGS_DA_OUT_PRG
|
|
|
|