{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Budget Journal","MAP_BUDG_JRNL_FLATFILE","sql","MenuSheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget Journal","index":0,"n_rows":15,"n_cols":27,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,4,8,5],[9,4,9,10],[10,4,10,10],[3,4,3,5],[6,4,6,5],[7,4,7,5],[4,4,4,5],[5,4,5,5]]}
[]
[]
[null,"Journal Header",null,null,null,null,null,null,null,null,null,null,"Budget Entry Types",null,null,null,"Ledger Groups",null,null,null,null,null,"Business Units"]
[null,"Business Unit","KK_BD_HD_IMP.BUSINESS_UNIT",{"$f":"TRIM(MID(BU,1,SEARCH(\" - \",BU,1)))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"Entry Type","Description","Drop Down",null,"SetID","Ledger Grp","Descr","Use Budget Period ?","Drop down",null,"BU","Descr","Drop Down"]
[null,"Journal ID","KK_BD_HD_IMP.JOURNAL_ID",{"$f":"JRNL_ID","v":"NEXT"},"NEXT",null,null,null,null,null,null,null,0,"Original",{"$f":"M5& \" - \" & N5","v":"0 - Original"},null,"SHARE","CC_EXP","Exp Comtmnt Cntrl Ledger Group","Y",{"$f":"R5&\" - \" & S5","v":"CC_EXP - Exp Comtmnt Cntrl Ledger Group"},null,"CED01","Continuing Education",{"$f":"W5&\" - \" & X5","v":"CED01 - Continuing Education"}]
[null,"Journal Date","KK_BD_HD_IMP.JOURNAL_DATE",{"$f":"TEXT(JRNL_DATE,\"mmddyyyy\")","v":"01001900"},null,null,null,null,null,null,null,null,1,"Adjustment","1 - Adjustment",null,null,null,null,null,null,null,"CIT01","City College",{"$f":"W6&\" - \" & X6","v":"CIT01 - City College"}]
[null,"Ledger Group","KK_BD_HD_IMP.LEDGER_GROUP",{"$f":"TRIM(MID(LEDGER_GROUP,1,SEARCH(\" - \",LEDGER_GROUP,1)))","v":"CC_EXP"},"CC_EXP - Exp Comtmnt Cntrl Ledger Group",null,null,null,null,null,null,null,2,"Budget Transfer","2 - Budget Transfer",null,null,null,null,null,null,null,"DIS01","District Operations",{"$f":"W7&\" - \" & X7","v":"DIS01 - District Operations"}]
[null,"Budget Entry Type","KK_BD_HD_IMP.KK_BUDG_TRANS_TYPE",{"$f":"TRIM(MID(ENTRY_TYPE,1,SEARCH(\" - \",ENTRY_TYPE,1)))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES01","Mesa College",{"$f":"W8&\" - \" & X8","v":"MES01 - Mesa College"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIR01","Miramar College","MIR01 - Miramar College"]
[null,"Description"]
[null,"Comments","COMMENTS.DESCR100",{"$f":"BUD_JRNL_COMMENT","v":0}]
[]
[null,"Journal Line(s)"]
[null,"KK_BD_LN_IMP.BUDGET_PERIOD",null,null,"KK_BD_LN_IMP.FUND_CODE","KK_BD_LN_IMP.DEPTID","KK_BD_LN_IMP.PRODUCT","KK_BD_LN_IMP.ACCOUNT","KK_BD_LN_IMP.OPERATING_UNIT","KK_BD_LN_IMP.MONETARY_AMOUNT","KK_BD_LN_IMP.LINE_DESCR",null,null,null,null,null,null,null,null,null,null,null,null,null,"REVENUE","Y",{"$f":"T13&\" - \" & Y14","v":" - REVENUE"}]
[null,"Budget Period",null,null,"Fund","Dept ID","Activity","Account","Operating Unit","Amount","Line Description"]

{"sheet":"MAP_BUDG_JRNL_FLATFILE","index":1,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[]
["File Layout","KK_BUDGET_JRNL_IMPORT"]
[1,{"$f":"A4+1","v":2},{"$f":"B4+1","v":3},4,5,6,7,8]
["File Segment","Order of Processing","Single Row/Multiple Rows (S/M)","XL Name to identify Budget Journal ranges","Field Column Offset","Field Row Offset","Data Column Offset","Data Row Offset"]
[{"$f":"A11","v":"COMMENTS"},1,"S","BUDGET_COMMENTS",2,1,1,0,null,false]
[{"$f":"A13","v":"KK_BD_HD_IMP"},2,"S","BUDGET_HEADER",2,1,1,0]
[{"$f":"A39","v":"KK_BD_LN_IMP"},3,"M","BUDGET_LINES",1,1,0,2]
[]
["File Segment Name","Field Seq Nbr","Field Name","Field Description","Field Type","Start Pos","Length","Decimal Pos","Date Format","Date Separator","Default","Include on Budget Journal Template?","Comments"]
["COMMENTS",1,"RECORD_TYPE","Record Type","CHAR",1,1,0," "," ","#",null,null,1]
["COMMENTS",2,"DESCR100","Description","CHAR",2,100,0," "," ",null,null,null,{"$f":"N11+1","v":2}]
["KK_BD_HD_IMP",1,"RECORD_TYPE","Record Type","CHAR",1,1,0," "," ","H",null,null,{"$f":"N12+1","v":3}]
["KK_BD_HD_IMP",2,"KK_BUDG_TRANS_TYPE","Budget Entry Type","CHAR",2,1,0," "," ",null,null," Budget Entry Type\n\n0 = Original\n1 = Adjustment\n2 = Transfer Adjustment\n3 = Transfer Original\n4 = Closing\n5 = Roll Forward",4]
["KK_BD_HD_IMP",3,"BUSINESS_UNIT","Business Unit","CHAR",3,5,0," "," ",null,null,null,5]
["KK_BD_HD_IMP",4,"JOURNAL_ID","Journal ID","CHAR",8,10,0," "," ",null,null,null,6]
["KK_BD_HD_IMP",5,"JOURNAL_DATE","Journal Date","DATE",18,8,0,"MMDDYYYY"," ",null,null,null,7]
["KK_BD_HD_IMP",7,"KK_GEN_PARENT","Generate Parent Budget(s)","CHAR",26,1,0," "," ",{"$f":"IF(parent_gen=TRUE,\"Y\",\"N\")","v":"N"},null,null,8]
["KK_BD_HD_IMP",8,"KK_DEFAULT_EE","Use Default Entry Event","CHAR",27,1,0," "," ","N",null,null,9]
["KK_BD_HD_IMP",6,"KK_PARENT_ENT_TYPE","Parent Budget Entry Type","CHAR",28,1,0," "," ",{"$f":"MID('Budget Journal'!ENTRY_TYPE,1,1)","v":""},null,null,10]
["KK_BD_HD_IMP",9,"LEDGER_GROUP","Ledger Group","CHAR",29,10,0," "," ",null,null,null,11]
["KK_BD_HD_IMP",10,"DESCR","Description","CHAR",39,30,0," "," ",null,null,null,12]
["KK_BD_HD_IMP",11,"FOREIGN_CURRENCY","Foreign Currency Code","CHAR",69,3,0," "," ","USD",null,null,13]
["KK_BD_HD_IMP",12,"RT_TYPE","Rate Type","CHAR",72,5,0," "," ","CRRNT",null,null,14]
["KK_BD_HD_IMP",13,"CUR_EFFDT","Currency Effective Date","DATE",77,8,0,"MMDDYYYY"," ",{"$f":"TEXT(NOW(),\"mmddyyyy\")","v":"06302015"},null,null,15]
["KK_BD_HD_IMP",14,"RATE_MULT","Rate Multiplier","SIGN_NUMBER",85,17,8," "," ",1,null,null,16]
["KK_BD_LN_IMP",1,"RECORD_TYPE","Record Type","CHAR",1,1,0," "," ","L",null,null,17]
["KK_BD_LN_IMP",2,"JOURNAL_LINE","GL Journal Line Number","NBR",2,9,0," "," ","INCREMENT",null,"Journal Line Number\n\nDefaults to a number that is one more than the previous line number. The first line defaults to 1.",18]
["KK_BD_LN_IMP",3,"ACCOUNT","Account","CHAR",11,10,0," "," ",null,null,null,19]
["KK_BD_LN_IMP",4,"DEPTID","Department","CHAR",21,10,0," "," ",null,null,null,20]
["KK_BD_LN_IMP",5,"OPERATING_UNIT","Operating Unit","CHAR",31,8,0," "," ",null,null,null,21]
["KK_BD_LN_IMP",6,"PRODUCT","Product","CHAR",39,6,0," "," ",null,null,null,22]
["KK_BD_LN_IMP",7,"FUND_CODE","Fund Code","CHAR",45,5,0," "," ",null,null,null,23]
["KK_BD_LN_IMP",8,"CLASS_FLD","Class Field","CHAR",50,5,0," "," ",null,null,null,24]
["KK_BD_LN_IMP",9,"PROGRAM_CODE","Program Code","CHAR",55,5,0," "," ",null,null,null,25]
["KK_BD_LN_IMP",10,"BUDGET_REF","Budget Reference","CHAR",60,8,0," "," ",null,null,null,26]
["KK_BD_LN_IMP",11,"AFFILIATE","Affiliate","CHAR",68,5,0," "," ",null,null,null,27]
["KK_BD_LN_IMP",12,"AFFILIATE_INTRA1","Fund Affiliate","CHAR",73,10,0," "," ",null,null,null,28]
["KK_BD_LN_IMP",13,"AFFILIATE_INTRA2","Operating Unit Affiliate","CHAR",83,10,0," "," ",null,null,null,29]
["KK_BD_LN_IMP",14,"CHARTFIELD1","SubLedger","CHAR",93,10,0," "," ",null,null,null,30]
["KK_BD_LN_IMP",15,"CHARTFIELD2","ChartField 2","CHAR",103,10,0," "," ",null,null,null,31]
["KK_BD_LN_IMP",16,"CHARTFIELD3","User Field","CHAR",113,10,0," "," ",null,null,null,32]
["KK_BD_LN_IMP",17,"BUSINESS_UNIT_PC","PC Business Unit","CHAR",123,5,0," "," ",null,null,null,33]
["KK_BD_LN_IMP",18,"PROJECT_ID","Project","CHAR",128,15,0," "," ",null,null,null,34]
["KK_BD_LN_IMP",19,"ACTIVITY_ID","Activity","CHAR",143,15,0," "," ",null,null,null,35]
["KK_BD_LN_IMP",20,"RESOURCE_TYPE","Source Type","CHAR",158,5,0," "," ",null,null,null,36]
["KK_BD_LN_IMP",21,"BUDGET_PERIOD","Budget Period","CHAR",163,8,0," "," ",null,null,null,37]
["KK_BD_LN_IMP",22,"STATISTICS_CODE","Statistics Code","CHAR",171,3,0," "," ",null,null,null,38]
["KK_BD_LN_IMP",23,"STATISTIC_AMOUNT","Statistic Amount","SIGN_NUMBER",174,17,2," "," ",null,null,null,39]
["KK_BD_LN_IMP",24,"FOREIGN_CURRENCY","Foreign Currency Code","CHAR",191,3,0," "," ",null,null,null,40]
["KK_BD_LN_IMP",25,"FOREIGN_AMOUNT","Foreign Amount","SIGN_NUMBER",194,28,3," "," ",null,null,null,41]
["KK_BD_LN_IMP",26,"JRNL_LN_REF","Journal Line Reference","CHAR",222,10,0," "," ",null,null,null,42]
["KK_BD_LN_IMP",27,"LINE_DESCR","Journal Line Description","CHAR",232,30,0," "," ",null,null,null,43]
["KK_BD_LN_IMP",28,"RT_TYPE","Rate Type","CHAR",262,5,0," "," ","CRRNT",null,null,44]
["KK_BD_LN_IMP",29,"RATE_MULT","Rate Multiplier","SIGN_NUMBER",267,17,8," "," ",1,null,null,45]
["KK_BD_LN_IMP",30,"MONETARY_AMOUNT","Monetary Amount","SIGN_NUMBER",284,28,3," "," ",null,null,null,46]
["KK_BD_LN_IMP",31,"ENTRY_EVENT","Entry Event","CHAR",312,10,0," "," ",null,null,null,47]
["KK_BD_LN_IMP",32,"KK_CUM_BEGIN_DT","Cumulative Begin Date","DATE",322,8,0,"MMDDYYYY"," ",null,null,null,48]
["KK_BD_LN_IMP",33,"KK_CUM_END_DT","End Date","DATE",330,8,0,"MMDDYYYY"," ",null,null,null,49]
["KK_BD_LN_IMP",34,"FUND_SOURCE","Funding Source","CHAR",338,6,0," "," ",null,null,null,50]

{"sheet":"sql","index":2,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
["Database Schema","SYSADM"]
[]
[]
["Sql Statement to return File Layout Information"]
[]
["Criteria 1",{"$f":"MAP_BUDG_JRNL_FLATFILE!B3","v":"KK_BUDGET_JRNL_IMPORT"}]
[]
["SELECT "]
["  A.FLDSEGNAME AS \"File Segment Name\""]
["  , C.FLDSEQNO AS \"Field Seq Nbr\""]
["  , A.FLDDELIMITERTYPE"]
["  , C.FLDFIELDNAME AS \"Field Name\""]
["  , E.LONGNAME AS \"Field Descr\""]
["  ,   CASE "]
["        WHEN  C.FLDFIELDTYPE = 0 THEN 'CHAR' WHEN  C.FLDFIELDTYPE = 1 "]
["        THEN 'LONG_CHAR' "]
["        WHEN  C.FLDFIELDTYPE = 2 THEN 'NBR' "]
["        WHEN  C.FLDFIELDTYPE = 3 THEN 'SIGN_NUMBER' "]
["        WHEN  C.FLDFIELDTYPE = 4 THEN 'DATE' "]
["        WHEN  C.FLDFIELDTYPE = 6 THEN 'DTTM' "]
["        ELSE 'UNK' "]
["      END AS \"Field Type\""]
["  , C.FLDSTART AS \"Start Pos\""]
["  , C.FLDLENGTH AS \"Length\""]
["  , C.DECIMAL_POS as \"Decimal Pos\""]
["  , CASE WHEN C.FLDFIELDTYPE IN (4,6) THEN C.FLDDATEFMT ELSE ' ' END AS \"Date Format\""]
["  , CASE WHEN C.FLDFIELDTYPE IN (4,6) THEN C.FLDDATESEPARATOR ELSE ' ' END AS \"Date Separator\""]
["FROM "]
[{"$f":"\"      \" & IF(SCHEMA<>\"\",SCHEMA & \".\",\"\") & \"PSFLDSEGDEFN A\"","v":"      SYSADM.PSFLDSEGDEFN A"}]
[{"$f":"\"     ,\" & IF(SCHEMA<>\"\",SCHEMA & \".\",\"\") & \"PSFLDSEGDEFN B\"","v":"     ,SYSADM.PSFLDSEGDEFN B"}]
[{"$f":"\"     ,\"&IF(SCHEMA<>\"\",SCHEMA&\".\",\"\")&\"PSFLDFIELDDEFN C\"","v":"     ,SYSADM.PSFLDFIELDDEFN C"}]
[{"$f":"\"     ,\"&IF(SCHEMA<>\"\",SCHEMA&\".\",\"\")&\"PSDBFIELD D  LEFT OUTER JOIN \" & IF(SCHEMA<>\"\",SCHEMA&\".\",\"\") & \"PSDBFLDLABL E ON D.FIELDNAME = E.FIELDNAME AND E.DEFAULT_LABEL = 1\"","v":"     ,SYSADM.PSDBFIELD D  LEFT OUTER JOIN SYSADM.PSDBFLDLABL E ON D.FIELDNAME = E.FIELDNAME AND E.DEFAULT_LABEL = 1"}]
["WHERE "]
[{"$f":"\"     \" & \"A.FLDDEFNNAME = \" & \"'\" & B7 & \"'\"","v":"     A.FLDDEFNNAME = 'KK_BUDGET_JRNL_IMPORT'"}]
["     AND A.FLDDEFNNAME = B.FLDDEFNNAME"]
["     AND A.FLDSEGNAME = B.FLDSEGNAME"]
["     AND B.FLDDEFNNAME = C.FLDDEFNNAME"]
["     AND B.FLDSEGNAME = C.FLDSEGNAME"]
["     AND C.FLDFIELDNAME = D.FIELDNAME"]
["  ORDER BY 1, 2, 4"]

{"sheet":"MenuSheet","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["Level","Caption","Position/Macro","Divider","FaceID","Require Admin Security"]
[1,"&PS Budget Journals",10]
[2,"Create &New Budget Journal Spreadsheet","CreateNewBudgetJrnl"]
[2,"Export Budget Journal as file","LoadFCreateFile"]