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

TRUNCATE TABLE CA_AICPA_FUNC_T DROP STORAGE
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('AS','0DF1FAB5ADCE03D2E043814FD88103D2',1.0,'ACADEMIC SUPPORT','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('AUX','0DF1FAB5ADCF03D2E043814FD88103D2',1.0,'AUXILIARY & SERVICE','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('IN','0DF1FAB5ADD003D2E043814FD88103D2',1.0,'INSTRUCTIONAL','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('IS','0DF1FAB5ADD103D2E043814FD88103D2',1.0,'INSTITUTIONAL SUPPORT','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('NA','0DF1FAB5ADD203D2E043814FD88103D2',1.0,'NOT APPLICABLE TO ACCOUNT','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('PP','0DF1FAB5ADD303D2E043814FD88103D2',1.0,'OPERATION AND MAINTENANCE OF PLANT','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('PS','0DF1FAB5ADD403D2E043814FD88103D2',1.0,'PUBLIC SERVICE','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('RE','0DF1FAB5ADD503D2E043814FD88103D2',1.0,'RESEARCH','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('S&F','0DF1FAB5ADD603D2E043814FD88103D2',1.0,'SCHOLARSHIPS & FELLOWSHIPS','Y')
/
INSERT INTO CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD,OBJ_ID,VER_NBR,FIN_AICPA_FUNC_NM,ROW_ACTV_IND)
  VALUES ('SS','0DF1FAB5ADD703D2E043814FD88103D2',1.0,'STUDENT SERVICES','Y')
/