[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_ACADHIS_INT |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AD_ACADHIS_INT
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| EDUCATION_ID | NUMBER | (15) | ||
| ORG_ID | NUMBER | (15) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| SELFREP_RANK_IN_CLASS | NUMBER | (4) | ||
| SELFREP_WEIGHTED_GPA | VARCHAR2 | (1) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| MATCH_IND | VARCHAR2 | (2) | ||
| STATUS | VARCHAR2 | (2) | Yes | |
| ERROR_CODE | VARCHAR2 | (30) | ||
| DUP_ACAD_HISTORY_ID | NUMBER | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| TYPE_OF_SCHOOL | VARCHAR2 | (60) | ||
| INTERFACE_ACADHIS_ID | NUMBER | (15) | Yes | |
| INTERFACE_ID | NUMBER | (15) | Yes | |
| TRANSCRIPT_REQUIRED | VARCHAR2 | (1) | Indicator for whether or not a transcript is required for the institution | |
| INSTITUTION_CODE | VARCHAR2 | (30) | Yes | |
| CURRENT_INST | VARCHAR2 | (1) | Yes | |
| PROGRAM_TYPE_ATTEMPTED | VARCHAR2 | (0) | Obsolete | |
| PROGRAM_TYPE_EARNED | VARCHAR2 | (0) | Obsolete | |
| PROGRAM_CODE | VARCHAR2 | (60) | ||
| COMMENTS | VARCHAR2 | (240) | ||
| START_DATE | DATE | |||
| END_DATE | DATE | |||
| PLANNED_COMPLETION_DATE | DATE | |||
| SELFREP_TOTAL_CP_ATTEMPTED | NUMBER | (7) | ||
| SELFREP_TOTAL_CP_EARNED | NUMBER | (7) | ||
| SELFREP_TOTAL_GP_UNITS_ATTEMP | NUMBER | (7) | ||
| SELFREP_INST_GPA | VARCHAR2 | (30) | ||
| SELFREP_GRADING_SCALE_ID | NUMBER | (15) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| SELFREP_WEIGHTED_RANK | VARCHAR2 | (1) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| CLASS_SIZE | NUMBER | (4) | ||
| UPDATE_EDUCATION_ID | NUMBER | (15) | Unique identifier to identify the OSS record which will map to EDUCATION_ID | |
| INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user | ||
| PERSON_ID | NUMBER | (15) | Person Identifier. This column will be populated by the import process. | |
| ERROR_TEXT | VARCHAR2 | (2000) | Error Text | |
| DEGREE_ATTEMPTED | VARCHAR2 | (10) | Degree Attempted | |
| DEGREE_EARNED | VARCHAR2 | (10) | Degree Earned |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EDUCATION_ID
, ORG_ID
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, SELFREP_RANK_IN_CLASS
, SELFREP_WEIGHTED_GPA
, ATTRIBUTE8
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, MATCH_IND
, STATUS
, ERROR_CODE
, DUP_ACAD_HISTORY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TYPE_OF_SCHOOL
, INTERFACE_ACADHIS_ID
, INTERFACE_ID
, TRANSCRIPT_REQUIRED
, INSTITUTION_CODE
, CURRENT_INST
, PROGRAM_TYPE_ATTEMPTED
, PROGRAM_TYPE_EARNED
, PROGRAM_CODE
, COMMENTS
, START_DATE
, END_DATE
, PLANNED_COMPLETION_DATE
, SELFREP_TOTAL_CP_ATTEMPTED
, SELFREP_TOTAL_CP_EARNED
, SELFREP_TOTAL_GP_UNITS_ATTEMP
, SELFREP_INST_GPA
, SELFREP_GRADING_SCALE_ID
, ATTRIBUTE6
, ATTRIBUTE7
, SELFREP_WEIGHTED_RANK
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, CLASS_SIZE
, UPDATE_EDUCATION_ID
, INTERFACE_RUN_ID
, PERSON_ID
, ERROR_TEXT
, DEGREE_ATTEMPTED
, DEGREE_EARNED
FROM APPS.IGS_AD_ACADHIS_INT;
APPS
IGS_AD_ACADHIS_INT_ALL
APPS
IGR_IMP_001
- show dependent code
|
|
|
|