All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.oracle.CA_FUND_GRP_T.sql Maven / Gradle / Ivy

There is a newer version: 1.6.2
Show newest version
TRUNCATE TABLE CA_FUND_GRP_T DROP STORAGE
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('AE','01AFB744FDC89556E043814FD8819556',1.0,'Y','AUXILIARY ENTERPRISES','05','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('AF','01AFB744FDC99556E043814FD8819556',1.0,'Y','AGENCY FUNDS','10','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('CG','01AFB744FDCA9556E043814FD8819556',1.0,'Y','CONTRACT & GRANTS','04','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('CL','01AFB744FDCB9556E043814FD8819556',1.0,'Y','CLEARING & ROTATING','06','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('DP','8E5E5B94-49A5-786D-3017-E613C531A4D3',1.0,'Y','DEPOSITS','13','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('DS','01AFB744FDCC9556E043814FD8819556',1.0,'Y','DESIGNATED FUNDS','02','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('EN','01AFB744FDCD9556E043814FD8819556',1.0,'Y','ENDOWMENTS','08','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('GF','196D4AE5469A6008E043814FD8816008',1.0,'Y','GENERAL FUNDS','01','C')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('LF','01AFB744FDCF9556E043814FD8819556',1.0,'Y','LOAN FUNDS','07','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('OF','01AFB744FDD09556E043814FD8819556',1.0,'Y','OTHER FUNDS','11','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('PF','01AFB744FDD19556E043814FD8819556',1.0,'Y','PLANT FUNDS','09','F')
/
INSERT INTO CA_FUND_GRP_T (FUND_GRP_CD,OBJ_ID,VER_NBR,DOBJ_MAINT_CD_ACTV_IND,FUND_GRP_NM,FIN_REPORT_SORT_CD,FND_GRP_BA_RSTR_LVL_CD)
  VALUES ('RF','01AFB744FDD29556E043814FD8819556',1.0,'Y','RESTRICTED FUNDS','03','F')
/




© 2015 - 2024 Weber Informatics LLC | Privacy Policy