Module: Common
Type: SCD2 Dimension
PER_SK
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PER_SK | VARCHAR2 | 39 | True | Person | |||
| SOURCE_RECORD_ID | VARCHAR2 | 39 | Source Record Id | ||||
| A1_HAS_CSS | VARCHAR2 | 1 | Has Self-Service Account | ||||
| A1_HAS_EMAIL | VARCHAR2 | 1 | Has Email | ||||
| A1_HAS_FAX | VARCHAR2 | 1 | Has Fax | ||||
| A1_HAS_PHONE | VARCHAR2 | 1 | Has Phone | ||||
| ADDRESS1 | VARCHAR2 | 254 | Address | ||||
| ADDRESS2 | VARCHAR2 | 254 | Address 2 | ||||
| ADDRESS3 | VARCHAR2 | 254 | Address 3 | ||||
| ADDRESS4 | VARCHAR2 | 254 | Address 4 | ||||
| CITY | VARCHAR2 | 90 | City | ||||
| COUNTRY | VARCHAR2 | 3 | Country | ||||
| COUNTY | VARCHAR2 | 90 | County | ||||
| EFFECTIVE_FROM | TIMESTAMP | 0 | 6 | Effective Date From | |||
| EFFECTIVE_TO | TIMESTAMP | 0 | 6 | Effective Date To | |||
| EMAILID | VARCHAR2 | 254 | Email Address | ||||
| F1_BI_LS_SL_DESCR | VARCHAR2 | 1000 | Life Support / Sensitive Load Description | ||||
| GEO_CODE | VARCHAR2 | 11 | Geographical Code | ||||
| HOUSE_TYPE | VARCHAR2 | 2 | House Type | ||||
| IN_CITY_LIMIT | VARCHAR2 | 1 | In City Limit | ||||
| IS_CURRENT | VARCHAR2 | 1 | Is Current | ||||
| IS_DELETED | VARCHAR2 | 1 | Is Deleted | ||||
| LS_SL_FLG | VARCHAR2 | 2 | Life Support / Sensitive Load | ||||
| NUM1 | VARCHAR2 | 6 | Number 1 | ||||
| NUM2 | VARCHAR2 | 4 | Number 2 | ||||
| OVRD_MAIL_NAME1 | VARCHAR2 | 254 | Name 1 | ||||
| OVRD_MAIL_NAME2 | VARCHAR2 | 254 | Name 2 | ||||
| OVRD_MAIL_NAME3 | VARCHAR2 | 254 | Name 3 | ||||
| PERSON_NAME | VARCHAR2 | 254 | Person Name | ||||
| PER_ID | VARCHAR2 | 10 | Person | ||||
| PER_OR_BUS_FLG | VARCHAR2 | 2 | Person/Business | ||||
| POSTAL | VARCHAR2 | 12 | Postal | ||||
| STATE | VARCHAR2 | 6 | State | ||||
| TIME_ZONE_CD | VARCHAR2 | 10 | Time Zone | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |