Module: Common
Type: Dimension
SA_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SA_ID | VARCHAR2 | 10 | True | Service Agreement | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| ALLOW_BILLING_SW | VARCHAR2 | 1 | Eligible for Billing | ||||
| ALLOW_EST_SW | VARCHAR2 | 1 | Allow Estimates | ||||
| ALLOW_RCR_CHG_FLG | VARCHAR2 | 1 | Recurring Charge | ||||
| BUS_ACTIVITY_DESC | VARCHAR2 | 250 | Business Activity | ||||
| C1_BI_CIS_DIV_LBL | VARCHAR2 | 5 | CIS Division | ||||
| C1_PREPAID_METER_FLG | VARCHAR2 | 4 | Prepay Option | ||||
| CASH_ONLY_PTS_THRS | NUMBER | 5 | 0 | Cash-Only Threshold | |||
| CIAC_REVIEW_DT | DATE | 0 | CIAC Review Date | ||||
| CIS_DIVISION | VARCHAR2 | 5 | CIS Division | ||||
| CIS_DIV_RESTRICT_FLG | VARCHAR2 | 4 | Restrict to Account CIS Division | ||||
| CR_RAT_THRS | NUMBER | 5 | 0 | Credit Rating Threshold | |||
| CUST_READ_FLG | VARCHAR2 | 2 | Customer Read | ||||
| DAYS_BEFORE_EXP | NUMBER | 3 | 0 | Renewal Days Before Expiration | |||
| DEBT_CL_CD | VARCHAR2 | 4 | Debt Class | ||||
| DEL_PAY_PRIO_FLG | VARCHAR2 | 2 | Delinquent Pay Prty | ||||
| ELIG_BUDGET_SW | VARCHAR2 | 1 | Eligible For Budget | ||||
| END_DT | DATE | 0 | End Date | ||||
| EXPIRE_DT | DATE | 0 | Expiration Date | ||||
| HIGH_BILL_AMT | NUMBER | 15 | 2 | Maximum Bill Threshold | |||
| IB_BASE_TM_DAY_FLG | VARCHAR2 | 2 | Start Day Option | ||||
| IB_SA_CUTOFF_TM | TIMESTAMP | 0 | 6 | IB SA Cutoff Time | |||
| INIT_ST_DT_OPT_FLG | VARCHAR2 | 4 | Initial Start Date Option | ||||
| INT_CALC_DT | DATE | 0 | Deposit Interest Calculated | ||||
| LATE_PAY_CHARGE_SW | VARCHAR2 | 1 | Late Payment Charge | ||||
| NBR_PYMNT_PERIODS | NUMBER | 3 | 0 | Number of Payment Periods | |||
| NB_APAY_FLG | VARCHAR2 | 4 | NBB Autopay | ||||
| NB_ELIG_FLG | VARCHAR2 | 4 | NBB Eligibility | ||||
| NB_MONITOR_FLG | VARCHAR2 | 4 | NBB Monitor | ||||
| NO_PRO_REF_FLG | VARCHAR2 | 4 | RV Selection Date | ||||
| OLD_ACCT_ID | VARCHAR2 | 36 | Old Account | ||||
| ONE_TIME_CH_SW | VARCHAR2 | 1 | One Time Charge | ||||
| OVRD_CRRT_CASH_SW | VARCHAR2 | 1 | Override Credit Rating/Cash Only | ||||
| OVRD_INT_FLG | VARCHAR2 | 4 | Override Interest | ||||
| PAY_PRIORITY_FLG | VARCHAR2 | 2 | Payment Priority | ||||
| PA_ELIG_FLG | VARCHAR2 | 4 | Eligible for Payment Arrangement | ||||
| PROP_SA_STAT_FLG | VARCHAR2 | 2 | Proposal SA Status | ||||
| RATE_SRCE_FLG | VARCHAR2 | 4 | Rate Source | ||||
| RENEWAL_DT | DATE | 0 | Renewal Date | ||||
| SA_RENEWAL_FLG | VARCHAR2 | 4 | SA Renewal | ||||
| SA_STATUS_FLG | VARCHAR2 | 2 | SA Status | ||||
| SA_TYPE_CD | VARCHAR2 | 8 | SA Type | ||||
| SIC_CD | VARCHAR2 | 8 | SIC | ||||
| SPECIAL_ROLE_FLG | VARCHAR2 | 2 | Special Role | ||||
| SPECIAL_USAGE_FLG | VARCHAR2 | 4 | Special Usage | ||||
| START_CASH_ONL_PTS | NUMBER | 5 | 0 | Beginning Cash-Only Score | |||
| START_CR_RAT_PTS | NUMBER | 5 | 0 | Beginning Credit Rating | |||
| START_DT | DATE | 0 | Start Date | ||||
| START_OPT_CD | VARCHAR2 | 12 | Start Option | ||||
| STOP_OPTION_FLG | VARCHAR2 | 4 | Stop Option | ||||
| STOP_REQED_BY | VARCHAR2 | 50 | Stop Requested By | ||||
| STOP_RSN_FLG | VARCHAR2 | 4 | Stop Reason | ||||
| STRT_REQED_BY | VARCHAR2 | 50 | Start Requested By | ||||
| STRT_RSN_FLG | VARCHAR2 | 4 | Start Reason | ||||
| SUB_SA_SW | VARCHAR2 | 1 | Sub SA | ||||
| SVC_TYPE_CD | VARCHAR2 | 30 | Service Type | ||||
| TOT_TO_BILL_AMT | NUMBER | 15 | 2 | Total Amount to Bill | |||
| USE_CALENDAR_FLG | VARCHAR2 | 2 | Use Calendar Billing | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |