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    

Copyright © 2019, 2024, Oracle and/or its affiliates.