[12:08:19 CDT(-0500)] <JasonElwood> JS- are there any other conditions for the MAP plan status except a row in external_person_planning_status?
[12:40:03 CDT(-0500)] <js70> not at this time
[14:29:43 CDT(-0500)] <JasonElwood> JS- so I've tested this back and forth. I'm having problems with both the plan status and dev course indicator. A rows is returned with this query for the student I'm using. select * from external_person_planning_status where school_id = 'jgarcia35'
[14:31:18 CDT(-0500)] <JasonElwood> And the is_dev indicator doesn't appear to be saved on the plan. This query returns the course with is_dev = . select * from external_course where is_dev = 'Y' Is the value in external_course supposed to be some other value? It does show as false in map_plan_course when saved to a plan.
[14:32:48 CDT(-0500)] <js70> I'll check but I'm pretty sure is_dev = "Y" is correct.
[14:33:16 CDT(-0500)] <js70> hold on let me look.
[14:34:28 CDT(-0500)] <js70> is_dev is boolean on the PlanCourse
[14:34:43 CDT(-0500)] <js70> there may be a translaction issue.
[14:36:10 CDT(-0500)] <js70> I just tested that the indicator worked if planCourse is_dev was true
[14:37:30 CDT(-0500)] <JasonElwood> it's definitely is_dev = Y in external_course. when that course is dragged to a plan, is_dev = f in map_plan_course
[14:38:39 CDT(-0500)] <js70> is_dev = ? in map_plan_course?
[14:38:51 CDT(-0500)] <JasonElwood> false
[14:39:17 CDT(-0500)] <JasonElwood> when I manually update it to true, the indicator shows up. looks like the value isn't being carried over from external_course
[14:39:31 CDT(-0500)] <js70> yep, thats whats happening
[14:39:49 CDT(-0500)] <js70> didn't think to test that part.
[14:39:52 CDT(-0500)] <js70> like a dope.
[14:40:04 CDT(-0500)] <JasonElwood> but I know that has worked because I've seen the Dev Cr Hrs total show more than zero
[14:40:33 CDT(-0500)] <js70> yeah, if the plan_course_dev was set by hand perhaps?
[14:41:21 CDT(-0500)] <JasonElwood> if is_dev in external_course should be Y or N, then we have a problem. And, I'll open a ticket
[14:43:52 CDT(-0500)] <js70> we have a problem external bools are standardized on Y,N operational appears to be boolean.
[14:45:04 CDT(-0500)] <dmccallum54> we have hql querying that external field directly with true/false?
[14:46:39 CDT(-0500)] <JasonElwood> the calculation of Dev Hrs on the plan used to work
[14:47:29 CDT(-0500)] <js70> No, pretty sure this is all client side concerns.
[14:47:43 CDT(-0500)] <JasonElwood> I created 1454
[14:48:48 CDT(-0500)] <JasonElwood> the were another question about the planning_status. similar situation where the row exists in the database, but the status on the MAP shows "Student is Currently: No Status"
[14:49:13 CDT(-0500)] <JasonElwood> I can create a ticket if you don't think it is a data issue
[14:50:19 CDT(-0500)] <JasonElwood> external_person_planning_status.status = OFF or ON
[14:50:39 CDT(-0500)] <js70> better create a ticket
[14:50:47 CDT(-0500)] <JasonElwood> np
[14:54:23 CDT(-0500)] <JasonElwood> re-opened 968
[14:54:34 CDT(-0500)] <js70> k