[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_OUT_PRG_REF |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_DA_OUT_PRG_REF |
Subobject Name: | |
Status: | VALID |
IGS_DA_OUT_PRG_REF stores outgoing program reference information on the programs found for the students selected in the request. --Obsolete
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_DA_OUT_PRG_REF_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
BATCH_ID
PERSON_ID PROGRAM_SEQ_NUM PROGRAM_REF_CODE_TYPE PROGRAM_REF_CODE |
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 report |
PROGRAM_SEQ_NUM | NUMBER | Yes | Sequence id which helps to link the program which serves as the "parent" of the students requested or officially declared program to its associated major(s), minor(s) and track/option(s). | |
PROGRAM_REF_CODE | VARCHAR2 | (30) | Yes | Reference code(s) related to either the requested program or officially declared program as determined in program request type. These codes have meaning for either the third party software or the user. |
PROGRAM_REF_CODE_TYPE | VARCHAR2 | (10) | Yes | User-defined type of code associated with the program reference code. |
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
, PROGRAM_SEQ_NUM
, PROGRAM_REF_CODE
, PROGRAM_REF_CODE_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_PRG_REF;
IGS.IGS_DA_OUT_PRG_REF does not reference any database object
IGS.IGS_DA_OUT_PRG_REF is referenced by following:
|
|
|