Accounts and Service Agreements
Module: Customer Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACCT_ID | VARCHAR2 | 10 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| PER_ID | VARCHAR2 | 10 | Person | DW_EWC_X_EWDI_CUST_CI_ACCT_PER_D | PER_ID | ||
| PREM_ID | VARCHAR2 | 38 | Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| SA_ID | VARCHAR2 | 10 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 71 | Source Record Id | ||||
| A1_ACCT_PER_ID | VARCHAR2 | 10 | Account Person Relationship | DW_EWC_X_EWDI_CUST_CI_ACCT_PER_D | ACCT_ID | ||
| A1_ACCT_PER_REL_TYPE_CD | VARCHAR2 | 8 | Account Person Relation Type | DW_EWC_X_EWDI_CUST_CI_ACCT_REL_TYP_D | ACCT_REL_TYPE_CD | ||
| A1_SA_END_DT | NUMBER | 38 | 0 | Service Agreement End Date | DW_APPS_DAY_D | CALENDAR_DATE | |
| A1_SA_START_DT | NUMBER | 38 | 0 | Service Agreement Start Date | DW_APPS_DAY_D | CALENDAR_DATE | |
| RS_CD | VARCHAR2 | 38 | Rate | DW_EWB_X_EWDI_BASE_CI_RS_D | RATE_SCHEDULE_CD | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |