[Home] [Help] [Dependency Information]
Object Name: | IGS_CA_INST |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_CA_INST |
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 modified to capture the enrollment method type related to self service.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CAL_TYPE | VARCHAR2 | (10) | Yes | |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
START_DT | DATE | Yes | ||
END_DT | DATE | Yes | ||
CAL_STATUS | VARCHAR2 | (10) | Yes | |
ALTERNATE_CODE | VARCHAR2 | (10) | ||
SUP_CAL_STATUS_DIFFER_IND | VARCHAR2 | (1) | Yes | |
PRIOR_CI_SEQUENCE_NUMBER | NUMBER | (6) | ||
ORG_ID | NUMBER | (15) | ||
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) | ||
SS_DISPLAYED | VARCHAR2 | (1) | Indicates whether the load calendar is to be displayed to self service users or not. | |
DESCRIPTION | VARCHAR2 | (30) | ||
IVR_DISPLAY_IND | VARCHAR2 | (1) | To indicate if the calendar is to be listed in IVR | |
TERM_INSTRUCTION_TIME | NUMBER | Term Instructional Time of the Program, measured in weeks. | ||
PLANNING_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for planning or not |
SCHEDULE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for schedule or not |
ADMIN_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the load calendar is available for searching in self-service or not |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CAL_TYPE
, SEQUENCE_NUMBER
, START_DT
, END_DT
, CAL_STATUS
, ALTERNATE_CODE
, SUP_CAL_STATUS_DIFFER_IND
, PRIOR_CI_SEQUENCE_NUMBER
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SS_DISPLAYED
, DESCRIPTION
, IVR_DISPLAY_IND
, TERM_INSTRUCTION_TIME
, PLANNING_FLAG
, SCHEDULE_FLAG
, ADMIN_FLAG
FROM APPS.IGS_CA_INST;
|
|
|