CONTRACT CONT NO NUMBER CONTSTAT_ID VARCHAR STATUS_EFFECTIVE DATE DATE CUST NO NUMBER CUSTOMER CUST NO NUMBER CUST_NAME

[answerhappygod]

Contract Cont No Number Contstat Id Varchar Status Effective Date Date Cust No Number Customer Cust No Number Cust Name 1 (119.3 KiB) Viewed 39 times

CONTRACT CONT NO NUMBER CONTSTAT_ID VARCHAR STATUS_EFFECTIVE DATE DATE CUST NO NUMBER CUSTOMER CUST NO NUMBER CUST_NAME VARCHAR CUST ADDR1 VARCHAR CITY_NAME VARCHAR STATED VARCHAR ZIP CODE VARCHAR CUSTOMER SITE CUST NO INUMBER SITE NO NUMBER START DATE DATE END DATE IDATE SITE SITE_NO SITE NAME SITE_ADDR1 CITY_NAME STATED ZIB_CODE SITETYPE_ID SERVCO_NO NUMBER VARCHAR VARCHAR VARCHAR VARCHAR VACHAR VACHAS NUMBER RECUR_LINE Y CONT_NO NUMBER RECLINE_NO NUMBER BILLTO CUST_NO NUMBER SERVICE SITE NO NUMBER RECSTAT_ID VARCHAR MONTHLY_AMT NUMBER RECUR START DATE DATE RECUR_END_DATE DATE BILLCODE_ID VARCHAR HUST BALANCE FORWARD HIS? CUST_NO NUMBER START BAL AMT NUMBER END BAL_AMT NUMBER END_BAL DATE DATE JOB JOB NO JOBSTAT ID SITE_NO CREATE_DATE COMPLETE DATE NUMBER VARCHAR NUMBER DATE DATE SERVICE COMPANY SERVCO NO NUMBER SERVCO NAME VARCHAR BILL CODE BILLCODE 1D VARCHAR DESCR VARCHAR SERVTYPE_ID VARCHAR 8. Scenario: You have a business request to provide data and analysis on customers that are actively paying for some type of maintenance plan and have no outstanding balance. a. Using the table relationship diagram provided, write a query to create the QSP_CUSTOMER table with the following data: i. BILLING_CUST_NO ii. CUST_NAME iii. CUST_END_BALANCE iv. SERVICE_SITE_NO Additional Definitions: V. SITE_STATE Active charges: vi. CONTRACT_NO vii. RECUR_LINE_NO RECBSTAT_ID on the RECUR_LINE needs to have a value of B, BC or FC AND viii. RECBSTAT_ID ix. BILL_CODE Today's date must be between the RECUR_LINE start and end date values X. RECUR_START_DATE Maintenance Plan: xi. RECUR_END_DATE The SERVTYPE_ID of the BILL_CODE must be like 'QSP xii. MONTHLY_AMT xiii. SERVICE_TYPE xiv. BILLCODE_DESCR . . .