Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - CSF Tables and Views

TABLE - CSF.CSF_ACCESS_HOURS_B
TABLE - CSF.CSF_ACCESS_HOURS_TL
TABLE - CSF.CSF_DC_QUERIES_B
TABLE - CSF.CSF_DC_QUERIES_TL
TABLE - CSF.CSF_DEBRIEF_HEADERS
TABLE - CSF.CSF_DEBRIEF_LINES
TABLE - CSF.CSF_EXT_LOCATIONS
TABLE - CSF.CSF_GNTICONS_SETUP_B
TABLE - CSF.CSF_LF_BLOCKS
TABLE - CSF.CSF_LF_NAMES
TABLE - CSF.CSF_LF_PLACES
TABLE - CSF.CSF_LF_PLACE_NAMES
TABLE - CSF.CSF_LF_PLACE_POSTCS
TABLE - CSF.CSF_LF_POIS
TABLE - CSF.CSF_LF_POI_NAMES
TABLE - CSF.CSF_LF_POSTCODES
TABLE - CSF.CSF_LF_ROADSEGMENTS
TABLE - CSF.CSF_LF_ROADSEGM_NAMES
TABLE - CSF.CSF_LF_ROADSEGM_PLACES
TABLE - CSF.CSF_LF_ROADSEGM_POSTS
TABLE - CSF.CSF_L_AGENDALAYOUTS
TABLE - CSF.CSF_L_QUERIES
TABLE - CSF.CSF_L_QUERYREQUESTS
TABLE - CSF.CSF_L_SODS
TABLE - CSF.CSF_L_SOTS
TABLE - CSF.CSF_MAP_ACCESS_HOURS_B
TABLE - CSF.CSF_MAP_ACCESS_HOURS_TL
TABLE - CSF.CSF_MD_ADM_BOUNDS
TABLE - CSF.CSF_MD_HYDROS
TABLE - CSF.CSF_MD_INST_STYLE_SHTS
TABLE - CSF.CSF_MD_LAND_USES
TABLE - CSF.CSF_MD_LYR_METADATA
TABLE - CSF.CSF_MD_LYR_STYLE_SHTS
TABLE - CSF.CSF_MD_NAMES
TABLE - CSF.CSF_MD_OM_ADMINS
TABLE - CSF.CSF_MD_OM_HYDROS
TABLE - CSF.CSF_MD_OM_POIS
TABLE - CSF.CSF_MD_OM_ROADS
TABLE - CSF.CSF_MD_POIS
TABLE - CSF.CSF_MD_POI_NM_ASGNS
TABLE - CSF.CSF_MD_RAIL_SEGS
TABLE - CSF.CSF_MD_RDSEG_NM_ASGNS
TABLE - CSF.CSF_MD_RD_SEGS
TABLE - CSF.CSF_MD_THEME_METADATA
TABLE - CSF.CSF_PARAMS
TABLE - CSF.CSF_PHONETIC_VALUES
TABLE - CSF.CSF_PLAN_TERRS
TABLE - CSF.CSF_RATING_SCALES_B
TABLE - CSF.CSF_RATING_SCALES_TL
TABLE - CSF.CSF_REQUIRED_SKILLS_B
TABLE - CSF.CSF_RESOURCE_SKILLS_B
TABLE - CSF.CSF_R_FILTERS_ALL_B
TABLE - CSF.CSF_R_FILTERS_ALL_TL
TABLE - CSF.CSF_R_FILTER_PARAMS_B
TABLE - CSF.CSF_R_FILTER_PARAMS_TL
TABLE - CSF.CSF_R_HZ_LOC_EXTNS
TABLE - CSF.CSF_R_MESSAGES
TABLE - CSF.CSF_R_MESSAGE_TOKENS
TABLE - CSF.CSF_R_PLAN_OPTIONS
TABLE - CSF.CSF_R_PLAN_OPTION_TASKS
TABLE - CSF.CSF_R_REQUEST_FILTERS
TABLE - CSF.CSF_R_REQUEST_TASKS
TABLE - CSF.CSF_R_REQUEST_VALUES
TABLE - CSF.CSF_R_RESOURCE_RESULTS
TABLE - CSF.CSF_R_SCENARIOS_ALL_B
TABLE - CSF.CSF_R_SCENARIOS_ALL_TL
TABLE - CSF.CSF_R_SCENARIO_FILTERS
TABLE - CSF.CSF_R_SCENARIO_VALUES
TABLE - CSF.CSF_R_SCHED_REQUESTS
TABLE - CSF.CSF_R_SPARES_OPTIONS
TABLE - CSF.CSF_R_TASK_ASSIGN_EXTNS
TABLE - CSF.CSF_R_TDS_ROUTE_CACHE
TABLE - CSF.CSF_SDM_CTRY_PROFILES
TABLE - CSF.CSF_SKILLS_B
TABLE - CSF.CSF_SKILLS_TL
TABLE - CSF.CSF_SKILL_LEVELS_B
TABLE - CSF.CSF_SKILL_LEVELS_TL
TABLE - CSF.CSF_SKILL_TYPES_B
TABLE - CSF.CSF_SKILL_TYPES_TL
TABLE - CSF.CSF_TDS_BINARY_MAPS
TABLE - CSF.CSF_TDS_BINARY_TILES
TABLE - CSF.CSF_TDS_CONDITIONS
TABLE - CSF.CSF_TDS_COND_SEGS
TABLE - CSF.CSF_TDS_INTERVALS
TABLE - CSF.CSF_TDS_NODES
TABLE - CSF.CSF_TDS_RDBLCK_INTVLS
TABLE - CSF.CSF_TDS_RDBLCK_SGMNTS
TABLE - CSF.CSF_TDS_ROADBLOCKS
TABLE - CSF.CSF_TDS_ROUTE_CACHE
TABLE - CSF.CSF_TDS_SEGMENTS
TABLE - CSF.CSF_TDS_SEGM_NODES
TABLE - CSF.CSF_TDS_TILES
VIEW - APPS.CSF_ACCESS_HOURS_VL
VIEW - APPS.CSF_CT_TASKS
VIEW - APPS.CSF_CT_TASK_ASSIGNMENTS
VIEW - APPS.CSF_DC_QUERIES_VL
VIEW - APPS.CSF_DEBRIEF_EXP_LINES_V
VIEW - APPS.CSF_DEBRIEF_HEADERS_V
VIEW - APPS.CSF_DEBRIEF_LAB_LINES_V
VIEW - APPS.CSF_DEBRIEF_MAT_LINES_V
VIEW - APPS.CSF_DEBRIEF_SRC_NUMBERS_V
VIEW - APPS.CSF_DEBRIEF_TASKS_V
VIEW - APPS.CSF_DEBRIEF_TRANS_TYPES_V
VIEW - APPS.CSF_ESC_TASKS_V
VIEW - APPS.CSF_GNTICONS_SETUP_V
VIEW - APPS.CSF_L_SODS_V
VIEW - APPS.CSF_MAP_ACCESS_HOURS_VL
VIEW - APPS.CSF_PHONETIC_VALUES_VL
VIEW - APPS.CSF_PLAN_OPTIONS_V
VIEW - APPS.CSF_PLAN_TERRS_V
VIEW - APPS.CSF_PO_CONTACT_POINTS_V
VIEW - APPS.CSF_RATING_SCALES_VL
VIEW - APPS.CSF_REQUIRED_SKILLS_V
VIEW - APPS.CSF_RESOURCE_SKILLS_V
VIEW - APPS.CSF_RES_INV_ASSIGNMENTS_V
VIEW - APPS.CSF_SELECTED_RESOURCES_V
VIEW - APPS.CSF_SKILLS_VL
VIEW - APPS.CSF_SKILL_LEVELS_VL
VIEW - APPS.CSF_SKILL_TYPES_VL
VIEW - APPS.CSF_SR_HIST_V
VIEW - APPS.CSF_VALIDATE_TASKS_V

Table: CSF_ACCESS_HOURS_B

Description:
Primary Key: CSF_ACCESS_HOURS_B_PK
  1. ACCESS_HOUR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_ACCESS_HOURS_B.TASK_ID JTF_TASKS_B
Comments

Stores the Access Hours definition for a task

Indexes
Index Type Tablespace Column
CSF_ACCESS_HOURS_B_U1 UNIQUE APPS_TS_TX_IDX ACCESS_HOUR_ID
CSF_ACCESS_HOURS_B_U2 UNIQUE APPS_TS_TX_IDX TASK_ID
Columns
Name Datatype Length Mandatory Comments
ACCESS_HOUR_ID NUMBER
Y Primary Key for Table
TASK_ID NUMBER
Y Foreign Key to Task Id
ACCESSHOUR_REQUIRED VARCHAR2 (2) Y Access Hours Flag
AFTER_HOURS_FLAG VARCHAR2 (2) Y After Hours Flag
MONDAY_FIRST_START DATE

Monday First Slot Start Time
MONDAY_FIRST_END DATE

Monday First Slot End time
MONDAY_SECOND_START DATE

Monday Second Slot Start Time
MONDAY_SECOND_END DATE

Monday Second SLot End Time
TUESDAY_FIRST_START DATE

Tuesday First Slot Start TIme
TUESDAY_FIRST_END DATE

Tuesday First Slot End Time
TUESDAY_SECOND_START DATE

Tuesday Second Slot Start Time
TUESDAY_SECOND_END DATE

Tuesday Second Slot End Time
WEDNESDAY_FIRST_START DATE

Wednesday First Slot Start Time
WEDNESDAY_FIRST_END DATE

Wednesday First Slot End Time
WEDNESDAY_SECOND_START DATE

Wednesday Second Slot Start Time
WEDNESDAY_SECOND_END DATE

Wednesday Second Slot End Time
THURSDAY_FIRST_START DATE

Thursday First Slot Start Time
THURSDAY_FIRST_END DATE

Thursday First Slot End Time
THURSDAY_SECOND_START DATE

Thursday Second Slot Start Time
THURSDAY_SECOND_END DATE

Thursday Second Slot End Time
FRIDAY_FIRST_START DATE

Friday First Slot Start TIme
FRIDAY_FIRST_END DATE

Friday First Slot End Time
FRIDAY_SECOND_START DATE

Friday Second Slot Start Time
FRIDAY_SECOND_END DATE

Friday Second Slot End Time
SATURDAY_FIRST_START DATE

Saturday First Slot Start Time
SATURDAY_FIRST_END DATE

Saturday First Slot End Time
SATURDAY_SECOND_START DATE

Saturday Second Slot Start Time
SATURDAY_SECOND_END DATE

Saturday Second Slot End Time
SUNDAY_FIRST_START DATE

Sunday First Slot Start Time
SUNDAY_FIRST_END DATE

Sunday First Slot End Time
SUNDAY_SECOND_START DATE

Sunday Second Slot Start Time
SUNDAY_SECOND_END DATE

Sunday Second Slot End Time.
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update
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 identifier

[top of page]

CSF.CSF_ACCESS_HOURS_B does not reference any database object

CSF.CSF_ACCESS_HOURS_B is referenced by following:

APPS
SYNONYM - CSF_ACCESS_HOURS_B

[top of page]

Table: CSF_ACCESS_HOURS_TL

Description:
Primary Key: CSF_ACCESS_HOURS_TL_PK
  1. LANGUAGE
  2. ACCESS_HOUR_ID
Comments

Translation Table for CSF_ACCESS_HOURS_B

Columns
Name Datatype Length Mandatory Comments
ACCESS_HOUR_ID NUMBER
Y Primary Key
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
DESCRIPTION VARCHAR2 (240)
Stores Description when After Hours is selected.
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 identifier

[top of page]

CSF.CSF_ACCESS_HOURS_TL does not reference any database object

CSF.CSF_ACCESS_HOURS_TL is referenced by following:

APPS
SYNONYM - CSF_ACCESS_HOURS_TL

[top of page]

Table: CSF_DC_QUERIES_B

Description: CSF_DC_QUERIES_B contains WHERE-clauses for queries to populate the Dispatch Center with tasks
Primary Key: CSF_DC_QUERIES_PK
  1. QUERY_ID
Comments

CSF_DC_QUERIES_B contains WHERE-clauses for queries to populate the Dispatch Center with tasks

Indexes
Index Type Tablespace Column
CSF_DC_QUERIES_U1 NONUNIQUE APPS_TS_TX_IDX QUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y Primary key column
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
OBJECT_VERSION_NUMBER NUMBER

Sequence number used to detect concurrent recored updates.
WHERE_CLAUSE VARCHAR2 (4000) Y The where_clause of the query stored in this record
USER_ID NUMBER (15) Y User id of the owner of the query
SEEDED_FLAG VARCHAR2 (1)
Indicator wether the query is seeded or user entered
START_DATE_ACTIVE DATE
Y Start date of valid period
END_DATE_ACTIVE DATE

End date of valid period
SECURITY_GROUP_ID NUMBER

standard security column

[top of page]

CSF.CSF_DC_QUERIES_B does not reference any database object

CSF.CSF_DC_QUERIES_B is referenced by following:

APPS
SYNONYM - CSF_DC_QUERIES_B

[top of page]

Table: CSF_DC_QUERIES_TL

Description:
Primary Key: CSF_DC_QUERIES_TL_PK
  1. QUERY_ID
  2. LANGUAGE
Comments

Translation Table for CSF_DC_QUERIES_B

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Y Primary Key
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
NAME VARCHAR2 (30)
Query Name
DESCRIPTION VARCHAR2 (2000)
Description of the Query
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4)
Source Language

[top of page]

CSF.CSF_DC_QUERIES_TL does not reference any database object

CSF.CSF_DC_QUERIES_TL is referenced by following:

APPS
SYNONYM - CSF_DC_QUERIES_TL

[top of page]

Table: CSF_DEBRIEF_HEADERS

Description: Field Service Report header information
Primary Key: CSF_DEBRIEF_HEADERS_PK
  1. DEBRIEF_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_HEADERS.TASK_ASSIGNMENT_ID JTF_TASK_ASSIGNMENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID CSF_DEBRIEF_HEADERS
Comments

CSF_DEBRIEF_HEADERS contains the header information about the Field service report ie the information that a field service engineer records during a field visit .
The primary key is CS_DEBRIEF_HEADER_ID and this is a foreign key into CS_DEBRIEF_LINES.
Each Task has resource assignments and each such task resource assignment is associated with a Field Service Report . Every Field service report header indicates an interaction with the customer.

Indexes
Index Type Tablespace Column
CSF_DEBRIEF_HEADERS_U1 UNIQUE APPS_TS_TX_IDX DEBRIEF_HEADER_ID
CSF_DEBRIEF_HEADERS_U2 UNIQUE APPS_TS_TX_IDX DEBRIEF_NUMBER
CSF_DEBRIEF_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX TASK_ASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
DEBRIEF_HEADER_ID NUMBER
Y The unique identifier for header
DEBRIEF_NUMBER VARCHAR2 (50) Y The unique number for field service report
DEBRIEF_DATE DATE
Y The field service report date
DEBRIEF_STATUS_ID NUMBER

The Field Service Report status identifier
TASK_ASSIGNMENT_ID NUMBER
Y The task assignment unique identifier
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 segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
SECURITY_GROUP_ID NUMBER

Security group identifier
STATISTICS_UPDATED VARCHAR2 (15)
Statistics Updated
PROCESSED_FLAG VARCHAR2 (40)
Status of debrief while being processed
TRAVEL_START_TIME DATE

Travel Start Time
TRAVEL_END_TIME DATE

Travel End Time
OBJECT_VERSION_NUMBER NUMBER

Object version number
TRAVEL_DISTANCE_IN_KM NUMBER

Traveled distance stored in kilometers

[top of page]

CSF.CSF_DEBRIEF_HEADERS does not reference any database object

CSF.CSF_DEBRIEF_HEADERS is referenced by following:

APPS
SYNONYM - CSF_DEBRIEF_HEADERS

[top of page]

Table: CSF_DEBRIEF_LINES

Description: Field Service Report lines information
Primary Key: CSF_DEBRIEF_LINES_PK
  1. DEBRIEF_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID CSF_DEBRIEF_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CS_ESTIMATE_DETAILS.ORIGINAL_SOURCE_ID CSF_DEBRIEF_LINES
Comments

CSF_DEBRIEF_LINES is a table that contains line information for a Field Service report. ie the information that a field service engineer records during a field visit .
The primary key is CS_DEBRIEF_LINE_ID . Each Field Service Report can have multiple report lines that report material, labour and expenses incurred during a field service visit.
This information is used to upload to Charges , Installed Base and Spares Inventory modules.
Field Service Report data from mobile devices is also stored in here via public APIs.

Indexes
Index Type Tablespace Column
CSF_DEBRIEF_LINES_U1 UNIQUE APPS_TS_TX_IDX DEBRIEF_LINE_ID
CSF_DEBRIEF_LINES_N1 NONUNIQUE APPS_TS_TX_IDX DEBRIEF_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
DEBRIEF_LINE_ID NUMBER
Y The unique line identifier for each field service report line
DEBRIEF_HEADER_ID NUMBER
Y The primary key for the field service headers.
DEBRIEF_LINE_NUMBER NUMBER

The Field service line number
SERVICE_DATE DATE
Y Service date
TXN_BILLING_TYPE_ID NUMBER

The transaction billing type identifier
INVENTORY_ITEM_ID NUMBER

The inventory item identifier
ISSUING_INVENTORY_ORG_ID NUMBER

The issuing out inventory org identifier
RECEIVING_INVENTORY_ORG_ID NUMBER

Receiving inventory org identifier.
ISSUING_SUB_INVENTORY_CODE VARCHAR2 (10)
Issuing sub inventory code
RECEIVING_SUB_INVENTORY_CODE VARCHAR2 (10)
Receiving sub inventory code
ISSUING_LOCATOR_ID NUMBER

Issuing locator identifier
RECEIVING_LOCATOR_ID NUMBER

The receiving locator identifier
PARENT_PRODUCT_ID NUMBER (15)
The parent product identifier for the removed out item
REMOVED_PRODUCT_ID NUMBER (15)
The product identifier for the removed item
STATUS_OF_RECEIVED_PART VARCHAR2 (30)
The status of the received part
ITEM_SERIAL_NUMBER VARCHAR2 (30)
Serial number of the item
ITEM_REVISION VARCHAR2 (3)
Revision of the item
ITEM_LOTNUMBER VARCHAR2 (80)
Item lot number
UOM_CODE VARCHAR2 (3)
The uom code of the item
QUANTITY NUMBER

The quantity of the item
RMA_HEADER_ID NUMBER

The order identifier
DISPOSITION_CODE VARCHAR2 (30)
The item disposition code
MATERIAL_REASON_CODE VARCHAR2 (30)
The material line reason code
LABOR_REASON_CODE VARCHAR2 (30)
The labor line reason code
EXPENSE_REASON_CODE VARCHAR2 (30)
The expense line reason code
LABOR_START_DATE DATE

The labor start date
LABOR_END_DATE DATE

The labor end date
STARTING_MILEAGE NUMBER

The starting mileage
ENDING_MILEAGE NUMBER

The ending mileage
EXPENSE_AMOUNT NUMBER

The expense amount
CURRENCY_CODE VARCHAR2 (15)
The currency code
DEBRIEF_LINE_STATUS_ID NUMBER

The line status identifier
CHANNEL_CODE VARCHAR2 (30)
The channel code of the line
CHARGE_UPLOAD_STATUS VARCHAR2 (30)
Charge update interface status
CHARGE_UPLOAD_MSG_CODE VARCHAR2 (30)
Charge update message code
CHARGE_UPLOAD_MESSAGE VARCHAR2 (240)
Charge update message
IB_UPDATE_STATUS VARCHAR2 (30)
Installed base update interface status
IB_UPDATE_MSG_CODE VARCHAR2 (30)
Installed base update interface message code
IB_UPDATE_MESSAGE VARCHAR2 (240)
Installed base update interface message
SPARE_UPDATE_STATUS VARCHAR2 (30)
Inventory update interface status
SPARE_UPDATE_MSG_CODE VARCHAR2 (30)
Inventory update interface message code
SPARE_UPDATE_MESSAGE VARCHAR2 (240)
Inventory update interface message
CREATED_BY NUMBER (15) Y The standard who column
CREATION_DATE DATE
Y The standard who column
LAST_UPDATED_BY NUMBER (15) Y The standard who column
LAST_UPDATE_DATE DATE
Y The standard who column
LAST_UPDATE_LOGIN NUMBER (15)
The standard who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
SECURITY_GROUP_ID NUMBER

Security group identifier
UPG_ORIG_SYSTEM_REF VARCHAR2 (60)
Column containing source tablename for upgrade
UPG_ORIG_SYSTEM_REF_ID NUMBER

Column containing primary key for upgrade
BUSINESS_PROCESS_ID NUMBER

Business process identifier
RETURN_REASON_CODE VARCHAR2 (30)
Return reason code
INSTANCE_ID NUMBER

The Id of the Instance we are debriefing
STATISTICS_UPDATED VARCHAR2 (15)
Statistics Updated
ERROR_TEXT VARCHAR2 (2000)
Error if debrief was processed with an error.
TRANSACTION_TYPE_ID NUMBER

Transaction Type Id
RETURN_DATE DATE

Return date for loaner transactions.
OBJECT_VERSION_NUMBER NUMBER

Object version number
ITEM_OPERATIONAL_STATUS_CODE VARCHAR2 (30)
Instance operational status code
MATERIAL_TRANSACTION_ID NUMBER

Material Transaction Identifier

[top of page]

CSF.CSF_DEBRIEF_LINES does not reference any database object

CSF.CSF_DEBRIEF_LINES is referenced by following:

APPS
SYNONYM - CSF_DEBRIEF_LINES

[top of page]

Table: CSF_EXT_LOCATIONS

Description:
Comments

DEFINITION
The Location table includes all invalid address information for: Customers and Resources.
EXAMPLE
MISCELLANEOUS
This Location table will have the invalida address information. If the address is corrected, the validated_flag will be set to 'Y'. The addresses which are having the validated_flag as 'N' are invalid address.

Columns
Name Datatype Length Mandatory Comments
CSF_EXT_LOCATION_ID NUMBER (15) Y A unique identifier for the Locations.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row.
TASK_ID NUMBER (15) Y Task_id for the task from the jtf_tasks_b table
LOCATION_ID NUMBER (15) Y Location_id for the task from the hz_locations table
VALIDATED_FLAG VARCHAR2 (1) Y Indicates if the location was validated. Y for validated, N for unvalidated
OVERRIDE_FLAG VARCHAR2 (1) Y Indicates if the location was overriden. Y for overridden, N if not overridden
LOG_DETAIL_SHORT VARCHAR2 (500) Y Short detail of the address error
LOG_DETAIL_LONG VARCHAR2 (2000) Y Detailed expression of the error.

[top of page]

CSF.CSF_EXT_LOCATIONS does not reference any database object

CSF.CSF_EXT_LOCATIONS is referenced by following:

APPS
SYNONYM - CSF_EXT_LOCATIONS

[top of page]

Table: CSF_GNTICONS_SETUP_B

Description:
Comments

Stores the Icons which can be enabled to show in Scheduling Chart

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER
Y Sequence Id - Primary Key
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
OBJECT_VERSION_NUMBER NUMBER

The object version number is incremented by one at every update.
ICON_FILE_NAME VARCHAR2 (2000) Y Stores the Icon File Name
DESCRIPTION VARCHAR2 (2000) Y Description to explain the usage of Icon.
RANKING NUMBER
Y Ranking
ACTIVE VARCHAR2 (1) Y Active or Not

[top of page]

CSF.CSF_GNTICONS_SETUP_B does not reference any database object

CSF.CSF_GNTICONS_SETUP_B is referenced by following:

APPS
SYNONYM - CSF_GNTICONS_SETUP_B

[top of page]

Table: CSF_LF_BLOCKS

Description: Defines the available address range for a segment
Primary Key: CSF_LF_BLOCKS_PK
  1. BLOCK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_BLOCKS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
Comments

DEFINITION
The Block table includes available address ranges for a certain roadsegment. Typically a block record describes the Start and End house number, both on the Left and Right side of the road segment.
EXAMPLE
MISCELLANEOUS
One roadsegment can have multiple blocks (e.g. commercial vs. base address range).

Columns
Name Datatype Length Mandatory Comments
BLOCK_ID NUMBER (30) Y Surrogate key used for primary unique identifiers
LEFT_ADDRESS_FORMAT VARCHAR2 (1)
Address format (numeric, alphanumeric, unaddressed) for road segment
LEFT_ADDRESS_SCHEME VARCHAR2 (1)
Address scheme (Odd, Even, Mixed) at Left Side of road segment
START_LEFT_ADDRESS VARCHAR2 (10)
Left House Number at Reference Node
END_LEFT_ADDRESS VARCHAR2 (10)
Left House Number at non-Reference node
RIGHT_ADDRESS_FORMAT VARCHAR2 (1)
Address format (numeric, alphanumeric, unaddressed) for road segment
RIGHT_ADDRESS_SCHEME VARCHAR2 (1)
Address scheme (Odd, Even, Mixed) at Right Side of road segment
START_RIGHT_ADDRESS VARCHAR2 (10)
Right House Number at Reference Node
END_RIGHT_ADDRESS VARCHAR2 (10)
Right House Number at Non-Reference Node
ADDRESS_TYPE VARCHAR2 (1)
Type of block (base, commercial etc.)
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode

[top of page]

CSF.CSF_LF_BLOCKS does not reference any database object

CSF.CSF_LF_BLOCKS is referenced by following:

APPS
SYNONYM - CSF_LF_BLOCKS

[top of page]

Table: CSF_LF_NAMES

Description: Stores all Name information for the Location Finder
Primary Key: CSF_LF_NAMES_PK
  1. NAME_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_POI_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_ROADSEGM_NAMES.NAME_ID CSF_LF_NAMES
Comments

DEFINITION
The Name Table includes all Name information for: RoadSegment, POI and Place.
EXAMPLE
MISCELLANEOUS
The Name table will have multiple entries when an entity has multiple names. Therefore the Name table includes all available Official, Alternate, Stale, Vanity names for entities.

Columns
Name Datatype Length Mandatory Comments
NAME_ID NUMBER (30) Y Unique key for Name
NAME VARCHAR2 (70) Y Actual name of the entity (Streetname, POI name, Place name)
LANGUAGE_CODE VARCHAR2 (3)
3 letter MARC language code for name
JUNCTION_NAME VARCHAR2 (3)
Is Name a Junction Name?
EXIT_NUMBER VARCHAR2 (3)
Is Name an Exit Number?
ROUTE_TYPE NUMBER

Indication of Route Number level (only for Route Nrs.)
PREFIX VARCHAR2 (1)
Prefix for Street Name (e.g. E, W; US only)
BASE_NAME VARCHAR2 (240)
Base Name of Street Name (e.g. 'High' in High Street)
STREET_TYPE VARCHAR2 (35)
Street Type of Street Name (e.g. 'Street' in High Street)
STREET_TYPE_ATTACHED VARCHAR2 (1)
Street Type attached to Base Name?
STREET_TYPE_BEFORE_BASE VARCHAR2 (1)
Street Type before Base Name?
SUFFIX VARCHAR2 (1)
Suffix of Street Name (e.g. N, W; US only)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode

[top of page]

CSF.CSF_LF_NAMES does not reference any database object

CSF.CSF_LF_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_NAMES

[top of page]

Table: CSF_LF_PLACES

Description: Contains all Administrative areas and Zones
Primary Key: CSF_LF_PLACES_PK
  1. PLACE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_POSTCS.PLACE_ID CSF_LF_PLACES
CSF_LF_POIS.PLACE_ID CSF_LF_PLACES
CSF_LF_ROADSEGM_PLACES.PLACE_ID CSF_LF_PLACES
Comments

DEFINITION
A place represents an administrative level. The administrative levels included differ per country. At a minimum the following administrative levels are included:
- Settlement (also refered to as the built up area)
- Municipality
- Country
Depending on the country, additional admin levels could be included.
EXAMPLE
Utrecht, Deutschland, Chicago, Illinois, Firenze, E17, La Defense
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
PLACE_ID NUMBER (30) Y Unique key that identifies the place
PLACE_USAGE_ADMIN VARCHAR2 (3) Y Identifies if the Place represents an Administrative unit
PLACE_PARENT_LEVEL NUMBER

Defines level of the parent admin unit (e.g. Municipality, Province)
PLACE_USAGE_ZONE VARCHAR2 (3) Y Identifies if the Place represents a Zone
PARENT_PLACE_ID NUMBER (30)
The parent place id for the place table
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_PLACES does not reference any database object

CSF.CSF_LF_PLACES is referenced by following:

APPS
SYNONYM - CSF_LF_PLACES

[top of page]

Table: CSF_LF_PLACE_NAMES

Description: Defines relation between Place and Name
Primary Key: CSF_LF_PLACE_NAMES_PK
  1. PLACE_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_NAMES.NAME_ID CSF_LF_NAMES
Comments

DEFINITION
Intersection table required since one place can have many names (e.g. Exonyms, Synonyms) and one Name can be used by multiple Places (e.g. Utrecht city, municipality and province).
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
PLACE_NAME_ID NUMBER (30) Y Surrogate key used for primary unique identifiers
NAME_TYPE VARCHAR2 (1) Y Indication if Name represents Official or Alternate name for Place.
PLACE_ID NUMBER (30) Y Unique key that identifies the place
NAME_ID NUMBER (30) Y Unique key for Name
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode

[top of page]

CSF.CSF_LF_PLACE_NAMES does not reference any database object

CSF.CSF_LF_PLACE_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_PLACE_NAMES

[top of page]

Table: CSF_LF_PLACE_POSTCS

Description: Defines relation between Place and Postcode tables
Primary Key: CSF_LF_PLACE_POSTCS_PK
  1. PLACE_POSTCODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_POSTCS.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID CSF_LF_POSTCODES
Comments

DEFINITION
Intersection table required since one Postcode can be located in multiple Places, and one Place can have multiple Postcodes.
EXAMPLE
MISCELLANEOUS
The information is retrieved from the GDF3.0 relations 1018 and 1009.
Relation Place-Postcode will only be available for Settlement and Municipality Place level.

Columns
Name Datatype Length Mandatory Comments
PLACE_POSTCODE_ID NUMBER (30) Y Unique identifier for the Place Postcode table
PLACE_ID NUMBER (30) Y Unique key that identifies the place
POSTAL_CODE_ID NUMBER (30) Y Primary key for the Postal Code table
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode

[top of page]

CSF.CSF_LF_PLACE_POSTCS does not reference any database object

CSF.CSF_LF_PLACE_POSTCS is referenced by following:

APPS
SYNONYM - CSF_LF_PLACE_POSTCS

[top of page]

Table: CSF_LF_POIS

Description: Stores POI (points of interests) in the roadnetwork that are known by the name for LF
Primary Key: CSF_LF_POIS_PK
  1. POI_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_POIS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_POIS.PLACE_ID CSF_LF_PLACES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_POI_NAMES.POI_ID CSF_LF_POIS
Comments

DEFINITION
Points Of Interest (POI) are single points in the road network database that are typically known by their name, e.g. City Centres, Airports, Hotels.
EXAMPLE
Hotel Mayfair, Luchthaven Schiphol, Tour Eiffel, Buckingham Palace, New Orleans, Tai Chek
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000082997C00017$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000082997C00018$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER (30) Y Unique identifier for POI Table
FEATURE_CODE NUMBER
Y Describes type of POI
POI_ADDRESS VARCHAR2 (240)
Full address of the POI (Streetname and HouseNr)
TELEPHONE_NUMBER VARCHAR2 (240)
Phone number of the POI
CHAIN_NAME VARCHAR2 (240)
Chain where the POI is part of
FOOD_TYPE VARCHAR2 (240)
Type of food served in Restau
IMPORTANCE NUMBER
Y Indication if POI is of National Importance
POPULATION NUMBER

Estimated population for City Centre POI
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
PLACE_ID NUMBER (30) Y Foreign key to place table
POI_POINT SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_POIS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_POIS is referenced by following:

APPS
SYNONYM - CSF_LF_POIS

[top of page]

Table: CSF_LF_POI_NAMES

Description: Defines the relation between POI and Name tables
Primary Key: CSF_LF_POI_NAMES_PK
  1. POI_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_POI_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_POI_NAMES.POI_ID CSF_LF_POIS
Comments

DEFINITION
Intersection table required since one POI can have multiple names (i.e. Exoonyms, Synonyms) and one Name can be shared by multiple POIs (e.g. Shell, Holiday Inn).
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
POI_NAME_ID NUMBER (30) Y Surrogate key used for primary unique identifiers
NAME_TYPE VARCHAR2 (1) Y Indication if name is used as Official or Alternate Name for POI
POI_ID NUMBER (30) Y Unique identifier for POI Table
NAME_ID NUMBER (30) Y Unique key for Name
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_POI_NAMES does not reference any database object

CSF.CSF_LF_POI_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_POI_NAMES

[top of page]

Table: CSF_LF_POSTCODES

Description: Stores the Postcode information and the centroid of each Postcode area
Primary Key: CSF_LF_POSTCODES_PK
  1. POSTAL_CODE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID CSF_LF_POSTCODES
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID CSF_LF_POSTCODES
Comments

DEFINITION
Defines postal code that is valid for a RoadSegment or POI and represents the official numeric or alphanumeric postal code present in that country.
EXAMPLE
MISCELLANEOUS
The PostCode table is related to the Place Table for retrieving Country ID.
Postal Codes could be duplicated between countries, therefore the Country ID is required.

Indexes
Index Type Tablespace Column
SYS_IL0000083001C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083001C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POSTAL_CODE_ID NUMBER (30) Y Primary key for the Postal Code table
POSTAL_CODE VARCHAR2 (240) Y Actual numeric or alphanumeric Postal Code
COUNTRY_CODE VARCHAR2 (240) Y The country for which the postcode is.
POSTAL_CODE_LOCUS SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_POSTCODES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_POSTCODES is referenced by following:

APPS
SYNONYM - CSF_LF_POSTCODES

[top of page]

Table: CSF_LF_ROADSEGMENTS

Description: Stores roadsegments with their navigable attributes
Primary Key: CSF_LF_ROADSEGMENTS_PK
  1. ROADSEGMENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_BLOCKS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_POIS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
Comments

DEFINITION
A Road Segment is a navigable feature such as a Road, Ferry or Walkway. Road Segments make up the navigable road network. A Road Segment is always bounded by two nodes. A road segment will have various attributes associated with it.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083003C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083003C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
ROADSEGMENT_LENGTH NUMBER
Y Length of road segment
TIME_ZONE NUMBER

The time zone for this road segment
ROADSEGMENT_GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier user for running in hosted mode.

[top of page]

CSF.CSF_LF_ROADSEGMENTS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_ROADSEGMENTS is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGMENTS

[top of page]

Table: CSF_LF_ROADSEGM_NAMES

Description: Defines the relation between roadsegments and the name table
Primary Key: CSF_LF_ROADSEGM_NAMES_PK
  1. ROADSEGMENT_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
Comments

DEFINITION
Intersection table since one roadsegment can have multiple names (e.g. E34 and A12) and one name can be used by multiple roadsegments.
EXAMPLE
MISCELLANEOUS
Some roadsegments do not have a name in reality (so called 'Valid Unnamed'). For these roadsegment no entry exist in the Roadsegment Name table.

Columns
Name Datatype Length Mandatory Comments
ROADSEGMENT_NAME_ID NUMBER (30) Y Unique identifier for RoadSegment Name table
NAME_TYPE VARCHAR2 (1) Y Indication if RoadSegment's Name represents Official, Alternate, Stale or Vanity Name'
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
NAME_ID NUMBER (30) Y Unique key for Name
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_ROADSEGM_NAMES does not reference any database object

CSF.CSF_LF_ROADSEGM_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_NAMES

[top of page]

Table: CSF_LF_ROADSEGM_PLACES

Description: Defines relation between Roadsegments and Places
Primary Key: CSF_LF_ROADSEGM_PLACES_PK
  1. ROADSEGM_PLACE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_PLACES.PLACE_ID CSF_LF_PLACES
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
Comments

DEFINITION
Intersection table required since one Segment can be located in multiple places (e.g. road on admin boundary) and one place contains multiple segments.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083008C00011$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083008C00012$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ROADSEGM_PLACE_ID NUMBER (30) Y Surrogate key used for primary unique identifiers
PLACE_SIDE VARCHAR2 (1)
Specifies side of roadsegment to which Place belongs
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
PLACE_ID NUMBER (30) Y Unique key that identifies the place
ROAD_CENTROID SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_ROADSEGM_PLACES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_ROADSEGM_PLACES is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_PLACES

[top of page]

Table: CSF_LF_ROADSEGM_POSTS

Description: Defines relation between Roadsegment and Postcodes
Primary Key: CSF_LF_ROADSEGM_POSTS_PK
  1. ROADSEGMENT_POSTCODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID CSF_LF_POSTCODES
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
Comments

DEFINITION
Intersection table since one Roadsegment can contains multiple Postal Codes (e.g. roadsegment on postcode boundary --> left / right different Postal Code), and one Postal Code will be shared by multiple RoadSegments.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
ROADSEGMENT_POSTCODE_ID NUMBER (30) Y Surrogate key used for primary unique identifiers
POSTCODE_SIDE VARCHAR2 (1)
Post Code exits on Left (L), Right (R) or Both (B) sides
ROADSEGMENT_ID NUMBER (30) Y Permanent identifier for RoadSegment (=GDF3.0 Edge ID)
POSTAL_CODE_ID NUMBER (30) Y Primary key for the Postal Code table
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_LF_ROADSEGM_POSTS does not reference any database object

CSF.CSF_LF_ROADSEGM_POSTS is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_POSTS

[top of page]

Table: CSF_L_AGENDALAYOUTS

Description: Agenda Layout on the Laptop
Primary Key: CSF_L_AGENDALAYOUTS_PK
  1. AGENDALAYOUT_ID
Comments
Columns
Name Datatype Length Mandatory Comments
AGENDALAYOUT_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
COL NUMBER (15) Y
FIELDNAME VARCHAR2 (50) Y
USERFIELDNAME VARCHAR2 (50) Y
VISIBLE NUMBER (15) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_L_AGENDALAYOUTS does not reference any database object

CSF.CSF_L_AGENDALAYOUTS is referenced by following:

APPS
SYNONYM - CSF_L_AGENDALAYOUTS

[top of page]

Table: CSF_L_QUERIES

Description: List of Queries
Primary Key: CSF_L_QUERIES_PK
  1. QUERY_ID
Comments
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
QUERYFOR VARCHAR2 (20) Y
FORMNAME VARCHAR2 (20) Y
SQLTITEL VARCHAR2 (20) Y
SQLSTRING VARCHAR2 (2000) Y
RUNREMOTE NUMBER (15)
REFRESHRATE NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_L_QUERIES does not reference any database object

CSF.CSF_L_QUERIES is referenced by following:

APPS
SYNONYM - CSF_L_QUERIES

[top of page]

Table: CSF_L_QUERYREQUESTS

Description: Requests for executing Queries
Primary Key: CSF_L_QUERYREQUESTS_PK
  1. QUERYREQUEST_ID
Comments
Columns
Name Datatype Length Mandatory Comments
QUERYREQUEST_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
EMPLID VARCHAR2 (20) Y
REQUESTDATE DATE
Y
QUERY_ID NUMBER (15) Y
QUERYINPUT VARCHAR2 (255)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_L_QUERYREQUESTS does not reference any database object

CSF.CSF_L_QUERYREQUESTS is referenced by following:

APPS
SYNONYM - CSF_L_QUERYREQUESTS

[top of page]

Table: CSF_L_SODS

Description: Service Order Description
Primary Key: CSF_L_SODS_PK
  1. SOD_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SOD_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
SOT_ID NUMBER (15) Y
SODTYPE VARCHAR2 (20) Y
SODDESCR VARCHAR2 (50) Y
FILENAMEHDR VARCHAR2 (255) Y
FILENAMEFTR VARCHAR2 (255)
DEFSOD_ID NUMBER (15) Y
TASK_TYPE_ID NUMBER

ITEM_PATTERN VARCHAR2 (240)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_L_SODS does not reference any database object

CSF.CSF_L_SODS is referenced by following:

APPS
SYNONYM - CSF_L_SODS

[top of page]

Table: CSF_L_SOTS

Description: Service Order Types
Primary Key: CSF_L_SOTS_PK
  1. SOT_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SOT_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
DESCR VARCHAR2 (50) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_L_SOTS does not reference any database object

CSF.CSF_L_SOTS is referenced by following:

APPS
SYNONYM - CSF_L_SOTS

[top of page]

Table: CSF_MAP_ACCESS_HOURS_B

Description:
Primary Key: CSF_MAP_ACCESS_HOURS_B_PK
  1. ACCESS_HOUR_MAP_ID
Comments

This table stores information about access hours. The access hours can be linked to a customer or a customer site or a location.
The access hour information defined in this table is copied to the Preventive Maintenance tasks when those get created.
The access hour information will be used while scheduling the tasks.

Indexes
Index Type Tablespace Column
CSF_MAP_ACCESS_HOURS_B_U1 UNIQUE APPS_TS_TX_IDX ACCESS_HOUR_MAP_ID
CSF_MAP_ACCESS_HOURS_B_U2 UNIQUE APPS_TS_TX_IDX CUSTOMER_ID
CUSTOMER_SITE_ID
CUSTOMER_LOCATION_ID
Columns
Name Datatype Length Mandatory Comments
ACCESS_HOUR_MAP_ID NUMBER
Y Access hour map unique identifier
CUSTOMER_ID NUMBER

Customer identifier
CUSTOMER_SITE_ID NUMBER

Customer site identifier
CUSTOMER_LOCATION_ID NUMBER

Customer location identifier
ACCESSHOUR_REQUIRED VARCHAR2 (2)
Access Hours or After Hours identifier
AFTER_HOURS_FLAG VARCHAR2 (2)
After Hours flag
MONDAY_FIRST_START DATE

Monday first window start time
MONDAY_FIRST_END DATE

Monday first window end time
MONDAY_SECOND_START DATE

Monday second window start time
MONDAY_SECOND_END DATE

Monday second window end time
TUESDAY_FIRST_START DATE

Tuesday first window start time
TUESDAY_FIRST_END DATE

Tuesday first window end time
TUESDAY_SECOND_START DATE

Tuesday second window start time
TUESDAY_SECOND_END DATE

Tuesday second window end time
WEDNESDAY_FIRST_START DATE

Wednesday first window start time
WEDNESDAY_FIRST_END DATE

Wednesday first window end time
WEDNESDAY_SECOND_START DATE

Wednesday second window start time
WEDNESDAY_SECOND_END DATE

Wednesday second window end time
THURSDAY_FIRST_START DATE

Thursday first window start time
THURSDAY_FIRST_END DATE

Thursday first window end time
THURSDAY_SECOND_START DATE

Thursday second window start time
THURSDAY_SECOND_END DATE

Thursday second window end time
FRIDAY_FIRST_START DATE

Friday first window start time
FRIDAY_FIRST_END DATE

Friday first window end time
FRIDAY_SECOND_START DATE

Friday second window start time
FRIDAY_SECOND_END DATE

Friday second window end time
SATURDAY_FIRST_START DATE

Saturday first window start time
SATURDAY_FIRST_END DATE

Saturday first window end time
SATURDAY_SECOND_START DATE

Saturday second window start time
SATURDAY_SECOND_END DATE

Saturday second window end time
SUNDAY_FIRST_START DATE

Sunday first window start time
SUNDAY_FIRST_END DATE

Sunday first window end time
SUNDAY_SECOND_START DATE

Sunday second window start time
SUNDAY_SECOND_END DATE

Sunday second window end time
OBJECT_VERSION_NUMBER NUMBER

Object version number
CREATED_BY NUMBER

Standard Who column - with the user id from FND_USER
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

CSF.CSF_MAP_ACCESS_HOURS_B does not reference any database object

CSF.CSF_MAP_ACCESS_HOURS_B is referenced by following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_B

[top of page]

Table: CSF_MAP_ACCESS_HOURS_TL

Description:
Primary Key: CSF_MAP_ACCESS_HOURS_TL_PK
  1. ACCESS_HOUR_MAP_ID
  2. LANGUAGE
Comments

This table stores the translated values of the after hours description.

Indexes
Index Type Tablespace Column
CSF_MAP_ACCESS_HOURS_TL_U1 NONUNIQUE APPS_TS_TX_IDX ACCESS_HOUR_MAP_ID
Columns
Name Datatype Length Mandatory Comments
ACCESS_HOUR_MAP_ID NUMBER
Y Access hours map unique identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4)
Source language
DESCRIPTION VARCHAR2 (240)
After hours description
CREATED_BY NUMBER

Standard Who column - with the user id from FND_USER
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

CSF.CSF_MAP_ACCESS_HOURS_TL does not reference any database object

CSF.CSF_MAP_ACCESS_HOURS_TL is referenced by following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_TL

[top of page]

Table: CSF_MD_ADM_BOUNDS

Description: Defines an administrative boundary defined in a country.
Primary Key: CSF_MD_ADM_BOUNDS_PK
  1. ADMIN_BOUND_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_ADM_BOUNDS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.ADMIN_BOUND_ID CSF_MD_ADM_BOUNDS
Comments

DEFINITION
A MD ADMIN BOUND defines an administrative boundary defined in a country.
EXAMPLE
MISCELLANEOUS
The enitity can be both linear and and polygon.

Indexes
Index Type Tablespace Column
SYS_IL0000083012C00012$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083012C00013$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ADMIN_BOUND_ID NUMBER (30) Y The ADMIN BOUND ID 's unique identifier.
ADMIN_LEVEL NUMBER
Y The ADMIN LEVEL defines the administrative level represented by this carthographic entity.
FEATURE_CODE NUMBER
Y The FEATURE CODE defines the type of administrative level.
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
AREA NUMBER

Defines the surface in square units.
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_ADM_BOUNDS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_ADM_BOUNDS is referenced by following:

APPS
SYNONYM - CSF_MD_ADM_BOUNDS
MATERIALIZED VIEW - CSF_MD_ADM_BOUNDS_MAT_V

[top of page]

Table: CSF_MD_HYDROS

Description: Defines a hydrographic feature.
Primary Key: CSF_MD_HYDROS_PK
  1. HYDROGRAPHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_HYDROS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.HYDROGRAPHY_ID CSF_MD_HYDROS
Comments

DEFINITION
A MD HYDROGRAPHY defines hydrographic cartographic feature.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083015C00012$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083015C00013$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
HYDROGRAPHY_ID NUMBER (30) Y The HYDROGRAPHY ID defines the unique identifier of the entity.
FEATURE_CODE NUMBER
Y The FEATURE CODE defines the type of hydrography.
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
WATER_TYPE NUMBER

Defines type of water feature stored
AREA NUMBER

Defines the surface in square units.
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_HYDROS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_HYDROS is referenced by following:

APPS
SYNONYM - CSF_MD_HYDROS
MATERIALIZED VIEW - CSF_MD_HYDROS_MAT_V

[top of page]

Table: CSF_MD_INST_STYLE_SHTS

Description: Defines map instance style sheets
Primary Key: CSF_MS_INST_STYLE_SHTS_PK
  1. INST_STYLE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_ADM_BOUNDS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_HYDROS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_RD_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LAND_USES.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LYR_METADATA.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_POIS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_RAIL_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Comments

DEFINITION
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
STYLE_TYPE VARCHAR2 (8) Y Style type
COLOR NUMBER
Y Color
DISPLAY_PRIORITY NUMBER
Y Priority which style sheet has to displayed first.
ISS_SIZE NUMBER
Y Size style
PATTERN NUMBER
Y pattern
XOR_MODE NUMBER
Y Map drawing mode.
XOR_COLOR NUMBER
Y Map drawing mode.
LINE_MULTIPASS_STYLE NUMBER
Y Map drawing line characteristic
LINE_CAP_STYLE NUMBER
Y Map drawing line characteristic
LINE_JOIN_STYLE NUMBER
Y Map drawing line characteristic
LINE_NODE_STYLE NUMBER
Y Map drawing line characteristic
AREA_ALPHA NUMBER
Y Defines the area alpha style
AREA_BORDER_STYLE NUMBER
Y Defines the map area border style
MARKER_TYPE NUMBER
Y Indicates the map marker type.
MARKER_TEXT_MBR NUMBER
Y Indicates the minimum bounding rectangle of the marker
TEXT_BACK_COLOR NUMBER
Y Map text characteristic
TEXT_FONT_HINT NUMBER
Y Map text characteristic
TEXT_BOLD NUMBER
Y Map text characteristic
TEXT_COLOR NUMBER
Y Map text characteristic
TEXT_HALO NUMBER
Y Map text characteristic
TEXT_ITALIC NUMBER
Y Map text characteristic
TEXT_SIZE NUMBER
Y Map text characteristic
TEXT_UNDERLINE NUMBER
Y Map text characteristic
TEXT_X_OFFSET NUMBER
Y Map text characteristic
TEXT_Y_OFFSET NUMBER
Y Map text characteristic
TEXT_ORIENTATION NUMBER
Y Map text characteristic
LABELING_ENABLED VARCHAR2 (1)
Indicate if labeling is enable in this style sheet.
LABEL_TEXT_SIZE NUMBER

Label drawing characteristic
LABEL_COLOR NUMBER

Label drawing characteristic
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
LINE_COLOR NUMBER
Y Line Color
FILL_COLOR NUMBER
Y Fill Color

[top of page]

CSF.CSF_MD_INST_STYLE_SHTS does not reference any database object

CSF.CSF_MD_INST_STYLE_SHTS is referenced by following:

APPS
SYNONYM - CSF_MD_INST_STYLE_SHTS

[top of page]

Table: CSF_MD_LAND_USES

Description: Defines the geometry of various land usages
Primary Key: CSF_MD_LAND_USES_PK
  1. LANDUSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_LAND_USES.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.LANDUSE_ID CSF_MD_LAND_USES
Comments

DEFINITION
A LAND USE defines the geometry of various land usages.
EXAMPLE
Some examples of land usages are: Parks, Forest, Industrial complex, Airport, Island, Military base, Reservations, etc.
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083021C00012$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083021C00013$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
LANDUSE_ID NUMBER (30) Y Generic unique identifier for an entity
FEATURE_CODE NUMBER
Y The FEATURE CODE defines the type of land usage.
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
PARK_TYPE NUMBER

Defines type of Park, sub-attribute for Feature Code 7170
AREA NUMBER

Specifies the surface in square units.
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_LAND_USES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_LAND_USES is referenced by following:

APPS
SYNONYM - CSF_MD_LAND_USES
MATERIALIZED VIEW - CSF_MD_LAND_USES_MAT_V

[top of page]

Table: CSF_MD_LYR_METADATA

Description: Defines map display layer metadata
Primary Key: CSF_MD_LYR_METADATA_PK
  1. LAYER_METADATA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID CSF_MD_LYR_STYLE_SHTS
CSF_MD_LYR_METADATA.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LYR_METADATA.THEME_METADATA_ID CSF_MD_THEME_METADATA
Comments
Columns
Name Datatype Length Mandatory Comments
LAYER_METADATA_ID NUMBER (30) Y
THEME_METADATA_ID NUMBER (30) Y
LAYER_NAME VARCHAR2 (32)
LAYER_DB_LINK VARCHAR2 (32)
LAYER_OWNER VARCHAR2 (32)
LAYER_TABLE VARCHAR2 (32)
LAYER_WHERE_CLAUSE VARCHAR2 (1024)
LAYER_VERSION VARCHAR2 (32)
CREATION_DATE DATE

COPYRIGHT_DATE DATE

LAST_EDIT_DATE DATE

CHAR_SET VARCHAR2 (32)
LAYER_STYLE_SHEET_ID NUMBER (30) Y
INST_STYLE_ID NUMBER (30) Y
LAYER_TABLE_2 VARCHAR2 (32)
LAYER_TABLE_3 VARCHAR2 (32)
LAYER_WHERE_CLAUSE_2 VARCHAR2 (1024)
GEOMETRY_COLUMN_NAME VARCHAR2 (240)
ID_COLUMN_NAME VARCHAR2 (240)
ITEM_NAME_COLUMN_NAME VARCHAR2 (240)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_MD_LYR_METADATA does not reference any database object

CSF.CSF_MD_LYR_METADATA is referenced by following:

APPS
SYNONYM - CSF_MD_LYR_METADATA

[top of page]

Table: CSF_MD_LYR_STYLE_SHTS

Description: Defines the visual display characteristics of a map layer
Primary Key: CSF_MD_LYR_STYLE_SHTS_PK
  1. LAYER_STYLE_SHEET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID CSF_MD_LYR_STYLE_SHTS
Comments

DEFINITION
A MD LAYER STYLE SHEET defines the visual display characteristics of a map layer.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083026C00012$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083026C00013$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
LAYER_STYLE_SHEET_ID NUMBER (30) Y Unique layer style sheet identifier
MIN_SCALE NUMBER
Y Minimum scale of give layer style sheet
MAX_SCALE NUMBER
Y Maximum scale of given layer style sheet
DEFAULT_SCALE NUMBER
Y Default scale for given layer style sheet
DISPLAY_PRIORITY NUMBER
Y Display priority for given layer style sheet
CENTER SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_LYR_STYLE_SHTS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_LYR_STYLE_SHTS is referenced by following:

APPS
SYNONYM - CSF_MD_LYR_STYLE_SHTS

[top of page]

Table: CSF_MD_NAMES

Description: Defines the name of the given geographic entities in the model.
Primary Key: CSF_MD_NAMES_PK
  1. NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.HYDROGRAPHY_ID CSF_MD_HYDROS
CSF_MD_NAMES.ADMIN_BOUND_ID CSF_MD_ADM_BOUNDS
CSF_MD_NAMES.LANDUSE_ID CSF_MD_LAND_USES
CSF_MD_NAMES.RAILROAD_SEGMENT_ID CSF_MD_RAIL_SEGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.NAME_ID CSF_MD_NAMES
CSF_MD_RDSEG_NM_ASGNS.NAME_ID CSF_MD_NAMES
Comments

DEFINITON
The MD NAME defines the name of the given geographic entities in the model.
EXAMPLE
Name of administrative boundaries, Points of interrest, Road/road-segments, etc.
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
NAME_ID NUMBER (30) Y The NAME ID defines the unique identifier of the name.
NAME VARCHAR2 (70) Y The full name of the entity.
NAME_TYPE VARCHAR2 (1) Y The NAME TYPE defines if the name is an official name, stale name, vanity name. etc.
LANGUAGE_CODE VARCHAR2 (3)
The LANGUAGE CODE defines the language in which the name is written.
ROUTE_TYPE NUMBER

The ROUTE TYPE defines the classification of route numbers by importance and regional function.
ROAD_JUNCTION_NAME VARCHAR2 (3)
The ROAD JUNCTION NAME defines if the name represents a motorway junction.
ROAD_EXIT_NUMBER VARCHAR2 (3)
The ROAD EXIT NUMBER defines if the name represents a road exit number.
RAILROAD_SEGMENT_ID NUMBER (30)
Generic unique identifier for an entity
LANDUSE_ID NUMBER (30)
Generic unique identifier for an entity
ADMIN_BOUND_ID NUMBER (30)
The ADMIN BOUND ID 's unique identifier.
HYDROGRAPHY_ID NUMBER (30)
The HYDROGRAPHY ID defines the unique identifier of the entity.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_NAMES does not reference any database object

CSF.CSF_MD_NAMES is referenced by following:

APPS
MATERIALIZED VIEW - CSF_MD_ADM_BOUNDS_MAT_V
MATERIALIZED VIEW - CSF_MD_HYDROS_MAT_V
MATERIALIZED VIEW - CSF_MD_LAND_USES_MAT_V
SYNONYM - CSF_MD_NAMES
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V
MATERIALIZED VIEW - CSF_MD_RAIL_SEGS_MAT_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_OM_ADMINS

Description:
Primary Key: CSF_MD_OM_ADMINS_PK
  1. ADMIN_BOUND_ID
Comments
Indexes
Index Type Tablespace Column
SYS_IL0000324518C00011$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000324518C00012$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ADMIN_BOUND_ID NUMBER (30) Y
FEATURE_CODE NUMBER
Y
AREA NUMBER

NAME VARCHAR2 (70)
GEOMETRY SDO_GEOMETRY (1)

[top of page]

CSF.CSF_MD_OM_ADMINS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_ADMINS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_ADMINS

[top of page]

Table: CSF_MD_OM_HYDROS

Description:
Primary Key: CSF_MD_OM_HYDROS_PK
  1. HYDROGRAPHY_ID
Comments
Indexes
Index Type Tablespace Column
SYS_IL0000324521C00011$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000324521C00012$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
HYDROGRAPHY_ID NUMBER
Y
FEATURE_CODE NUMBER
Y
AREA NUMBER

NAME VARCHAR2 (70)
GEOMETRY SDO_GEOMETRY (1)

[top of page]

CSF.CSF_MD_OM_HYDROS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_HYDROS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_HYDROS

[top of page]

Table: CSF_MD_OM_POIS

Description:
Primary Key: CSF_MD_OM_POIS_PK
  1. POI_ID
Comments
Indexes
Index Type Tablespace Column
SYS_IL0000324524C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000324524C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER
Y
FEATURE_CODE NUMBER
Y
NAME VARCHAR2 (70)
GEOMETRY SDO_GEOMETRY (1)

[top of page]

CSF.CSF_MD_OM_POIS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_POIS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_POIS

[top of page]

Table: CSF_MD_OM_ROADS

Description:
Primary Key: CSF_MD_OM_ROADS_PK
  1. ROAD_SEGMENT_ID
Comments
Indexes
Index Type Tablespace Column
SYS_IL0000324526C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000324526C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ROAD_SEGMENT_ID NUMBER
Y
FEATURE_CODE NUMBER
Y
NAME VARCHAR2 (70)
GEOMETRY SDO_GEOMETRY (1)

[top of page]

CSF.CSF_MD_OM_ROADS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_ROADS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_ROADS

[top of page]

Table: CSF_MD_POIS

Description: This table defines POI (point of interest) for Map Display
Primary Key: CSF_MD_POIS_PK
  1. POI_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_POIS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.POI_ID CSF_MD_POIS
Comments

DEFINITION
This table defines POI (point of interest) for Map Display
EXAMPLE
Holiday Inn, Shell petrol station, etc.
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083030C00016$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083030C00017$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
POI_ID NUMBER (30) Y A unique identifier for the POI.
FEATURE_CODE NUMBER
Y The FEATURE CODE defines the type the POI.
FOOD_TYPE VARCHAR2 (240)
The FOOD TYPE defines the type of food served in restaurants.
IMPORTANCE VARCHAR2 (3) Y The IMPORTANCE defines if the POI if of local or national importance.
POI_ADDRESS VARCHAR2 (240)
The POI ADDESS defines the streetname and house number of the POI.
TELEPHONE_NUMBER VARCHAR2 (240)
The POI telephone number
POPULATION NUMBER (25)
The POPULATION defines the estimated number of inhabitans of the city.
CHAIN_NAME VARCHAR2 (240)
The CHAIN NAME defines the name of the chain to which the POI belongs to.
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_POIS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_POIS is referenced by following:

APPS
SYNONYM - CSF_MD_POIS
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V

[top of page]

Table: CSF_MD_POI_NM_ASGNS

Description: Defines the relationship between the MD NAME and the MD NAMES and MD POI tables.
Primary Key: CSF_MD_POI_NM_ASGNS_PK
  1. POI_NM_ASGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.NAME_ID CSF_MD_NAMES
CSF_MD_POI_NM_ASGNS.POI_ID CSF_MD_POIS
Comments

DEFINITOIN
A MD POI NAMES ASGN defines the M:M relationship between the MD NAME and the MD POI NAMES ASGN entity.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
POI_NM_ASGN_ID NUMBER (30) Y The POI NM ASGN ID defines the unique identifier of the entity.
NAME_TYPE VARCHAR2 (1) Y The NAME TYPE defines type of the name given to the POI.
NAME_ID NUMBER (30) Y The NAME ID defines the unique identifier of the name.
POI_ID NUMBER (30) Y A unique identifier for the POI.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_POI_NM_ASGNS does not reference any database object

CSF.CSF_MD_POI_NM_ASGNS is referenced by following:

APPS
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V
SYNONYM - CSF_MD_POI_NM_ASGNS

[top of page]

Table: CSF_MD_RAIL_SEGS

Description: Defines an individual line segment representing a railroad.
Primary Key: CSF_MD_RAIL_SEGS_PK
  1. RAILROAD_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RAIL_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.RAILROAD_SEGMENT_ID CSF_MD_RAIL_SEGS
Comments

DEFINITION
A RAIL SEGMENT defines an individual line segment representing a railroad.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083036C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083036C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
RAILROAD_SEGMENT_ID NUMBER (30) Y Generic unique identifier for an entity
FEATURE_CODE NUMBER
Y Surrogate key used for primary unique identifiers
INST_STYLE_ID NUMBER (30)
Generic unique identifier for an entity
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_RAIL_SEGS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_RAIL_SEGS is referenced by following:

APPS
SYNONYM - CSF_MD_RAIL_SEGS
MATERIALIZED VIEW - CSF_MD_RAIL_SEGS_MAT_V

[top of page]

Table: CSF_MD_RDSEG_NM_ASGNS

Description: Defines the relation between the road segments and names table.
Primary Key: CSF_MD_RDSEG_NM_ASGNS_PK
  1. RD_SEG_NM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID CSF_MD_RD_SEGS
CSF_MD_RDSEG_NM_ASGNS.NAME_ID CSF_MD_NAMES
Comments

DEFINITION
A MD RDSEG NAME ASGN defines the M:M relationship between the MD NAME and MD ROAD SEGMENT entity.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
RD_SEG_NM_ID NUMBER (30) Y Generic unique identifier for an entity
NAME_TYPE VARCHAR2 (1) Y The NAME TYPE defines the type of the name given to the road segment.
ROAD_SEGMENT_ID NUMBER (30) Y The ROAD SEGMENT ID defines the unique identifier for a road segment.
NAME_ID NUMBER (30) Y The NAME ID defines the unique identifier of the name.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_RDSEG_NM_ASGNS does not reference any database object

CSF.CSF_MD_RDSEG_NM_ASGNS is referenced by following:

APPS
SYNONYM - CSF_MD_RDSEG_NM_ASGNS
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_RD_SEGS

Description: Defines a navigable feature.
Primary Key: CSF_MD_RD_SEGS_PK
  1. ROAD_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RD_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID CSF_MD_RD_SEGS
Comments

DEFINITION
A MD ROAD SEGMENT defines a navigable feature. Elements in the MD ROAD SEGMENT a part of the navigable road network.
EXAMPLE
Some examples of navigable features are: Roads, Ferries, Walkway
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083040C00028$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083040C00029$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
ROAD_SEGMENT_ID NUMBER (30) Y The ROAD SEGMENT ID defines the unique identifier for a road segment.
FUNCTIONAL_CLASS NUMBER
Y The FUNCTIONAL CLASS defines the level of importance of the road.
CONSTRUCTION_STATUS NUMBER

The CONSTRUCTION STATUS determines if a road segment is currently under contruction .
FORM_OF_WAY NUMBER

The FORM OF WAY determines the physical characteristics of the road segment.
SPEED_CATEGORY NUMBER

The SPEED CATEGORY defines the legal speed that applies to the road segment.
LANE_CATEGORY NUMBER

The LANE CATEGORY defines the number of lanes of the road segment.
ONEWAY_DIRECTION NUMBER
Y The ONEWAY DIRECTORY determines in which end the road can be enterred. The direction is specified using the start and end node.
TOLL_ROAD VARCHAR2 (3) Y The TOLL ROAD defines if toll fee needs to be paid for using the road.
PAVED VARCHAR2 (3)
The PAVED attribute defines if a road is paved or unpaved.
FEATURE_CODE NUMBER
Y The FEATURE CODE determines the type of road segment. Currently only one type is in use. In a later release this column will determine the aggregation state of a road segment.
FERRY_TYPE VARCHAR2 (240)
Date and time this occurrence ceases being active for user access
ACCESS_CAR VARCHAR2 (3) Y The ACCESS CAR determines if the road segment is accessible for cars.
ACCESS_CARPOOL VARCHAR2 (3) Y The ACCESS CARPOOL determines if the road segment is accessible for carpool vehicles.
ACCESS_DELIVERY VARCHAR2 (3) Y The ACCESS DELIVERY determines if the road segment is accessible for delivery vehicles.
ACCESS_TAXI VARCHAR2 (3) Y The ACCESS TAXI determines if the road segment is accessible for taxies.
ACCESS_PEDESTRIAN VARCHAR2 (3) Y The ACCESS PEDESTRIAN determines if the road segment is accessible for pedestrians.
ACCESS_BUS VARCHAR2 (3) Y The ACCESS BUS determines if the road segment is accessible for busses.
ACCESS_BICYCLE VARCHAR2 (3) Y The ACCESS BICYCLE determines if the road segment is accessible for bicycles.
ACCESS_EMERGENCY VARCHAR2 (3) Y The ACCESS EMERGENCY determines if the road segment is accessible for emergency vehicles.
ACCESS_TRUCK VARCHAR2 (3) Y The ACCESS TRUCK determines if the road segment is accessible for trucks.
INST_STYLE_ID NUMBER (30) Y Generic unique identifier for an entity
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_RD_SEGS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_RD_SEGS is referenced by following:

APPS
SYNONYM - CSF_MD_RD_SEGS
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_THEME_METADATA

Description: Defines the version information of an entire theme.
Primary Key: CSF_MD_THEME_METADATA_PK
  1. THEME_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.THEME_METADATA_ID CSF_MD_THEME_METADATA
Comments

DEFINITION
A MD THEME METADATA defines the version information of an entire theme.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
THEME_ID NUMBER (30) Y Unique identifier of theme metadata
THEME_NAME VARCHAR2 (32) Y The name of the theme
THEME_CODE NUMBER
Y Theme code
THEME_VERSION VARCHAR2 (32) Y The version string of a given theme
CREATION_DATE DATE

Theme creation date
COPYRIGHT_DATE DATE

Theme copyright date
LAST_EDIT_DATE DATE

Date the theme was last edited
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_MD_THEME_METADATA does not reference any database object

CSF.CSF_MD_THEME_METADATA is referenced by following:

APPS
SYNONYM - CSF_MD_THEME_METADATA

[top of page]

Table: CSF_PARAMS

Description: Parameters for Laptop and Palm
Primary Key: CSF_PARAMS_PK
  1. PARAM_ID
Comments
Columns
Name Datatype Length Mandatory Comments
PARAM_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
NAME VARCHAR2 (50) Y
VALUE VARCHAR2 (2000) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_PARAMS does not reference any database object

CSF.CSF_PARAMS is referenced by following:

APPS
SYNONYM - CSF_PARAMS

[top of page]

Table: CSF_PHONETIC_VALUES

Description:
Primary Key: CSF_PH_VAL_PK
  1. PHONETICS_ID
Comments

Each alphabet can have multiple grammar and any language alphabets with respective grammars can be added.

Columns
Name Datatype Length Mandatory Comments
PHONETICS_ID NUMBER (15) Y Phonetics identifier
LANGUAGE VARCHAR2 (30) Y Language of phonetic and alphabet
PHONETIC VARCHAR2 (30) Y Word that is spoken e.g Alpha, lower case Alpha
CODE VARCHAR2 (30) Y Alphabet that is understood when the phonetic is spoken e.g 'A', 'a'
DESCRIPTION VARCHAR2 (240)
Description e.g Upper case A of the English Alphabet
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
START_DATE_ACTIVE DATE

The date when the phonetic becomes active
END_DATE_ACTIVE DATE

The date when the phonetic becomes inactive
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_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column

[top of page]

CSF.CSF_PHONETIC_VALUES does not reference any database object

CSF.CSF_PHONETIC_VALUES is referenced by following:

APPS
SYNONYM - CSF_PHONETIC_VALUES

[top of page]

Table: CSF_PLAN_TERRS

Description: Associative (relationship) table to map between the territory and resource group tables
Primary Key: CSF_PLAN_TERRS_PK
  1. PLAN_TERR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_PLAN_TERRS.GROUP_ID JTF_RS_GROUPS_B
CSF_PLAN_TERRS.TERR_ID JTF_TERR_ALL
Comments

This table maps territories to resource groups, thus making the resource group a planner group for those territories. This information is used for UI reasons. It limits the available number of resources in the Control Tower.

Indexes
Index Type Tablespace Column
CSF_PLAN_TERRS_U1 UNIQUE APPS_TS_TX_IDX TERR_ID
GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_TERR_ID NUMBER
Y Unique identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Sequential number used for database locking control
TERR_ID NUMBER
Y Foreign key to JTF_TERR_ALL
GROUP_ID NUMBER
Y Foreign key to JTF_RS_GROUPS_B
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_PLAN_TERRS does not reference any database object

CSF.CSF_PLAN_TERRS is referenced by following:

APPS
SYNONYM - CSF_PLAN_TERRS

[top of page]

Table: CSF_RATING_SCALES_B

Description: Skill types
Primary Key: CSF_RATING_SCALE_B_PK
  1. RATING_SCALE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_SKILL_LEVELS_B.RATING_SCALE_ID CSF_RATING_SCALES_B
CSF_SKILL_TYPES_B.RATING_SCALE_ID CSF_RATING_SCALES_B
Comments

CSF_RATING_SCALES_B is used to store rating scales.

Indexes
Index Type Tablespace Column
CSF_RATING_SCALES_B_U1 UNIQUE APPS_TS_TX_IDX RATING_SCALE_ID
Columns
Name Datatype Length Mandatory Comments
RATING_SCALE_ID NUMBER (15) Y Primary key of the table
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
SEEDED_FLAG VARCHAR2 (1)
identifies whether this record is seeded
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
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 identifier
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

[top of page]

CSF.CSF_RATING_SCALES_B does not reference any database object

CSF.CSF_RATING_SCALES_B is referenced by following:

APPS
SYNONYM - CSF_RATING_SCALES_B

[top of page]

Table: CSF_RATING_SCALES_TL

Description: Skill types
Primary Key: CSF_RATING_SCALES_TL_PK
  1. RATING_SCALE_ID
  2. LANGUAGE
Comments

Translation Table for CSF_RATING_SCALES_B

Indexes
Index Type Tablespace Column
CSF_RATING_SCALES_TL_U1 UNIQUE APPS_TS_TX_IDX RATING_SCALE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RATING_SCALE_ID NUMBER
Y Primary key for table CSF_R_FILTER_PARAMS_B.
NAME VARCHAR2 (30) Y Name of the rating scale
DESCRIPTION VARCHAR2 (240)
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 identifier
SOURCE_LANG VARCHAR2 (4) Y Source lang
LANGUAGE VARCHAR2 (4) Y Languaga

[top of page]

CSF.CSF_RATING_SCALES_TL does not reference any database object

CSF.CSF_RATING_SCALES_TL is referenced by following:

APPS
SYNONYM - CSF_RATING_SCALES_TL

[top of page]

Table: CSF_REQUIRED_SKILLS_B

Description: This table is used to see which object has required skills
Primary Key: CSF_REQUIRED_SKILLS_B_PK
  1. REQUIRED_SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_REQUIRED_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B
Comments

This table is used to see which object has required skills

Indexes
Index Type Tablespace Column
CSF_REQUIRED_SKILLS_B_U1 UNIQUE APPS_TS_TX_IDX REQUIRED_SKILL_ID
CSF_REQUIRED_SKILLS_B_U2 UNIQUE APPS_TS_TX_IDX HAS_SKILL_ID
HAS_SKILL_TYPE
SKILL_ID
SKILL_TYPE_ID
CSF_REQUIRED_SKILLS_B_N1 NONUNIQUE APPS_TS_TX_IDX SKILL_ID
SKILL_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
REQUIRED_SKILL_ID NUMBER (15) Y Primary key of the table
SKILL_TYPE_ID NUMBER (15) Y Foreign key to the skill type
SKILL_ID NUMBER (15) Y Foreign key to skill
HAS_SKILL_TYPE VARCHAR2 (30) Y Skill owner object type identifier. Column HAS_SKILL_TYPE identifies the type of id that is stored in column HAS_SKILL_ID. For example, if column HAS_SKILL_TYPE has value 'TASK' then column HAS_SKILL_ID contains a TASK_ID. In that case, the skill represented by this row is a required skill for the given task.
HAS_SKILL_ID NUMBER (15) Y Column HAS_SKILL_ID stores the ID-value of the skill owner object. For instance, if the skill is required for a task, column HAS_SKILL_ID contains a TASK_ID.
SKILL_LEVEL_ID NUMBER (15) Y Foreign key to skill level
SKILL_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether the skll as such is mandatory for a task
LEVEL_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether the specific skill level is mandatory for a task
DISABLED_FLAG VARCHAR2 (1)
Flag indicating whether the assignment is disabled: soft removal
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Foreign key to the skill type id
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SECURITY_GROUP_ID NUMBER

Security group identifier
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

[top of page]

CSF.CSF_REQUIRED_SKILLS_B does not reference any database object

CSF.CSF_REQUIRED_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_REQUIRED_SKILLS_B

[top of page]

Table: CSF_RESOURCE_SKILLS_B

Description: Skill types
Primary Key: CSF_RESOURCE_SKILLS_B_PK
  1. RESOURCE_SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_RESOURCE_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B
Comments

Used to map skills to resources.

Indexes
Index Type Tablespace Column
CSF_RESOURCE_SKILLS_B_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_SKILL_ID
CSF_RESOURCE_SKILLS_B_U2 UNIQUE APPS_TS_TX_IDX SKILL_ID
SKILL_TYPE_ID
RESOURCE_ID
RESOURCE_TYPE
CSF_RESOURCE_SKILLS_B_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
RESOURCE_TYPE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_SKILL_ID NUMBER (15) Y Primary key
SKILL_TYPE_ID NUMBER (15) Y Foreign key to the skill type id
SKILL_ID NUMBER (15) Y Foreign key to the skill id
RESOURCE_TYPE VARCHAR2 (30) Y Foreign key to the resource type
RESOURCE_ID NUMBER (15) Y Foreign key to the resource id
SKILL_LEVEL_ID NUMBER (15) Y Foreign key to the skill level id
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
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 identifier
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

[top of page]

CSF.CSF_RESOURCE_SKILLS_B does not reference any database object

CSF.CSF_RESOURCE_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_RESOURCE_SKILLS_B

[top of page]

Table: CSF_R_FILTERS_ALL_B

Description: Data table with scheduler filter definitions
Primary Key: CSF_R_FILTERS_ALL_B_PK
  1. FILTER_ID
Comments
Columns
Name Datatype Length Mandatory Comments
FILTER_ID NUMBER
Y
FILTER_NAME VARCHAR2 (30) Y
FILTER_COST_VALUE_ID NUMBER

ACTIVE_FROM_DATE DATE
Y
ACTIVE_TO_DATE DATE

DISPLAY_SEQUENCE NUMBER
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER

ORG_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_FILTERS_ALL_B does not reference any database object

CSF.CSF_R_FILTERS_ALL_B is referenced by following:

APPS
SYNONYM - CSF_R_FILTERS_ALL_B

[top of page]

Table: CSF_R_FILTERS_ALL_TL

Description: Translated companion to table CSF_R_FILTER_DEFS_ALL_B.
Primary Key: CSF_R_FILTERS_ALL_TL_PK
  1. FILTER_ID
  2. LANGUAGE
Comments
Columns
Name Datatype Length Mandatory Comments
FILTER_ID NUMBER
Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
FILTER_DISPLAY_NAME VARCHAR2 (150)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_R_FILTERS_ALL_TL does not reference any database object

CSF.CSF_R_FILTERS_ALL_TL is referenced by following:

APPS
SYNONYM - CSF_R_FILTERS_ALL_TL

[top of page]

Table: CSF_R_FILTER_PARAMS_B

Description: Filter parameters.
Primary Key: CSF_R_FILTER_PARAMS_B_PK
  1. FILTER_PARAM_ID
Comments
Columns
Name Datatype Length Mandatory Comments
FILTER_PARAM_ID NUMBER
Y
PARAM_NAME VARCHAR2 (50) Y
PARAM_TYPE VARCHAR2 (50) Y
FILTER_ID NUMBER
Y
DEFAULT_VALUE VARCHAR2 (50)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y
LOOKUP_TYPE VARCHAR2 (30)

[top of page]

CSF.CSF_R_FILTER_PARAMS_B does not reference any database object

CSF.CSF_R_FILTER_PARAMS_B is referenced by following:

APPS
SYNONYM - CSF_R_FILTER_PARAMS_B

[top of page]

Table: CSF_R_FILTER_PARAMS_TL

Description: Translated companion to table CSF_R_FILTER_PARAMS_B.
Primary Key: CSF_R_FILTER_PARAMS_TL_PK
  1. FILTER_PARAM_ID
  2. LANGUAGE
Comments
Columns
Name Datatype Length Mandatory Comments
FILTER_PARAM_ID NUMBER
Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
PARAM_DISPLAY_NAME VARCHAR2 (150)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_R_FILTER_PARAMS_TL does not reference any database object

CSF.CSF_R_FILTER_PARAMS_TL is referenced by following:

APPS
SYNONYM - CSF_R_FILTER_PARAMS_TL

[top of page]

Table: CSF_R_HZ_LOC_EXTNS

Description: This table is for storing locations
Primary Key: CSF_R_HZ_LOC_EXTNS_PK
  1. LOCATION_ID
Comments
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER (15) Y

[top of page]

CSF.CSF_R_HZ_LOC_EXTNS does not reference any database object

CSF.CSF_R_HZ_LOC_EXTNS is referenced by following:

APPS
SYNONYM - CSF_R_HZ_LOC_EXTNS

[top of page]

Table: CSF_R_MESSAGES

Description: Messages
Primary Key: CSF_R_MESSAGES_PK
  1. MESSAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGES.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_MESSAGES_U1 UNIQUE APPS_TS_TX_IDX MESSAGE_ID
CSF_R_MESSAGES_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_TASK_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID NUMBER
Y rimary key for table CSF_R_MESSAGES.
REQUEST_TASK_ID NUMBER
Y Foreign key to table CSF_R_REQUEST_TASKS.
NAME VARCHAR2 (30) Y FND message name.
TYPE VARCHAR2 (30)
FND message type. (ERROR, WARNING). If NULL an error is assumed.
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.

[top of page]

CSF.CSF_R_MESSAGES does not reference any database object

CSF.CSF_R_MESSAGES is referenced by following:

APPS
SYNONYM - CSF_R_MESSAGES

[top of page]

Table: CSF_R_MESSAGE_TOKENS

Description: Message tokens
Primary Key: CSF_R_MESSAGE_TOKENS_PK
  1. MESSAGE_TOKEN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGE_TOKENS.MESSAGE_ID CSF_R_SCHED_REQUESTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_MESSAGE_TOKENS_U1 UNIQUE APPS_TS_TX_IDX MESSAGE_TOKEN_ID
CSF_R_MESSAGE_TOKENS_N1 NONUNIQUE APPS_TS_TX_IDX MESSAGE_ID
Columns
Name Datatype Length Mandatory Comments
MESSAGE_TOKEN_ID NUMBER
Y Primary key for table CSF_R_MESSAGE_TOKENS.
MESSAGE_ID NUMBER
Y Foreign key to table CSF_R_SCHED_REQUESTS.
NAME VARCHAR2 (60) Y The message token name.
VALUE VARCHAR2 (4000) Y The message token value.
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.

[top of page]

CSF.CSF_R_MESSAGE_TOKENS does not reference any database object

CSF.CSF_R_MESSAGE_TOKENS is referenced by following:

APPS
SYNONYM - CSF_R_MESSAGE_TOKENS

[top of page]

Table: CSF_R_PLAN_OPTIONS

Description: This table is for storing the planoptions
Primary Key: CSF_R_PLAN_OPTIONS_PK
  1. PLAN_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID CSF_R_PLAN_OPTIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_PLAN_OPTIONS_U1 UNIQUE APPS_TS_TX_IDX PLAN_OPTION_ID
CSF_R_PLAN_OPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_RESULT_ID
SPARES_OPTION_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_OPTION_ID NUMBER
Y Primary key for table CSF_R_PLAN_OPTIONS.
RESOURCE_RESULT_ID NUMBER
Y Foreign key to table CSF_R_RESOURCE_RESULTS.
SCHEDULED_START_DATE DATE

Scheduled task start date.
SPARES_OPTION_ID NUMBER

Foreign key relation to spares option pertaining to a request task.
COST NUMBER

Calculated cost for the plan option.
SHIFT_START_DATE DATE

Start date/time of the shift that the plan option belongs to. OBSOLETED
SHIFT_END_DATE DATE

End date/time of the shift that the plan option belongs to. OBSOLETED
WIN_TO_PROMIS_ID NUMBER

Window to promise ID
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y Object version number. Number is incremented by one after every update.
SCHEDULED_END_DATE DATE

Scheduled task start date.

[top of page]

CSF.CSF_R_PLAN_OPTIONS does not reference any database object

CSF.CSF_R_PLAN_OPTIONS is referenced by following:

APPS
SYNONYM - CSF_R_PLAN_OPTIONS

[top of page]

Table: CSF_R_PLAN_OPTION_TASKS

Description: This is a table to store the trips for which the planoptions apply
Primary Key: CSF_R_PLAN_OPTION_TASKS_PK
  1. PLAN_OPTION_TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID CSF_R_PLAN_OPTIONS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_PLAN_OPTION_TASKS_U1 UNIQUE APPS_TS_TX_IDX PLAN_OPTION_TASK_ID
CSF_R_PLAN_OPTION_TASKS_N1 NONUNIQUE APPS_TS_TX_IDX PLAN_OPTION_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_OPTION_TASK_ID NUMBER
Y Primary key for table CSF_R_PLAN_OPTION_TASKS.
PLAN_OPTION_ID NUMBER
Y Foreign key to table CSF_R_PLAN_OPTIONS.
TASK_ID NUMBER

Foreign key to the task affected by the requests schedule action.
SCHEDULED_START_DATE DATE

The calculated/adjusted scheduled start date.
SCHEDULED_END_DATE DATE

The calculated/adjusted scheduled end date.
TRAVEL_TIME NUMBER

The calculated/adjusted travel time to the task.
TASK_ASSIGNMENT_ID NUMBER

Foreign key to table JTF_TASK_ASSIGNMENTS. Added to make some queries in Forms easier. Without this, Forms has to query the task assignment id based on the task id and the resource id from the associated plan option.
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y Object version number. Number is incremented by one after every update.
OBJECT_CAPACITY_ID NUMBER
Y The object capacity identifier is a foreign key to the trip.

[top of page]

CSF.CSF_R_PLAN_OPTION_TASKS does not reference any database object

CSF.CSF_R_PLAN_OPTION_TASKS is referenced by following:

APPS
SYNONYM - CSF_R_PLAN_OPTION_TASKS

[top of page]

Table: CSF_R_REQUEST_FILTERS

Description: This table is for storing the filter settings for a request
Primary Key: CSF_R_REQUEST_FILTERS_PK
  1. REQUEST_FILTER_ID
Comments
Columns
Name Datatype Length Mandatory Comments
REQUEST_FILTER_ID NUMBER
Y
FILTER_ID NUMBER
Y
SCHED_REQUEST_ID NUMBER
Y
ENABLED_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_REQUEST_FILTERS does not reference any database object

CSF.CSF_R_REQUEST_FILTERS is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_FILTERS

[top of page]

Table: CSF_R_REQUEST_TASKS

Description: This table stores the task needs to be scheduled for a request
Primary Key: CSF_R_REQUEST_TASKS_PK
  1. REQUEST_TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID CSF_R_SCHED_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGES.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_REQUEST_TASKS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_TASK_ID
CSF_R_REQUEST_TASKS_N1 NONUNIQUE APPS_TS_TX_IDX SCHED_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_TASK_ID NUMBER
Y Primary key for table CSF_R_REQUEST_TASKS.
SCHED_REQUEST_ID NUMBER
Y Foreign key to table CSF_R_SCHED_REQUESTS.
TASK_ID NUMBER
Y The ID of the task to be processed. In a case a trip will be processed this column stores the ID of the first task in the trip.
RESULT_FLAG VARCHAR2 (1)
tores the result of the execution of the request.
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.

[top of page]

CSF.CSF_R_REQUEST_TASKS does not reference any database object

CSF.CSF_R_REQUEST_TASKS is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_TASKS

[top of page]

Table: CSF_R_REQUEST_VALUES

Description: This table is the table tostore the values of the filters
Primary Key: CSF_R_REQUEST_VALUES_PK
  1. REQUEST_VALUE_ID
Comments
Columns
Name Datatype Length Mandatory Comments
REQUEST_VALUE_ID NUMBER
Y
FILTER_PARAM_ID NUMBER
Y
SCHED_REQUEST_ID NUMBER

PARAM_VALUE VARCHAR2 (4000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_REQUEST_VALUES does not reference any database object

CSF.CSF_R_REQUEST_VALUES is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_VALUES

[top of page]

Table: CSF_R_RESOURCE_RESULTS

Description: Table containing the result of the 'resoure filters' (Prefferred, Territory, Geography, Skills)
Primary Key: CSF_R_RESOURCE_RESULTS_PK
  1. RESOURCE_RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_RESOURCE_RESULTS_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_RESULT_ID
CSF_R_RESOURCE_RESULTS_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_TASK_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_RESULT_ID NUMBER
Y Primary key of table CSF_R_RESOURCE_RESULTS.
REQUEST_TASK_ID NUMBER
Y Foreign key to table CSF_R_REQUEST_TASKS.
RESOURCE_ID NUMBER

The ID of the resource eligable for scheduling.
RESOURCE_TYPE VARCHAR2 (30)
The resource type of the resource eligable for scheduling.
GROUPING_ORDER NUMBER

Grouping order
GROUPING_OPERATION VARCHAR2 (30)
Grouping operation
DISTANCE NUMBER

Distance
ENABLED_FLAG VARCHAR2 (1)
Enabled flag
PREFERRED_RESOURCES_FLAG VARCHAR2 (1)
Is the resource preferred
TERRITORY_FLAG VARCHAR2 (1)
Territory flag
GEOGRAPHY_FLAG VARCHAR2 (1)
Geography flag
SKILL_FLAG VARCHAR2 (1)
Skill flag
SPARE_FLAG VARCHAR2 (1)
Spare flag
SECURITY_GROUP_ID NUMBER

Security group identifier.
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
TERRITORY_RANK NUMBER

The rank of the territory to which the resource is related.
TERRITORY_ID NUMBER

The territory ID to which the resource is related.
PLANWIN_START DATE

The start of the individual plan window. This window deviates from the task when the resource's skill is not available throughout the whole task plan window.
PLANWIN_END DATE

The end of the individual plan window. This window deviates from the task when the resource's skill is not available throughout the whole task plan window.

[top of page]

CSF.CSF_R_RESOURCE_RESULTS does not reference any database object

CSF.CSF_R_RESOURCE_RESULTS is referenced by following:

APPS
SYNONYM - CSF_R_RESOURCE_RESULTS

[top of page]

Table: CSF_R_SCENARIOS_ALL_B

Description: Scenario definitions.
Primary Key: CSF_R_SCENARIOS_ALL_B_PK
  1. SCENARIO_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SCENARIO_ID NUMBER
Y
SCENARIO_NAME VARCHAR2 (30) Y
ACTIVE_FROM_DATE DATE
Y
ACTIVE_TO_DATE DATE

SEEDED_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER

ORG_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_SCENARIOS_ALL_B does not reference any database object

CSF.CSF_R_SCENARIOS_ALL_B is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIOS_ALL_B

[top of page]

Table: CSF_R_SCENARIOS_ALL_TL

Description: Translated companion to table CSF_R_SCENAR_DEFS_ALL_TL.
Primary Key: CSF_R_SCENAR_DEFS_ALL_TL_PK
  1. SCENARIO_ID
  2. LANGUAGE
Comments
Columns
Name Datatype Length Mandatory Comments
SCENARIO_ID NUMBER
Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
SCENARIO_DISPLAY_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (300)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

[top of page]

CSF.CSF_R_SCENARIOS_ALL_TL does not reference any database object

CSF.CSF_R_SCENARIOS_ALL_TL is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIOS_ALL_TL

[top of page]

Table: CSF_R_SCENARIO_FILTERS

Description: Defines the associations between scenarios and filters.
Primary Key: CSF_R_SCENARIO_FILTERS_PK
  1. SCENARIO_FILTER_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SCENARIO_FILTER_ID NUMBER
Y
SCENARIO_ID NUMBER
Y
FILTER_ID NUMBER
Y
ENABLED_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_SCENARIO_FILTERS does not reference any database object

CSF.CSF_R_SCENARIO_FILTERS is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIO_FILTERS

[top of page]

Table: CSF_R_SCENARIO_VALUES

Description: Filter parameter values.
Primary Key: CSF_R_SCENARIO_VALUES_PK
  1. SCENARIO_VALUE_ID
Comments
Columns
Name Datatype Length Mandatory Comments
SCENARIO_VALUE_ID NUMBER
Y
SCENARIO_ID NUMBER
Y
FILTER_PARAM_ID NUMBER
Y
PARAM_VALUE VARCHAR2 (4000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

CSF.CSF_R_SCENARIO_VALUES does not reference any database object

CSF.CSF_R_SCENARIO_VALUES is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIO_VALUES

[top of page]

Table: CSF_R_SCHED_REQUESTS

Description: Scheduler requests.
Primary Key: CSF_R_SCHED_REQUEST_PK
  1. SCHED_REQUEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGE_TOKENS.MESSAGE_ID CSF_R_SCHED_REQUESTS
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID CSF_R_SCHED_REQUESTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_SCHED_REQUESTS_U1 UNIQUE APPS_TS_TX_IDX SCHED_REQUEST_ID
CSF_R_SCHED_REQUESTS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
SCHED_REQUEST_ID NUMBER
Y Primary key for table CSF_R_SCHEDULER_REQUESTS.
RESULT_FLAG VARCHAR2 (1)
Column RESULT_FLAG represents the result of the complete scheduler request. Possible values: NULL, no result yet. 'S', all tasks in the request were scheduled successfully, or, if not tasks are involved in this scheduling action, the acion was completed successfully. 'E' one or more errors were encountered. 'U' an unexpected error occurred, e.g. the concurrent program that executes the request has been cancelled from the concurrent request user interface.
CONCURRENT_REQUEST_ID NUMBER

Concurrent Program column. Foreign key to table FND_CONCURRENT_REQUESTS. If the request is executed in semi-interactive mode, a concurrent request will be queued to perform the request. This column stores the concurrent request id. It enables the caller of the semi-interactive request to find the output file of the concurrent request. The CONCURRENT_REQUEST_ID column is null for interactive scheduler requests.
PROGRAM_UPDATE_DATE DATE

Concurrent Program column. Date/time when concurrent request was queued.
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program column. Foreign key to table FND_APPLICATION. The product identifier for Field Service ('CSF') is 513.
PROGRAM_ID NUMBER

Concurrent Program column. Foreign key to table FND_CONCURRENT_PROGRAMS.
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 identifier
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
PLANMODE NUMBER
Y Numeric value to indicate the plan mode used for this request.
SPARES_LIKELIHOOD NUMBER

The level of availability of parts.
SCHED_REQUEST_NAME VARCHAR2 (300) Y The name of the request. This name points to the Scheduler class which delivers the service.
EXTENDED_EFFORT NUMBER

New effort for the parent task to be extended
PARENT_REQUEST_ID NUMBER

Parent request id if this is a child request.
TARGET_STATUS_ID NUMBER

The id of the status to which the task has to be set by the request.
ROUTE_BASED_FLAG VARCHAR2 (1)
Route Based Scheduling should be enabled or not
CHANGED_OPTION_START DATE

Scheduled Start date
CHANGED_OPTION_END DATE

Scheduled End Date
CHANGED_PLANNED_START DATE

Changed Planned Start Date
CHANGED_PLANNED_END DATE

Changed Planned End Date
DISABLED_ACCESS_HOURS_FLAG VARCHAR2 (1)
Access Hours flag disabled
CUSTOMER_CONF_RCVD VARCHAR2 (1)
Flag indicating that the scheduled task must be set to 'Customer confirmation received'.

[top of page]

CSF.CSF_R_SCHED_REQUESTS does not reference any database object

CSF.CSF_R_SCHED_REQUESTS is referenced by following:

APPS
SYNONYM - CSF_R_SCHED_REQUESTS

[top of page]

Table: CSF_R_SPARES_OPTIONS

Description: The table that contains the result(s) after the spares api is called
Primary Key: CSF_R_SPARES_OPTIONS_PK
  1. SPARES_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
CSF_R_SPARES_OPTIONS_U1 UNIQUE APPS_TS_TX_IDX SPARES_OPTION_ID
CSF_R_SPARES_OPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_RESULT_ID
Columns
Name Datatype Length Mandatory Comments
SPARES_OPTION_ID NUMBER
Y Primary key for table CSF_R_SPARES_OPTIONS.
RESOURCE_RESULT_ID NUMBER
Y Foreign key to table CSF_R_RESOURCE_RESULTS.
AVAILABILITY_DATE DATE

The date and time on which the spares are available to the engineer.
COST NUMBER

Cost amount associated with spares and used for the calculation of the cost of te plan option.
SECURITY_GROUP_ID NUMBER

Security group identifier
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.

[top of page]

CSF.CSF_R_SPARES_OPTIONS does not reference any database object

CSF.CSF_R_SPARES_OPTIONS is referenced by following:

APPS
SYNONYM - CSF_R_SPARES_OPTIONS

[top of page]

Table: CSF_R_TASK_ASSIGN_EXTNS

Description: Table to store the task assignment extensions
Primary Key: CSF_R_TASK_ASSIGN_PK
  1. TASK_ASSIGNMENT_ID
Comments
Columns
Name Datatype Length Mandatory Comments
TASK_ASSIGNMENT_ID NUMBER
Y
TASK_ID NUMBER

RESOURCE_ID NUMBER

RESOURCE_TYPE VARCHAR2 (30)
SHIFT_CONSTRUCT_ID NUMBER

SHIFT_START_DATE DATE

SHIFT_END_DATE DATE

TASK_TYPE_ID NUMBER

SECURITY_GROUP_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Y
SHIFT_ID NUMBER

SHIFT_INDICATOR NUMBER

[top of page]

CSF.CSF_R_TASK_ASSIGN_EXTNS does not reference any database object

CSF.CSF_R_TASK_ASSIGN_EXTNS is referenced by following:

APPS
SYNONYM - CSF_R_TASK_ASSIGN_EXTNS

[top of page]

Table: CSF_R_TDS_ROUTE_CACHE

Description: Table to store cache routes
Comments
Columns
Name Datatype Length Mandatory Comments
ROUTE_CACHE_ID NUMBER (15)
LOCATION_FROM_ID NUMBER (15)
LOCATION_TO_ID NUMBER (15)
FROM_IDENT VARCHAR2 (20)
TO_IDENT VARCHAR2 (20)
DURATION NUMBER

DISTANCE NUMBER

DATETIME DATE

[top of page]

CSF.CSF_R_TDS_ROUTE_CACHE does not reference any database object

CSF.CSF_R_TDS_ROUTE_CACHE is referenced by following:

APPS
SYNONYM - CSF_R_TDS_ROUTE_CACHE

[top of page]

Table: CSF_SDM_CTRY_PROFILES

Description: Defines country profiles
Primary Key: CSF_SDM_CTRY_PROFILES_PK
  1. COUNTRY_PROFILE_ID
Comments

DEFINITION

EXAMPLE

MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083090C00025$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000083090C00026$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
COUNTRY_PROFILE_ID NUMBER (30) Y Unique identifier for given country profile
COUNTRY_NAME VARCHAR2 (60)
The name of the country
COUNTRY_ID NUMBER (30)
ISO numeric country code
COUNTRY_CODE_A3 VARCHAR2 (3)
3 letter country code
NATIONAL_LANG_CODE VARCHAR2 (3)
ISO language code
NATIONAL_LANG_CODE2 VARCHAR2 (3)
ISO language code
DRIVING_SIDE VARCHAR2 (1)
Driving side
HOUSE_NUMBER_POS VARCHAR2 (1)
House number position
NUMBER_ADMIN_LEVELS NUMBER

Number of administrative levels
ORDER_1_AREA_SIGNIFICANT VARCHAR2 (3)
Order 1 area significance
ORDER_2_AREA_SIGNIFICANT VARCHAR2 (3)
Order 2 area significance
ORDER_3_AREA_SIGNIFICANT VARCHAR2 (3)
Order 3 area significance
ORDER_4_AREA_SIGNIFICANT VARCHAR2 (3)
Order 4 area significance
ORDER_8_AREA_SIGNIFICANT VARCHAR2 (3)
Order 8 area significance
ORDER_9_AREA_SIGNIFICANT VARCHAR2 (3)
Order 9 area significance
MIN_MUNICIPAL_LEVEL NUMBER

Country's minimum municipality level
PLACE_ID NUMBER (30)
Place id
DEFAULT_DISPLAY_WIDTH NUMBER

Default display width
DEFAULT_DISPLAY_CENTER SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_SDM_CTRY_PROFILES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_SDM_CTRY_PROFILES is referenced by following:

APPS
SYNONYM - CSF_SDM_CTRY_PROFILES

[top of page]

Table: CSF_SKILLS_B

Description: Skill types
Primary Key: CSF_SKILLS_B_PK
  1. SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_RESOURCE_SKILLS_B.SKILL_ID CSF_SKILLS_B
Comments

CSF_SKILL_B is used to store skills.

Indexes
Index Type Tablespace Column
CSF_SKILLS_B_U1 UNIQUE APPS_TS_TX_IDX SKILL_ID
CSF_SKILLS_B_N1 NONUNIQUE APPS_TS_TX_IDX SKILL_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
SKILL_ID NUMBER (15) Y Primary key for table
SKILL_TYPE_ID NUMBER (15) Y Foreign key to the skill type id
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
SKILL_ALIAS VARCHAR2 (30)
Alternative to the NAME defined in table CSF_SKILL_TL.
SEEDED_FLAG VARCHAR2 (1)
identifies whether this record is seeded
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
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 identifier
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

[top of page]

CSF.CSF_SKILLS_B does not reference any database object

CSF.CSF_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_SKILLS_B

[top of page]

Table: CSF_SKILLS_TL

Description: Skill types
Primary Key: CSF_SKILLS_TL_PK
  1. SKILL_ID
  2. LANGUAGE
Comments

Translation Table for CSF_SKILLS_B

Indexes
Index Type Tablespace Column
CSF_SKILLS_TL_U1 UNIQUE APPS_TS_TX_IDX SKILL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SKILL_ID NUMBER
Y Primary key for table
NAME VARCHAR2 (30) Y Name of the skill
DESCRIPTION VARCHAR2 (240)
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 identifier
SOURCE_LANG VARCHAR2 (4) Y Source lang
LANGUAGE VARCHAR2 (4) Y Language

[top of page]

CSF.CSF_SKILLS_TL does not reference any database object

CSF.CSF_SKILLS_TL is referenced by following:

APPS
SYNONYM - CSF_SKILLS_TL

[top of page]

Table: CSF_SKILL_LEVELS_B

Description: Skill types
Primary Key: CSF_SKILL_LEVELS_B_PK
  1. SKILL_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILL_LEVELS_B.RATING_SCALE_ID CSF_RATING_SCALES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B
Comments

CSF_SKILL_LEVELS_B is used to store skill levels.

Indexes
Index Type Tablespace Column
CSF_SKILL_LEVELS_B_U1 UNIQUE APPS_TS_TX_IDX SKILL_LEVEL_ID
CSF_SKILL_LEVELS_B_N1 NONUNIQUE APPS_TS_TX_IDX RATING_SCALE_ID
Columns
Name Datatype Length Mandatory Comments
SKILL_LEVEL_ID NUMBER (15) Y Primary key
RATING_SCALE_ID NUMBER (15) Y Foreign key to the reating scale id
STEP_VALUE NUMBER (15) Y quantification of the skill level, which provides an ordering of skill levels.
CORRECTION_FACTOR NUMBER

Correction factor associated with the skill level. In the skills module this is used to correct the planned effort of a task to give a better estimation based on the skill level of the resource (default value is 1)
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
SEEDED_FLAG VARCHAR2 (1)
identifies whether this record is seeded
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
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 identifier
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

[top of page]

CSF.CSF_SKILL_LEVELS_B does not reference any database object

CSF.CSF_SKILL_LEVELS_B is referenced by following:

APPS
SYNONYM - CSF_SKILL_LEVELS_B

[top of page]

Table: CSF_SKILL_LEVELS_TL

Description: Skill types
Primary Key: CSF_SKILL_LEVELS_TL_PK
  1. SKILL_LEVEL_ID
Comments

Translation Table for CSF_SKILL_LEVELS_B

Indexes
Index Type Tablespace Column
CSF_SKILL_LEVELS_TL_U1 UNIQUE APPS_TS_TX_IDX SKILL_LEVEL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SKILL_LEVEL_ID NUMBER
Y Primary key for table
NAME VARCHAR2 (30) Y Name of the skill level
DESCRIPTION VARCHAR2 (240)
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 identifier
SOURCE_LANG VARCHAR2 (4) Y Source lang
LANGUAGE VARCHAR2 (4) Y Language

[top of page]

CSF.CSF_SKILL_LEVELS_TL does not reference any database object

CSF.CSF_SKILL_LEVELS_TL is referenced by following:

APPS
SYNONYM - CSF_SKILL_LEVELS_TL

[top of page]

Table: CSF_SKILL_TYPES_B

Description: Skill types
Primary Key: CSF_SKILL_TYPES_B_PK
  1. SKILL_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILL_TYPES_B.RATING_SCALE_ID CSF_RATING_SCALES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
Comments

CSF_SKILL_TYPES_B is used to store skill types.

Indexes
Index Type Tablespace Column
CSF_SKILL_TYPES_B_U1 UNIQUE APPS_TS_TX_IDX SKILL_TYPE_ID
CSF_SKILL_TYPES_B_N1 NONUNIQUE APPS_TS_TX_IDX RATING_SCALE_ID
Columns
Name Datatype Length Mandatory Comments
SKILL_TYPE_ID NUMBER
Y Primary key for table
KEY_COLUMN VARCHAR2 (200)
Select statement element representing a primary key column. E.g. inventory_item_id in case of a product skill object
DATA_COLUMN VARCHAR2 (2000)
Select statement element representing a column list
NAME_NUMBER_COLUMN VARCHAR2 (200)
Select statement element representing a column which contains the string or numeric value by which the object is usually known, e.g. product name. This information is used for display purposes
FROM_CLAUSE VARCHAR2 (2000)
Select statement representing the list of views or tables
WHERE_CLAUSE VARCHAR2 (2000)
Select statement representing the where clause
ORDER_BY_CLAUSE VARCHAR2 (200)
Select statement representing the order by clause
START_DATE_ACTIVE DATE
Y Start Active date
END_DATE_ACTIVE DATE

End Date active
RATING_SCALE_ID NUMBER (15) Y Foreign key to the rating scale id
SEEDED_FLAG VARCHAR2 (1)
identifies whether this record is seeded
OBJECT_VERSION_NUMBER NUMBER
Y The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned.
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 identifier
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

[top of page]

CSF.CSF_SKILL_TYPES_B does not reference any database object

CSF.CSF_SKILL_TYPES_B is referenced by following:

APPS
SYNONYM - CSF_SKILL_TYPES_B

[top of page]

Table: CSF_SKILL_TYPES_TL

Description: Skill types
Primary Key: CSF_SKILL_TYPES_TL_PK
  1. SKILL_TYPE_ID
Comments

Translation Table for CSF_SKILL_TYPES_B

Indexes
Index Type Tablespace Column
CSF_SKILL_TYPES_TL_U1 UNIQUE APPS_TS_TX_IDX SKILL_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SKILL_TYPE_ID NUMBER
Y Primary key for table
NAME VARCHAR2 (30) Y name of the table
DESCRIPTION VARCHAR2 (240)
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 identifier
SOURCE_LANG VARCHAR2 (4) Y Source lang
LANGUAGE VARCHAR2 (4) Y Language

[top of page]

CSF.CSF_SKILL_TYPES_TL does not reference any database object

CSF.CSF_SKILL_TYPES_TL is referenced by following:

APPS
SYNONYM - CSF_SKILL_TYPES_TL

[top of page]

Table: CSF_TDS_BINARY_MAPS

Description: Defines the digital roadmap for route calculation.
Primary Key: CSF_TDS_BINARY_MAPS_PK
  1. BINARY_MAP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_BINARY_TILES.BINARY_MAP_ID CSF_TDS_BINARY_MAPS
Comments

DEFINITION
A TDS BINARY MAP defines the digital roadmap (stored in blobs) upon which route calculations will be performed.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083081C00005$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083081C00006$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083081C00007$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083081C00008$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
BINARY_MAP_ID NUMBER (30) Y Unique identifier for a binary map.
DRIVING_SIDE VARCHAR2 (1)
Determines the driving side for the given map.
VERSION VARCHAR2 (10)
The version string for the given map.
NAME VARCHAR2 (120)
A name string describing the given map.
CONFIG CLOB (4000)
Contains TDS configuration data
ROADBLOCKS BLOB (4000)
BLOB holding binary roadblock data.
CONDITIONS BLOB (4000)
BLOB holding binary driving condition data.
TIMEINTERVALS BLOB (4000)
BLOB holding condition time interval data.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
MAX_AVG_SPEED NUMBER

The calculate average of the given segment maximum speed

[top of page]

CSF.CSF_TDS_BINARY_MAPS does not reference any database object

CSF.CSF_TDS_BINARY_MAPS is referenced by following:

APPS
SYNONYM - CSF_TDS_BINARY_MAPS

[top of page]

Table: CSF_TDS_BINARY_TILES

Description: Defines a spatial index to a digital map.
Primary Key: CSF_TDS_BINARY_TILES_PK
  1. BINARY_TILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_BINARY_TILES.BINARY_MAP_ID CSF_TDS_BINARY_MAPS
Comments

DEFINITION
A BINARY TILE defines an spatial index to a digital map.
EXAMPLE
MISCELLANEOUS

Indexes
Index Type Tablespace Column
SYS_IL0000083075C00003$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083075C00004$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
BINARY_TILE_ID NUMBER (30) Y Unique identifier for a binary tile.
BINARY_MAP_ID NUMBER (30) Y Unique identifier to the map this tile belongs to.
SEGMENTS BLOB (4000)
BLOB holding road network segment data.
NODES BLOB (4000)
BLOB holding road network node data.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_BINARY_TILES does not reference any database object

CSF.CSF_TDS_BINARY_TILES is referenced by following:

APPS
SYNONYM - CSF_TDS_BINARY_TILES

[top of page]

Table: CSF_TDS_CONDITIONS

Description: This table stores the conditions for the TDS.
Primary Key: CSF_TDS_CONDITIONS_PK
  1. CONDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_CONDITIONS.INTERVAL_ID CSF_TDS_INTERVALS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.CONDITION_ID CSF_TDS_CONDITIONS
Comments

DEFINITION
A Condition defines a specific restriction that applies to a road segment or to a combination of road segments. It can include Vehicles type for which the condition applies and time contraints for a condition.
EXAMPLE
Turn Restriction, access limited by a Gate, temporary change in Oneway information, Construction on a road during certain period of time.
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
CONDITION_ID NUMBER (30) Y Unique identifier for Condition Table
ACCESS_BUS VARCHAR2 (3) Y does condition apply to public buses?
ACCESS_BICYCLE VARCHAR2 (3) Y does condition apply to bicycles?
ACCESS_CARS VARCHAR2 (3) Y does condition apply to passenger cars?
ACCESS_TAXI VARCHAR2 (3) Y does condition apply to taxis?
ACCESS_CARPOOL VARCHAR2 (3) Y does condition apply to carpool cars?
ACCESS_DELIVERY VARCHAR2 (3) Y does condition apply to delivery trucks?
ACCESS_TRUCK VARCHAR2 (3) Y does condition apply to trucks?
ACCESS_EMERGENCY VARCHAR2 (3) Y does condition apply to emergency vehicles?
ACCESS_PEDESTRIAN VARCHAR2 (3) Y does condition apply to pedestrians?
ACCESS_THROUGH_TRAFFIC VARCHAR2 (3) Y can segment be used for through traffic?
BIN_INDEX NUMBER

used to generate segment index for binary TDS file
CONDITION_TYPE NUMBER (1) Y Defines the type of Conditions
NR_SEGMENT_INVOLVED NUMBER (2) Y specifies how many roadsegment are involved in the condition
CONSTRUCTION_STATUS NUMBER (1)
specifies the type of construction (open or closed)
DIRECTION_OF_TRAFFIC NUMBER (1)
specifies the oneway information for a segment
INTERVAL_ID NUMBER (30)
Unique identifier for the Interval entity
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_CONDITIONS does not reference any database object

CSF.CSF_TDS_CONDITIONS is referenced by following:

APPS
SYNONYM - CSF_TDS_CONDITIONS

[top of page]

Table: CSF_TDS_COND_SEGS

Description: Intersection table for condition and segments
Primary Key: CSF_TDS_COND_SEGS_PK
  1. CONDITION_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.CONDITION_ID CSF_TDS_CONDITIONS
CSF_TDS_COND_SEGS.SEGMENT_ID CSF_TDS_SEGMENTS
Comments

DEFINITION
Intersection table required since one segment can be part of multiple conditions and one condition can be composed of multiple segments.
EXAMPLE
MISCELLANEOUS
The sequence number in the Condition Segment table defines where in the condition the segment occurs.

Columns
Name Datatype Length Mandatory Comments
CONDITION_SEGMENT_ID NUMBER (30) Y Unique identifier for the Condition Segment Table
SEQUENCE_NUMBER NUMBER (4) Y Defines sequence of Segment in Condition
CONDITION_ID NUMBER (30) Y Unique identifier for Condition Table
SEGMENT_ID NUMBER (30) Y Unique identifier for Segment Table
JUNC_NODE_FLAG VARCHAR2 (3)
Indicates that condition segment is part of a junction.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_COND_SEGS does not reference any database object

CSF.CSF_TDS_COND_SEGS is referenced by following:

APPS
SYNONYM - CSF_TDS_COND_SEGS

[top of page]

Table: CSF_TDS_INTERVALS

Description: The intervals table
Primary Key: CSF_TDS_INTERVALS_PK
  1. INTERVAL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_CONDITIONS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_SEGMENTS.INTERVAL_ID CSF_TDS_INTERVALS
Comments

DEFINITION
The INTERVAL table define the Time period during which a certain Condition, Roadblock or Daylight Saving Period is valid.
EXAMPLE
MISCELLANEOUS
The Time period is defined as composite time-units (year, month, week, day, hour, minute).
The Time period includes a start time and a period of duration.

Columns
Name Datatype Length Mandatory Comments
INTERVAL_ID NUMBER (30) Y Unique identifier for the Interval entity
S_INTERVAL_TYPE NUMBER
Y Defines the start period of the Time Interval as a certain Interval Type.
S_YEAR NUMBER

Defines the Start time of the Interval as a precise Year.
S_MONTH_OF_YEAR NUMBER

Defines the End time of the Interval as a Month of the Year.
S_DAY_OF_YEAR NUMBER

Defines specific day in year at which time interval starts.
S_DAY_OF_MONTH NUMBER

Defines the Start time of the Interval as a fixed day of the Month.
S_DAY_OF_WEEK NUMBER

Defines the Start time of the Interval as a fixed day in the Week.
S_HOUR_OF_DAY NUMBER

Specifies the exact hour within the day at which the time interval starts.
S_MINUTE_OF_HOUR NUMBER

Specifies the exact minute within the hour at which the time interval starts.
E_INTERVAL_TYPE NUMBER
Y Defines the ending period of the Time Interval as a certain Interval Type.
E_YEAR NUMBER

Defines the End time of the Interval as a precise Year.
E_MONTH_OF_YEAR NUMBER

Defines the End time of the Interval as a Month of the Year.
E_WEEK_OF_YEAR NUMBER

Defines the End time of the Interval as a Week of the Year.
E_DAY_OF_MONTH NUMBER

Defines the End time of the Interval as a fixed day of the Month.
E_DAY_OF_WEEK NUMBER

Defines the End time of the Interval as a fixed day in the Week.
E_HOUR_OF_DAY NUMBER

Specifies the exact hour within the day at which the time interval ends.
E_MINUTE_OF_HOUR NUMBER

Specifies the exact minute within the hour at which the time interval starts.
BIN_INDEX NUMBER

used to generate the segment index in the Binary TDS file
E_WEEK_OF_MONTH NUMBER

Defines week within month at which interval ends
S_WEEK_OF_YEAR NUMBER

Defines the Start time of the Interval as a Week of the Year.
E_DAY_OF_YEAR NUMBER

Defines specific day in year at which time interval ends.
S_WEEK_OF_MONTH NUMBER

Defines week within month at which interval starts
GDF_TIME_DOMAIN_STRING VARCHAR2 (500)
Holds the GDF time domain string defining a condition interval.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_INTERVALS does not reference any database object

CSF.CSF_TDS_INTERVALS is referenced by following:

APPS
SYNONYM - CSF_TDS_INTERVALS

[top of page]

Table: CSF_TDS_NODES

Description: The nodes table
Primary Key: TDS_NODES_PK
  1. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_NODES.TILE_ID CSF_TDS_TILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGM_NODES.NODE_ID CSF_TDS_NODES
Comments

DEFINITION
A TDS NODE defined a junctions in a road network.
EXAMPLE
MISCELLANEOUS
A node is alway a start-/end point of a segment.

Indexes
Index Type Tablespace Column
SYS_IL0000083055C00010$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083055C00011$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
NODE_ID NUMBER (30) Y The TDS NODE ID defines the unique identifier of the entity.
BIN_INDEX NUMBER (10)
value used to generate segment index in binary TDS file
TILE_ID NUMBER (30)
The TILE ID defines the unique identifier of the entity.
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_NODES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_NODES is referenced by following:

APPS
SYNONYM - CSF_TDS_NODES

[top of page]

Table: CSF_TDS_RDBLCK_INTVLS

Description: Intersection table for Roadblocks and intervals
Primary Key: CSF_TDS_RDBLCK_INTVLS_PK
  1. ROADBLOCK_INTERVAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
Comments

DEFINITION
Intersection table required since one Roadblock can have multiple time restrictions and one interval (time restriction) can be shared by multiple roadblocks.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
ROADBLOCK_INTERVAL_ID NUMBER (30) Y unique identifier for Roadblock Interval entity
ROADBLOCK_ID NUMBER (30) Y Generic unique identifier for an entity
INTERVAL_ID NUMBER (30) Y Unique identifier for the Interval entity
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_RDBLCK_INTVLS does not reference any database object

CSF.CSF_TDS_RDBLCK_INTVLS is referenced by following:

APPS
SYNONYM - CSF_TDS_RDBLCK_INTVLS

[top of page]

Table: CSF_TDS_RDBLCK_SGMNTS

Description: The relation between RoadBlocks and Segments
Primary Key: CSF_TDS_RDBLCK_SGMNTS_PK
  1. ROADBLOCK_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID CSF_TDS_SEGMENTS
Comments

DEFINITION
The TDS RDBLCK SGMNT defines the M:M relationship between the TDS SEGMENT and TDS ROADBLOCK entity.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
ROADBLOCK_SEGMENT_ID NUMBER (30) Y Generic unique identifier for an entity
ROADBLOCK_ID NUMBER (30) Y Generic unique identifier for an entity
SEGMENT_ID NUMBER (30) Y The SEGMENT ID defines the unique identifier for the entity.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_RDBLCK_SGMNTS does not reference any database object

CSF.CSF_TDS_RDBLCK_SGMNTS is referenced by following:

APPS
SYNONYM - CSF_TDS_RDBLCK_SGMNTS

[top of page]

Table: CSF_TDS_ROADBLOCKS

Description: Defines a travel duration delay for a segment.
Primary Key: CSF_TDS_ROADBLOCKS_PK
  1. ROADBLOCK_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
Comments

DEFINITION
A TDS ROADBLOCK defines a travel duration delay for a segment.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
ROADBLOCK_ID NUMBER (30) Y Generic unique identifier for an entity
TRB_DELAY NUMBER
Y The DELAY defined the delay factor (as percentage) caused by the roadblock
BIN_INDEX NUMBER

Value used to generate segment index in binary TDS file
CREATED_BY NUMBER (15)
User id of roadblock creator
CREATION_DATE DATE

Date roadblock created on.
LAST_UPDATED_BY NUMBER (15)
User id of last updator
LAST_UPDATE_DATE DATE

Data last updated
LAST_UPDATE_LOGIN NUMBER (15)
Last update login
SECURITY_GROUP_ID VARCHAR2 (240)
Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_ROADBLOCKS does not reference any database object

CSF.CSF_TDS_ROADBLOCKS is referenced by following:

APPS
SYNONYM - CSF_TDS_ROADBLOCKS

[top of page]

Table: CSF_TDS_ROUTE_CACHE

Description:
Comments
Indexes
Index Type Tablespace Column
SYS_IL0000148613C00018$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000148613C00019$$ UNIQUE APPS_TS_TX_DATA
SYS_IL0000148613C00020$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
SEGMENT_FROM NUMBER

SIDE_FROM NUMBER

SPOT_FROM NUMBER

SEGMENT_TO NUMBER

SIDE_TO NUMBER

SPOT_TO NUMBER

RESULTTIME NUMBER

RESULTDISTANCE NUMBER

DATETIME DATE

HITCOUNT NUMBER

ROUTE_CACHE_ID NUMBER (30)
GEOMETRY SDO_GEOMETRY (1)
ROUTE CLOB (4000)
SECURITY_GROUP_ID NUMBER

FROM_SEGMENT_ID NUMBER (15)
TO_SEGMENT_ID NUMBER (15)
CONFIG VARCHAR2 (100)
TIME NUMBER (15)
DISTANCE NUMBER (15)
COST NUMBER (15)
RAMHITCOUNT NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

FROM_SEGMENT_SIDE VARCHAR2 (1)
TO_SEGMENT_SIDE VARCHAR2 (1)
FROM_SEGMENT_POSITION VARCHAR2 (3)
TO_SEGMENT_POSITION VARCHAR2 (3)

[top of page]

CSF.CSF_TDS_ROUTE_CACHE references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_ROUTE_CACHE is referenced by following:

APPS
SYNONYM - CSF_TDS_ROUTE_CACHE

[top of page]

Table: CSF_TDS_SEGMENTS

Description: Defines a connection between two nodes.
Primary Key: CSF_TDS_SEGMENTS_PK
  1. SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGMENTS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_SEGMENTS.TILE_ID CSF_TDS_TILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.SEGMENT_ID CSF_TDS_SEGMENTS
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID CSF_TDS_SEGMENTS
CSF_TDS_SEGM_NODES.SEGMENT_ID CSF_TDS_SEGMENTS
Comments

DEFINITION
A TDS SEGMENT defines a connection between two nodes.
EXAMPLE
MISCELLANEOUS
A segment is the smallest entity representing a road. A road is made up of several segments.

Columns
Name Datatype Length Mandatory Comments
SEGMENT_ID NUMBER (30) Y Generic unique identifier for an entity
FUNCTIONAL_CLASS NUMBER (1) Y The FUNCTIONAL CLASS defines the importance level of the road for routing.
LENGTH NUMBER
Y The LENGTH defines the length of the segment in meters.
LANE_CATEGORY NUMBER (1)
The LANE CATEGORY defines the number of lanes available in the segment.
ONEWAY_DIRECTION NUMBER (1) Y The ONEWAY DIRECTION defines the allowed direction of the traffic flow.
ROAD_CONDITION NUMBER (1)
The ROAD CONDITION defines if a road is paved or not.
SPECIAL_RESTRICTIONS NUMBER (1)
The SPECIAL RESTRICTIONS defines if a segment is publicly accessible.
TIME_ZONE NUMBER

The TIME ZONE defines the GMT offset of the segment.
BRUNNEL_TYPE NUMBER (1)
The BRUNNEL TYPE defines if the segment is either a bridge of a tunnel.
AVERAGE_SPEED NUMBER (3)
The AVERAGE SPEED defines the legal speed limit for a roadsegment in kilometers per hours.
BIN_INDEX NUMBER

Used to generate an index for Segments in the Binary file
TOLL_ROAD NUMBER (1) Y The TOLL ROAD defines if the segment is or is part of a toll road.
FERRY_TYPE NUMBER (1)
The FERRY TYPE defines the type of transport of the ferry.
DIVIDED_ROAD_ELEMENT NUMBER (1) Y The DIVIDED ROAD ELEMENT defines if the segment is divided in terms of accessiblity.
DIVIDER_TYPE NUMBER (1)
The DIVIDER TYPE determines if the segment/road divider is either a legal or hysical barrier.
ACCESS_CARS VARCHAR2 (3)
Specifies if a road is accessible by regular passenger cars.
ACCESS_BUS VARCHAR2 (3)
Specifies if a roadsegment is accessible by Public Buses.
ACCESS_TAXI VARCHAR2 (3)
Specifies if a roadsegment is accessible by Taxis.
ACCESS_DELIVERY VARCHAR2 (3)
Specifies if a roadsegment is accessible by (small) Delivery Trucks.
ACCESS_TRUCK VARCHAR2 (3)
Specifies if a roadsegment is accessible by larger Trucks.
ACCESS_EMERGENCY VARCHAR2 (3)
Specifies is a roadsegment is accessible by Emergency Vehicles.
ACCESS_PEDESTRIAN VARCHAR2 (3)
Specifies if the roadsegment is accessible by Pedestrians.
ACCESS_BICYCLE VARCHAR2 (3)
Specifies is a roadsemgment is accessible by Bicycles.
ACCESS_CARPOOL VARCHAR2 (3)
Specifies if a roadsegment is accessible by High Occupancy Vehicles (i.e. passenger cars where a certain minimum number of passengers is required).
ACCESS_THROUGH_TRAFFIC VARCHAR2 (3)
The THROUGH TRAFFIC defines if the segment can be used for ongoing traffic. THROUGH TRAFFIC = N means that the road is only accessible for local resident that live in this area, and can not be used for transit traffic.
TILE_ID NUMBER (30)
The TILE ID defines the unique identifier of the entity.
INTERVAL_ID NUMBER (30)
Unique identifier for the Interval entity
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_SEGMENTS does not reference any database object

CSF.CSF_TDS_SEGMENTS is referenced by following:

APPS
SYNONYM - CSF_TDS_SEGMENTS

[top of page]

Table: CSF_TDS_SEGM_NODES

Description: Defines the relation between the segments and the nodes table
Primary Key: CSF_TDS_SEGM_NODES_PK
  1. SEGMENT_NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGM_NODES.NODE_ID CSF_TDS_NODES
CSF_TDS_SEGM_NODES.SEGMENT_ID CSF_TDS_SEGMENTS
Comments

DEFINITION
Intersection table required since one Node can be part of multiple segments and one Segment is composed of two node.
EXAMPLE
MISCELLANEOUS

Columns
Name Datatype Length Mandatory Comments
SEGMENT_NODE_ID NUMBER (30) Y Unique identifier for Segment Node table
SEGM_NODE_TYPE NUMBER (1) Y Defines wether a node Starting = 0 or Ending = 1
NODE_ID NUMBER (30) Y The TDS NODE ID defines the unique identifier of the entity.
SEGMENT_ID NUMBER (30) Y Unique identifier to segment
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_SEGM_NODES does not reference any database object

CSF.CSF_TDS_SEGM_NODES is referenced by following:

APPS
SYNONYM - CSF_TDS_SEGM_NODES

[top of page]

Table: CSF_TDS_TILES

Description: Defines the result of spatial index creation (tiling).
Primary Key: CSF_TDS_TILES_PK
  1. TILE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_NODES.TILE_ID CSF_TDS_TILES
CSF_TDS_SEGMENTS.TILE_ID CSF_TDS_TILES
Comments

DEFINITION
A TDS TILE defines the result of spatial index creation (tiling).
EXAMPLE
MISCELLANEOUS
Rather a a rectangular region in the network containing nodes and edges (segments). A tile can be loaded separately into memory.

Indexes
Index Type Tablespace Column
SYS_IL0000083073C00013$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000083073C00014$$ UNIQUE APPS_TS_MEDIA
Columns
Name Datatype Length Mandatory Comments
TILE_ID NUMBER (30) Y The TILE ID defines the unique identifier of the entity.
SUCC_TILE_1 NUMBER

The SUCC TILE 1 defines a reference to the first successive tile.
SUCC_TILE_2 NUMBER

The SUCC TILE 2 defines a reference to the second successive tile.
SUCC_TILE_3 NUMBER

The SUCC TILE 3 defines a reference to the third successive tile.
SUCC_TILE_4 NUMBER

The SUCC TILE 4 defines a reference to the fourth successive tile.
BIN_INDEX NUMBER

Numeric value used to generate index for Segment in Binary TDS file
GEOMETRY SDO_GEOMETRY (1)
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.

[top of page]

CSF.CSF_TDS_TILES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_TILES is referenced by following:

APPS
SYNONYM - CSF_TDS_TILES

[top of page]

View: CSF_ACCESS_HOURS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view of form block in CSFACHRS form. Corresponds to the CSF_ACCESS_HOURS_B and CSF_ACCESS_HOURS_TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identification
ACCESS_HOUR_ID NUMBER
Y Access Hour Id
TASK_ID NUMBER
Y Task Id
ACCESSHOUR_REQUIRED VARCHAR2 (2) Y Access Hours Flag
AFTER_HOURS_FLAG VARCHAR2 (2) Y After Hours Flag
MONDAY_FIRST_START DATE

Monday First Slot Start Time
MONDAY_FIRST_END DATE

Monday First Slot End Time
MONDAY_SECOND_START DATE

Monday Second Slot Start Time
MONDAY_SECOND_END DATE

Monday Second Slot End Time
TUESDAY_FIRST_START DATE

Tuesday First Slot Start Time
TUESDAY_FIRST_END DATE

Tuesday First Slot End Time
TUESDAY_SECOND_START DATE

Tuesday Second Slot Start Time
TUESDAY_SECOND_END DATE

Tuesday Second Slot End Time
WEDNESDAY_FIRST_START DATE

Wednesday First Slot Start Time
WEDNESDAY_FIRST_END DATE

WednesDay First Slot End Time
WEDNESDAY_SECOND_START DATE

Wednesday Second Slot Start Time
WEDNESDAY_SECOND_END DATE

Wednesday Second Slot End Time
THURSDAY_FIRST_START DATE

Thursday First Slot Start TIme
THURSDAY_FIRST_END DATE

Thursday First Slot End Time
THURSDAY_SECOND_START DATE

Thursday Second Slot Start TIme
THURSDAY_SECOND_END DATE

Thursday Second Slot End Time
FRIDAY_FIRST_START DATE

Friday First Slot Start Time
FRIDAY_FIRST_END DATE

Friday First Slot End TIme
FRIDAY_SECOND_START DATE

Friday Second Slot Start Time
FRIDAY_SECOND_END DATE

Friday Second Slot End Time
SATURDAY_FIRST_START DATE

Saturday First Slot Start Time
SATURDAY_FIRST_END DATE

Saturday First Slot End Time
SATURDAY_SECOND_START DATE

Saturday Second Slot Start TIme
SATURDAY_SECOND_END DATE

Saturday Second Slot End Time
SUNDAY_FIRST_START DATE

Sunday First Slot Start Time
SUNDAY_FIRST_END DATE

Sunday First Slot End Time
SUNDAY_SECOND_START DATE

Sunday Second Slot Start Time
SUNDAY_SECOND_END DATE

Sunday Second Slot End Time
DESCRIPTION VARCHAR2 (240)
Description for After Hours
OBJECT_VERSION_NUMBER NUMBER
Y User given identification of a query stored in this record.
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

[top of page]

APPS.CSF_ACCESS_HOURS_VL references the following:

APPS
SYNONYM - CSF_ACCESS_HOURS_B
SYNONYM - CSF_ACCESS_HOURS_TL
APPS.CSF_ACCESS_HOURS_VL is referenced by following:

APPS
PACKAGE BODY - CSFW_TASKS_PUB
PACKAGE BODY - CSF_ACCESS_HOURS_PUB

[top of page]

View: CSF_CT_TASKS

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identification
TASK_ID NUMBER
Y Task Id
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
TASK_NUMBER VARCHAR2 (30) Y Task Number
TASK_TYPE_ID NUMBER
Y Task Type
TASK_STATUS_ID NUMBER
Y Task Status
TASK_PRIORITY_ID NUMBER

Task Priority
OWNER_ID NUMBER
Y Owner Id
OWNER_TYPE_CODE VARCHAR2 (30) Y Owner Type Code
ASSIGNED_BY_ID NUMBER

Assigned By
CUST_ACCOUNT_ID NUMBER

Customer Account Id
CUSTOMER_ID NUMBER

Customer Id
ADDRESS_ID NUMBER

Address Id
PARENT_TASK_ID NUMBER

Parent Task Id
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Source Object Type Code
TIMEZONE_ID NUMBER

Time zone Id
SOURCE_OBJECT_ID NUMBER

Source Object Id
SOURCE_OBJECT_NAME VARCHAR2 (80)
Source Object Name
DURATION NUMBER

Duration
DURATION_UOM VARCHAR2 (3)
Duration UOM
PLANNED_EFFORT NUMBER

Planned Effort
PLANNED_EFFORT_UOM VARCHAR2 (3)
Planned Effort UOM
ACTUAL_EFFORT NUMBER

Actual Effort
ACTUAL_EFFORT_UOM VARCHAR2 (3)
Actual Effort UOM
PLANNED_START_DATE DATE

Planned Start Date
PLANNED_END_DATE DATE

Planned End Date
SCHEDULED_START_DATE DATE

Scheduled Start Date
SCHEDULED_END_DATE DATE

Scheduled End Date
ACTUAL_START_DATE DATE

Actual Start Date
ACTUAL_END_DATE DATE

Actual End Date
TASK_NAME VARCHAR2 (80) Y Task Name
DESCRIPTION VARCHAR2 (4000)
Description
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
OWNER_TERRITORY_ID NUMBER

Owner Territory Id
TASK_STATUS VARCHAR2 (30) Y Task Status
STATUS_SCHEDULABLE_FLAG VARCHAR2 (1)
Status Schedulable Flag
TASK_TYPE VARCHAR2 (30) Y Task Type
TYPE_SCHEDULABLE_FLAG VARCHAR2 (1)
Type Schedulable Flag
TASK_PRIORITY VARCHAR2 (30)
Task Priority
ORG_ID NUMBER

Organization Id
INCIDENT_ID NUMBER (15) Y Incident ID
INCIDENT_NUMBER VARCHAR2 (64) Y Incident Number
INCIDENT_CUSTOMER_ID NUMBER (15)
Incident Customer Id
INCIDENT_ACCOUNT_ID NUMBER

Incident Account Id
INCIDENT_CREATION_DATE DATE
Y Service Request Creation Date
CONTRACT_SERVICE_ID NUMBER

Contract Service Id
INCIDENT_URGENCY_ID NUMBER (15)
Urgency Id
OBLIGATION_DATE DATE

Obligation Date
PROBLEM_CODE VARCHAR2 (50)
Problem Code
RESOLUTION_CODE VARCHAR2 (50)
Resolution Code
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer Product Id
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Current Serial Number
PRODUCT_REVISION VARCHAR2 (240)
Product Revision
INV_ITEM_REVISION VARCHAR2 (240)
Inventory Item Revision
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Id
INV_ORGANIZATION_ID NUMBER

Inventory Organization Id
INSTALLED_BASE_FLAG VARCHAR2 (1)
Installed base Flag
SUMMARY VARCHAR2 (240) Y Summary
INCIDENT_CUSTOMER_NAME VARCHAR2 (360)
Incident Customer Name
PRODUCT_NAME VARCHAR2 (40)
Product Name
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product Description
REVISION_QTY_CONTROL_CODE NUMBER

Revision Quantity Control Code
LOCATION_ID NUMBER (15)
Location Id
ADDRESS1 VARCHAR2 (240)
Address1
ADDRESS2 VARCHAR2 (240)
Address2
POSTAL_CODE VARCHAR2 (60)
Postal Code
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTRY VARCHAR2 (60)
Country
ADDRESS3 VARCHAR2 (240)
Address3
ADDRESS4 VARCHAR2 (240)
Address4
COUNTY VARCHAR2 (60)
County
TASK_SPLIT_FLAG VARCHAR2 (1)
Task Split Flag
PARTY_NUMBER VARCHAR2 (30)
Party Number
CLOSED_FLAG VARCHAR2 (1)
Closed Flag
ASSIGNED_FLAG VARCHAR2 (1)
Assigned Flag
INCIDENT_TYPE_ID NUMBER (15) Y Incident Type Id
INCIDENT_TYPE_NAME VARCHAR2 (90) Y Incident Type Name
OPEN_FLAG VARCHAR2 (1)
Open Flag
START_DATE_TYPE VARCHAR2 (30)
Start Date Type
END_DATE_TYPE VARCHAR2 (30)
End Date Type
TASK_TIMEZONE_ID NUMBER

Task Timezone Id
WORKING_FLAG VARCHAR2 (1)
Working Flag
REJECTED_FLAG VARCHAR2 (1)
Rejected Flag
COMPLETED_FLAG VARCHAR2 (1)
Completed Flag

[top of page]

APPS.CSF_CT_TASKS references the following:

APPS
PACKAGE - CSF_TASKS_PUB
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_B
SYNONYM - JTF_TASK_TYPES_TL
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.CSF_CT_TASKS is not referenced by any database object

[top of page]

View: CSF_CT_TASK_ASSIGNMENTS

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identification
TASK_ASSIGNMENT_ID NUMBER
Y Task Assignment Id
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
TASK_ID NUMBER
Y Task Id
RESOURCE_TYPE_CODE VARCHAR2 (30) Y Resource Type Code
RESOURCE_ID NUMBER
Y Resource Id
ACTUAL_EFFORT NUMBER

Actual Effort
ACTUAL_EFFORT_UOM VARCHAR2 (3)
Actual Effort UOM
SCHEDULE_FLAG VARCHAR2 (1)
Schedule flag
SCHED_TRAVEL_DISTANCE NUMBER

Scheduled Travel Distance
SCHED_TRAVEL_DURATION NUMBER

Scheduled Travel Duration
SCHED_TRAVEL_DURATION_UOM VARCHAR2 (3)
Scheduled Travel Duration UOM
ACTUAL_TRAVEL_DISTANCE NUMBER

Actual Travel Distance
ACTUAL_TRAVEL_DURATION NUMBER

Actual Travel Duration
ACTUAL_TRAVEL_DURATION_UOM VARCHAR2 (3)
Actual Travel Duration UOM
ACTUAL_START_DATE DATE

Actual Start Date
ACTUAL_END_DATE DATE

Actual End Date
OBJECT_VERSION_NUMBER NUMBER
Y Object version Number
RESOURCE_TERRITORY_ID NUMBER

Resource Territory Id
ASSIGNMENT_STATUS_ID NUMBER
Y Assignment Status Id
SHIFT_CONSTRUCT_ID NUMBER

Shift Construct Id
ASSIGNEE_ROLE VARCHAR2 (30)
Assignee Role
SHOW_ON_CALENDAR VARCHAR2 (1)
Show on Calendar
CATEGORY_ID NUMBER

Category Id
ASSIGNMENT_STATUS VARCHAR2 (30) Y Assignment Status
STATUS_CANCELLED_FLAG VARCHAR2 (1)
Cancelled Flag Status
RESOURCE_NAME VARCHAR2 (4000)
Resource Name
RESOURCE_TYPE_NAME VARCHAR2 (4000)
Resource Type Name
BOOKING_START_DATE DATE

BOOKING_END_DATE DATE

OBJECT_CAPACITY_ID NUMBER

[top of page]

APPS.CSF_CT_TASK_ASSIGNMENTS references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
PACKAGE - CSF_UTIL_PVT
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_STATUSES_VL
APPS.CSF_CT_TASK_ASSIGNMENTS is referenced by following:

APPS
PACKAGE BODY - CSF_TASKS_PUB

[top of page]

View: CSF_DC_QUERIES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view for the Queries block in the Dispatch Center

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
QUERY_ID NUMBER
Y Standard who column
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
OBJECT_VERSION_NUMBER NUMBER

Sequence number used to detect concurrent recored updates.
NAME VARCHAR2 (30)
User given identification of a query stored in this record.
DESCRIPTION VARCHAR2 (2000)
Text describing the query stored in this record
WHERE_CLAUSE VARCHAR2 (4000) Y The where_clause of the query stored in this record
USER_ID NUMBER (15) Y User id of the owner of the query
SEEDED_FLAG VARCHAR2 (1)
Indicator wether the query is seeded or user entered
START_DATE_ACTIVE DATE
Y Start date of valid period
END_DATE_ACTIVE DATE

End date of valid period

[top of page]

APPS.CSF_DC_QUERIES_VL references the following:

APPS
SYNONYM - CSF_DC_QUERIES_B
SYNONYM - CSF_DC_QUERIES_TL
APPS.CSF_DC_QUERIES_VL is referenced by following:

APPS
PACKAGE BODY - CSF_DC_QUERIES_PKG
VIEW - CSF_DC_QUERY_EXTNS_V

[top of page]

View: CSF_DEBRIEF_EXP_LINES_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CHANNEL_CODE VARCHAR2 (30)
Channel Code
DEBRIEF_LINE_ID NUMBER
Y The field service line identifier
DEBRIEF_HEADER_ID NUMBER
Y The unique identifier for header
SERVICE_DATE DATE
Y Service date
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
UOM_CODE VARCHAR2 (3)
Issuing inventory org identifier
QUANTITY NUMBER

EXPENSE_AMOUNT NUMBER

Issuing sub inventory code
CURRENCY_CODE VARCHAR2 (15)
The unique id for the order
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
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
EXPENSE_REASON_CODE VARCHAR2 (30)
Expense Reason Code
BUSINESS_PROCESS_ID NUMBER

TRANSACTION_TYPE_ID NUMBER (15) Y Trx type identifier
TXN_TYPE VARCHAR2 (90) Y Transaction type
EXPENSE_MEANING VARCHAR2 (80)
Expense meaning code
CHARGE_UPLOAD_STATUS VARCHAR2 (30)
Expense description
CHARGE_UPLOAD_MSG_CODE VARCHAR2 (30)
Item name
CHARGE_UPLOAD_MESSAGE VARCHAR2 (240)
Item description
ERROR_TEXT VARCHAR2 (2000)
Error text after debrief was processed

[top of page]

APPS.CSF_DEBRIEF_EXP_LINES_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
PACKAGE - CS_STD
SYNONYM - CS_TRANSACTION_TYPES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV

APPS.CSF_DEBRIEF_EXP_LINES_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_HEADERS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
DEBRIEF_HEADER_ID NUMBER
Y The unique identifier for the field service report header
DEBRIEF_NUMBER VARCHAR2 (50) Y The unique number for the field service report
DEBRIEF_DATE DATE
Y Field service report date
DEBRIEF_STATUS_ID NUMBER

Field service report status identifier
TASK_ID NUMBER
Y
TASK_ASSIGNMENT_ID NUMBER
Y Task assignment identifier
PROCESSED_FLAG VARCHAR2 (40)
Debrief Status while being processed
SCHEDULED_START_DATE DATE

Scheduled Start Date
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
TASK_NUMBER VARCHAR2 (30) Y Task number
TASK_SOURCE VARCHAR2 (30)
Task source
TASK_NAME VARCHAR2 (80) Y Task name
TASK_DESCRIPTION VARCHAR2 (4000)
Task description
TASK_STATUS VARCHAR2 (30) Y Task status
TASK_ASSIGNMENT_STATUS VARCHAR2 (30) Y Task assignment status
CUSTOMER_NAME VARCHAR2 (360)
Customer name
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
ADDRESS VARCHAR2 (966)
Address
CITY_STATE_ZIP VARCHAR2 (185)
City zip code
RESOURCE_ID NUMBER
Y Unique id for the engineer
RESOURCE_NAME VARCHAR2 (4000)
Resource name
RESOURCE_TYPE VARCHAR2 (30) Y Resource type
SOURCE_NUMBER VARCHAR2 (64)
Source number
INCIDENT_ID NUMBER (15)
Incident identifier
SOURCE_DATE DATE

Source date
PO_NUMBER VARCHAR2 (50)
Purchase order number
PRODUCT_NAME VARCHAR2 (40)
Product name
PRODUCT_ID NUMBER

Product identifier
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product description
SOURCE_OBJECT_ID NUMBER

Source object identifier
CUSTOMER_ID NUMBER (15)
Customer identifier
CUST_ACCOUNT_ID NUMBER

Customer account identifier
ORGANIZATION_ID NUMBER

Organziation Identifier

[top of page]

APPS.CSF_DEBRIEF_HEADERS_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_HEADERS
PACKAGE - CSF_UTIL_PVT
SYNONYM - CS_INCIDENTS_ALL_B
VIEW - JTF_PARTIES_ALL_V
VIEW - JTF_TASKS_VL
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_STATUSES_VL
VIEW - MTL_SYSTEM_ITEMS_B_KFV
APPS.CSF_DEBRIEF_HEADERS_V is referenced by following:

APPS
PACKAGE BODY - CSD_GEN_ERRMSGS_PVT

[top of page]

View: CSF_DEBRIEF_LAB_LINES_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CHANNEL_CODE VARCHAR2 (30)
Channel Code
DEBRIEF_LINE_ID NUMBER

Field service line identifier
DEBRIEF_HEADER_ID NUMBER

Field service header identifier
SERVICE_DATE DATE

Service date
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
UOM_CODE VARCHAR2 (3)
The uom code
LABOR_START_DATE DATE

Labor start date
LABOR_END_DATE DATE

Labor end date
QUANTITY NUMBER

STARTING_MILEAGE NUMBER

Starting mileage
ENDING_MILEAGE NUMBER

End mileage
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure definition column
LABOR_REASON_CODE VARCHAR2 (30)
Labor reason Code
BUSINESS_PROCESS_ID NUMBER

TRANSACTION_TYPE_ID NUMBER (15)
Transaction type identifier
TXN_TYPE VARCHAR2 (90)
Transaction type
TXN_TYPE_DESCRIPTION VARCHAR2 (720)
Transaction type description
LABOR_MEANING VARCHAR2 (80)
Labor meaning
CHARGE_UPLOAD_STATUS VARCHAR2 (30)
Labor description
CHARGE_UPLOAD_MSG_CODE VARCHAR2 (30)
Item number
CHARGE_UPLOAD_MESSAGE VARCHAR2 (240)
ERROR_TEXT VARCHAR2 (2000)
Error text after debrief was processed

[top of page]

APPS.CSF_DEBRIEF_LAB_LINES_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
PACKAGE - CS_STD
VIEW - CS_TRANSACTION_TYPES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV
APPS.CSF_DEBRIEF_LAB_LINES_V is referenced by following:

APPS
PACKAGE BODY - CSF_DEBRIEF_PVT

[top of page]

View: CSF_DEBRIEF_MAT_LINES_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CHANNEL_CODE VARCHAR2 (30)
Channel code
DEBRIEF_LINE_ID NUMBER
Y Field service line identifier
DEBRIEF_HEADER_ID NUMBER
Y Field service header identifier
SERVICE_DATE DATE
Y Service date
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
INSTANCE_ID NUMBER

INSTANCE_NUMBER VARCHAR2 (30)
INVENTORY_ORG_ID NUMBER

Issuing inventory org identifier
SUB_INVENTORY_CODE VARCHAR2 (10)
Issuing sub inventory code
LOCATOR NUMBER

Issuing locator identifier
UOM_CODE VARCHAR2 (3)
Uom code
PARENT_PRODUCT_ID NUMBER (15)
Parent product identifier
REMOVED_PRODUCT_ID NUMBER (15)
Removed product identifier
RECEIVED_PART_STATUS VARCHAR2 (30)
Received part status
QUANTITY NUMBER

Quantity
ITEM_REVISION VARCHAR2 (3)
Item revision
ITEM_LOTNUMBER VARCHAR2 (80)
Item lot number
ITEM_SERIAL_NUMBER VARCHAR2 (30)
Item serial number
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
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attttribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column
MATERIAL_REASON_CODE VARCHAR2 (30)
Material reason Code
BUSINESS_PROCESS_ID NUMBER

TRANSACTION_TYPE_ID NUMBER (15) Y
LINE_ORDER_CATEGORY_CODE VARCHAR2 (30)
Transaction billing type identifier
TXN_TYPE VARCHAR2 (90) Y Transaction type
MATERIAL_MEANING VARCHAR2 (80)
Material meaning
REVISION_FLAG VARCHAR2 (1)
Revision flag
IB_UPDATE_STATUS VARCHAR2 (30)
IB_UPDATE_MSG_CODE VARCHAR2 (30)
IB_UPDATE_MESSAGE VARCHAR2 (240)
SPARE_UPDATE_STATUS VARCHAR2 (30)
SPARE_UPDATE_MSG_CODE VARCHAR2 (30)
SPARE_UPDATE_MESSAGE VARCHAR2 (240)
CHARGE_UPLOAD_STATUS VARCHAR2 (30)
CHARGE_UPLOAD_MSG_CODE VARCHAR2 (30)
CHARGE_UPLOAD_MESSAGE VARCHAR2 (240)
RETURN_REASON_CODE VARCHAR2 (30)
RETURN_REASON VARCHAR2 (80)
RETURN_DATE DATE

ERROR_TEXT VARCHAR2 (2000)
Error text after debrief was processed

[top of page]

APPS.CSF_DEBRIEF_MAT_LINES_V references the following:

APPS
VIEW - ASO_I_RETURN_CODES_V
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
VIEW - CS_TRANSACTION_TYPES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV

APPS.CSF_DEBRIEF_MAT_LINES_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_SRC_NUMBERS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
SOURCE_NUMBER VARCHAR2 (64)
SOURCE_TYPE VARCHAR2 (30)
SOURCE_TYPE_CODE CHAR (2)
INCIDENT_ID NUMBER

REPAIR_LINE_ID NUMBER

DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.CSF_DEBRIEF_SRC_NUMBERS_V references the following:

APPS
SYNONYM - CSD_REPAIRS
SYNONYM - CS_INCIDENTS_ALL
VIEW - JTF_OBJECTS_VL
VIEW - JTF_TASKS_VL

APPS.CSF_DEBRIEF_SRC_NUMBERS_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_TASKS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
RESOURCE_NAME VARCHAR2 (4000)
RESOURCE_ID NUMBER

OWNER_NAME VARCHAR2 (4000)
OWNER_ID NUMBER

OWNER_TYPE_CODE VARCHAR2 (30)
TASK_NUMBER VARCHAR2 (30)
TASK_NAME VARCHAR2 (80)
TASK_ID NUMBER

TASK_STATUS VARCHAR2 (30)
TASK_STATUS_ID NUMBER

TASK_PRIORITY_ID NUMBER

TASK_PRIORITY_NAME VARCHAR2 (30)
TASK_ASSIGNMENT_STATUS VARCHAR2 (30)
SOURCE_TYPE_CODE VARCHAR2 (30)
SOURCE_TYPE_NAME VARCHAR2 (30)
SOURCE_NUMBER VARCHAR2 (80)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_NUMBER VARCHAR2 (40)
UNIT_OF_MEASURE VARCHAR2 (3)
QUANTITY NUMBER

QUANTITY_RCVD NUMBER

QUANTITY_SHIPPED NUMBER

INCIDENT_ID NUMBER (15)
DEBRIEF_NUMBER VARCHAR2 (50)
DEBRIEF_HEADER_ID NUMBER

DEBRIEF_DATE DATE

CUSTOMER_ID NUMBER (15)
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_NUMBER VARCHAR2 (30)
RESOURCE_TYPE_CODE VARCHAR2 (30)
TASK_ASSIGNMENT_ID NUMBER

RESOURCE_TYPE_NAME VARCHAR2 (30)
CUSTOMER_ACCOUNT_ID NUMBER

CUSTOMER_PRODUCT_ID NUMBER (15)
REPAIR_LINE_ID NUMBER

SCHEDULED_START_DATE DATE

SCHEDULED_END_DATE DATE

PLANNED_EFFORT NUMBER

PLANNED_EFFORT_UOM VARCHAR2 (3)
PROCESSED_FLAG VARCHAR2 (40)
CLOSED_FLAG VARCHAR2 (1)
COMPLETED_FLAG VARCHAR2 (1)
CANCELLED_FLAG VARCHAR2 (1)
ON_HOLD_FLAG VARCHAR2 (1)
REJECTED_FLAG VARCHAR2 (1)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

ADDRESS_ID NUMBER

TASK_TYPE_ID NUMBER

TASK_TYPE VARCHAR2 (30)
TASK_DESCRIPTION VARCHAR2 (4000)
ADDRESS VARCHAR2 (4000)
SERIAL_NUMBER VARCHAR2 (30)
EXTERNAL_REFERENCE_NUMBER VARCHAR2 (30)
CONTRACT_NUMBER VARCHAR2 (120)
SERVICE_NAME VARCHAR2 (40)
SERVICE_DESCRIPTION VARCHAR2 (240)
WARRANTY_FLAG VARCHAR2 (1)
STATUS_CODE VARCHAR2 (30)
SERVICE_START_DATE DATE

SERVICE_END_DATE DATE

[top of page]

APPS.CSF_DEBRIEF_TASKS_V references the following:

APPS
SYNONYM - CSD_REPAIRS
SYNONYM - CSF_DEBRIEF_HEADERS
PACKAGE - CSF_UTIL_PVT
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL
PACKAGE - CS_STD
PACKAGE - HZ_FORMAT_PUB
SYNONYM - HZ_PARTY_SITES
VIEW - JTF_OBJECTS_VL
VIEW - JTF_PARTIES_ALL_V
VIEW - JTF_TASKS_VL
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_PRIORITIES_VL
VIEW - JTF_TASK_STATUSES_VL
VIEW - JTF_TASK_TYPES_VL
VIEW - MTL_SYSTEM_ITEMS_B_KFV
VIEW - OKS_ENT_LINE_DETAILS_V

APPS.CSF_DEBRIEF_TASKS_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_TRANS_TYPES_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_TYPE_ID NUMBER (15) Y Transaction type identifier
NAME VARCHAR2 (90) Y Transaction type name
BUSINESS_PROCESS_ID NUMBER (15) Y
LINE_ORDER_CATEGORY_CODE VARCHAR2 (30)

[top of page]

APPS.CSF_DEBRIEF_TRANS_TYPES_V references the following:

APPS
SYNONYM - CSI_INSTANCE_STATUSES
VIEW - CSI_TXN_SUB_TYPES
SYNONYM - CSI_TXN_TYPES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
SYNONYM - CS_BUSINESS_PROCESSES
SYNONYM - CS_BUS_PROCESS_TXNS
VIEW - CS_TRANSACTION_TYPES_VL
SYNONYM - CS_TXN_BILLING_TYPES

APPS.CSF_DEBRIEF_TRANS_TYPES_V is not referenced by any database object

[top of page]

View: CSF_ESC_TASKS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER
Y Object
TASK_ID NUMBER
Y Task id
TASK_NUMBER VARCHAR2 (30) Y Number of the task
OBJECT_VERSION_NUMBER NUMBER
Y Object version
OWNER_ID NUMBER
Y Owner
OWNER_TYPE_CODE VARCHAR2 (30) Y Owner type
OWNER_TERRITORY_ID NUMBER

Owner territory
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard creation date
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
TASK_NAME VARCHAR2 (80) Y Name of the task
DESCRIPTION VARCHAR2 (4000)
Description
TASK_TYPE_ID NUMBER
Y Task type
TASK_STATUS_ID NUMBER
Y Task status
STATUS_NAME VARCHAR2 (30)
status name
CLOSED_FLAG VARCHAR2 (1)
Closed flag
ESCALATION_LEVEL VARCHAR2 (30)
Escalation level
ESC_LEVEL_NAME VARCHAR2 (80)
Name of escalation
REASON_CODE VARCHAR2 (30)
Reason code
REASON_NAME VARCHAR2 (80)
Name of the reason
CUSTOMER_ID NUMBER

Customer
CUST_ACCOUNT_ID NUMBER

Customer Acccount
ADDRESS_ID NUMBER

Address
PARENT_TASK_ID NUMBER

Parent task
DELETED_FLAG VARCHAR2 (1)
Deleted flag
ACTUAL_START_DATE DATE

Actual start date
ACTUAL_END_DATE DATE

Actual end date
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Source Object type
SOURCE_OBJECT_ID NUMBER

Source object
SOURCE_OBJECT_NAME VARCHAR2 (80)
Source object name
TASK_PRIORITY_ID NUMBER

Task priority
ASSIGNED_BY_ID NUMBER

Assigned by
PRIVATE_FLAG VARCHAR2 (1)
Private flag
PUBLISH_FLAG VARCHAR2 (1)
Publish flag
WORKFLOW_PROCESS_ID NUMBER

Workflow process
PLANNED_END_DATE DATE

Planned end date
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column

[top of page]

APPS.CSF_ESC_TASKS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_REFERENCES_B
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL

APPS.CSF_ESC_TASKS_V is not referenced by any database object

[top of page]

View: CSF_GNTICONS_SETUP_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identification
SEQ_ID NUMBER
Y Sequence id
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
OBJECT_VERSION_NUMBER NUMBER

The object version number is incremented by one at every update.
ICON_FILE_NAME VARCHAR2 (2000) Y File Name of th Icon.
DESCRIPTION VARCHAR2 (2000) Y Description about the usage of the Icon
RANKING NUMBER
Y Ranking
ACTIVE VARCHAR2 (1) Y Icon is Active or not.

[top of page]

APPS.CSF_GNTICONS_SETUP_V references the following:

APPS
SYNONYM - CSF_GNTICONS_SETUP_B
APPS.CSF_GNTICONS_SETUP_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG

[top of page]

View: CSF_L_SODS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SOD_SOD_ID NUMBER (15) Y
SOD_SOT_ID NUMBER (15) Y
SOD_SODTYPE VARCHAR2 (20) Y
SOD_SODDESCR VARCHAR2 (50) Y
SOD_FILENAMEHDR VARCHAR2 (255) Y
SOD_FILENAMEFTR VARCHAR2 (255)
SOD_DEFSOD_ID NUMBER (15) Y
SOD_TASK_TYPE_ID NUMBER

SOD_ITEM_PATTERN VARCHAR2 (240)
SOD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
SOD_ATTRIBUTE1 VARCHAR2 (150)
SOD_ATTRIBUTE2 VARCHAR2 (150)
SOD_ATTRIBUTE3 VARCHAR2 (150)
SOD_ATTRIBUTE4 VARCHAR2 (150)
SOD_ATTRIBUTE5 VARCHAR2 (150)
SOD_ATTRIBUTE6 VARCHAR2 (150)
SOD_ATTRIBUTE7 VARCHAR2 (150)
SOD_ATTRIBUTE8 VARCHAR2 (150)
SOD_ATTRIBUTE9 VARCHAR2 (150)
SOD_ATTRIBUTE10 VARCHAR2 (150)
SOD_ATTRIBUTE11 VARCHAR2 (150)
SOD_ATTRIBUTE12 VARCHAR2 (150)
SOD_ATTRIBUTE13 VARCHAR2 (150)
SOD_ATTRIBUTE14 VARCHAR2 (150)
SOD_ATTRIBUTE15 VARCHAR2 (150)
SOT_SOT_ID NUMBER (15) Y
SOT_DESCR VARCHAR2 (50) Y
SOT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
SOT_ATTRIBUTE1 VARCHAR2 (150)
SOT_ATTRIBUTE2 VARCHAR2 (150)
SOT_ATTRIBUTE3 VARCHAR2 (150)
SOT_ATTRIBUTE4 VARCHAR2 (150)
SOT_ATTRIBUTE5 VARCHAR2 (150)
SOT_ATTRIBUTE6 VARCHAR2 (150)
SOT_ATTRIBUTE7 VARCHAR2 (150)
SOT_ATTRIBUTE8 VARCHAR2 (150)
SOT_ATTRIBUTE9 VARCHAR2 (150)
SOT_ATTRIBUTE10 VARCHAR2 (150)
SOT_ATTRIBUTE11 VARCHAR2 (150)
SOT_ATTRIBUTE12 VARCHAR2 (150)
SOT_ATTRIBUTE13 VARCHAR2 (150)
SOT_ATTRIBUTE14 VARCHAR2 (150)
SOT_ATTRIBUTE15 VARCHAR2 (150)
JTT_TASK_TYPE_ID NUMBER

JTT_NAME VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
SOD_ORDER VARCHAR2 (68)

[top of page]

APPS.CSF_L_SODS_V references the following:

APPS
SYNONYM - CSF_L_SODS
SYNONYM - CSF_L_SOTS
VIEW - JTF_TASK_TYPES_VL

APPS.CSF_L_SODS_V is not referenced by any database object

[top of page]

View: CSF_MAP_ACCESS_HOURS_VL

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACCESS_HOUR_MAP_ID NUMBER
Y
CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

CUSTOMER_LOCATION_ID NUMBER

ACCESSHOUR_REQUIRED VARCHAR2 (2)
AFTER_HOURS_FLAG VARCHAR2 (2)
MONDAY_FIRST_START DATE

MONDAY_FIRST_END DATE

MONDAY_SECOND_START DATE

MONDAY_SECOND_END DATE

TUESDAY_FIRST_START DATE

TUESDAY_FIRST_END DATE

TUESDAY_SECOND_START DATE

TUESDAY_SECOND_END DATE

WEDNESDAY_FIRST_START DATE

WEDNESDAY_FIRST_END DATE

WEDNESDAY_SECOND_START DATE

WEDNESDAY_SECOND_END DATE

THURSDAY_FIRST_START DATE

THURSDAY_FIRST_END DATE

THURSDAY_SECOND_START DATE

THURSDAY_SECOND_END DATE

FRIDAY_FIRST_START DATE

FRIDAY_FIRST_END DATE

FRIDAY_SECOND_START DATE

FRIDAY_SECOND_END DATE

SATURDAY_FIRST_START DATE

SATURDAY_FIRST_END DATE

SATURDAY_SECOND_START DATE

SATURDAY_SECOND_END DATE

SUNDAY_FIRST_START DATE

SUNDAY_FIRST_END DATE

SUNDAY_SECOND_START DATE

SUNDAY_SECOND_END DATE

OBJECT_VERSION_NUMBER NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER

LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4)
DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.CSF_MAP_ACCESS_HOURS_VL references the following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_B
SYNONYM - CSF_MAP_ACCESS_HOURS_TL
APPS.CSF_MAP_ACCESS_HOURS_VL is referenced by following:

APPS
PACKAGE BODY - CSF_MAP_ACC_HRS_PKG
PACKAGE BODY - CSF_PREVENTIVE_MAINTENANCE_PVT

[top of page]

View: CSF_PHONETIC_VALUES_VL

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PHONETICS_ID NUMBER (15) Y Unique identifier
LANGUAGE VARCHAR2 (30) Y Language of phonetic and alphabet
PHONETIC VARCHAR2 (30) Y Word that is spoken e.g Alpha, lower case Alpha
CODE VARCHAR2 (30) Y Alphabet that is understood when the phonetic is spoken e.g 'A', 'a'
DESCRIPTION VARCHAR2 (240)
Description e.g Upper case A of the English Alphabet
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
START_DATE_ACTIVE DATE

The date when the phonetic becomes active
END_DATE_ACTIVE DATE

The date when the phonetic becomes inactive
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_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

APPS.CSF_PHONETIC_VALUES_VL references the following:

APPS
SYNONYM - CSF_PHONETIC_VALUES

APPS.CSF_PHONETIC_VALUES_VL is not referenced by any database object

[top of page]

View: CSF_PLAN_OPTIONS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
SCHED_REQUEST_ID NUMBER
Y Schedule Request Id
PLAN_OPTION_ID NUMBER
Y Plan Option Id
COST NUMBER

Cost
RESOURCE_ID NUMBER

Resource Id
RESOURCE_TYPE VARCHAR2 (30)
Resource Type
RESOURCE_NAME VARCHAR2 (4000)
Resource Name
START_TIME DATE

Plan Option Start Time
END_TIME DATE

Plan Option End Time
TRAVEL_TIME VARCHAR2 (5)
Travel Time
SPARES_DATE DATE

Spares Availability Date
SPARES_COST NUMBER

Spares Cost
TASK_TYPE_ID NUMBER

Task Type Id
OBJECT_CAPACITY_ID NUMBER
Y Object Capacity Id
TASK_ID NUMBER

Task Id
TASK_ASSIGNMENT_ID NUMBER

Task Assignment Id

[top of page]

APPS.CSF_PLAN_OPTIONS_V references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
SYNONYM - CSF_R_PLAN_OPTIONS
SYNONYM - CSF_R_PLAN_OPTION_TASKS
SYNONYM - CSF_R_REQUEST_TASKS
SYNONYM - CSF_R_RESOURCE_RESULTS
SYNONYM - CSF_R_SPARES_OPTIONS
SYNONYM - JTF_TASKS_B
APPS.CSF_PLAN_OPTIONS_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG

[top of page]

View: CSF_PLAN_TERRS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identification
PLAN_TERR_ID NUMBER
Y Planner Group Territory Id
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
TERR_ID NUMBER
Y Territory Id
GROUP_ID NUMBER
Y Group Id
TERR_NAME VARCHAR2 (2000) Y Territory Name
GROUP_NAME VARCHAR2 (60) Y Group Name

[top of page]

APPS.CSF_PLAN_TERRS_V references the following:

APPS
SYNONYM - CSF_PLAN_TERRS
VIEW - JTF_RS_GROUPS_VL
SYNONYM - JTF_TERR_ALL

APPS.CSF_PLAN_TERRS_V is not referenced by any database object

[top of page]

View: CSF_PO_CONTACT_POINTS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
SR_CONTACT_POINT_ID NUMBER

CONTACT_PARTY_ID NUMBER

INCIDENT_ID NUMBER

CONTACT_POINT_TYPE VARCHAR2 (30)
CONTACT_POINT_ID NUMBER

PRIMARY_FLAG VARCHAR2 (1)
CONTACT_TYPE VARCHAR2 (30)
LOOKUP_MEANING VARCHAR2 (80)
RELATIONSHIP_ID NUMBER

SUBJECT_PARTY_ID NUMBER

CONTACT_NAME VARCHAR2 (391)
CONTACT_COMM_PREF VARCHAR2 (2081)
MODIFIABLE_TYPE NUMBER

MODIFIABLE_NAME NUMBER

DISPLAY_CONTACT_TYPE VARCHAR2 (30)
DISPLAY_PRIMARY_FLAG VARCHAR2 (1)

[top of page]

APPS.CSF_PO_CONTACT_POINTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - CS_HZ_SR_CONTACT_POINTS
VIEW - CS_INCIDENTS_ALL_VL
VIEW - CS_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
APPS.CSF_PO_CONTACT_POINTS_V is referenced by following:

APPS
PACKAGE BODY - CSP_PICK_UTILS

[top of page]

View: CSF_RATING_SCALES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view of form block in CSFSKMGT(Skill Management) form. Corresponds to the CSF_RATING_SCALES_B and CSF_RATING_SCALES_TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
RATING_SCALE_ID NUMBER (15) Y Rating Scale Id
NAME VARCHAR2 (30) Y Name
DESCRIPTION VARCHAR2 (240)
DESCRIPTION
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
SEEDED_FLAG VARCHAR2 (1)
SEEDED_FLAG
OBJECT_VERSION_NUMBER NUMBER
Y object version number
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
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Atrribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category

[top of page]

APPS.CSF_RATING_SCALES_VL references the following:

APPS
SYNONYM - CSF_RATING_SCALES_B
SYNONYM - CSF_RATING_SCALES_TL

APPS.CSF_RATING_SCALES_VL is not referenced by any database object

[top of page]

View: CSF_REQUIRED_SKILLS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
REQUIRED_SKILL_ID NUMBER (15) Y RESOURCE_SKILL_ID
SKILL_TYPE_ID NUMBER (15) Y SKILL_TYPE_ID
SKILL_ID NUMBER (15) Y SKILL_ID
SKILL_TYPE_NAME VARCHAR2 (30) Y Skill Type name
SKILL_TYPE_DESCRIPTION VARCHAR2 (240)
DESCRIPTION
HAS_SKILL_TYPE VARCHAR2 (30) Y HAS_SKILL_TYPE
HAS_SKILL_ID NUMBER (15) Y HAS_SKILL_ID
SKILL_LEVEL_ID NUMBER (15) Y SKILL_LEVEL_ID
SKILL_LEVEL_NAME VARCHAR2 (73)
SKILL_LEVEL_NAME
SKILL_LEVEL_DESCRIPTION VARCHAR2 (240)
SKILL_LEVEL_DESCRIPTION
SKILL_REQUIRED_FLAG VARCHAR2 (1)
SKILL_REQUIRED_FLAG
LEVEL_REQUIRED_FLAG VARCHAR2 (1)
LEVEL_REQUIRED_FLAG
DISABLED_FLAG VARCHAR2 (1)
DISABLED_FLAG
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
OBJECT_VERSION_NUMBER NUMBER
Y object version number
CREATED_BY NUMBER (15) Y CREATED by
CREATION_DATE DATE
Y creation date
LAST_UPDATED_BY NUMBER (15) Y last updated by
LAST_UPDATE_DATE DATE
Y last updated date
LAST_UPDATE_LOGIN NUMBER (15)
last update login
ATTRIBUTE1 VARCHAR2 (150)
attr 1
ATTRIBUTE2 VARCHAR2 (150)
attr2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE 3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE cat

[top of page]

APPS.CSF_REQUIRED_SKILLS_V references the following:

APPS
SYNONYM - CSF_REQUIRED_SKILLS_B
VIEW - CSF_SKILL_LEVELS_VL
VIEW - CSF_SKILL_TYPES_VL

APPS.CSF_REQUIRED_SKILLS_V is not referenced by any database object

[top of page]

View: CSF_RESOURCE_SKILLS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
RESOURCE_SKILL_ID NUMBER (15) Y RESOURCE_SKILL_ID
SKILL_TYPE_ID NUMBER (15) Y SKILL_TYPE_ID
SKILL_ID NUMBER (15) Y SKILL_ID
SKILL_TYPE_NAME VARCHAR2 (30) Y Skill Type name
SKILL_TYPE_DESCRIPTION VARCHAR2 (240)
Skill Type Description
RESOURCE_TYPE VARCHAR2 (30) Y RESOURCE_TYPE
RESOURCE_ID NUMBER (15) Y RESOURCE_ID
SKILL_LEVEL_ID NUMBER (15) Y SKILL_LEVEL_ID
SKILL_LEVEL_NAME VARCHAR2 (73)
SKILL_LEVEL_NAME
SKILL_LEVEL_DESCRIPTION VARCHAR2 (240)
SKILL_LEVEL_DESCRIPTION
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
OBJECT_VERSION_NUMBER NUMBER
Y object version number
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
ATTRIBUTE1 VARCHAR2 (150)
attr 1
ATTRIBUTE2 VARCHAR2 (150)
attr2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE 3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE cat

[top of page]

APPS.CSF_RESOURCE_SKILLS_V references the following:

APPS
VIEW - CSF_RESOURCES_V
SYNONYM - CSF_RESOURCE_SKILLS_B
VIEW - CSF_SKILL_LEVELS_VL
VIEW - CSF_SKILL_TYPES_VL

APPS.CSF_RESOURCE_SKILLS_V is not referenced by any database object

[top of page]

View: CSF_RES_INV_ASSIGNMENTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
CSP_INV_LOC_ASSIGNMENT_ID NUMBER (35) Y
RESOURCE_ID NUMBER (35) Y
RESOURCE_TYPE VARCHAR2 (30) Y
RESOURCE_NAME VARCHAR2 (360)
SUBINVENTORY_CODE VARCHAR2 (10) Y
DEFAULT_CODE VARCHAR2 (30)
EFFECTIVE_DATE_START DATE

EFFECTIVE_DATE_END DATE

ORGANIZATION_ID NUMBER (35) Y
CREATED_BY NUMBER (35) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (35) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (35)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.CSF_RES_INV_ASSIGNMENTS_V references the following:

APPS
VIEW - CSP_INV_LOC_ASSIGNMENTS_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - JTF_RS_ALL_RESOURCES_VL

APPS.CSF_RES_INV_ASSIGNMENTS_V is not referenced by any database object

[top of page]

View: CSF_SELECTED_RESOURCES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y
RESOURCE_TYPE VARCHAR2 (60)
RESOURCE_NAME VARCHAR2 (4000)

[top of page]

APPS.CSF_SELECTED_RESOURCES_V references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
PACKAGE - CSF_UTIL_PVT
TYPE - JTF_NUMBER_TABLE
SYNONYM - JTF_TERR_RSC_ALL
APPS.CSF_SELECTED_RESOURCES_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG
PACKAGE BODY - CSF_PLANBOARD_TASKS
PACKAGE BODY - CSF_TRIPS_PUB

[top of page]

View: CSF_SKILLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view of form block in CSFSKMGT(Skill Management) form. Corresponds to the CSF_SKILS_B and CSF_SKILLS_TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
SKILL_ID NUMBER (15) Y SKILL_ID
SKILL_TYPE_ID NUMBER (15) Y SKILL_TYPE_ID
NAME VARCHAR2 (30) Y Filter name
DESCRIPTION VARCHAR2 (240)
DESCRIPTION
SKILL_ALIAS VARCHAR2 (30)
SKILL_ALIAS
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
SEEDED_FLAG VARCHAR2 (1)
SEEDED_FLAG
OBJECT_VERSION_NUMBER NUMBER
Y object version number
CREATED_BY NUMBER (15) Y CREATED by
CREATION_DATE DATE
Y creation date
LAST_UPDATED_BY NUMBER (15) Y last updated by
LAST_UPDATE_DATE DATE
Y last updated date
LAST_UPDATE_LOGIN NUMBER (15)
last update login
ATTRIBUTE1 VARCHAR2 (150)
attr 1
ATTRIBUTE2 VARCHAR2 (150)
attr2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE 3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE cat

[top of page]

APPS.CSF_SKILLS_VL references the following:

APPS
SYNONYM - CSF_SKILLS_B
SYNONYM - CSF_SKILLS_TL

APPS.CSF_SKILLS_VL is not referenced by any database object

[top of page]

View: CSF_SKILL_LEVELS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view of form block in CSFSKMGT(Skill Management) form. Corresponds to the CSF_SKILL_LEVELS_B and CSF_SKILL_LEVELS_TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
SKILL_LEVEL_ID NUMBER (15) Y SKILL_ID
RATING_SCALE_ID NUMBER (15) Y RATING_SCALE_ID
NAME VARCHAR2 (30) Y Filter name
DESCRIPTION VARCHAR2 (240)
DESCRIPTION
STEP_VALUE NUMBER (15) Y STEP_VALUE
CORRECTION_FACTOR NUMBER

CORRECTION_FACTOR
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
SEEDED_FLAG VARCHAR2 (1)
SEEDED_FLAG
OBJECT_VERSION_NUMBER NUMBER
Y object version number
CREATED_BY NUMBER (15) Y CREATED by
CREATION_DATE DATE
Y creation date
LAST_UPDATED_BY NUMBER (15) Y last updated by
LAST_UPDATE_DATE DATE
Y last updated date
LAST_UPDATE_LOGIN NUMBER (15)
last update login
ATTRIBUTE1 VARCHAR2 (150)
attr 1
ATTRIBUTE2 VARCHAR2 (150)
attr2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE 3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE cat

[top of page]

APPS.CSF_SKILL_LEVELS_VL references the following:

APPS
SYNONYM - CSF_SKILL_LEVELS_B
SYNONYM - CSF_SKILL_LEVELS_TL
APPS.CSF_SKILL_LEVELS_VL is referenced by following:

APPS
VIEW - CSF_REQUIRED_SKILLS_V
VIEW - CSF_RESOURCE_SKILLS_V

[top of page]

View: CSF_SKILL_TYPES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Base view of form block in CSFSKMGT(Skill Management) form. Corresponds to the CSF_SKILL_TYPES_B and CSF_SKILL_TYPES_TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
SKILL_TYPE_ID NUMBER
Y SKILL_TYPE_ID
NAME VARCHAR2 (30) Y Filter name
DESCRIPTION VARCHAR2 (240)
DESCRIPTION
KEY_COLUMN VARCHAR2 (200)
KEY_COLUMN
DATA_COLUMN VARCHAR2 (2000)
DATA_COLUMN
NAME_NUMBER_COLUMNS VARCHAR2 (200)
NAME_NUMBER_COLUMNS
FROM_CLAUSE VARCHAR2 (2000)
FROM_CLAUSE
WHERE_CLAUSE VARCHAR2 (2000)
WHERE_CLAUSE
ORDER_BY_CLAUSE VARCHAR2 (200)
ORDER_BY_CLAUSE
START_DATE_ACTIVE DATE
Y START_DATE_ACTIVE
END_DATE_ACTIVE DATE

END_DATE_ACTIVE
RATING_SCALE_ID NUMBER (15) Y RATING_SCALE_ID
SEEDED_FLAG VARCHAR2 (1)
SEEDED_FLAG
OBJECT_VERSION_NUMBER NUMBER
Y object version number
CREATED_BY NUMBER (15) Y CREATED by
CREATION_DATE DATE
Y creation date
LAST_UPDATED_BY NUMBER (15) Y last updated by
LAST_UPDATE_DATE DATE
Y last updated date
LAST_UPDATE_LOGIN NUMBER (15)
last update login
ATTRIBUTE1 VARCHAR2 (150)
attr 1
ATTRIBUTE2 VARCHAR2 (150)
attr2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE 3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE cat

[top of page]

APPS.CSF_SKILL_TYPES_VL references the following:

APPS
SYNONYM - CSF_SKILL_TYPES_B
SYNONYM - CSF_SKILL_TYPES_TL
APPS.CSF_SKILL_TYPES_VL is referenced by following:

APPS
VIEW - CSF_REQUIRED_SKILLS_V
VIEW - CSF_RESOURCE_SKILLS_V

[top of page]

View: CSF_SR_HIST_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identification
INCIDENT_ID NUMBER (15) Y Incident Id
ORG_ID NUMBER

Organization Id
CREATION_DATE DATE
Y Service Request Creation Date
INCIDENT_NUMBER VARCHAR2 (64) Y Service Request Number
INCIDENT_NUMBER_N VARCHAR2 (64) Y Service Request Number
SUMMARY VARCHAR2 (240) Y Summary
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Id
INSTALL_SITE_USE_ID NUMBER (15)
Install Site Use Id
PROBLEM_CODE VARCHAR2 (50)
Problem Code
EXPECTED_RESOLUTION_DATE DATE

Expected Resolution Date
INCIDENT_DATE DATE

Incident Date
CUSTOMER_PRODUCT_ID NUMBER (15)
Customer Product Id
REFERENCE_NUMBER VARCHAR2 (30)
Reference Number
RESOLUTION_CODE VARCHAR2 (50)
Resolution Code
INCIDENT_TYPE VARCHAR2 (90)
Incident Type
SEVERITY VARCHAR2 (90)
Severity
STATUS_CODE VARCHAR2 (90)
Status Code
URGENCY VARCHAR2 (90)
Urgency
CUSTOMER_ID NUMBER (15)
Customer Id
EMPLOYEE_ID NUMBER (15)
Employee id
EMPLOYEE_NAME VARCHAR2 (0)
Employee Name
CONTRACT_SERVICE_ID NUMBER

Contract Service id
CUSTOMER_NUMBER VARCHAR2 (30) Y Customer Number
CALLER_TYPE VARCHAR2 (30) Y Caller Type
PRODUCT_NAME VARCHAR2 (40)
Product Name
PRODUCT_DESCRIPTION VARCHAR2 (240)
Product Description
OWNER VARCHAR2 (360)
Owner
COMPANY_NAME VARCHAR2 (360) Y Company Name
CONTACT_NAME VARCHAR2 (301)
Contact Name
PHONE VARCHAR2 (40)
Phone
EMAIL VARCHAR2 (2000)
Email Address
TIME_ZONE_NAME VARCHAR2 (50)
Time zone Name
COUNTRY VARCHAR2 (60)
Country
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
CONTACT_TYPE VARCHAR2 (30)
Contact Type
CONTACT_NUMBER VARCHAR2 (30)
Contact Number
GROUP_TYPE VARCHAR2 (30)
Group Type
TEXT_INDEX VARCHAR2 (1)
Text Index used for Text summary

[top of page]

APPS.CSF_SR_HIST_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_HZ_SR_CONTACT_POINTS
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_SEVERITIES_TL
SYNONYM - CS_INCIDENT_STATUSES_TL
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - CS_INCIDENT_URGENCIES_TL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_TIMEZONES
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.CSF_SR_HIST_V is not referenced by any database object

[top of page]

View: CSF_VALIDATE_TASKS_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TASK_ID NUMBER
Y
TASK_NUMBER VARCHAR2 (30) Y
CUST_ACCOUNT_ID NUMBER

CUSTOMER_ID NUMBER

ADDRESS_ID NUMBER

PARENT_TASK_ID NUMBER

SOURCE_OBJECT_ID NUMBER

SOURCE_OBJECT_NAME VARCHAR2 (80)
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
DURATION NUMBER

DURATION_UOM VARCHAR2 (3)
PLANNED_EFFORT NUMBER

PLANNED_EFFORT_UOM VARCHAR2 (3)
ACTUAL_EFFORT NUMBER

ACTUAL_EFFORT_UOM VARCHAR2 (3)
PLANNED_START_DATE DATE

PLANNED_END_DATE DATE

SCHEDULED_START_DATE DATE

SCHEDULED_END_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_END_DATE DATE

INCIDENT_ID NUMBER (15) Y
INCIDENT_NUMBER VARCHAR2 (64) Y
TASK_NAME VARCHAR2 (80) Y
TASK_STATUS VARCHAR2 (30) Y
TASK_TYPE VARCHAR2 (30) Y
TASK_PRIORITY VARCHAR2 (30)
TASK_DESCRIPTION VARCHAR2 (4000)
INCIDENT_CUSTOMER_NUMBER VARCHAR2 (30) Y
INCIDENT_CUSTOMER_NAME VARCHAR2 (360) Y
LOCATION_ID NUMBER (15) Y
ADDRESS_STYLE VARCHAR2 (30)
ADDRESS VARCHAR2 (488)
ADDRESS1 VARCHAR2 (240) Y
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
ADDRESS_KEY VARCHAR2 (500)
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
COUNTY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTRY VARCHAR2 (60) Y
VALIDATED_FLAG VARCHAR2 (1) Y
OVERRIDE_FLAG VARCHAR2 (1) Y
LOG_DETAIL_SHORT VARCHAR2 (500) Y
LOG_DETAIL_LONG VARCHAR2 (2000) Y
TIMEZONE_ID NUMBER

[top of page]

APPS.CSF_VALIDATE_TASKS_V references the following:

APPS
SYNONYM - CSF_EXT_LOCATIONS
PACKAGE - CSF_TASKS_PUB
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_B
SYNONYM - JTF_TASK_TYPES_TL
APPS.CSF_VALIDATE_TASKS_V is referenced by following:

APPS
PACKAGE BODY - CSF_TASK_ADDRESS_PVT

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract