DW_CXSR_COVERAGE_HEADERS_D

Dimension table for Coverage header

Details

Module: Service Request Management

Key Columns

COVERAGE_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
COVERAGE_HEADER_ID NUMBER 38 0 True Primary key column of the table
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated Unique Identifier
COVERAGE_HEADER_PUID VARCHAR2 128 System generated PUID for coverage header
STANDARD_COVERAGE_YN VARCHAR2 16 This column indicates whether the coverage header is standard or custom.
START_DATE DATE Start date of the coverage
END_DATE DATE End Date of the coverage
WARRANTY_YN VARCHAR2 16 Flag to identify whether it is a warranty or service template. Y - Warranty Template N - Service Template
TRANSFER_OPTION VARCHAR2 32 Transfer option code to determine action to be taken for service contract during transfer of item instance in Installed Base
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row
COVERAGE_NAME VARCHAR2 256 Template Name
COVERAGE_DESCRIPTION VARCHAR2 999 Template Description
CORP_CURRENCY_CODE VARCHAR2 16 CorpCurrencyCode
CURCY_CONV_RATE_TYPE VARCHAR2 32 CurcyConvRateType
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row