Page Comparison

-- Campuses (from Rutgers):

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '01', 'COLLEGE AV');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '02', 'BUSCH');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '03', 'LIVINGSTON');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '04', 'NEWARK');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '05', 'CAMDEN');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '06', 'COOK');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '07', ' ');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '08', ' ');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '09', 'DOUGLASS');

INSERT INTO prd_campuses (id, code, name)
  VALUES (prd_campuses_seq.NEXTVAL, '99', 'OFF CAMPUS');


-- Identifiers (from Rutgers):

INSERT INTO prd_identifier_types (identifier_t, name)
  VALUES (prd_identifier_types_seq.NEXTVAL, 'SSN');

INSERT INTO prd_identifier_types (identifier_t, name)
  VALUES (prd_identifier_types_seq.NEXTVAL, 'RUID');

INSERT INTO prd_identifier_types (identifier_t, name)
  VALUES (prd_identifier_types_seq.NEXTVAL, 'RCPID');

INSERT INTO prd_identifier_types (identifier_t, name)
  VALUES (prd_identifier_types_seq.NEXTVAL, 'IID');

INSERT INTO prd_identifier_types (identifier_t, name)
  VALUES (prd_identifier_types_seq.NEXTVAL, 'NETID');


-- Needed sequence that's not created by JPA:

CREATE SEQUENCE rcpid_generator_seq;


-- Example Data Types

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Affiliation', 'Faculty');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Department', 'Computer Science');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Affiliation', 'SAKAI Access');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Status', 'Active');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Status', 'InActive');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Phone', 'Cell');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Phone', 'Home');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Phone', 'Campus');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Address', 'Home');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'Address', 'Campus');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'EmailAddress', 'Home');

INSERT INTO ctx_data_types (id, data_type, description)
 VALUES (ctx_data_types_seq.NEXTVAL, 'EmailAddress', 'Campus');


-- Example Roles and Organizational Units and Roles

INSERT INTO prd_rolesdrd_organizational_units
   (prd_roles.id, code, titlename, affiliation_t, campus_id, organizational_unit_idt)

 (SELECT prddrd_organizational_rolesunits_seq.NEXTVAL, 'PROCSI', 'ProfessorComputer Science', dt.id, d.campus_
     c.id, ddt.id
   FROM prd_campuses FROMc, ctx_data_types dt, drd_organizational_units d

    WHERE c.code = '02'
     WHEREAND dt.data_type = 'AffiliationDepartment' AND dt.description = 'Faculty'
       AND d.code = 'CSIComputer Science');

  INSERT INTO prd_roles (prd_roles.id, code, title, affiliation_t, campus_id, organizational_unit_id)
  (SELECT prd_roles_seq.NEXTVAL, 'SAKPRO', 'SAKAI UserProfessor', dt.id, d.campus_id, d.id
     FROM ctx_data_types dt, drd_organizational_units d
      WHERE dt.data_type = 'Affiliation' AND dt.description = 'SAKAIFaculty'
Access'       AND d.code = 'CSI');

 INSERT INTO drd_organizational_units
   (prd_roles (prd_roles.id, code, title, nameaffiliation_t, campus_id, organizational_unit_tid)
  (SELECT drdprd_organizational_unitsroles_seq.NEXTVAL, 'CSISAK', 'ComputerSAKAI ScienceUser',      c.dt.id, d.campus_id, dtd.id
   FROM prd_campuses c,FROM ctx_data_types dt, drd_organizational_units d
      WHERE cdt.codedata_type = '02Affiliation'      AND dt.data_typedescription = 'DepartmentSAKAI Access'
      AND dtd.descriptioncode = 'Computer ScienceCSI');