• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• CA_RC_T.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.oracle.CA_RC_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE CA_RC_T DROP STORAGE
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('01','014A17B043939D5EE043814FD8819D5E',1.0,'BALANCE SHEET','BALANCE SHT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('02','014A17B043949D5EE043814FD8819D5E',1.0,'INSTRUCTIONAL PROGRAMS','INSTRUCT PRG','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('04','014A17B043959D5EE043814FD8819D5E',1.0,'ARTS & SCIENCES','A&S','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('06','014A17B043969D5EE043814FD8819D5E',1.0,'ARTS AND LETTERS','ARTS&LETTERS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('08','014A17B043979D5EE043814FD8819D5E',1.0,'HEALTH & REHABILITATION SCIENCES','HLTH & REHAB','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('10','014A17B043989D5EE043814FD8819D5E',1.0,'MEDICINE & HEALTH SCIENCES','MEDICINE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('12','014A17B043999D5EE043814FD8819D5E',1.0,'NURSING','NURSING','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('14','014A17B0439A9D5EE043814FD8819D5E',1.0,'DENTISTRY','DENTISTRY','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('16','014A17B0439B9D5EE043814FD8819D5E',1.0,'DENTAL EDUCATION','DENTAL EDUC','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('18','014A17B0439C9D5EE043814FD8819D5E',1.0,'LIBERAL ARTS','LIBERAL ARTS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('20','014A17B0439D9D5EE043814FD8819D5E',1.0,'SCIENCE','SCIENCE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('22','014A17B0439E9D5EE043814FD8819D5E',1.0,'NATURAL SCIENCES','NATURAL SCI','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('23','014A17B0439F9D5EE043814FD8819D5E',1.0,'SOCIAL SCIENCES','SOCIAL SCI','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('24','014A17B043A09D5EE043814FD8819D5E',1.0,'BUSINESS','BUSINESS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('26','014A17B043A19D5EE043814FD8819D5E',1.0,'EDUCATION','EDUCATION','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('28','014A17B043A29D5EE043814FD8819D5E',1.0,'HEALTH, PHYSICAL EDUCATION & RECREATION','HPER','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('30','014A17B043A39D5EE043814FD8819D5E',1.0,'HERRON SCHOOL OF ART AND DESIGN','HERRON','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('32','014A17B043A49D5EE043814FD8819D5E',1.0,'LAW','LAW','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('34','014A17B043A59D5EE043814FD8819D5E',1.0,'ENGINEERING & TECHNOLOGY','E&T','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('36','014A17B043A69D5EE043814FD8819D5E',1.0,'PUBLIC & ENVIRONMENTAL AFFAIRS','SPEA','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('38','014A17B043A79D5EE043814FD8819D5E',1.0,'SOCIAL WORK','SOCIAL WORK','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('40','014A17B043A89D5EE043814FD8819D5E',1.0,'LIBRARY & INFORMATION SCIENCE','SLIS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('42','014A17B043A99D5EE043814FD8819D5E',1.0,'MUSIC','MUSIC','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('43','014A17B043AA9D5EE043814FD8819D5E',1.0,'ARTS','ARTS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('44','014A17B043AB9D5EE043814FD8819D5E',1.0,'OPTOMETRY','OPTOMETRY','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('45','014A17B043D49D5EE043814FD8819D5E',1.0,'INFORMATICS','INFORMATICS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('46','014A17B043AC9D5EE043814FD8819D5E',1.0,'IUPU COLUMBUS','COLUMBUS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('48','014A17B043AD9D5EE043814FD8819D5E',1.0,'DISTRIBUTED EDUCATION','DISTR EDUC','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('49','014A17B043AE9D5EE043814FD8819D5E',1.0,'UNIVERSITY COLLEGE','UNIV COLLEGE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('50','014A17B043AF9D5EE043814FD8819D5E',1.0,'JOURNALISM','JOURNALISM','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('51','014A17B043B09D5EE043814FD8819D5E',1.0,'RADIOGRAPHY','RADIOGRAPHY','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('52','014A17B043B19D5EE043814FD8819D5E',1.0,'OTHER ACADEMIC PROGRAMS','OTHER ACAD','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('56','014A17B043B29D5EE043814FD8819D5E',1.0,'STATEWIDE TECHNOLOGY','STATEWIDE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('58','014A17B043B39D5EE043814FD8819D5E',1.0,'ACADEMIC SUPPORT','ACADEMIC','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('60','014A17B043B49D5EE043814FD8819D5E',1.0,'DEAN OF FACULTIES','DEAN OF FAC','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('64','014A17B043B59D5EE043814FD8819D5E',1.0,'VICE PRESIDENT FOR RESEARCH','VP RESEARCH','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('65','014A17B043B69D5EE043814FD8819D5E',1.0,'INTEGRATED TECHNOLOGIES','INTEGR TECH','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('66','014A17B043B79D5EE043814FD8819D5E',1.0,'COMPUTER SERVICES','COMP SERV','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('67','014A17B043B89D5EE043814FD8819D5E',1.0,'TECHNOLOGY SUPPORT','TECH SUPPORT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('68','014A17B043B99D5EE043814FD8819D5E',1.0,'LIBRARY','LIBRARY','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('70','014A17B043BA9D5EE043814FD8819D5E',1.0,'STUDENT SERVICES','STUDENT SERV','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('73','014A17B043BB9D5EE043814FD8819D5E',1.0,'UNDERGRADUATE EDUCATION','UNDERGRAD ED','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('74','014A17B043BC9D5EE043814FD8819D5E',1.0,'EXECUTIVE MANAGEMENT','EXEC MGT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('75','014A17B043BD9D5EE043814FD8819D5E',1.0,'EXECUTIVE MANAGEMENT/ACADEMIC SUPPORT','EXEC MGT/AS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('76','014A17B043BE9D5EE043814FD8819D5E',1.0,'GENERAL ADMINISTRATION','GEN ADMIN','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('77','014A17B043BF9D5EE043814FD8819D5E',1.0,'INCOME','INCOME','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('78','014A17B043C09D5EE043814FD8819D5E',1.0,'ADMINISTRATIVE AFFAIRS','ADMIN AFF','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('79','014A17B043C19D5EE043814FD8819D5E',1.0,'EXTERNAL AFFAIRS','EXTERNAL AFF','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('80','014A17B043C29D5EE043814FD8819D5E',1.0,'BUDGET & FISCAL AFFAIRS','BUDGET','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('81','014A17B043C39D5EE043814FD8819D5E',1.0,'BUDGET/STUDENT SUPPORT','BUDGET/STU','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('82','014A17B043C49D5EE043814FD8819D5E',1.0,'PHYSICAL PLANT','PHYS PLANT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('83','014A17B043C59D5EE043814FD8819D5E',1.0,'ENROLLMENT SERVICES','ENROLL SERV','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('84','014A17B043C69D5EE043814FD8819D5E',1.0,'INTERCAMPUS TRANSFERS','INTRCMPSXFRE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('85','014A17B043C79D5EE043814FD8819D5E',1.0,'FACILITIES DEBT SERVICE','DEBT SERV','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('86','014A17B043C89D5EE043814FD8819D5E',1.0,'OFFICE OF ACADEMIC SUPPORT & DIVERSITY','ACAD SUPPORT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('87','014A17B043C99D5EE043814FD8819D5E',1.0,'HOSPITALS','HOSPITALS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('88','014A17B043CA9D5EE043814FD8819D5E',1.0,'PRESIDENT''S OFFICE','PRESIDENT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('89','014A17B043CB9D5EE043814FD8819D5E',1.0,'OTHER UNIVERSITY ADMINISTRATION ACCOUNTS','OTHER UA','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('90','014A17B043CC9D5EE043814FD8819D5E',1.0,'VP FOR ACADEMIC AFFAIRS','ACAD AFFAIRS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('92','014A17B043CD9D5EE043814FD8819D5E',1.0,'VP AND CHIEF FINANCIAL OFFICER','VP & CFO','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('94','014A17B043CE9D5EE043814FD8819D5E',1.0,'VP FOR INFORMATION TECHNOLOGY','VPIT','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('96','014A17B043CF9D5EE043814FD8819D5E',1.0,'VP FOR UNIV RELATIONS&CORP PARTNERSHIPS','U REL/CORP','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('97','014A17B043D59D5EE043814FD8819D5E',1.0,'VP FOR GOVERNMENT RELATIONS','GOVT RELTNS','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('98','014A17B043D09D5EE043814FD8819D5E',1.0,'VP AND CHIEF ADMINISTRATIVE OFFICER','ADMIN','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('99','014A17B043D19D5EE043814FD8819D5E',1.0,'SYSTEM CONTINGENCIES','CONTING','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('AG','014A17B043D29D5EE043814FD8819D5E',1.0,'RC AGGREGATION','AGGREGATE','Y')
/
INSERT INTO CA_RC_T (RC_CD,OBJ_ID,VER_NBR,RC_NM,RC_SHRT_NM,RC_ACTIVE_CD)
  VALUES ('NO','014A17B043D39D5EE043814FD8819D5E',1.0,'NO RESPONSIBILITY CENTER','NO RC','Y')
/