Module: Customer Analytics
Type: Dimension
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACCT_ID | VARCHAR2 | 10 | Account | ||||
| PER_ID | VARCHAR2 | 10 | Person | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 21 | Source Record Id | ||||
| ALW_PREF_FLG | VARCHAR2 | 4 | Allow Preference | ||||
| BILL_ADDR_SRCE_FLG | VARCHAR2 | 38 | Bill Address Source | ||||
| BILL_FORMAT_FLG | VARCHAR2 | 38 | Bill Format | ||||
| CSS_ACCESS_ROLE_FLG | VARCHAR2 | 38 | Self-Service Access Role | ||||
| FIN_RESP_SW | VARCHAR2 | 1 | Financially Responsible | ||||
| MAIN_CUST_SW | VARCHAR2 | 1 | Main Customer | ||||
| NAME_PFX_SFX | VARCHAR2 | 50 | Pfx/Sfx Name | ||||
| NBR_BILL_COPIES | NUMBER | 2 | 0 | Number of Bill Copies | |||
| NOTIFY_SW | VARCHAR2 | 1 | Receives Collection and Overdue Notices | ||||
| PFX_SFX_FLG | VARCHAR2 | 38 | Prefix/Suffix | ||||
| RECEIVE_COPY_SW | VARCHAR2 | 1 | Receives Copy of Bill | ||||
| RECV_QTE_SW | VARCHAR2 | 38 | Receives Copy of Quote | ||||
| THRD_PTY_SW | VARCHAR2 | 1 | Third Party Guarantor | ||||
| WEB_ACCESS_FLG | VARCHAR2 | 38 | Web Self Service Access | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |