PERIODOS CCSS sin medicina
SELECT
Contact.id,
Contact.FirstName,
Contact.Segundo_Nombre__c,
Contact.LastName,
Contact.Segundo_Apellido__c,
Contact.Tipo_de_Identificacion__c,
Contact.Identificacion__c,
Contact.hed__Gender__c,
Contact.email,
Opportunity.Test_Score__c,
Opportunity.Program_Plan_id__r.Linea_de_negocio__c,
Opportunity.Program_Plan_id__r.hed__Account__r.Codigo_Banner_Programa__c,
Opportunity.Program_Plan_id__r.No_presenta_Entrevista__c,
Opportunity.Program_Plan_id__r.No_presenta_examen_YQueSigo__c,
Opportunity.Program_Plan_id__r.Presenta_examen_en_Moodle__c,
Opportunity.Program_Plan_id__r.Periodo_Academico__r.Codigo_banner__c,
Opportunity.Program_Plan_id__r.Codigo_Major__c,
Opportunity.Program_Plan_id__r.Tipo_de_Programa__c
FROM OpportunityContactRole
WHERE Opportunity.StageName = ‘Inscrito Pregrado’
AND Opportunity.Program_Plan_id__r.Linea_de_negocio__c = ‘UG’
AND Opportunity.Program_Plan_id__r.hed__Account__r.Codigo_Banner_Programa__c in (‘UDLA1P624-624′,’UDLA1P714-714′,’UDLA1P724-724′,’UDLA1P734-734′,’UDLA1P714-714F’)
AND Opportunity.Program_Plan_id__r.Periodo_Academico__r.Codigo_banner__c in (‘202420′,’202510’)
AND Opportunity.Test_Score__r.Estado_Yquesigo__c in (‘A’, ‘R’)
MEDICINA
SELECT
Contact.id,
Contact.FirstName,
Contact.Segundo_Nombre__c,
Contact.LastName,
Contact.Segundo_Apellido__c,
Contact.Tipo_de_Identificacion__c,
Contact.Identificacion__c,
Contact.hed__Gender__c,
Contact.email,
Opportunity.Test_Score__c,
Opportunity.Program_Plan_id__r.Linea_de_negocio__c,
Opportunity.Program_Plan_id__r.hed__Account__r.Codigo_Banner_Programa__c,
Opportunity.Program_Plan_id__r.No_presenta_Entrevista__c,
Opportunity.Program_Plan_id__r.No_presenta_examen_YQueSigo__c,
Opportunity.Program_Plan_id__r.Presenta_examen_en_Moodle__c,
Opportunity.Program_Plan_id__r.Periodo_Academico__r.Codigo_banner__c,
Opportunity.Program_Plan_id__r.Codigo_Major__c,
Opportunity.Program_Plan_id__r.Tipo_de_Programa__c
FROM OpportunityContactRole
WHERE Opportunity.StageName = ‘Inscrito Pregrado’
AND Opportunity.Program_Plan_id__r.Linea_de_negocio__c = ‘UG’
AND Opportunity.Program_Plan_id__r.hed__Account__r.Codigo_Banner_Programa__c in (‘UDLA1P704-704’)
AND Opportunity.Program_Plan_id__r.Periodo_Academico__r.Codigo_banner__c in (‘202420′,’202510’)
AND Opportunity.Test_Score__r.Estado_Yquesigo__c in (‘A’, ‘R’)
POSGRADO ECONOMETRÍA**************************************
SELECT
Contact.id,
Contact.FirstName,
Contact.Segundo_Nombre__c,
Contact.LastName,
Contact.Segundo_Apellido__c,
Contact.Tipo_de_Identificacion__c,
Contact.Identificacion__c,
Contact.hed__Gender__c,
Contact.email,
Opportunity.Test_Score__c,
Opportunity.Program_Plan__r.Linea_de_negocio__c,
Opportunity.Program_Plan__r.hed__Account__r.Codigo_Banner_Programa__c,
Opportunity.Program_Plan__r.No_presenta_Entrevista__c,
Opportunity.Program_Plan__r.No_presenta_examen_YQueSigo__c,
Opportunity.Program_Plan__r.Presenta_examen_en_Moodle__c,
Opportunity.Program_Plan__r.Periodo_Academico__r.Codigo_banner__c,
Opportunity.Program_Plan__r.Codigo_Major__c,
Opportunity.Program_Plan__r.Tipo_de_Programa__c
FROM OpportunityContactRole
WHERE Opportunity.StageName = ‘Inscrito Posgrado’
AND Opportunity.Program_Plan__r.Linea_de_negocio__c = ‘GR’
AND Opportunity.Program_Plan__r.hed__Account__r.Codigo_Banner_Programa__c like ‘%UDLA5P002%’
AND Opportunity.Program_Plan__r.Periodo_Academico__r.Codigo_banner__c in (‘202400’)