[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_SH_USEC_OCCURS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_SH_USEC_OCCURS |
Subobject Name: | |
Status: | VALID |
This table is used to store the shadow table to Unit Section Occurrences Table. This will store the old values if changed for MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY, START_TIME, END_TIME, BUILDING_CODE, ROOM_CODE, INSTRUCTOR_ID fields in IGS_PS_USEC_OCCURS table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_SH_USEC_OCCURS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USECSH_ID |
IGS_PS_SH_USEC_OCCURS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_SECTION_OCCURRENCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USECSH_ID | NUMBER | (15) | Yes | Unique Identifier for the Shadow Records |
UNIT_SECTION_OCCURRENCE_ID | NUMBER | (10) | Yes | Unit Section Occurrence Id |
MONDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Monday | |
TUESDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Tuesday | |
WEDNESDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Wednesday | |
THURSDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Thursday | |
FRIDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Friday | |
SATURDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Saturday | |
SUNDAY | VARCHAR2 | (1) | Old value whether Unit Section Occurrence was on Sunday | |
ROOM_CODE | NUMBER | (10) | Old value of Room Code | |
BUILDING_CODE | NUMBER | (10) | Old value of Building Code | |
START_TIME | DATE | Old value of Start Time of Unit Section Occurrence | ||
END_TIME | DATE | Old value of End Time of Unit Section Occurrence | ||
INSTRUCTOR_ID | VARCHAR2 | (2000) | Old value for Instructor | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT USECSH_ID
, UNIT_SECTION_OCCURRENCE_ID
, MONDAY
, TUESDAY
, WEDNESDAY
, THURSDAY
, FRIDAY
, SATURDAY
, SUNDAY
, ROOM_CODE
, BUILDING_CODE
, START_TIME
, END_TIME
, INSTRUCTOR_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_SH_USEC_OCCURS;
IGS.IGS_PS_SH_USEC_OCCURS does not reference any database object
IGS.IGS_PS_SH_USEC_OCCURS is referenced by following:
|
|
|