DBA Data[Home] [Help] [Dependency Information]

TABLE: OKS.OKS_BILLRATE_SCHEDULES

Object Details
Object Name: OKS_BILLRATE_SCHEDULES
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_BILLRATE_SCHEDULES
Subobject Name:
Status: VALID


OKS_BILLRATE_SCHEDULES table is populated by coverage form. This table stores the bill rate and schedules for service activity billing type of 'Labor' defined in business process. Both Holiday as well as Regular bill rate schedules are stored in this table. If HOLIDAY_YN flag is 'N' then it's a Regular schedule, if it is 'Y then it's a Holiday schedule. Bill rate code for a bill rate schedule could be 'NORMAL', 'DOUBLE' or 'OVERTIME'. It stores the applicable labor item, flat rate and percentage over list price for the bill rate schedule. In Charges module, during charge line creation, this information is used to derive the charge amount for Labor activity.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_BILLRATE_SCHEDULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKS_BILLRATE_SCHEDULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLE_ID
OKS_BILLRATE_SCHEDULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBT_CLE_ID
OKS_BILLRATE_SCHEDULES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDNZ_CHR_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Unique Identifier for records in OKS_BILLRATE_SCHEDULES
CLE_ID NUMBER

Unique Identifier for Contract Line. Specifies the Contract Line to which this Bill rate schedule applies. Contract Line is a Bill rate line (LSE_ID is either 6, 24,60). (References OKC_K_LINES_B.ID)
BT_CLE_ID NUMBER

Contract Line Id. Specifies the Contract Line to which this Bill rate applies. Contract Line is a Service Activity Billing type line (LSE_ID is either 5, 23,59) (References OKC_K_LINES_B.ID).
DNZ_CHR_ID NUMBER

Unique Identifier for Contract Header, denormalized for efficiency.
START_HOUR NUMBER

Start hour for the bill rate schedule
START_MINUTE NUMBER

Start minute for the bill rate schedule.
END_HOUR NUMBER

End hour for the bill rate schedule.
END_MINUTE NUMBER

End minute for the bill rate schedule.
MONDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Monday
TUESDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Tuesday
WEDNESDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Wednesday
THURSDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Thursday
FRIDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Friday.
SATURDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Saturday
SUNDAY_FLAG VARCHAR2 (1)
Flag to indicate if the Bill Rates schedule is applicable for Sunday
OBJECT1_ID1 VARCHAR2 (40)
First part of primary key to OKX view identifying Labor item. With OBJECT1_ID2, it identifies the labor item in the inventory org.
OBJECT1_ID2 VARCHAR2 (40)
Second part of primary key to OKX view identifying inventory organization. With OBJECT1_ID1, it identifies the labor item in the inventory org.
JTOT_OBJECT1_CODE VARCHAR2 (30)
JTF Object code identifying the OKX view for inventory Labor item. Identifies the Source Object (Table/View/Object) that contains the item.
BILL_RATE_CODE VARCHAR2 (40)
Type of Bill Rates applicable for the schedule. Valid values are 'Double', 'Normal', 'Overtime'. This is a look up code referenced in Bill Rate schedule. It does not drive any functionality in down stream applications.
FLAT_RATE NUMBER

Fixed rate for the schedule.
UOM VARCHAR2 (3)
Unit Of Measure for the flat rate.
HOLIDAY_YN VARCHAR2 (1)
Flag to identify whether the schedule is for holidays or regular days.
PERCENT_OVER_LIST_PRICE NUMBER

Percentage over the list price for the labor item to be applied in charges module. PERCENT_OVER_LIST_PRICE and FLAT_RATE are mutually exclusive.
PROGRAM_APPLICATION_ID NUMBER

With PROGRAM_ID, keeps track of which concurrent program created or updated each row
PROGRAM_ID NUMBER

With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row
PROGRAM_UPDATE_DATE DATE

Date the concurrent program updated the record
REQUEST_ID NUMBER

Unique Identifier of a concurrent request
CREATED_BY NUMBER (15) Yes ID of the user who created the record
CREATION_DATE DATE
Yes Date the record was created
LAST_UPDATED_BY NUMBER (15) Yes ID of the last user who updated the record
LAST_UPDATE_DATE DATE
Yes Date the record was last updated
LAST_UPDATE_LOGIN NUMBER (15)
OS ID of the user who last updated the record
SECURITY_GROUP_ID NUMBER

Now obsolete. Used to create a Virtual Private Database which was originally designed to be used by Hosting services.
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      CLE_ID
,      BT_CLE_ID
,      DNZ_CHR_ID
,      START_HOUR
,      START_MINUTE
,      END_HOUR
,      END_MINUTE
,      MONDAY_FLAG
,      TUESDAY_FLAG
,      WEDNESDAY_FLAG
,      THURSDAY_FLAG
,      FRIDAY_FLAG
,      SATURDAY_FLAG
,      SUNDAY_FLAG
,      OBJECT1_ID1
,      OBJECT1_ID2
,      JTOT_OBJECT1_CODE
,      BILL_RATE_CODE
,      FLAT_RATE
,      UOM
,      HOLIDAY_YN
,      PERCENT_OVER_LIST_PRICE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM OKS.OKS_BILLRATE_SCHEDULES;

Dependencies

[top of page]

OKS.OKS_BILLRATE_SCHEDULES does not reference any database object

OKS.OKS_BILLRATE_SCHEDULES is referenced by following:

SchemaAPPS
SynonymOKS_BILLRATE_SCHEDULES