[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUAAI_HIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SUAAI_HIST_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Rowid | |
PERSON_ID | NUMBER | (15) | Yes | Person ID that has been modified and is part of request made |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number for the person. |
PERSON_NAME | VARCHAR2 | (360) | Yes | Person name. |
FULL_NAME | VARCHAR2 | (450) | Full Name of the Person. | |
SEX_MEANING | VARCHAR2 | (80) | Sex of the person. | |
BIRTH_DT | DATE | Birth date of the person. | ||
API_PERSON_ID | VARCHAR2 | (20) | Alternate person id. | |
ENCUMBERED_IND | VARCHAR2 | (4000) | Indecated the if the person is encumbred. | |
DECEASED_IND | VARCHAR2 | (1) | Indecated the if the person is deceased. | |
COURSE_CD | VARCHAR2 | (6) | Yes | Program Code for the program application instance |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code for which the override applied |
CAL_TYPE | VARCHAR2 | (10) | Yes | Unit Load Calendar Type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unit Load Calendar Instance |
ACAD_ALT_CODE | VARCHAR2 | (10) | Academic alternate code. | |
TEACH_ALT_CODE | VARCHAR2 | (10) | Teaching alternate code. | |
ASS_ID | NUMBER | (10) | Yes | The assessment item ID of an assessment item that has been linked to the student and against whom the history is getting tracked. An assessment item ID is a system-generated number that is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unit offerings before it can be assigned to student unit attempts. |
CREATION_DT | DATE | Yes | Creation Date. | |
ATTEMPT_NUMBER | NUMBER | (2) | Yes | Number of the attempt made. |
ASSESSMENT_TYPE | VARCHAR2 | (10) | Yes | Type of assessment |
REFERENCE | VARCHAR2 | (10) | References of the assessment item | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
LOCATION_CD | VARCHAR2 | (10) | Yes | Unit Section Location code |
UNIT_CLASS | VARCHAR2 | (10) | Yes | Unit Section Unit Class |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, PERSON_NUMBER
, PERSON_NAME
, FULL_NAME
, SEX_MEANING
, BIRTH_DT
, API_PERSON_ID
, ENCUMBERED_IND
, DECEASED_IND
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ACAD_ALT_CODE
, TEACH_ALT_CODE
, ASS_ID
, CREATION_DT
, ATTEMPT_NUMBER
, ASSESSMENT_TYPE
, REFERENCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, UOO_ID
, LOCATION_CD
, UNIT_CLASS
FROM APPS.IGS_AS_SUAAI_HIST_V;
APPS.IGS_AS_SUAAI_HIST_V is not referenced by any database object
|
|
|