[Home] [Help] [Dependency Information]
Object Name: | OKC_TIMEVALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_TIMEVALUES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Timevalue quantifies the time component of a rule. A timevalue may either be a timepoint (e.g. Oct 15, 1999 at 13:00 hours), an interval (e.g. 2 weeks), or a cycle, which is a set of intervals (every two weeks)
Term, Duration, Period, Interval, Shift,Cycle,Continuance
Days,Dates,Times,Periods,Durations,Seasons,Shifts etc.
A specific point in time. TIMEPOINTS may be absolute (January 1, 1999 at noon), generic (Monday at 8AM), a reference to an EVENT (an injury accident) or NAMED DAY, or relative to an absolute or reference (30 days after an injury accident).
An absolute point in time ie. it is a single actual point in the past present or future
A point in time relative (some duration prior to or post) to another point in time.
eg.
60 days ARO (after receipt of order)
The reference point may not have a value at specification time and the possibility exists that it may not have obtained one by execution time.
An absolute point in time ie. it is a single actual point in the past present or future, which is specified by reference to a name.
eg.
order receipt date(time)
cancellation date(time)
If the before/after attribute is used, it may mean the duration starts before the given ("start") date, e.g. "7 days prior to the end of January". The default setting is after, or a start point and a duration. The "before" setting flips this to mean a duration and an end point.
A generic interval may either have
- a generic start point (e.g. Saturday 8AM) and a duration (e.g. 10 hours); or
- a generic start point and end point (e.g. Saturday 8AM to Saturday at 5PM).
A named generic interval which implicitly defines its own bounds (given a context).
eg.
SATURDAY = the interval x: dd/mm/yyyy 00:00 <= x < dd/mm/yyyy + 1 00:00 for any dd/mm/yyyy which is a Saturday! The context required here is the value of dd/mm/yyyy.
The result can be thought of as the intervals themselves or as points (taken to be the start point of each interval). Thus a CYCLE defines either recurring points separated by various intervals, or recurring intervals. Some intervals may be defined as inactive eg. a CYCLE of WORKWEEK may have 7 intervals of 1 DAY in duration, of which 2 are inactive.
The actual instances of SPAN (and therefore rotation) may be be either calculated from the definitions when required, or generated once (as far into the forseeable future as seems appropriate - this is specified by the end point of the CYCLE) into the appropriate tables for either actual point or interval.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Primary key column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | CHAR | (1) | Indicates a value was changed in another language. Not fully implemented in 11i | |
SPN_ID | NUMBER | Foreign key to OKC_SPAN. | ||
TVE_ID_OFFSET | NUMBER | Surrogate key used for primary unique identifiers. | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure code. | |
TVE_ID_GENERATED_BY | NUMBER | Surrogate key used for primary unique identifiers. | ||
TVE_ID_STARTED | NUMBER | Surrogate key used for primary unique identifiers. | ||
TVE_ID_ENDED | NUMBER | Surrogate key used for primary unique identifiers. | ||
TVE_ID_LIMITED | NUMBER | Surrogate key used for primary unique identifiers. | ||
CNH_ID | NUMBER | Foreign key to OKC_CONDITION_HEADERS_B. | ||
DNZ_CHR_ID | NUMBER | Yes | Contract ID. Denormalized for performance. | |
TZE_ID | NUMBER | (15) | Surrogate key used for primary unique identifiers. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
DURATION | NUMBER | (10) | Number of related times units. | |
OPERATOR | VARCHAR2 | (6) | Boolean operators equivalent to phrases such as "on or before". | |
BEFORE_AFTER | VARCHAR2 | (3) | For time rules, indicates if reference is before or after given date. | |
DATETIME | DATE | Date/Time value. | ||
MONTH | NUMBER | (2) | Month value. | |
DAY | NUMBER | (2) | Day value. | |
DAY_OF_WEEK | VARCHAR2 | (9) | Day of week value. | |
HOUR | NUMBER | (2) | Hour value. | |
MINUTE | NUMBER | (2) | Minute value. | |
SECOND | NUMBER | (2) | Second value. | |
NAME | VARCHAR2 | (150) | Timevalue name. | |
INTERVAL_YN | VARCHAR2 | (3) | Yes/No field. | |
NTH | NUMBER | weekday in month | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
TVE_TYPE | VARCHAR2 | (10) | Yes | Time value 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
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, SPN_ID
, TVE_ID_OFFSET
, UOM_CODE
, TVE_ID_GENERATED_BY
, TVE_ID_STARTED
, TVE_ID_ENDED
, TVE_ID_LIMITED
, CNH_ID
, DNZ_CHR_ID
, TZE_ID
, DESCRIPTION
, SHORT_DESCRIPTION
, COMMENTS
, DURATION
, OPERATOR
, BEFORE_AFTER
, DATETIME
, MONTH
, DAY
, DAY_OF_WEEK
, HOUR
, MINUTE
, SECOND
, NAME
, INTERVAL_YN
, NTH
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TVE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_TIMEVALUES_V;
|
|
|