[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_SCH_INT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_SCH_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) | ||
CALENDAR_TYPE | VARCHAR2 | (10) | ||
SEQUENCE_NUMBER | NUMBER | (6) | ||
TRANSACTION_TYPE | VARCHAR2 | (10) | Yes | |
UNIT_SECTION_OCCURRENCE_ID | NUMBER | (10) | Yes | |
UNIT_CD | VARCHAR2 | (10) | ||
VERSION_NUMBER | NUMBER | (3) | ||
UNIT_TITLE | VARCHAR2 | (90) | ||
OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | ||
UNIT_CLASS | VARCHAR2 | (10) | ||
MONDAY | VARCHAR2 | (1) | ||
TUESDAY | VARCHAR2 | (1) | ||
WEDNESDAY | VARCHAR2 | (1) | ||
THURSDAY | VARCHAR2 | (1) | ||
FRIDAY | VARCHAR2 | (1) | ||
SATURDAY | VARCHAR2 | (1) | ||
SUNDAY | VARCHAR2 | (1) | ||
UNIT_SECTION_START_DATE | DATE | |||
UNIT_SECTION_END_DATE | DATE | |||
START_TIME | DATE | |||
END_TIME | DATE | |||
ENROLLMENT_MAXIMUM | NUMBER | (6) | ||
ENROLLMENT_ACTUAL | NUMBER | (6) | ||
INSTRUCTOR_ID | NUMBER | (15) | ||
SURNAME | VARCHAR2 | (150) | ||
BUILDING_CODE | NUMBER | (10) | Scheduled Building Identifier -Obsolete | |
ROOM_CODE | NUMBER | (10) | Scheduled Room Identifier -Obsolete | |
LOCATION_CD | VARCHAR2 | (10) | ||
UNIT_SEC_CROSS_UNIT_SEC_ID | NUMBER | |||
UOO_ID | NUMBER | (7) | ||
SCHEDULE_STATUS | VARCHAR2 | (30) | ||
ERROR_TEXT | VARCHAR2 | (2000) | ||
TRANSACTION_ID | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
INT_OCCURS_ID | NUMBER | Yes | ||
INT_USEC_ID | NUMBER | |||
GIVEN_NAMES | VARCHAR2 | (150) | ||
MIDDLE_NAME | VARCHAR2 | (60) | ||
DEDICATED_BUILDING_CODE | NUMBER | (10) | Dedicated Building Identifier -Obsolete | |
DEDICATED_ROOM_CODE | NUMBER | (10) | Dedicated Room Identifier -Obsolete | |
PREFERRED_BUILDING_CODE | NUMBER | (10) | Preferred Building Identifier -Obsolete | |
PREFERRED_ROOM_CODE | NUMBER | (10) | Preferred Room Identifier -Obsolete | |
TBA_STATUS | VARCHAR2 | (1) | ||
USO_START_DATE | DATE | |||
USO_END_DATE | DATE | |||
BUILDING_ID | NUMBER | (10) | Scheduled Building Identifier. | |
ROOM_ID | NUMBER | (10) | Scheduled Room Identifier. | |
DEDICATED_BUILDING_ID | NUMBER | (10) | Dedicated Building Identifier. | |
DEDICATED_ROOM_ID | NUMBER | (10) | Dedicated Room Identifier. | |
PREFERRED_BUILDING_ID | NUMBER | (10) | Preferred Building Identifier. | |
PREFERRED_ROOM_ID | NUMBER | (10) | Preferred Room Identifier. | |
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) | ||
ABORT_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the occurrence is ABORTED. |
IMPORT_DONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the occurrence has been imported to production. |
OCCURRENCE_IDENTIFIER | VARCHAR2 | (30) | Unique identity for an occurrence within a unit section. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CALENDAR_TYPE
, SEQUENCE_NUMBER
, TRANSACTION_TYPE
, UNIT_SECTION_OCCURRENCE_ID
, UNIT_CD
, VERSION_NUMBER
, UNIT_TITLE
, OWNER_ORG_UNIT_CD
, UNIT_CLASS
, MONDAY
, TUESDAY
, WEDNESDAY
, THURSDAY
, FRIDAY
, SATURDAY
, SUNDAY
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, START_TIME
, END_TIME
, ENROLLMENT_MAXIMUM
, ENROLLMENT_ACTUAL
, INSTRUCTOR_ID
, SURNAME
, BUILDING_CODE
, ROOM_CODE
, LOCATION_CD
, UNIT_SEC_CROSS_UNIT_SEC_ID
, UOO_ID
, SCHEDULE_STATUS
, ERROR_TEXT
, TRANSACTION_ID
, ORG_ID
, INT_OCCURS_ID
, INT_USEC_ID
, GIVEN_NAMES
, MIDDLE_NAME
, DEDICATED_BUILDING_CODE
, DEDICATED_ROOM_CODE
, PREFERRED_BUILDING_CODE
, PREFERRED_ROOM_CODE
, TBA_STATUS
, USO_START_DATE
, USO_END_DATE
, BUILDING_ID
, ROOM_ID
, DEDICATED_BUILDING_ID
, DEDICATED_ROOM_ID
, PREFERRED_BUILDING_ID
, PREFERRED_ROOM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ABORT_FLAG
, IMPORT_DONE_FLAG
, OCCURRENCE_IDENTIFIER
FROM APPS.IGS_PS_SCH_INT;
|
|
|