Oracle Customer Hub (UCM) Master Data Management Reference > Schema Changes for Oracle Customer Hub (UCM) Version 8.2 > Modified Tables for Oracle Customer Hub (UCM) Version 8.2 >

S_UCM_CONTACT Table


Table 426 shows details of the S_UCM_CONTACT table.

Table 426. S_UCM_CONTACT table
Column Name
Data Type
Comments

MARITAL_STAT_DT

Date

Date marital status was changed.

DEATH_DT

Date

Date of constituent's death.

CLASS_YEAR

Number

Current projected graduation year or latest graduation year for alumni.

PLACE_OF_DEATH

Varchar

Place of constituent's death.

DEATH_CERT_NUM

Varchar

Death certificate number

VETERAN_FLG

Character

Required. Veteran benefits designation. Indicates whether a person is eligible for veteran's benefits or is a veteran.

ETHNICITY_CD

Varchar

Ethnicity code.

TRANSACTION_ID

Varchar

Transaction ID.

PR_COUNTRY

Varchar

Primary country of contact.

PRIM_STATE_CD

Varchar

Primary state of contact.

IMPORT_TASK_NUM

Varchar

Task number of the import operation.

IMPORT_TASK_ID

Varchar

Task ID of the import operation.

IMP_TASK_BATCH_NUM

Varchar

Batch number of the import operation.

VALID_FLG

Character

Indicates whether the record is valid.

IMP_BAT_UNIQUE_REF

Varchar

Unique reference number of batch import operation.

OPERATION_CD

Varchar

Operation code.

ERROR_CODE

Varchar

Error code.

ERROR_MSG_TEXT

Varchar

Text of any error messages generated.

Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.