This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
| Description: | Scheduler cost parameters |
|---|
DEFINITION
The CSR_COSTS_ALL_B defines the list of cost parameters
EXAMPLE
MISCELLANEOUS
| Index | Type | Tablespace | Column |
|---|---|---|---|
| CSR_COSTS_ALL_B_U1 | UNIQUE | APPS_TS_SEED |
COST_ID
ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COST_ID | NUMBER | Y | Primary Key column | |
| NAME | VARCHAR2 | (80) | Y | Cost parameter name |
| VALUE | NUMBER | Y | Cost parameter value | |
| CREATED_BY | NUMBER | Y | Standard Who column | |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield column | |
| ORG_ID | NUMBER | (15) | Multi Org Organization ID | |
| SECURITY_GROUP_ID | NUMBER | Security group id |
CSR.CSR_COSTS_ALL_B does not reference any database object
CSR.CSR_COSTS_ALL_B is referenced by following:
| Description: | Translation table for CSR_COSTS_ALL_B |
|---|
DEFINITION
The CSR_COSTS_ALL_TL defines the translated table for CSR_COSTS_ALL_B
EXAMPLE
MISCELLANEOUS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COST_ID | NUMBER | Y | Foreign key in CSR_COSTS_ALL_B table | |
| LANGUAGE | VARCHAR2 | (4) | Y | Language code of description |
| SOURCE_LANG | VARCHAR2 | (4) | Y | Translated-from column |
| DESCRIPTION | VARCHAR2 | (1500) | Cost parameter description | |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| SECURITY_GROUP_ID | NUMBER | Security Group Id |
CSR.CSR_COSTS_ALL_TL does not reference any database object
CSR.CSR_COSTS_ALL_TL is referenced by following:
| Description: | Table to store Timing Scenario Definitions |
|---|
DEFINITION
Table to store Timing Scenario Definitions
EXAMPLE
MISCELLANEOUS
| Index | Type | Tablespace | Column |
|---|---|---|---|
| CSR_TESTS_B_U1 | UNIQUE | APPS_TS_SUMMARY | TEST_NUMBER |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TEST_NUMBER | NUMBER | Y | Primary Key of the Table | |
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
| TASK_NUMBER | NUMBER | Y | Task Number for which Timing is Analyzed | |
| PLANNED_START | DATE | Planned Start Date of the Task being Timed | ||
| PLANNED_END | DATE | Planned End Date of the Task being Timed | ||
| PLAN_MODE | VARCHAR2 | (240) | Mode of Scheduling | |
| SPARES | VARCHAR2 | (240) | Identifies whether Spares was Checked during the Operation | |
| TRIPS | VARCHAR2 | (240) | Indicates whether the Trips were empty / full during the Timing | |
| TDS_ROUTE | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Scheduler operating in Route Mode | |
| TDS_LOC | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Scheduler operating in Estimate Mode | |
| TDS_DFLT | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Scheduler operating in Default Mode | |
| TERRITORIES | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Resource Manager API called with Territory Qualifiers | |
| CONTRACTS | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Resource Manager API called with Contracts | |
| IB | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Resource Manager API called with Installed Base | |
| SKILLS | VARCHAR2 | (240) | If checked, indicates that the Timing was gathered with Resource Manager API called with Skills | |
| TIMESTAMP | DATE | Identifies the date this Timing Results was started | ||
| STOPWATCH | NUMBER | Stopwatch | ||
| DESCRIPTION | VARCHAR2 | (4000) | Description for the current test case. |
CSR.CSR_TESTS_B does not reference any database object
CSR.CSR_TESTS_B is referenced by following:
| Description: | Table to store Timing Test Results |
|---|
DEFINITION
Table to store Timing Test Results
EXAMPLE
MISCELLANEOUS
| Index | Type | Tablespace | Column |
|---|---|---|---|
| CSR_TEST_RESULTS_U1 | UNIQUE | APPS_TS_SUMMARY |
TEST_NUMBER
TIMER_SEQ |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TEST_NUMBER | NUMBER | Y | Identifies the test and is a foreign key to CSR_TESTS_B | |
| TIMER_SEQ | NUMBER | Y | Sequence Number of the Timing Mark | |
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
| TIMER_NAME | VARCHAR2 | (300) | Y | Name of the Timer being Marked |
| TIMER_VALUE | NUMBER | Y | Value of the Timer being Marked | |
| TIMER_MEANING | VARCHAR2 | (60) | Y | Meaning of the Timer |
CSR.CSR_TEST_RESULTS_B does not reference any database object
CSR.CSR_TEST_RESULTS_B is referenced by following:
| Description: | table to store timing data, temporarily for current test run |
|---|
DEFINITION
The CSR_TIMERS_B table records timing data, temporarily for current test run
EXAMPLE
MISCELLANEOUS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEQ | NUMBER | Y | Sequence in the timing flow | |
| OBJECT_VERSION_NUMBER | NUMBER | Object version number | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
| NAME | VARCHAR2 | (300) | Y | Name of timing interval |
| VALUE | NUMBER | Y | Value of the timing | |
| MEANING | VARCHAR2 | (60) | Y | Meaning of the value of the timing |
| DESCRIPTION | VARCHAR2 | (4000) | Description of the timing interval | |
| TRIP_POSITION | NUMBER | Currently evaluated position in the trip | ||
| TRIP_TASKS | NUMBER | Number of tasks in the current trip |
CSR.CSR_TIMERS_B does not reference any database object
CSR.CSR_TIMERS_B is referenced by following:
| Description: | Window-to-promise parameters |
|---|
DEFINITION
The CSR_WIN_PROMIS_ALL_B defines which windos to promise are available.
EXAMPLE
MISCELLANEOUS
| Index | Type | Tablespace | Column |
|---|---|---|---|
| CSR_WIN_PROMIS_ALL_B_U1 | UNIQUE | APPS_TS_SEED |
WIN_PROMIS_ID
ORG_ID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WIN_PROMIS_ID | NUMBER | Y | Primary Key column | |
| START_TIME | DATE | Y | Window to promise start time | |
| END_TIME | DATE | Y | End time of the window to promise interval | |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield column | |
| ORG_ID | NUMBER | (15) | Multi Org Organization ID | |
| SECURITY_GROUP_ID | NUMBER | Security Group Id |
CSR.CSR_WIN_PROMIS_ALL_B does not reference any database object
CSR.CSR_WIN_PROMIS_ALL_B is referenced by following:
| Description: | The translated table for window to promise parameters |
|---|
DEFINITION
The CSR_WIN_PROMIS_ALL_TL defines the translated table for CSR_WIN_PROMISS_ALL_B
EXAMPLE
MISCELLANEOUS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WIN_PROMIS_ID | NUMBER | Y | Foreign key to the CSR_WIN_TO_PROMIS_ALL_B table | |
| LANGUAGE | VARCHAR2 | (4) | Y | Language code of name and description columns |
| SOURCE_LANG | VARCHAR2 | (4) | Y | Translated-from column |
| NAME | VARCHAR2 | (80) | Y | Window to promise name |
| DESCRIPTION | VARCHAR2 | (1500) | Description of the window to promise interval | |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| SECURITY_GROUP_ID | NUMBER | Security Group Id |
CSR.CSR_WIN_PROMIS_ALL_TL does not reference any database object
CSR.CSR_WIN_PROMIS_ALL_TL is referenced by following:
MultiLingual view (a language resolved view of the data.)
View of the cost parameters used by Oracle Scheduler
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Standard Row Id | |
| COST_ID | NUMBER | Y | Primary Key | |
| DESCRIPTION | VARCHAR2 | (1500) | Cost Parameters Description | |
| NAME | VARCHAR2 | (80) | Y | Cost Parameters Name |
| VALUE | NUMBER | Y | Cost Parameter Value | |
| CREATED_BY | NUMBER | Y | Standard Who Column | |
| CREATION_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield column | |
| ORG_ID | NUMBER | (15) | Multi Organization Column |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTUAL_END_DATE | DATE | The actual end date given by the resource | ||
| ACTUAL_START_DATE | DATE | The actual start date given by the resource | ||
| PLANNED_EFFORT | NUMBER | Task duration column | ||
| PLANNED_EFFORT_UOM | VARCHAR2 | (4000) | task duration unit of measure column | |
| SCHEDULED_END_DATE | DATE | Scheduled end date column | ||
| SCHEDULED_START_DATE | DATE | Scheduled start date column | ||
| TASK_ID | NUMBER | Y | Primary key of Task | |
| TASK_TYPE_ID | NUMBER | Y | Task type ID column | |
| PLANNED_END_DATE | DATE | Bound before indication | ||
| PLANNED_START_DATE | DATE | Bound after indication | ||
| BOUND_MODE_CODE | VARCHAR2 | (30) | Codewhich defines how the bounds must be interpreted | |
| SOFT_BOUND_FLAG | VARCHAR2 | (1) | Indication of soft or hard contraints for bound dates | |
| CREATION_DATE | DATE | Y | Standard who column | |
| OBJECT_VERSION_NUMBER | NUMBER | Y | Number to indicate the last changed version | |
| SCHEDULABLE_FLAG | VARCHAR2 | (1) | Indication whether task can be handled by Oracle Scheduler | |
| TASK_STATUS_ID | NUMBER | Y | Task Status ID Column | |
| LOCUS_SEGMENTID | NUMBER | NavTech TDS Segment ID Column | ||
| LOCUS_SIDE | NUMBER | NavTech TDS Side Column | ||
| LOCUS_SPOT | NUMBER | NavTech TDS Spot Column | ||
| SHOULD_CALL_LF | VARCHAR2 | (4000) | Indication whether Location Finder is used or not | |
| LOCATION_ID | NUMBER | (15) | NavTech TDS Location ID Column | |
| TIMEZONE_ID | NUMBER | Foreign key to define timezone | ||
| TA_TASK_ASSIGNMENT_ID | NUMBER | Foreign key to task assignment | ||
| TA_SCHED_TRAVEL_DISTANCE | NUMBER | The scheduled travel distance | ||
| TA_SCHED_TRAVEL_DURATION | NUMBER | The scheduled travel duration | ||
| TA_SCHED_TRAVEL_DURATION_UOM | VARCHAR2 | (4000) | The scheduled travel duration unit of measure | |
| TA_OBJECT_VERSION_NUMBER | NUMBER | The object version number of the task assignment | ||
| TA_SCHEDULABLE_FLAG | VARCHAR2 | (1) | Flag that indicates whether the task assignment can be handled by Oracle Scheduler | |
| TA_RESOURCE_ID | NUMBER | Foreign key to the assigned resource | ||
| TA_RESOURCE_TYPE_CODE | VARCHAR2 | (30) | Foreign key to the assigned resource | |
| TA_ASSIGNMENT_STATUS_ID | NUMBER | Status of the assignment ID column | ||
| TY_SCHEDULE_FLAG | VARCHAR2 | (1) | Indication whether the task type can be handled by Oracle Scheduler | |
| LOCUS_LAT | NUMBER | Location latitude. Long/Lat coordinates are used when the distance between two locations is calculated geometrically rather than using route information. | ||
| LOCUS_LON | NUMBER | Location longitude. Long/Lat coordinates are used when the distance between two locations is calculated geometrically rather than using route information. | ||
| AVAILABILITY_DATE | DATE | The date/time after which spares are available. Only for tasks that have already been assigned. For unassigned tasks the AVAILABILITY_DATE is null. | ||
| OBJECT_CAPACITY_ID | NUMBER | Foreign key to CSF_TRIPS table. Specifies the trip this task-assignment belongs to. | ||
| PARENT_TASK_ID | NUMBER | If this task-assignment refers to a child-task, this field specifies the parent of that child-task. For inspection parent-tasks and break/fix tasks, this field is null. | ||
| TASK_CONFIRMATION_STATUS | VARCHAR2 | (1) | Field indicating whether customer confirmation is required or not, and if it is, whether confirmation has been attained or not. 'N' or Null, no confirmation required. 'R' confirmation required but not yet attained. 'C' confirmation required and confirmed. | |
| TASK_CONFIRMATION_COUNTER | NUMBER | Number of times the company had to ask the customer for confirmation because of schedule changes. | ||
| ACCESS_HOURS_REQUIRED | VARCHAR2 | (2) | Specifies whether customer requires special access hours for the task at hand. 'N' or Null, no access hours required. 'Y' special access hours required; the access hours are specified in the subsequent fields. | |
| AFTER_HOURS_FLAG | VARCHAR2 | (2) | Specifies if customer requires access only outside normal working hours. 'N' or Null, no access outside working hours. 'Y' access only outside working hours. | |
| MONDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| MONDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| MONDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| MONDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| TUESDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| TUESDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| TUESDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| TUESDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| WEDNESDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| WEDNESDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| WEDNESDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| WEDNESDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| THURSDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| THURSDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| THURSDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| THURSDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| FRIDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| FRIDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| FRIDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| FRIDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| SATURDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| SATURDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| SATURDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| SATURDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| SUNDAY_FIRST_START | DATE | Start of first access hours window for given day. | ||
| SUNDAY_FIRST_END | DATE | End of first access hours window for given day. | ||
| SUNDAY_SECOND_START | DATE | Start of second access hours window for given day. | ||
| SUNDAY_SECOND_END | DATE | End of second access hours window for given day. | ||
| TASK_SPLIT_FLAG | VARCHAR2 | (1) | Identifies whether the Task is a Normal / Parent / Child Task | |
| TS_ASSIGNED_FLAG | VARCHAR2 | (1) | Value of Assigned Flag corresponding to the Task Status | |
| TS_WORKING_FLAG | VARCHAR2 | (1) | Value of Working Flag corresponding to the Task Status | |
| TS_APPROVED_FLAG | VARCHAR2 | (1) | Value of Approved Flag corresponding to the Task Status | |
| TS_COMPLETED_FLAG | VARCHAR2 | (1) | Value of Completed Flag corresponding to the Task Status | |
| TS_CANCELLED_FLAG | VARCHAR2 | (1) | Value of Cancelled Flag corresponding to the Task Status | |
| TS_CLOSED_FLAG | VARCHAR2 | (1) | Value of Closed Flag corresponding to the Task Status | |
| TS_REJECTED_FLAG | VARCHAR2 | (1) | Value of Rejected Flag corresponding to the Task Status | |
| TS_ACCEPTED_FLAG | VARCHAR2 | (1) | Value of Accepted Flag corresponding to the Task Status | |
| TS_ON_HOLD_FLAG | VARCHAR2 | (1) | Value of On Hold Flag corresponding to the Task Status | |
| TS_DELETE_ALLOWED_FLAG | VARCHAR2 | (1) | Value of Delete Allowed Flag corresponding to the Task Status | |
| TASK_NUMBER | VARCHAR2 | (30) | Y | Task Number |
| HAS_PARENT_DEPENDENCY | CHAR | (1) | Indicates whether the Task is dependent on other tasks | |
| HAS_CHILD_DEPENDENCY | CHAR | (1) | Indicates whether there are other tasks dependent on this task | |
| SPARES_REQUIRED_FLAG | CHAR | (1) | Indicates whether Spares is required for this Task | |
| ACTUAL_EFFORT | NUMBER | Actual Effort of the Task | ||
| PERSONAL_TASK_FLAG | CHAR | (1) | Indicates whether the Task is a Personal Task (ie) not associated with a Service Request | |
| LOCUS_SRID | NUMBER |
APPS.CSR_PLAN_TASKS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEQ | NUMBER | |||
| NAME | VARCHAR2 | (300) | ||
| MEANING | VARCHAR2 | (60) | ||
| VALUE | NUMBER |
APPS.CSR_TIMERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTUAL_START_DATE | DATE | The actual start date given by the resource | ||
| ACTUAL_END_DATE | DATE | The actual end date given by the resource | ||
| PLANNED_EFFORT | NUMBER | Task duration column | ||
| TA_SCHED_TRAVEL_DURATION_UOM | VARCHAR2 | (4000) | scheduled travel duration unit of measure | |
| PLANNED_EFFORT_UOM | VARCHAR2 | (4000) | task duration unit of measure | |
| TA_SCHED_TRAVEL_DURATION | NUMBER | Travel duration calculated by scheduler | ||
| TA_SCHED_TRAVEL_DISTANCE | NUMBER | Travel distance (km?) calculated by scheduler | ||
| SCHEDULED_START_DATE | DATE | Start date/time calculated by scheduler | ||
| SCHEDULED_END_DATE | DATE | End date/time calculated by scheduler | ||
| TA_TASK_ASSIGNMENT_ID | NUMBER | Y | Primary key in jtf_task_assignments table | |
| TASK_ID | NUMBER | Y | Primary key in jtf_tasks_b | |
| TASK_TYPE_ID | NUMBER | Y | Task type. Foreign key in jtf_task_types_b table | |
| PLANNED_START_DATE | DATE | Planned start time is the earliest date/time on which the task with id task_id may be scheduled. | ||
| PLANNED_END_DATE | DATE | Planned end date is the latest time on which this the task with task_id has to start. Note that the scheduled date/time may actually be later than the planned_end_date because the planned_end_date has already passed when the task is offered to scheduler for scheduling. | ||
| SOFT_BOUND_FLAG | VARCHAR2 | (1) | Soft Bound Flag | |
| TASK_STATUS_ID | NUMBER | Y | Status id, foreign key in jtf_task_statuses_b | |
| TIMEZONE_ID | NUMBER | Task timezone id, based on location (party_site_address) where task has to be performed | ||
| TA_OBJECT_VERSION_NUMBER | NUMBER | Y | Task assignment object version number. Incremented after every update of the task assignment (ta_task_assignment_id) | |
| CREATION_DATE | DATE | Y | Task creation date/time | |
| TA_ASSIGNMENT_STATUS_ID | NUMBER | Y | Task assignment status. Foreign key in jtf_task_statuses_b. | |
| TA_RESOURCE_ID | NUMBER | Y | Resource that (who?) the task with task_id is assigned to. Foreign key in jtf_rs_resource_extns. | |
| TA_RESOURCE_TYPE_CODE | VARCHAR2 | (30) | Y | Resource type (also called 'category') of the resource with id resource_id. This field refers to jtf_rs_resource_extns.category |
| TA_SHIFT_CONSTRUCT_ID | NUMBER | Shift of resource resource_id. The shift construct is derived from the resource's calendar and refers to a shift on a certain day. Foreign key in table jtf_cal_shift_constructs. | ||
| OBJECT_VERSION_NUMBER | NUMBER | Y | Task object version number. This number is incremented when the task with id task_id is updated. | |
| TY_SCHEDULE_FLAG | VARCHAR2 | (1) | Schedule flag of task type with id task_type_id. Indicates whether scheduler may schedule a task of this type. | |
| SCHEDULABLE_FLAG | VARCHAR2 | (1) | Task status schedulable flag. Indicates whether a task in the status given by task_status_id may be scheduled by scheduler. | |
| TA_SCHEDULABLE_FLAG | VARCHAR2 | (1) | Taks assignment status schedulable flag. Indicates whether a task assignment with status id ta_assignment_status_id may be scheduled by scheduler. | |
| ASSIGNMENT_COUNT | NUMBER | Nr of task assignments belonging to task with id task_id. Task assignments with 'cancelled' flag set will *not* be counted. | ||
| LOCUS_SEGMENTID | NUMBER | Locus segment id is a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations. This field specifies the segment in a network of roades. | ||
| LOCUS_SIDE | NUMBER | Locus side a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations. This field specifies the side of the road the task's address is located on. | ||
| LOCUS_SPOT | NUMBER | Locus spot is a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations. | ||
| SHOULD_CALL_LF | VARCHAR2 | (4000) | 'Y', 'N' value indicating whether the address associated with the task with id task_id could be found in the road network. If found, the locus_segmentid, locus_spot and locus_side have valid values. If not found the locus_xx fields have meaningless values. | |
| LOCUS_LAT | NUMBER | Latitude value of address. | ||
| LOCUS_LON | NUMBER | Longitude value of address. | ||
| LOCATION_ID | NUMBER | (15) | Identifies location where task with id task_id has to be performed. Foreign key in hz_locaitons. | |
| BOUND_MODE_CODE | VARCHAR2 | (30) | Codewhich defines how the bounds must be interpreted | |
| AVAILABILITY_DATE | DATE | The date/time after which spares are available. Only for tasks that have already been assigned. For tasks without spares reservations, the AVAILABILITY_DATE is null. | ||
| OBJECT_CAPACITY_ID | NUMBER | Y | Foreign key to CAC_SR_OBJECT_CAPACITY table. Specifies the trip this task-assignment belongs to. | |
| PARENT_TASK_ID | NUMBER | If this task-assignment refers to a child-task, this field specifies the parent of that child-task. For inspection parent-tasks and break/fix tasks, this field is null. | ||
| TASK_CONFIRMATION_STATUS | VARCHAR2 | (1) | Field indicating whether customer confirmation is required or not, and if it is, whether confirmation has been attained or not. 'N' or Null, no confirmation required. 'R' confirmation required but not yet attained. 'C' confirmation required and confirmed. | |
| TASK_CONFIRMATION_COUNTER | NUMBER | Number of times the company had to ask the customer for confirmation because of schedule changes. | ||
| ACCESS_HOURS_REQUIRED | VARCHAR2 | (2) | Specifies whether customer requires special access hours for the task at hand. 'N' or Null, no access hours required. 'Y' special access hours required; the access hours are specified in the subsequent fields. | |
| AFTER_HOURS_FLAG | VARCHAR2 | (2) | Specifies if customer requires access only outside normal working hours. 'N' or Null, no access outside working hours. 'Y' access only outside working hours. | |
| MONDAY_FIRST_START | DATE | Start of first access hours window. | ||
| MONDAY_FIRST_END | DATE | End of first access hours window. | ||
| MONDAY_SECOND_START | DATE | Start of second access hours window. | ||
| MONDAY_SECOND_END | DATE | End of second access hours window. | ||
| TUESDAY_FIRST_START | DATE | Start of first access hours window. | ||
| TUESDAY_FIRST_END | DATE | End of first access hours window. | ||
| TUESDAY_SECOND_START | DATE | Start of second access hours window. | ||
| TUESDAY_SECOND_END | DATE | End of second access hours window. | ||
| WEDNESDAY_FIRST_START | DATE | Start of first access hours window. | ||
| WEDNESDAY_FIRST_END | DATE | End of first access hours window. | ||
| WEDNESDAY_SECOND_START | DATE | Start of second access hours window. | ||
| WEDNESDAY_SECOND_END | DATE | End of second access hours window. | ||
| THURSDAY_FIRST_START | DATE | Start of first access hours window. | ||
| THURSDAY_FIRST_END | DATE | End of first access hours window. | ||
| THURSDAY_SECOND_START | DATE | Start of second access hours window. | ||
| THURSDAY_SECOND_END | DATE | End of second access hours window. | ||
| FRIDAY_FIRST_START | DATE | Start of first access hours window. | ||
| FRIDAY_FIRST_END | DATE | End of first access hours window. | ||
| FRIDAY_SECOND_START | DATE | Start of second access hours window. | ||
| FRIDAY_SECOND_END | DATE | End of second access hours window. | ||
| SATURDAY_FIRST_START | DATE | Start of first access hours window. | ||
| SATURDAY_FIRST_END | DATE | End of first access hours window. | ||
| SATURDAY_SECOND_START | DATE | Start of second access hours window. | ||
| SATURDAY_SECOND_END | DATE | End of second access hours window. | ||
| SUNDAY_FIRST_START | DATE | Start of first access hours window. | ||
| SUNDAY_FIRST_END | DATE | End of first access hours window. | ||
| SUNDAY_SECOND_START | DATE | Start of second access hours window. | ||
| SUNDAY_SECOND_END | DATE | End of second access hours window. | ||
| TASK_SPLIT_FLAG | VARCHAR2 | (1) | Identifies whether the Task is a Normal / Parent / Child Task | |
| OC_TRIP_STATUS | NUMBER | Y | Status of the Trip | |
| TS_ASSIGNED_FLAG | VARCHAR2 | (1) | Value of Assigned Flag corresponding to the Task Status | |
| TS_WORKING_FLAG | VARCHAR2 | (1) | Value of Working Flag corresponding to the Task Status | |
| TS_APPROVED_FLAG | VARCHAR2 | (1) | Value of Approved Flag corresponding to the Task Status | |
| TS_COMPLETED_FLAG | VARCHAR2 | (1) | Value of Completed Flag corresponding to the Task Status | |
| TS_CANCELLED_FLAG | VARCHAR2 | (1) | Value of Cancelled Flag corresponding to the Task Status | |
| TS_CLOSED_FLAG | VARCHAR2 | (1) | Value of Closed Flag corresponding to the Task Status | |
| TS_REJECTED_FLAG | VARCHAR2 | (1) | Value of Rejected Flag corresponding to the Task Status | |
| TS_ACCEPTED_FLAG | VARCHAR2 | (1) | Value of Accepted Flag corresponding to the Task Status | |
| TS_ON_HOLD_FLAG | VARCHAR2 | (1) | Value of On Hold Flag corresponding to the Task Status | |
| TS_DELETE_ALLOWED_FLAG | VARCHAR2 | (1) | Value of Delete Allowed Flag corresponding to the Task Status | |
| TASK_NUMBER | VARCHAR2 | (30) | Y | Task Number |
| HAS_PARENT_DEPENDENCY | CHAR | (1) | Indicates whether the Task is dependent on other tasks | |
| HAS_CHILD_DEPENDENCY | CHAR | (1) | Indicates whether there are other tasks dependent on this task | |
| SPARES_REQUIRED_FLAG | CHAR | (1) | Indicates whether Spares is required for this Task | |
| ACTUAL_EFFORT | NUMBER | Actual Effort of the Task | ||
| PERSONAL_TASK_FLAG | CHAR | (1) | Indicates whether the Task is a Personal Task (ie) not associated with a Service Request | |
| ACTUAL_TRAVEL_DURATION | NUMBER | |||
| ACTUAL_TRAVEL_DISTANCE | NUMBER | |||
| LOCUS_SRID | NUMBER |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TIMEZONE_ID | NUMBER | (15) | Y | Foreign key to time zone |
| START_TIME | DATE | Y | Start time of the WtP | |
| END_TIME | DATE | Y | End time of the WtP | |
| START_TIME_SERVER | DATE | Start time in the server time zone | ||
| END_TIME_SERVER | DATE | End time in the server time zone | ||
| WIN_PROMIS_ID | NUMBER | Y | Window to promise ID column |
APPS.CSR_WIN_PROMISES_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
View on window to promises used by Oracle Scheduler
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row ID column | |
| WIN_PROMIS_ID | NUMBER | Y | Primary key | |
| NAME | VARCHAR2 | (80) | Y | The name of the WtP |
| DESCRIPTION | VARCHAR2 | (1500) | The description of the WtP | |
| START_TIME | DATE | Y | The start time of the WtP | |
| END_TIME | DATE | Y | The end time of the WtP | |
| CREATED_BY | NUMBER | (15) | Y | Standard who column |
| CREATION_DATE | DATE | Y | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard who column | |
| LAST_UPDATE_DATE | DATE | Y | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield column | |
| ORG_ID | NUMBER | (15) | Multiple organizations ID column |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WINDOW_TYPE | VARCHAR2 | (80) | Y | Name of the WTP Window |
| START_TIME | DATE | Start Time of the WTP Window | ||
| END_TIME | DATE | End Time of the WTP Window | ||
| WTP_DATE | DATE | Date of the WTP Plan Option | ||
| COST | NUMBER | Cost of the Plan Option | ||
| PLAN_OPTION_ID | NUMBER | Y | Identifier to the CSF_R_PLAN_OPTIONS Table which stores more information about the generated Plan Option | |
| RESOURCE_NAME | VARCHAR2 | (4000) | Name of the Resource to whom the Plan Option is assigned | |
| RESOURCE_ID | NUMBER | Id of the Resource to whom the Plan Option is assigned | ||
| RESOURCE_TYPE | VARCHAR2 | (30) | Type of the Resource to whom the Plan Option is assigned | |
| SCHED_REQUEST_ID | NUMBER | Y | Identifier to CSF_R_SCHED_REQUESTS which has more information about the request which asked for this Plan Option | |
| WIN_PROMIS_ID | NUMBER | Y | Identifier to CSR_WIN_PROMIS_B |
APPS.CSR_WTP_DISPLAY_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |