Person
Overview
The Person Managed Object in ORMB represents an individual customer or contact and is the main entity for managing customer-related data. It stores identification details, contact information, demographic data, and role associations such as account holder, billing contact, or authorized representative. Person MO links to accounts, service instances, payment profiles, and billing preferences, enabling a complete view of customer relationships and interactions. It supports customer lifecycle management by tracking status, managing communication preferences, and maintaining accurate records. Integration points allow synchronization with CRM systems, external databases, and multi-channel communication platforms
Conforming Layers
The Payment subject area has the following conforming layers:
PER_ADDR_SEAS_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| PER_ID | Unique identifier for the person record. | VARCHAR | 14 |
| SEQ_NUM | Unique sequence number for multiple addresses of the same person. | DECIMAL(5,0) | (5,0) |
| ADDRESS1 | Primary address line, usually containing street and house number. | VARCHAR | 356 |
| ADDRESS2 | Additional address details like apartment, suite, or floor number. | VARCHAR | 356 |
| ADDRESS3 | Placeholder for extended address formats, often used in certain regions. | VARCHAR | 356 |
| ADDRESS4 | Placeholder for more complex address formats. | VARCHAR | 356 |
| CITY | City of the address. | VARCHAR | 126 |
| NUM1 | First numeric identifier of the address. | VARCHAR | 9 |
| NUM2 | Second numeric identifier of the address. | VARCHAR | 6 |
| COUNTY | County or regional division of the address. | VARCHAR | 126 |
| POSTAL | Postal or ZIP code of the address. | VARCHAR | 17 |
| HOUSE_TYPE | Type of housing. | VARCHAR | 3 |
| GEO_CODE | Geographic code of the address. | VARCHAR | 16 |
| IN_CITY_LIMIT | Indicator whether the address lies within city limits. | VARCHAR | 2 |
| STATE | State or province part of the address. | VARCHAR | 9 |
| COUNTRY | Country code of the address. | VARCHAR | 5 |
| SEASON_START_MMDD | Start date when the seasonal address becomes valid. | VARCHAR | 6 |
| SEASON_END_MMDD | End date when the seasonal address is no longer valid. | VARCHAR | 6 |
| EFF_STATUS | Indicator whether the seasonal address is active or inactive. | VARCHAR | 2 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in PER_ID || SEQ_NUM format. This is the primary key. |
VARCHAR | 20 |
PER_CONTDET_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| C1_CONTACT_ID | Unique identifier for a person’s contact detail record. | VARCHAR | 10 |
| PER_ID | Unique identifier that specifies the person record. | VARCHAR | 10 |
| COMM_RTE_TYPE_CD | Code describing the type of communication route, such as phone, email, or SMS. | VARCHAR | 30 |
| CONTACT_VALUE | Actual value of the contact, such as phone number or email address. | VARCHAR | 254 |
| CND_PRIMARY_FLG | Indicator whether the contact is the primary method for communication. | VARCHAR | 4 |
| CONTACT_VALUE_EXT | Additional details related to the contact value, such as an extension number. | VARCHAR | 6 |
| DND_START_TM | Start of the do not disturb period of the contact. | TIMESTAMP | |
| DND_END_TM | End of the do not disturb period of the contact. | TIMESTAMP | |
| CND_VERIF_STATUS_FLG | Indicator whether the contact has been verified. | VARCHAR | 4 |
| CND_ACTINACT_FLG | Indicator whether the contact detail is active or inactive. | VARCHAR | 4 |
| CONTACT_NAME | Name associated with the contact. | VARCHAR | 100 |
| CONTACT_EXT_ID | External identifier linked to the contact record. | VARCHAR | 254 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in C1_CONTACT_ID format. This is the primary key. |
VARCHAR | 10 |
PER_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| SRC_CUST_ID | Unique identifier for a person record within the system. | VARCHAR | 14 |
| NAME_TYPE_CD | Type of name being stored for the person. For example, it can be a legal name, preferred name, or alternate name. | VARCHAR | 6 |
| NAME | Actual name of the person. It may represent the full name or a specific variation depending on the type flag. | VARCHAR | 356 |
| NAME_TYPE_1_CD | Placeholder for a configurable attribute column from the ATTRIBUTE_MAP table. It stores business-specific values without modifying the base data model. | VARCHAR | 254 |
| NAME_1 | Placeholder for an alternate name variation. | VARCHAR | 356 |
| NAME_TYPE_2_CD | Placeholder for a configurable attribute column from the ATTRIBUTE_MAP table. It stores business-specific values without modifying the base data model. | VARCHAR | 254 |
| NAME_2 | Placeholder for an alternate name variation. | VARCHAR | 356 |
| PARENT_CUST_ID | Parent person identifier. | VARCHAR | 14 |
| PRIMARY_CONTACT_NO | Primary phone number of the person. | VARCHAR | 34 |
| OTHER_CONTACT_NO | Alternate contact number for backup. | VARCHAR | 34 |
| EMAIL_ID | Email address used for digital interactions like for electronic communication and notifications. | VARCHAR | 356 |
| LANGUAGE_CD | Preferred language of the person. | VARCHAR | 5 |
| ADDRESS1 | Primary address line, usually containing street and house number. | VARCHAR | 356 |
| ADDRESS2 | Additional address details like apartment, suite, or floor number. | VARCHAR | 356 |
| ADDRESS3 | Placeholder for extended address formats, often used in certain regions. | VARCHAR | 356 |
| ADDRESS4 | Placeholder for more complex address formats. | VARCHAR | 356 |
| CITY | City of the address. | VARCHAR | 126 |
| COUNTY | County or regional division of the address. | VARCHAR | 126 |
| POSTAL_CODE | Postal or ZIP code. | VARCHAR | 17 |
| IN_CITY_LIMIT | Indicator whether the address lies within city limits. | VARCHAR | 2 |
| GEO_CODE | Geographic code of the address. | VARCHAR | 16 |
| STATE_CD | State or province part of the address. | VARCHAR | 9 |
| COUNTRY_CD | Country where the person's registered address is. | VARCHAR | 5 |
| HOUSE_TYPE | Type of housing. | VARCHAR | 3 |
| MARITAL_STATUS | Marital status of the person. | VARCHAR | 23 |
| GENDER | Gender of the person. | VARCHAR | 23 |
| DATE_OF_BIRTH | Date of birth of the person. | TIMESTAMP | 23 |
| SEGMENT_CD | Code identifying the customer, market, or business segment associated with the person. | VARCHAR | 23 |
| CUST_REL_MGR_ID | Unique identifier for the customer relationship manager assigned to the person. | VARCHAR | 23 |
| ID_TYPE_CD | Type of identification assigned to a person. It indicates whether the identifier is a passport number, driver’s license, national ID, or another code. | VARCHAR | 12 |
| ID_TYPE_1_CD ID_TYPE_2_CD ID_TYPE_3_CD ID_TYPE_4_CD ID_TYPE_5_CD ID_TYPE_6_CD ID_TYPE_7_CD ID_TYPE_8_CD ID_TYPE_9_CD ID_TYPE_10_CD ID_TYPE_11_CD ID_TYPE_12_CD ID_TYPE_13_CD ID_TYPE_14_CD ID_TYPE_15_CD |
Placeholder for the type of additional identification of a person. | VARCHAR | 254 |
| ID_VAL | Specifies the identifier number of the person based on ID_TYPE_CD. |
VARCHAR | 126 |
| ID_VAL_1 ID_VAL_2 ID_VAL_3 ID_VAL_4 ID_VAL_5 ID_VAL_6 ID_VAL_7 ID_VAL_8 ID_VAL_9 ID_VAL_10 ID_VAL_11 ID_VAL_12 ID_VAL_13 ID_VAL_14 ID_VAL_15 |
Placeholder for additional identifier numbers of the person based on ID_TYPE_X_CD. |
VARCHAR | 126 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in PER_ID format. This is the primary key. |
VARCHAR | 14 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD CDF16_CD CDF17_CD CDF18_CD CDF19_CD CDF20_CD CDF21_CD CDF22_CD CDF23_CD CDF24_CD CDF25_CD CDF26_CD CDF27_CD CDF28_CD CDF29_CD CDF30_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 254 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL CDF16_VAL CDF17_VAL CDF18_VAL CDF19_VAL CDF20_VAL CDF21_VAL CDF22_VAL CDF23_VAL CDF24_VAL CDF25_VAL CDF26_VAL CDF27_VAL CDF28_VAL CDF29_VAL CDF30_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 356 |
| CDF13_EFFDT CDF14_EFFDT CDF15_EFFDT CDF25_EFFDT CDF26_EFFDT CDF27_EFFDT CDF28_EFFDT CDF29_EFFDT CDF30_EFFDT |
Placeholders for effective date of future implementation of ORMB characteristics. | TIMESTAMP |
PER_SS_PAYOPT_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| PER_PAY_OPT_ID | Unique identifier for the payment option. | VARCHAR | 14 |
| PER_ID | Unique identifier that specifies the person record. | 10 | |
| EXT_TYPE_FLG | External type flag for the payment method. This flag categorizes how the option is used in external processes. | VARCHAR | 2 |
| APAY_SRC_CD | Code identifying the autopay source.. | VARCHAR | 12 |
| EXT_SOURCE_ID | Identifier for the external source that is usually linked to third-party processors or institutions. | VARCHAR | 30 |
| EXT_ACCT_ID | Unique identifier for the external account. | VARCHAR | 50 |
| ENCR_EXT_ACCT_ID | Encrypted version of the external account ID. | VARCHAR | 108 |
| C1_CARDHOLDER_FNAME | First name of the cardholder. | VARCHAR | 50 |
| C1_CARDHOLDER_LNAME | Last name of the cardholder. | VARCHAR | 50 |
| CARD_TYPE_FLG | Flag identifying the type of card used. Possible values are debit, credit, or prepaid. | VARCHAR | 4 |
| CREDIT_CARD_NBR | Number of the credit card. | VARCHAR | 60 |
| ENCR_CREDIT_CARD_NBR | Encrypted version of the credit card number. | VARCHAR | 108 |
| EXP_MONTH | Expiration month of the card. | VARCHAR | 2 |
| EXP_YEAR | Expiration year of the card. | VARCHAR | 4 |
| ADDRESS1 | Primary address line, usually containing street and house number. | VARCHAR | 356 |
| ADDRESS2 | Additional address details like apartment, suite, or floor number. | VARCHAR | 356 |
| ADDRESS3 | Placeholder for extended address formats, often used in certain regions. | VARCHAR | 356 |
| ADDRESS4 | Placeholder for more complex address formats. | VARCHAR | 356 |
| HOUSE_TYPE | Type of housing. | VARCHAR | 3 |
| NUM1 | First numeric identifier of the address. | VARCHAR | 9 |
| NUM2 | Second numeric identifier of the address. | VARCHAR | 6 |
| IN_CITY_LIMIT | Indicator whether the address lies within city limits. | VARCHAR | 2 |
| CITY | City of the address. | VARCHAR | 126 |
| GEO_CODE | Geographic code of the address. | VARCHAR | 16 |
| COUNTY | County or regional division of the address. | VARCHAR | 126 |
| STATE | State or province part of the address. | VARCHAR | 9 |
| POSTAL | Postal or ZIP code. | VARCHAR | 12 |
| PHONE | Contact phone number linked the payment option. | VARCHAR | 24 |
| EMAILID | Email address linked to the payment option. | VARCHAR | 254 |
| COUNTRY | Country code of the address. | VARCHAR | 3 |
| HASH_EXT_ACCT_ID | Hashed value of the external account ID. | VARCHAR | 88 |
| HASH_CREDIT_CARD_NBR | Hashed value of the credit card number. | VARCHAR | 88 |
| PER_PAY_OPT_NAME | Descriptive name of the payment option. | VARCHAR | 254 |
| CDC_LOAD_DTTM | Date and time when the record was loaded into the system through the Change Data Capture (CDC) process. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in PER_PAY_OPT_ID format. This is the primary key. |
VARCHAR | 12 |