Want to Rollover but i got this message
09/09/2021 12:03:45
Date
DB Execute Failed. ERROR: column "course_period_id" of relation "billing_elements" does not exist LINE 2: DESCRIPTION,GRADE_LEVEL,COURSE_PERIOD_ID,ROLLOVER,SCHOOL_I... ^
Failure Notice
INSERT INTO BILLING_ELEMENTS (CATEGORY_ID,TITLE,REF,AMOUNT,
DESCRIPTION,GRADE_LEVEL,COURSE_PERIOD_ID,ROLLOVER,SCHOOL_ID,SYEAR)
SELECT CATEGORY_ID,TITLE,REF,AMOUNT,DESCRIPTION,GRADE_LEVEL,
(SELECT COURSE_PERIOD_ID
FROM COURSE_PERIODS
WHERE be.COURSE_PERIOD_ID IS NOT NULL
AND SYEAR='2021'
AND SCHOOL_ID='1'
AND ROLLOVER_ID=be.COURSE_PERIOD_ID
LIMIT 1),
ROLLOVER,SCHOOL_ID,'2021'
FROM BILLING_ELEMENTS be
WHERE be.SYEAR='2020'
AND be.SCHOOL_ID='1'
AND be.ROLLOVER='Y'
SQL query