[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_TIMESLOT_STUP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_TIMESLOT_STUP_V |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This view is used to capture all the details regarding a Timeslot Setup.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
IGS_EN_TIMESLOT_STUP_ID | NUMBER | (15) | Yes | Timeslot Setup Identifier that uniquely identifies a Timeslot setup. |
PROGRAM_TYPE_GROUP_CD | VARCHAR2 | (10) | Yes | A Program Type Group Code that is created in a Timeslot setup. |
PROGRAM_TYPE_GROUP | VARCHAR2 | (60) | Yes | A Program Type Group that is created in a Timeslot setup. |
CAL_TYPE | VARCHAR2 | (10) | Yes | A calendar Type that has been associated with a Timeslot . |
CAL_TYPE_DESC | VARCHAR2 | (60) | Yes | A calendar Type Description that has been associated with a Timeslot . |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Used to define a unique Sequence Number. |
ALTERNATE_CD | VARCHAR2 | (10) | The Alternate Code for the Timeslot Setup. | |
START_DT | DATE | Yes | The start date of a Timeslot. | |
END_DT | DATE | Yes | The end date of a Timeslot. | |
STUDENT_TYPE | VARCHAR2 | (10) | Yes | A Student Type that has been associated with a Timeslot Setup. |
STUDENT_TYPE_MEANING | VARCHAR2 | (80) | Yes | Description of a Student Type that has been associated with a Timeslot Setup. |
SURNAME_ALPHABET | VARCHAR2 | (1) | Assignment of Timeslot is made on the value entered for this field. | |
ASSIGN_RANDOMLY | VARCHAR2 | (1) | Yes | When checked , Timeslot is assigned Randomly for that particular Program Type. |
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 ROW_ID
, ORG_ID
, IGS_EN_TIMESLOT_STUP_ID
, PROGRAM_TYPE_GROUP_CD
, PROGRAM_TYPE_GROUP
, CAL_TYPE
, CAL_TYPE_DESC
, SEQUENCE_NUMBER
, ALTERNATE_CD
, START_DT
, END_DT
, STUDENT_TYPE
, STUDENT_TYPE_MEANING
, SURNAME_ALPHABET
, ASSIGN_RANDOMLY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_TIMESLOT_STUP_V;
APPS.IGS_EN_TIMESLOT_STUP_V is not referenced by any database object
|
|
|