[Home] [Help] [Dependency Information]
Object Name: | IGS_CA_DA_INST_DISPLAY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_CA_DA_INST_DISPLAY_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to provide derived, absolute and effective dates for the date alias instance. It is used in conjunction with the Inquire On Date Alias Instance form to provide a meaningful description when displaying date alias instance values.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DT_ALIAS | VARCHAR2 | (10) | Yes | The name of an event, not an actual date value. Each date alias is assigned a date alias category and can be assigned a calendarcategory. Date alias examples are Census, End-Lect, last day of lectures in teaching period and Wd-Cutoff, last day to withdraw from unit without failing. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | A system-generated number that is used to identify the date alias instance. |
CAL_TYPE | VARCHAR2 | (10) | Yes | The name of a type of calendar used within the organization. For example, ACAD-YR standard academic year, SEM-1 semester 1 teaching period, TRI-2 trimester 2 teaching period & Enrol-1 enrolment period 1. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | A system-generated number that is used to identify the calendar instance in the date alias instance that occurs. |
ABSOLUTE_VAL | DATE | The real date value allocated to an instance of a date alias. | ||
DERIVED_VAL | DATE | Gives the derived value of the date alias instance after taking into consideration the offset and others, after resolving the offset constraints. | ||
ALIAS_VAL | DATE | Holds the absolute value of the date alias if it exists, if not then has the derived value | ||
DAI_DESCRIPTION | VARCHAR2 | (121) | This field is a combination of two descriptions separated by a slash. The first description of an event not an actual date value. Each date alias is assigned a date alias category and can be assigned a calendar category. Date alias examples are government census date, last day of lectures in teaching period and last day to withdraw from unit without failing. The second description of a type of calendar used within the institution. For example, standard academic year, semester 1 teaching period, trimester 2 teaching period and enrollment period 1. | |
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 DT_ALIAS
, SEQUENCE_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ABSOLUTE_VAL
, DERIVED_VAL
, ALIAS_VAL
, DAI_DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_CA_DA_INST_DISPLAY_V;
APPS.IGS_CA_DA_INST_DISPLAY_V is not referenced by any database object
|
|
|