Address
Overview
The Address subject area represents an address record associated with a person, account, or other business entity. An address can be linked to multiple entities and supports effective-dating, allowing the system to maintain historical, current, and future addresses. It provides a centralized way to manage and reference address data across different transactions, ensuring consistency in billing, correspondence, and service delivery.
Conforming Layers
The Payment subject area has the following conforming layers:
ADDRESS_OBJ
| Column | Description | Data Type | Data Length |
| ENTITY_FLG | Flag indicating the type of entity associated with the address, such as person, premise, or account. | VARCHAR | 4 |
| ENTITY_ID | Identifier used to distinguish external business entities, which establishes relationships between records and supports audit tracking. | VARCHAR | 14 |
| EFFT_DT | Date when the address record becomes effective for the associated entity. | DATE | |
| ADDRESS_TYPE_FLG | Code flag identifying the type of address, such as billing, service, or mailing. | VARCHAR | 11 |
| PER_ID | Identifier for the person associated with the address record. | VARCHAR | 10 |
| ADDRESS_ID | Unique identifier for the address record. | VARCHAR | 12 |
| ADDRESS1 | Primary address line, usually containing street and house number. | VARCHAR | 254 |
| ADDRESS2 | Additional address details like apartment, suite, or floor number. | VARCHAR | 254 |
| ADDRESS3 | Placeholder for extended address formats, often used in certain regions. | VARCHAR | 254 |
| ADDRESS4 | Placeholder for more complex address formats. | VARCHAR | 254 |
| CITY | City of the address. | VARCHAR | 90 |
| STATE | State or province part of the address. | VARCHAR | 6 |
| COUNTY | County or regional division of the address. | VARCHAR | 90 |
| POSTAL | Postal or ZIP code of the address. | VARCHAR | 12 |
| COUNTRY | Country code of the address. | VARCHAR | 3 |
| HOUSE_TYPE | Type of housing. | VARCHAR | 2 |
| GEO_CODE | Geographic code of the address. | VARCHAR | 11 |
| IN_CITY_LIMIT_SW | Indicator whether the address lies within city limits. | VARCHAR | 1 |
| SEASON_START_MMDD | tart date when the seasonal address becomes valid. | VARCHAR | 4 |
| SEASON_END_MMDD | End date when the seasonal address is no longer valid. | VARCHAR | 4 |
| BUS_OBJ_CD | Business object code defining the lifecycle and processing rules for the address record. | VARCHAR | 30 |
| COMMENTS | Free-form comments or notes associated with the address record. | VARCHAR | 254 |
| SEASON_SEQ_NUM | Sequential number used to order multiple seasonal address records for the same entity. | NUMBER | 3 |
| CRE_DTTM | Date and time when the address record was created in the system. | TIMESTAMP | |
| BO_STATUS_CD | Current status code of the address record in its business object lifecycle. | VARCHAR | 12 |
| STATUS_UPD_DTTM | Date and time when the address status was last updated. | TIMESTAMP | |
| SEASON_EFF_STATUS | Status indicating the seasonal effectiveness of the address. | VARCHAR | 1 |
| ADDRESS5 | Fifth line of the address, providing additional space for extended address details. | VARCHAR | 254 |
| ADDRESS6 | Sixth line of the address, providing more space for capturing full address information. | VARCHAR | 254 |
| EMAIL_ID | Email identifier associated with the address record. | VARCHAR | 120 |
| ADDRESS7 | Seventh line of the address, providing further space for extended address information. | VARCHAR | 254 |
| COMPOSITE_KEY | Unique identifier in the ADDRESS_ID format. This is the primary key. |
VARCHAR | 12 |
| 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 |
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 |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 356 |
ADDRESS_LOG_OBJ
| Column | Description | Data Type | Data Length |
| ADDRESS_ID | Unique identifier for the address record. | VARCHAR | 12 |
| SEQNO | Sequential number used to differentiate multiple log entries associated with the same address. | NUMBER | 5 |
| PARM_SEQ | Parameter sequence number used to order multiple message parameters in a log entry. | NUMBER | 3 |
| MSG_PARM_TYP_FLG | Code flag indicating the type or category of the logged parameter. | VARCHAR | 4 |
| MSG_PARM_VAL | Value of the parameter captured in the address log entry. | VARCHAR | 2000 |
| LOG_DTTM | Date and time when the log entry was created in the system. | TIMESTAMP | |
| LOG_ENTRY_TYPE_FLG | Flag identifying the type of log entry, such as error, warning, or informational message. | VARCHAR | 4 |
| DESCRLONG | Extended description text providing detailed information about the log entry. | VARCHAR | 4000 |
| BO_STATUS_CD | Business object status code representing the lifecycle state of the address at the time of logging. | VARCHAR | 12 |
| MESSAGE_CAT_NBR | Identifier for the message category describing the type of message associated with the record. | NUMBER | 5 |
| MESSAGE_NBR | Identifier corresponding to a specific message associated with the record. | NUMBER | 5 |
| USER_ID | Identifier for the user who triggered or is associated with the log entry. | VARCHAR | 8 |
| CHAR_TYPE_CD | Code indicating the type of characteristic captured in the address log. | VARCHAR | 8 |
| SRCH_CHAR_VAL | Searchable value of the characteristic captured in the address log. | VARCHAR | 254 |
| COMPOSITE_KEY | Unique identifier in the ADDRESS_ID | SEQNO | PARM_SEQ format. This is the primary key. |
VARCHAR | 20 |