Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

[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

[15:09:36 CDT(-0500)] <JasonElwood> JS- is there any scenario where a course in a start term of the Move Plan feature would not move?

[15:09:58 CDT(-0500)] <js70> yeah, when its in the past

[15:10:09 CDT(-0500)] <js70> or its a transcript

[15:10:42 CDT(-0500)] <js70> everything in spring 2013 and earlier should not move

[15:11:03 CDT(-0500)] <js70> any transcripted course thats in the CORRECT term will not move.

[15:11:21 CDT(-0500)] <JasonElwood> even if the course is a planned course?

[15:11:31 CDT(-0500)] <js70> but right now, even if its not in the transcript, if its in the past it won't be moved.

[15:11:37 CDT(-0500)] <js70> yep

[15:11:39 CDT(-0500)] <JasonElwood> past I'm good with

  • No labels