Persons

The person view object contains personal and family information about a party of the Person type, including gender, marital status, academic title, previous last name, and so on. Some information in this view may also be stored in Party view object.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PersonExtractPVO

Primary Keys : PersonProfileId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
ActualContentSource The information regarding the source of the contact point.
Attribute1 A segment for the person descriptive flexfield.
Attribute10 A segment for the person descriptive flexfield.
Attribute11 A segment for the person descriptive flexfield.
Attribute12 A segment for the person descriptive flexfield.
Attribute13 A segment for the person descriptive flexfield.
Attribute14 A segment for the person descriptive flexfield.
Attribute15 A segment for the person descriptive flexfield.
Attribute16 A segment for the person descriptive flexfield.
Attribute17 A segment for the person descriptive flexfield.
Attribute18 A segment for the person descriptive flexfield.
Attribute19 A segment for the person descriptive flexfield.
Attribute2 A segment for the person descriptive flexfield.
Attribute20 A segment for the person descriptive flexfield.
Attribute21 A segment for the person descriptive flexfield.
Attribute22 A segment for the person descriptive flexfield.
Attribute23 A segment for the person descriptive flexfield.
Attribute24 A segment for the person descriptive flexfield.
Attribute25 A segment for the person descriptive flexfield.
Attribute26 A segment for the person descriptive flexfield.
Attribute27 A segment for the person descriptive flexfield.
Attribute28 A segment for the person descriptive flexfield.
Attribute29 A segment for the person descriptive flexfield.
Attribute3 A segment for the person descriptive flexfield.
Attribute30 A segment for the person descriptive flexfield.
Attribute4 A segment for the person descriptive flexfield.
Attribute5 A segment for the person descriptive flexfield.
Attribute6 A segment for the person descriptive flexfield.
Attribute7 A segment for the person descriptive flexfield.
Attribute8 A segment for the person descriptive flexfield.
Attribute9 A segment for the person descriptive flexfield.
AttributeCategory The context name for the person descriptive flexfield.
AttributeDate1 A date segment for the person descriptive flexfield.
AttributeDate10 A date segment for the person descriptive flexfield.
AttributeDate11 A date segment for the person descriptive flexfield.
AttributeDate12 A date segment for the person descriptive flexfield.
AttributeDate2 A date segment for the person descriptive flexfield.
AttributeDate3 A date segment for the person descriptive flexfield.
AttributeDate4 A date segment for the person descriptive flexfield.
AttributeDate5 A date segment for the person descriptive flexfield.
AttributeDate6 A date segment for the person descriptive flexfield.
AttributeDate7 A date segment for the person descriptive flexfield.
AttributeDate8 A date segment for the person descriptive flexfield.
AttributeDate9 A date segment for the person descriptive flexfield.
AttributeNumber1 A number segment for the person descriptive flexfield.
AttributeNumber10 A number segment for the person descriptive flexfield.
AttributeNumber11 A number segment for the person descriptive flexfield.
AttributeNumber12 A number segment for the person descriptive flexfield.
AttributeNumber2 A number segment for the person descriptive flexfield.
AttributeNumber3 A number segment for the person descriptive flexfield.
AttributeNumber4 A number segment for the person descriptive flexfield.
AttributeNumber5 A number segment for the person descriptive flexfield.
AttributeNumber6 A number segment for the person descriptive flexfield.
AttributeNumber7 A number segment for the person descriptive flexfield.
AttributeNumber8 A number segment for the person descriptive flexfield.
AttributeNumber9 A number segment for the person descriptive flexfield.
CertReasonCode The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type.
CertificationLevel The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type.
CleanlinessScore The overall score for the contact or account record for category Cleanliness.
Comments The comments entered by the user about the person.
CompletenessScore The overall score for the contact or account record for category Completeness.
ContactRole The name of the role of the contact.
CorpCurrencyCode The corporate currency code used by the CRM Extensibility framework. It's defaulted to the value set in the profile option ZCA_COMMON_CORPORATE_CURRENCY.
CreatedBy The user who created the record.
CreatedByModule The module through which the person record was created.
CreationDate The date and time of creating the record.
CurcyConvRateType The currency conversion rate type. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
CurrencyCode The currency code. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.
DataCloudStatus The enrichment status of the contact record from Data-as-a-Service. A list of valid values are defined in the lookup DATA_CLOUD_STATUS. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
DataConfidenceScore The overall data confidence score that indicates the level of data quality for a particular record.
DateOfBirth The date the person was born.
DateOfDeath The date the person died.
DeceasedFlag Indicates whether the person is deceased or not. If the value is True, then the person is deceased. The default value is False.
DeclaredEthnicity The declared ethnicity of the person.
Department The name the department of the contact.
DepartmentCode The code indicating the department of the contact. A list of accepted values is defined in the lookup DEPARTMENT_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
DoNotCallFlag Indicates whether the user can call the person or not. If the value is True, then the user must not call the person. The default value is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotContactFlag Indicates whether the user can contact the person or not by phone, e-mail, or mail. If the value is True, then the user must not contact the person. The default value is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotEmailFlag Indicates whether the user can e-mail the person or not. If the value is True, then the user must not contact the person by e-mail. The default value is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DoNotMailFlag Indicates whether the user can send mail to the person or not. If the value is True, then the user must not contact the person by mail. The default value is False. A list of accepted values is defined using the lookup YES_NO. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Common Lookups task.
DuplicateIndicator The duplicate status of the record in certain scenarios.
DuplicateScore The overall score for the contact or account record for category Duplicate.
EffectiveEndDate The date and time when the record becomes inactive.
EffectiveLatestChange Y indicates that this row represents the latest change in the day.
EffectiveSequence Indicates the order of different changes made during a day. The lowest value represents the earliest change in the day.
EffectiveStartDate The date and time when the row becomes active.
EnrichmentScore Overall score for the contact or account record for category Enrichment.
ExtnAttributeChar001 A column reserved for custom extension attributes of type string.
ExtnAttributeChar002 A column reserved for custom extension attributes of type string.
ExtnAttributeChar003 A column reserved for custom extension attributes of type string.
ExtnAttributeChar004 A column reserved for custom extension attributes of type string.
ExtnAttributeChar005 A column reserved for custom extension attributes of type string.
ExtnAttributeChar006 A column reserved for custom extension attributes of type string.
ExtnAttributeChar007 A column reserved for custom extension attributes of type string.
ExtnAttributeChar008 A column reserved for custom extension attributes of type string.
ExtnAttributeChar009 A column reserved for custom extension attributes of type string.
ExtnAttributeChar010 A column reserved for custom extension attributes of type string.
ExtnAttributeChar011 A column reserved for custom extension attributes of type string.
ExtnAttributeChar012 A column reserved for custom extension attributes of type string.
ExtnAttributeChar013 A column reserved for custom extension attributes of type string.
ExtnAttributeChar014 A column reserved for custom extension attributes of type string.
ExtnAttributeChar015 A column reserved for custom extension attributes of type string.
ExtnAttributeChar016 A column reserved for custom extension attributes of type string.
ExtnAttributeChar017 A column reserved for custom extension attributes of type string.
ExtnAttributeChar018 A column reserved for custom extension attributes of type string.
ExtnAttributeChar019 A column reserved for custom extension attributes of type string.
ExtnAttributeChar020 A column reserved for custom extension attributes of type string.
ExtnAttributeChar021 A column reserved for custom extension attributes of type string.
ExtnAttributeChar022 A column reserved for custom extension attributes of type string.
ExtnAttributeChar023 A column reserved for custom extension attributes of type string.
ExtnAttributeChar024 A column reserved for custom extension attributes of type string.
ExtnAttributeChar025 A column reserved for custom extension attributes of type string.
ExtnAttributeChar026 A column reserved for custom extension attributes of type string.
ExtnAttributeChar027 A column reserved for custom extension attributes of type string.
ExtnAttributeChar028 A column reserved for custom extension attributes of type string.
ExtnAttributeChar029 A column reserved for custom extension attributes of type string.
ExtnAttributeChar030 A column reserved for custom extension attributes of type string.
ExtnAttributeChar031 A column reserved for custom extension attributes of type string.
ExtnAttributeChar032 A column reserved for custom extension attributes of type string.
ExtnAttributeChar033 A column reserved for custom extension attributes of type string.
ExtnAttributeChar034 A column reserved for custom extension attributes of type string.
ExtnAttributeChar035 A column reserved for custom extension attributes of type string.
ExtnAttributeChar036 A column reserved for custom extension attributes of type string.
ExtnAttributeChar037 A column reserved for custom extension attributes of type string.
ExtnAttributeChar038 A column reserved for custom extension attributes of type string.
ExtnAttributeChar039 A column reserved for custom extension attributes of type string.
ExtnAttributeChar040 A column reserved for custom extension attributes of type string.
ExtnAttributeChar041 A column reserved for custom extension attributes of type string.
ExtnAttributeChar042 A column reserved for custom extension attributes of type string.
ExtnAttributeChar043 A column reserved for custom extension attributes of type string.
ExtnAttributeChar044 A column reserved for custom extension attributes of type string.
ExtnAttributeChar045 A column reserved for custom extension attributes of type string.
ExtnAttributeChar046 A column reserved for custom extension attributes of type string.
ExtnAttributeChar047 A column reserved for custom extension attributes of type string.
ExtnAttributeChar048 A column reserved for custom extension attributes of type string.
ExtnAttributeChar049 A column reserved for custom extension attributes of type string.
ExtnAttributeChar050 A column reserved for custom extension attributes of type string.
ExtnAttributeChar051 A column reserved for custom extension attributes of type string.
ExtnAttributeChar052 A column reserved for custom extension attributes of type string.
ExtnAttributeChar053 A column reserved for custom extension attributes of type string.
ExtnAttributeChar054 A column reserved for custom extension attributes of type string.
ExtnAttributeChar055 A column reserved for custom extension attributes of type string.
ExtnAttributeChar056 A column reserved for custom extension attributes of type string.
ExtnAttributeChar057 A column reserved for custom extension attributes of type string.
ExtnAttributeChar058 A column reserved for custom extension attributes of type string.
ExtnAttributeChar059 A column reserved for custom extension attributes of type string.
ExtnAttributeChar060 A column reserved for custom extension attributes of type string.
ExtnAttributeChar061 A column reserved for custom extension attributes of type string.
ExtnAttributeChar062 A column reserved for custom extension attributes of type string.
ExtnAttributeChar063 A column reserved for custom extension attributes of type string.
ExtnAttributeChar064 A column reserved for custom extension attributes of type string.
ExtnAttributeChar065 A column reserved for custom extension attributes of type string.
ExtnAttributeChar066 A column reserved for custom extension attributes of type string.
ExtnAttributeChar067 A column reserved for custom extension attributes of type string.
ExtnAttributeChar068 A column reserved for custom extension attributes of type string.
ExtnAttributeChar069 A column reserved for custom extension attributes of type string.
ExtnAttributeChar070 A column reserved for custom extension attributes of type string.
ExtnAttributeChar071 A column reserved for custom extension attributes of type string.
ExtnAttributeChar072 A column reserved for custom extension attributes of type string.
ExtnAttributeChar073 A column reserved for custom extension attributes of type string.
ExtnAttributeChar074 A column reserved for custom extension attributes of type string.
ExtnAttributeChar075 A column reserved for custom extension attributes of type string.
ExtnAttributeChar076 A column reserved for custom extension attributes of type string.
ExtnAttributeChar077 A column reserved for custom extension attributes of type string.
ExtnAttributeChar078 A column reserved for custom extension attributes of type string.
ExtnAttributeChar079 A column reserved for custom extension attributes of type string.
ExtnAttributeChar080 A column reserved for custom extension attributes of type string.
ExtnAttributeChar081 A column reserved for custom extension attributes of type string.
ExtnAttributeChar082 A column reserved for custom extension attributes of type string.
ExtnAttributeChar083 A column reserved for custom extension attributes of type string.
ExtnAttributeChar084 A column reserved for custom extension attributes of type string.
ExtnAttributeChar085 A column reserved for custom extension attributes of type string.
ExtnAttributeChar086 A column reserved for custom extension attributes of type string.
ExtnAttributeChar087 A column reserved for custom extension attributes of type string.
ExtnAttributeChar088 A column reserved for custom extension attributes of type string.
ExtnAttributeChar089 A column reserved for custom extension attributes of type string.
ExtnAttributeChar090 A column reserved for custom extension attributes of type string.
ExtnAttributeChar091 A column reserved for custom extension attributes of type string.
ExtnAttributeChar092 A column reserved for custom extension attributes of type string.
ExtnAttributeChar093 A column reserved for custom extension attributes of type string.
ExtnAttributeChar094 A column reserved for custom extension attributes of type string.
ExtnAttributeChar095 A column reserved for custom extension attributes of type string.
ExtnAttributeChar096 A column reserved for custom extension attributes of type string.
ExtnAttributeChar097 A column reserved for custom extension attributes of type string.
ExtnAttributeChar098 A column reserved for custom extension attributes of type string.
ExtnAttributeChar099 A column reserved for custom extension attributes of type string.
ExtnAttributeChar100 A column reserved for custom extension attributes of type string.
ExtnAttributeChar101 A column reserved for custom extension attributes of type string.
ExtnAttributeChar102 A column reserved for custom extension attributes of type string.
ExtnAttributeChar103 A column reserved for custom extension attributes of type string.
ExtnAttributeChar104 A column reserved for custom extension attributes of type string.
ExtnAttributeChar105 A column reserved for custom extension attributes of type string.
ExtnAttributeChar106 A column reserved for custom extension attributes of type string.
ExtnAttributeChar107 A column reserved for custom extension attributes of type string.
ExtnAttributeChar108 A column reserved for custom extension attributes of type string.
ExtnAttributeChar109 A column reserved for custom extension attributes of type string.
ExtnAttributeChar110 A column reserved for custom extension attributes of type string.
ExtnAttributeChar111 A column reserved for custom extension attributes of type string.
ExtnAttributeChar112 A column reserved for custom extension attributes of type string.
ExtnAttributeChar113 A column reserved for custom extension attributes of type string.
ExtnAttributeChar114 A column reserved for custom extension attributes of type string.
ExtnAttributeChar115 A column reserved for custom extension attributes of type string.
ExtnAttributeChar116 A column reserved for custom extension attributes of type string.
ExtnAttributeChar117 A column reserved for custom extension attributes of type string.
ExtnAttributeChar118 A column reserved for custom extension attributes of type string.
ExtnAttributeChar119 A column reserved for custom extension attributes of type string.
ExtnAttributeChar120 A column reserved for custom extension attributes of type string.
ExtnAttributeChar121 A column reserved for custom extension attributes of type string.
ExtnAttributeChar122 A column reserved for custom extension attributes of type string.
ExtnAttributeChar123 A column reserved for custom extension attributes of type string.
ExtnAttributeChar124 A column reserved for custom extension attributes of type string.
ExtnAttributeChar125 A column reserved for custom extension attributes of type string.
ExtnAttributeChar126 A column reserved for custom extension attributes of type string.
ExtnAttributeChar127 A column reserved for custom extension attributes of type string.
ExtnAttributeChar128 A column reserved for custom extension attributes of type string.
ExtnAttributeChar129 A column reserved for custom extension attributes of type string.
ExtnAttributeChar130 A column reserved for custom extension attributes of type string.
ExtnAttributeChar131 A column reserved for custom extension attributes of type string.
ExtnAttributeChar132 A column reserved for custom extension attributes of type string.
ExtnAttributeChar133 A column reserved for custom extension attributes of type string.
ExtnAttributeChar134 A column reserved for custom extension attributes of type string.
ExtnAttributeChar135 A column reserved for custom extension attributes of type string.
ExtnAttributeChar136 A column reserved for custom extension attributes of type string.
ExtnAttributeChar137 A column reserved for custom extension attributes of type string.
ExtnAttributeChar138 A column reserved for custom extension attributes of type string.
ExtnAttributeChar139 A column reserved for custom extension attributes of type string.
ExtnAttributeChar140 A column reserved for custom extension attributes of type string.
ExtnAttributeChar141 A column reserved for custom extension attributes of type string.
ExtnAttributeChar142 A column reserved for custom extension attributes of type string.
ExtnAttributeChar143 A column reserved for custom extension attributes of type string.
ExtnAttributeChar144 A column reserved for custom extension attributes of type string.
ExtnAttributeChar145 A column reserved for custom extension attributes of type string.
ExtnAttributeChar146 A column reserved for custom extension attributes of type string.
ExtnAttributeChar147 A column reserved for custom extension attributes of type string.
ExtnAttributeChar148 A column reserved for custom extension attributes of type string.
ExtnAttributeChar149 A column reserved for custom extension attributes of type string.
ExtnAttributeChar150 A column reserved for custom extension attributes of type string.
ExtnAttributeChar151 A column reserved for custom extension attributes of type string.
ExtnAttributeChar152 A column reserved for custom extension attributes of type string.
ExtnAttributeChar153 A column reserved for custom extension attributes of type string.
ExtnAttributeChar154 A column reserved for custom extension attributes of type string.
ExtnAttributeChar155 A column reserved for custom extension attributes of type string.
ExtnAttributeChar156 A column reserved for custom extension attributes of type string.
ExtnAttributeChar157 A column reserved for custom extension attributes of type string.
ExtnAttributeChar158 A column reserved for custom extension attributes of type string.
ExtnAttributeChar159 A column reserved for custom extension attributes of type string.
ExtnAttributeChar160 A column reserved for custom extension attributes of type string.
ExtnAttributeChar161 A column reserved for custom extension attributes of type string.
ExtnAttributeChar162 A column reserved for custom extension attributes of type string.
ExtnAttributeChar163 A column reserved for custom extension attributes of type string.
ExtnAttributeChar164 A column reserved for custom extension attributes of type string.
ExtnAttributeChar165 A column reserved for custom extension attributes of type string.
ExtnAttributeChar166 A column reserved for custom extension attributes of type string.
ExtnAttributeChar167 A column reserved for custom extension attributes of type string.
ExtnAttributeChar168 A column reserved for custom extension attributes of type string.
ExtnAttributeChar169 A column reserved for custom extension attributes of type string.
ExtnAttributeChar170 A column reserved for custom extension attributes of type string.
ExtnAttributeChar171 A column reserved for custom extension attributes of type string.
ExtnAttributeChar172 A column reserved for custom extension attributes of type string.
ExtnAttributeChar173 A column reserved for custom extension attributes of type string.
ExtnAttributeChar174 A column reserved for custom extension attributes of type string.
ExtnAttributeChar175 A column reserved for custom extension attributes of type string.
ExtnAttributeChar176 A column reserved for custom extension attributes of type string.
ExtnAttributeChar177 A column reserved for custom extension attributes of type string.
ExtnAttributeChar178 A column reserved for custom extension attributes of type string.
ExtnAttributeChar179 A column reserved for custom extension attributes of type string.
ExtnAttributeChar180 A column reserved for custom extension attributes of type string.
ExtnAttributeChar181 A column reserved for custom extension attributes of type string.
ExtnAttributeChar182 A column reserved for custom extension attributes of type string.
ExtnAttributeChar183 A column reserved for custom extension attributes of type string.
ExtnAttributeChar184 A column reserved for custom extension attributes of type string.
ExtnAttributeChar185 A column reserved for custom extension attributes of type string.
ExtnAttributeChar186 A column reserved for custom extension attributes of type string.
ExtnAttributeChar187 A column reserved for custom extension attributes of type string.
ExtnAttributeChar188 A column reserved for custom extension attributes of type string.
ExtnAttributeChar189 A column reserved for custom extension attributes of type string.
ExtnAttributeChar190 A column reserved for custom extension attributes of type string.
ExtnAttributeChar191 A column reserved for custom extension attributes of type string.
ExtnAttributeChar192 A column reserved for custom extension attributes of type string.
ExtnAttributeChar193 A column reserved for custom extension attributes of type string.
ExtnAttributeChar194 A column reserved for custom extension attributes of type string.
ExtnAttributeChar195 A column reserved for custom extension attributes of type string.
ExtnAttributeChar196 A column reserved for custom extension attributes of type string.
ExtnAttributeChar197 A column reserved for custom extension attributes of type string.
ExtnAttributeChar198 A column reserved for custom extension attributes of type string.
ExtnAttributeChar199 A column reserved for custom extension attributes of type string.
ExtnAttributeChar200 A column reserved for custom extension attributes of type string.
ExtnAttributeChar201 A column reserved for custom extension attributes of type string.
ExtnAttributeChar202 A column reserved for custom extension attributes of type string.
ExtnAttributeChar203 A column reserved for custom extension attributes of type string.
ExtnAttributeChar204 A column reserved for custom extension attributes of type string.
ExtnAttributeChar205 A column reserved for custom extension attributes of type string.
ExtnAttributeChar206 A column reserved for custom extension attributes of type string.
ExtnAttributeChar207 A column reserved for custom extension attributes of type string.
ExtnAttributeChar208 A column reserved for custom extension attributes of type string.
ExtnAttributeChar209 A column reserved for custom extension attributes of type string.
ExtnAttributeChar210 A column reserved for custom extension attributes of type string.
ExtnAttributeChar211 A column reserved for custom extension attributes of type string.
ExtnAttributeChar212 A column reserved for custom extension attributes of type string.
ExtnAttributeChar213 A column reserved for custom extension attributes of type string.
ExtnAttributeChar214 A column reserved for custom extension attributes of type string.
ExtnAttributeChar215 A column reserved for custom extension attributes of type string.
ExtnAttributeChar216 A column reserved for custom extension attributes of type string.
ExtnAttributeChar217 A column reserved for custom extension attributes of type string.
ExtnAttributeChar218 A column reserved for custom extension attributes of type string.
ExtnAttributeChar219 A column reserved for custom extension attributes of type string.
ExtnAttributeChar220 A column reserved for custom extension attributes of type string.
ExtnAttributeChar221 A column reserved for custom extension attributes of type string.
ExtnAttributeChar222 A column reserved for custom extension attributes of type string.
ExtnAttributeChar223 A column reserved for custom extension attributes of type string.
ExtnAttributeChar224 A column reserved for custom extension attributes of type string.
ExtnAttributeChar225 A column reserved for custom extension attributes of type string.
ExtnAttributeChar226 A column reserved for custom extension attributes of type string.
ExtnAttributeChar227 A column reserved for custom extension attributes of type string.
ExtnAttributeChar228 A column reserved for custom extension attributes of type string.
ExtnAttributeChar229 A column reserved for custom extension attributes of type string.
ExtnAttributeChar230 A column reserved for custom extension attributes of type string.
ExtnAttributeChar231 A column reserved for custom extension attributes of type string.
ExtnAttributeChar232 A column reserved for custom extension attributes of type string.
ExtnAttributeChar233 A column reserved for custom extension attributes of type string.
ExtnAttributeChar234 A column reserved for custom extension attributes of type string.
ExtnAttributeChar235 A column reserved for custom extension attributes of type string.
ExtnAttributeChar236 A column reserved for custom extension attributes of type string.
ExtnAttributeChar237 A column reserved for custom extension attributes of type string.
ExtnAttributeChar238 A column reserved for custom extension attributes of type string.
ExtnAttributeChar239 A column reserved for custom extension attributes of type string.
ExtnAttributeChar240 A column reserved for custom extension attributes of type string.
ExtnAttributeChar241 A column reserved for custom extension attributes of type string.
ExtnAttributeChar242 A column reserved for custom extension attributes of type string.
ExtnAttributeChar243 A column reserved for custom extension attributes of type string.
ExtnAttributeChar244 A column reserved for custom extension attributes of type string.
ExtnAttributeChar245 A column reserved for custom extension attributes of type string.
ExtnAttributeChar246 A column reserved for custom extension attributes of type string.
ExtnAttributeChar247 A column reserved for custom extension attributes of type string.
ExtnAttributeChar248 A column reserved for custom extension attributes of type string.
ExtnAttributeChar249 A column reserved for custom extension attributes of type string.
ExtnAttributeChar250 A column reserved for custom extension attributes of type string.
ExtnAttributeChar251 A column reserved for custom extension attributes of type string.
ExtnAttributeChar252 A column reserved for custom extension attributes of type string.
ExtnAttributeChar253 A column reserved for custom extension attributes of type string.
ExtnAttributeChar254 A column reserved for custom extension attributes of type string.
ExtnAttributeChar255 A column reserved for custom extension attributes of type string.
ExtnAttributeChar256 A column reserved for custom extension attributes of type string.
ExtnAttributeChar257 A column reserved for custom extension attributes of type string.
ExtnAttributeChar258 A column reserved for custom extension attributes of type string.
ExtnAttributeChar259 A column reserved for custom extension attributes of type string.
ExtnAttributeChar260 A column reserved for custom extension attributes of type string.
ExtnAttributeChar261 A column reserved for custom extension attributes of type string.
ExtnAttributeChar262 A column reserved for custom extension attributes of type string.
ExtnAttributeChar263 A column reserved for custom extension attributes of type string.
ExtnAttributeChar264 A column reserved for custom extension attributes of type string.
ExtnAttributeChar265 A column reserved for custom extension attributes of type string.
ExtnAttributeChar266 A column reserved for custom extension attributes of type string.
ExtnAttributeChar267 A column reserved for custom extension attributes of type string.
ExtnAttributeChar268 A column reserved for custom extension attributes of type string.
ExtnAttributeChar269 A column reserved for custom extension attributes of type string.
ExtnAttributeChar270 A column reserved for custom extension attributes of type string.
ExtnAttributeChar271 A column reserved for custom extension attributes of type string.
ExtnAttributeChar272 A column reserved for custom extension attributes of type string.
ExtnAttributeChar273 A column reserved for custom extension attributes of type string.
ExtnAttributeChar274 A column reserved for custom extension attributes of type string.
ExtnAttributeChar275 A column reserved for custom extension attributes of type string.
ExtnAttributeChar276 A column reserved for custom extension attributes of type string.
ExtnAttributeChar277 A column reserved for custom extension attributes of type string.
ExtnAttributeChar278 A column reserved for custom extension attributes of type string.
ExtnAttributeChar279 A column reserved for custom extension attributes of type string.
ExtnAttributeChar280 A column reserved for custom extension attributes of type string.
ExtnAttributeChar281 A column reserved for custom extension attributes of type string.
ExtnAttributeChar282 A column reserved for custom extension attributes of type string.
ExtnAttributeChar283 A column reserved for custom extension attributes of type string.
ExtnAttributeChar284 A column reserved for custom extension attributes of type string.
ExtnAttributeChar285 A column reserved for custom extension attributes of type string.
ExtnAttributeChar286 A column reserved for custom extension attributes of type string.
ExtnAttributeChar287 A column reserved for custom extension attributes of type string.
ExtnAttributeChar288 A column reserved for custom extension attributes of type string.
ExtnAttributeChar289 A column reserved for custom extension attributes of type string.
ExtnAttributeChar290 A column reserved for custom extension attributes of type string.
ExtnAttributeChar291 A column reserved for custom extension attributes of type string.
ExtnAttributeChar292 A column reserved for custom extension attributes of type string.
ExtnAttributeChar293 A column reserved for custom extension attributes of type string.
ExtnAttributeChar294 A column reserved for custom extension attributes of type string.
ExtnAttributeChar295 A column reserved for custom extension attributes of type string.
ExtnAttributeChar296 A column reserved for custom extension attributes of type string.
ExtnAttributeChar297 A column reserved for custom extension attributes of type string.
ExtnAttributeChar298 A column reserved for custom extension attributes of type string.
ExtnAttributeChar299 A column reserved for custom extension attributes of type string.
ExtnAttributeChar300 A column reserved for custom extension attributes of type string.
ExtnAttributeChar301 A column reserved for custom extension attributes of type string.
ExtnAttributeChar302 A column reserved for custom extension attributes of type string.
ExtnAttributeChar303 A column reserved for custom extension attributes of type string.
ExtnAttributeChar304 A column reserved for custom extension attributes of type string.
ExtnAttributeChar305 A column reserved for custom extension attributes of type string.
ExtnAttributeChar306 A column reserved for custom extension attributes of type string.
ExtnAttributeChar307 A column reserved for custom extension attributes of type string.
ExtnAttributeChar308 A column reserved for custom extension attributes of type string.
ExtnAttributeChar309 A column reserved for custom extension attributes of type string.
ExtnAttributeChar310 A column reserved for custom extension attributes of type string.
ExtnAttributeChar311 A column reserved for custom extension attributes of type string.
ExtnAttributeChar312 A column reserved for custom extension attributes of type string.
ExtnAttributeChar313 A column reserved for custom extension attributes of type string.
ExtnAttributeChar314 A column reserved for custom extension attributes of type string.
ExtnAttributeChar315 A column reserved for custom extension attributes of type string.
ExtnAttributeChar316 A column reserved for custom extension attributes of type string.
ExtnAttributeChar317 A column reserved for custom extension attributes of type string.
ExtnAttributeChar318 A column reserved for custom extension attributes of type string.
ExtnAttributeChar319 A column reserved for custom extension attributes of type string.
ExtnAttributeChar320 A column reserved for custom extension attributes of type string.
ExtnAttributeChar321 A column reserved for custom extension attributes of type string.
ExtnAttributeChar322 A column reserved for custom extension attributes of type string.
ExtnAttributeChar323 A column reserved for custom extension attributes of type string.
ExtnAttributeChar324 A column reserved for custom extension attributes of type string.
ExtnAttributeChar325 A column reserved for custom extension attributes of type string.
ExtnAttributeChar326 A column reserved for custom extension attributes of type string.
ExtnAttributeChar327 A column reserved for custom extension attributes of type string.
ExtnAttributeChar328 A column reserved for custom extension attributes of type string.
ExtnAttributeChar329 A column reserved for custom extension attributes of type string.
ExtnAttributeChar330 A column reserved for custom extension attributes of type string.
ExtnAttributeChar331 A column reserved for custom extension attributes of type string.
ExtnAttributeChar332 A column reserved for custom extension attributes of type string.
ExtnAttributeChar333 A column reserved for custom extension attributes of type string.
ExtnAttributeChar334 A column reserved for custom extension attributes of type string.
ExtnAttributeChar335 A column reserved for custom extension attributes of type string.
ExtnAttributeChar336 A column reserved for custom extension attributes of type string.
ExtnAttributeChar337 A column reserved for custom extension attributes of type string.
ExtnAttributeChar338 A column reserved for custom extension attributes of type string.
ExtnAttributeChar339 A column reserved for custom extension attributes of type string.
ExtnAttributeChar340 A column reserved for custom extension attributes of type string.
ExtnAttributeChar341 A column reserved for custom extension attributes of type string.
ExtnAttributeChar342 A column reserved for custom extension attributes of type string.
ExtnAttributeChar343 A column reserved for custom extension attributes of type string.
ExtnAttributeChar344 A column reserved for custom extension attributes of type string.
ExtnAttributeChar345 A column reserved for custom extension attributes of type string.
ExtnAttributeChar346 A column reserved for custom extension attributes of type string.
ExtnAttributeChar347 A column reserved for custom extension attributes of type string.
ExtnAttributeChar348 A column reserved for custom extension attributes of type string.
ExtnAttributeChar349 A column reserved for custom extension attributes of type string.
ExtnAttributeChar350 A column reserved for custom extension attributes of type string.
ExtnAttributeClob001 A column reserved for custom extension attributes of type string.
ExtnAttributeClob002 A column reserved for custom extension attributes of type string.
ExtnAttributeClob003 A column reserved for custom extension attributes of type string.
ExtnAttributeClob004 A column reserved for custom extension attributes of type string.
ExtnAttributeClob005 A column reserved for custom extension attributes of type string.
ExtnAttributeClob006 A column reserved for custom extension attributes of type string.
ExtnAttributeClob007 A column reserved for custom extension attributes of type string.
ExtnAttributeClob008 A column reserved for custom extension attributes of type string.
ExtnAttributeClob009 A column reserved for custom extension attributes of type string.
ExtnAttributeClob010 A column reserved for custom extension attributes of type string.
ExtnAttributeClob011 A column reserved for custom extension attributes of type string.
ExtnAttributeClob012 A column reserved for custom extension attributes of type string.
ExtnAttributeClob013 A column reserved for custom extension attributes of type string.
ExtnAttributeClob014 A column reserved for custom extension attributes of type string.
ExtnAttributeClob015 A column reserved for custom extension attributes of type string.
ExtnAttributeClob016 A column reserved for custom extension attributes of type string.
ExtnAttributeClob017 A column reserved for custom extension attributes of type string.
ExtnAttributeClob018 A column reserved for custom extension attributes of type string.
ExtnAttributeClob019 A column reserved for custom extension attributes of type string.
ExtnAttributeClob020 A column reserved for custom extension attributes of type string.
ExtnAttributeClob021 A column reserved for custom extension attributes of type string.
ExtnAttributeClob022 A column reserved for custom extension attributes of type string.
ExtnAttributeClob023 A column reserved for custom extension attributes of type string.
ExtnAttributeClob024 A column reserved for custom extension attributes of type string.
ExtnAttributeClob025 A column reserved for custom extension attributes of type string.
ExtnAttributeNumber001 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber002 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber003 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber004 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber005 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber006 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber007 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber008 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber009 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber010 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber011 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber012 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber013 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber014 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber015 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber016 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber017 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber018 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber019 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber020 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber021 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber022 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber023 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber024 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber025 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber026 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber027 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber028 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber029 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber030 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber031 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber032 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber033 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber034 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber035 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber036 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber037 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber038 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber039 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber040 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber041 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber042 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber043 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber044 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber045 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber046 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber047 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber048 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber049 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber050 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber051 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber052 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber053 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber054 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber055 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber056 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber057 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber058 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber059 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber060 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber061 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber062 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber063 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber064 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber065 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber066 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber067 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber068 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber069 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber070 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber071 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber072 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber073 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber074 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber075 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber076 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber077 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber078 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber079 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber080 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber081 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber082 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber083 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber084 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber085 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber086 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber087 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber088 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber089 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber090 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber091 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber092 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber093 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber094 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber095 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber096 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber097 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber098 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber099 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber100 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber101 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber102 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber103 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber104 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber105 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber106 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber107 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber108 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber109 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber110 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber111 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber112 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber113 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber114 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber115 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber116 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber117 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber118 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber119 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber120 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber121 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber122 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber123 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber124 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber125 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber126 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber127 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber128 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber129 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber130 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber131 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber132 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber133 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber134 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber135 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber136 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber137 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber138 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber139 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber140 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber141 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber142 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber143 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber144 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber145 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber146 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber147 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber148 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber149 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber150 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber151 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber152 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber153 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber154 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber155 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber156 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber157 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber158 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber159 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber160 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber161 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber162 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber163 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber164 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber165 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber166 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber167 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber168 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber169 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber170 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber171 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber172 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber173 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber174 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber175 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber176 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber177 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber178 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber179 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber180 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber181 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber182 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber183 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber184 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber185 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber186 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber187 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber188 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber189 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber190 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber191 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber192 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber193 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber194 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber195 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber196 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber197 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber198 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber199 A column reserved for custom extension attributes of type number.
ExtnAttributeNumber200 A column reserved for custom extension attributes of type number.
ExtnAttributeTimestamp001 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp002 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp003 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp004 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp005 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp006 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp007 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp008 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp009 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp010 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp011 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp012 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp013 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp014 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp015 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp016 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp017 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp018 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp019 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp020 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp021 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp022 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp023 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp024 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp025 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp026 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp027 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp028 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp029 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp030 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp031 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp032 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp033 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp034 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp035 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp036 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp037 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp038 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp039 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp040 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp041 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp042 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp043 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp044 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp045 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp046 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp047 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp048 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp049 A column reserved for custom extension attributes of type timestamp.
ExtnAttributeTimestamp050 A column reserved for custom extension attributes of type timestamp.
Gender The gender of the person, such as male, female, and unknown. A list of accepted values is defined in the lookup HZ_GENDER. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
HeadOfHouseholdFlag Indicates if the person is the head of the household. If the value is True, then the person is the head of the household. The default value is False.
HouseholdIncome The income of the household that this person is a part of.
HouseholdSize The size of the household this person is a part of.
InternalFlag Y or N which indicates whether the person is internal or external to the user's organization or not.
JgzzFiscalCode Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe.
JobTitle The job title of the person.
JobTitleCode The code indicating the job title of the person, for example, Analyst.
LastAssignedDate Date on which the Sales Profile Territory Assignment was last run by Assignment Manager.
LastContactDate The date when the person was last contacted.
LastEnrichmentDate The date when the record was last enriched.
LastKnownGps The geophysical location (GPS point) that was last reported for the person.
LastScoreUpdateDate Indicates when the last data confidence score on this record was computed.
LastSourceUpdateDate The timestamp when this record was updated by the source system in the last update source system column.
LastUpdateDate The date and time of last update of the record.
LastUpdateLogin The login of the user who last updated the record.
LastUpdateSourceSystem The Source System that last updated this record.
LastUpdatedBy The user who last updated the record.
MaritalStatus The marital status of the person. A list of accepted values is defined in the lookup MARITAL_STATUS. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Standard Lookups task.
MaritalStatusEffectiveDate The date when the person's marital status changed.
NamedFlag The flag indicating if this is a named account.
OwnerPartyId The PARTY_ID of the resource designated as the owner of the Sales Profile. Foreign key to the party view object.
PartyId The unique identifier of the person.
PartyNumber The unique alternate identifier for the person party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number. Inactive records can't be updated.
PersonAcademicTitle Academic title that's part of the person's name such as Dr. Jane Smith
PersonFirstName The first name of the person
PersonInitials The initials of the person's name.
PersonLastName The last or surname of the person
PersonLastNamePrefix The prefix for the last name of a person, such as Fon, or Van. For example, if a person's name is Hans Van, the last name of the person is captured using this attribute.
PersonMiddleName The middle name of the person.
PersonName The combination of title, first, middle, last, and suffix names.
PersonNameSuffix Indicates the place in a family structure. For example, in Tom Jones III, the III.
PersonPreNameAdjunct The salutary introduction such as Mr., Herr, and so on.
PersonPreviousLastName The previous last or surname of the person
PersonProfileId The unique identifier for the person's profile.
PersonSecondLastName The second last name for a person. In some cultures it isn't uncommon to have double last name. It's used in the same way the new field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used.
PersonTitle A professional or family title. Such as Don or The Right Honorable.
PersonalIncome The estimated gross annual income of the person.
PlaceOfBirth Place where the person was born. Typically, the city and country.
PrefFunctionalCurrency The code indicating the person's default currency. A list of valid currency codes are defined during the application setup.
PreferredContactMethod The preferred contact method of the person. The accepted values are defined in the lookup type HZ_PREFERRED_CONTACT_METHOD. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
PreferredContactPersonId The person PARTY_ID of a preferred contact for a given party. There should be a valid relationship.
PrimaryCustomerId The party identifier of a primary customer for a given person. There should be a valid relationship between the person and a customer.
PrimaryCustomerRelationshipId Identifier of the primary customer relationship.
RecencyScore The overall score for the contact or account record for category Recency.
RegistrationStatus The code indicating the registration status of the person. For example, Approved, Pending, or Rejected. The valid list of values is defined in the lookup ORA_CONTACT_REG_STATUS.
RentOwnInd Indicates if this contact owns or rents his or her residence. A list of valid values for rent, own, and lease are defined in the lookup OWN_RENT_IND. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task.
SalesAffinityCode The code indicating the affinity of a contact to the deploying organization. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesBuyingRoleCode The code indicating the roles played by a contact in the buying process, for example, decision maker or supporting role. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task.
SalesProfileStatus The status of a sales profile. Value can be ACTIVE or INACTIVE.
SalesProfileType The type of a sales profile. Value can be ZCA_CUSTOMER, ZCA_PROSPECT, ZCA_CONTACT and custom account type defined by the user.
Salutation The phrase used to address a contact party in any correspondence.
Status The status of the person. This is an internally-used column and the values are defined in the lookup HZ_STATUS. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.
SuffixOverriddenFlag This attribute will have Y if the suffix is overridden by user and N if not. Default value is N.
UniqueNameSuffix The suffix used to generate the attribute PartyUniqueName. The suffix is concatenated to the PersonName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.
ValidityScore The overall score for the contact or account record for category Validity.