• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• CA_ORG_RVRSN_CTGRY_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.mysql.CA_ORG_RVRSN_CTGRY_T.sql Maven / Gradle / Ivy

TRUNCATE TABLE CA_ORG_RVRSN_CTGRY_T
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C01','14B9E421E893A05CE043814FD881A05C',1.0,'Org Wages','01','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C02','14B9E421E894A05CE043814FD881A05C',1.0,'Salary/Fringes','02','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C03','14B9E421E895A05CE043814FD881A05C',1.0,'Financial Aid','03','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C04','14B9E421E896A05CE043814FD881A05C',1.0,'Capital Equip','04','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C05','14B9E421E897A05CE043814FD881A05C',1.0,'Reserve','05','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C06','14B9E421E898A05CE043814FD881A05C',1.0,'Transfer Out','06','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C07','14B9E421E899A05CE043814FD881A05C',1.0,'Transfer In','07','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C08','14B9E421E89AA05CE043814FD881A05C',1.0,'Travel','08','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C09','14B9E421E89BA05CE043814FD881A05C',1.0,'Other Expense','09','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C10','14B9E421E89CA05CE043814FD881A05C',1.0,'Assess Expend','10','Y')
/
INSERT INTO CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD,OBJ_ID,VER_NBR,ORG_RVRSN_CTGRY_NM,ORG_RVRSN_SORT_CD,ORG_RVRSN_CTGRY_ACTV_IND)
  VALUES ('C11','14B9E421E89DA05CE043814FD881A05C',1.0,'Revenue','11','Y')
/