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, 'AffiliationAFFILIATION', 'FacultyStaff');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'AFFILIATION', 'Student');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
 VALUES
(ctx_data_types_seq.NEXTVAL, 'DepartmentORGANIZATIONAL_UNIT', 'Computer ScienceMathematics');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'ORGANIZATIONAL_UNIT', 'Biology');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
 VALUES
(ctx_data_types_seq.NEXTVAL, 'AffiliationORGANIZATIONAL_UNIT', 'SAKAI AccessPsychology');
 
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'ORGANIZATIONAL_UNIT', 'Computer Science');
 
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
 VALUES
(ctx_data_types_seq.NEXTVAL, 'StatusSTATUS', 'Active');
 
INSERT INTO ctxCTX_dataDATA_typesTYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'StatusSTATUS', '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, 'PhonePHONE', 'CellLand');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'PHONE', 'Other');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'PhoneADDRESS', 'Home');
 
INSERT INTO ctxCTX_dataDATA_typesTYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'PhoneADDRESS', 'Campus');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'EMAIL', 'Home');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'AddressEMAIL', 'HomeCampus');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'URL', 'Personal');
 
INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
 VALUES
(ctx_data_types_seq.NEXTVAL, 'AddressSPONSOR', 'CampusPerson');

INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'NAME', 'Formal');

INSERT INTO CTX_DATA_TYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'EmailAddressNAME', 'HomeFormerly Known As');

INSERT INTO CTX_DATA_TYPES
(id, data_type, description)
VALUES
(ctx_data_types_seq.NEXTVAL, 'NAME', 'Maiden');

INSERT INTO CTX_DATA_TYPES
(id, data_type, description)

VALUES
(ctx_data_types_seq.NEXTVAL, 'EmailAddressNAME', 'CampusNickname');


-- Example Organizational Units and Roles

INSERT INTO drd_organizational_units
   (id, code, name, campus_id, organizational_unit_t)
 (SELECT drd_organizational_units_seq.NEXTVAL, 'CSI', 'Computer Science',
  c.id, dt.id
  FROM prd_campuses c, ctx_data_types dt
   WHERE c.code = '02'
    AND dt.data_type = 'ORGANIZATIONAL_UNIT' AND dt.description = 'Computer Science');
 
INSERT INTO drd_organizational_units
 (id, code, name, campus_id, organizational_unit_t)
(SELECT drd_organizational_units_seq.NEXTVAL, 'MATH', 'Mathematics',
  c.id, dt.id

  FROM prd_campuses c, ctx_data_types dt

   WHERE c.code = '02'
     AND dt.data_type = 'DepartmentORGANIZATIONAL_UNIT' AND dt.description = 'Computer ScienceMathematics');



 INSERT INTO prd_roles (prd_roles.id, code, title, affiliation_t, campus_id, organizational_unit_id)
  (SELECT prd_roles_seq.NEXTVAL, 'PRO', 'Professor', dt.id, d.campus_id, d.id
     FROM ctx_data_types dt, drd_organizational_units d
      WHERE dt.data_type = 'AffiliationAFFILIATION' AND dt.description = 'Faculty'
       AND d.code = 'CSI');

 INSERT INTO prd_roles (prd_roles.id, code, title, affiliation_t, campus_id, organizational_unit_id)
  (SELECT prd_roles_seq.NEXTVAL, 'SAK', 'SAKAI User', dt.id, d.campus_id, d.id
     FROM ctx_data_types dt, drd_organizational_units d
      WHERE dt.data_type = 'AffiliationAFFILIATION' AND dt.description = 'SAKAI AccessFaculty'
      AND d.code = 'CSIMATH');