{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data Entry","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":"Data Entry","index":0,"n_rows":10,"n_cols":25,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,10],[3,7,3,10],[4,7,4,10],[7,2,7,4],[3,5,3,6],[4,5,4,6],[7,5,7,24]]}
[null,"AKSAS Collocation Code to IRIS COA Elements - Crosswalk Table Maintenance "]
[null,"Control\nCounts","Entry\nCount","Error\nCount"]
[null,"Adds",0,0]
[null,"Changes",0,0,null,"Export Folder:",null,"C:\\",null,null,null,null,null,"= Required field not entered",null,null,null,null,"= Value entered is not in correct format"]
[null,"Deletes",0,0,null,"FTPS Link:",null,"https://ftps.dof.doa.alaska.gov",null,null,null,null,null,"= Value entered is less than minimum length",null,null,null,null,"= Numeric value is outside valid range"]
[null,"Total",0,0,null,null,null,null,null,null,null,null,null,"= Value entered exceeds maximum length",null,null,null,null,"= Invalid Transaction Type, valid types are A, C, and D"]
[]
[null,null,"Key Fields",null,null,"IRIS COA Elements"]
["Seq","Trxn","FY","CC","SY","BFY","Fund","Sub Fund","Appr Unit","Dept","Unit","Activity","Program","Phase","Pgm Period","Location","Function","Task","Task Order","Sub Unit","Sub Activity","Sub Location","Sub Function","Sub Task","Personal\nServices"]
["Num","Type",4,8,4,4,4,4,"9","4","4","4","10","6",6,4,10,4,6,4,4,4,4,4,1]

{"sheet":"Instructions","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,4,10,12],[11,4,11,12],[9,1,9,3],[13,1,13,3],[13,4,13,12],[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[4,1,4,12],[5,1,5,12],[6,1,6,12],[7,1,7,12],[8,1,8,12],[12,4,12,12],[10,1,10,3],[11,1,11,3],[12,1,12,3],[9,4,9,12]]}
[null,"AKSAS Collocation Code to IRIS COA Elements - Crosswalk Table Maintenance -  User Instructions"]
[null,"Overview\n\nThis Excel workbook template is provided as a tool for each agency to help maintain the entries in the AKSAS Collocation Code to IRIS chart of account element crosswalk table. The purpose of this crosswalk table is to allow external systems, such as AKPAY, to continue to provide AKSAS collocation codes on inbound interfaces to IRIS. The combination of collocation code, budget fiscal year, and fiscal year will be used to find a mathcing crosswalk table entry, and the IRIS chart of account elements from the crosswalk table will be used to populate the accounting line on the IRIS document.\n\nThe contents of the crosswalk table are maintained within the IRIS database and can be viewed using ALDER reporting. Any required changes to the crosswalk table information are made by authorized individuals in each department using this Excel template. Crosswalk data is entered or copied into the Data Entry sheet in this workbook. The Excel macros embedded in the workbook are then used to perform basic validation of the data, and then to  create a text file, in comma-separated value (CSV) format that is used to load the data to the actual tables in the IRIS database. After a CSV file has been created, it is transferred, using secure FTP, to a department specific folder that is accessible to authorized agency staff. From there, an automated batch process accesses the file and uses it to update the IRIS crosswalk table."]
[null,"Step-by-Step Instructions\n\n1)  After opening the CC_Xwalk workbook, or creating a new from a template, enter the crosswalk data to be added, changed, or deleted from the IRIS table. This data can be manually entered or it can be copied from another source, such as an ALDER report of the crosswalk table."]
[null,"2) For each row, identify the type of transaction (A, C, or D) in the TRXN TYPE column and enter all the desired chart of account elements. If the TRXN TYPE column is left blank, that row will be skipped during the validation and the data export processing. The first three columns, FY, CC, and BFY, are required for every transaction. For add and change transactions, enter all of the desired IRIS chart of account elements, even if they already exist in the table entry to be changed. Delete transactions require just the key fields and the transaction type. Additional fields can be entered on a delete transaction row, but they will be ignored."]
[null,"3) Validate the data by clicking on the Edit Data button and correct any errors that are found. The validation process will calculate the number of add, change, and delete transactions that were entered, calculate the number of errors detected, and highlight any cells with validation errors using color codes. The meaning of each color is explained by the legend at the top of the Data Entry sheet. For reference, the maximum length of each field is listed below field name in the column heading."]
[null,"4) After the data has been entered and validated, it is ready for export. Verfiy the folder location that is specified in the Export Folder cell. If the current value is not correct, click on the Set Folder button to change it. When the export folder location has been verified, click on the Save Data button to export the data to a CSV file. The data is re-validated prior to export and if any errors are found the process stops. If the export is successful, you will see dialog box with the name of the CSV file that was created."]
[null,"5) Next the exported CSV file is uploaded to the secure FTP server for processing. Click on the hyperlink in the FTPS Link cell to log in to that server using your default web browser. Each department is provided with a single FTP user account to use for crosswalk table maintenance. After logging in to your agencies crosswalk FTP account, click on the upload button and select the file creted in the previous step. Then log out of the FTP server by pressing the log out button in the uppoer right corner of the screen."]
[null,"6) The uploaded file will be automatically picked up for processing and you will receive an email notification with the results. If errors are detected during that process, a corrected file will need to be created and submitted. "]
[null,"Column Descriptions:"]
[null,"Seq Num",null,null,"The sequence number column is automatically populated during the validation process and is used to identify the individual transactions during later processing. It should be left blank."]
[null,"Trxn Type",null,null,"The valid values of transaction type are A, C, and D for add, change, and delete. If the transaction type column is left blank, then that row will be skipped during validation and export and the process will continue with any subsequent rows."]
[null,"FY - CC -SY",null,null,"The fiscal year, collocation code, and setup year for the crosswalk table entry. These three fields are the \"key\" values that will be provided on inbound interface transactions and will be used to lookup the crosswalk table entry.\n\nFor add transactions, the combination of value cannot exist on the IRIS crosswalk table. For change and delete transactions, it must exist."]
[null,"BFY thru Sub-Task",null,null,"These columns represent the IRIS chart of account elements that will be \"substituted\" for the FY-CC-SY values provided in the inbound interface. Refer to the IRIS user documentation for descriptions of the individual COA elements."]
[null,"Personal Services",null,null,"Set the personal services flag to Y to indicate that payroll may be charged to this collocation code. CC's entered in the labor distribution segment in AKPAY will be validated against the list of crosswalk entries where Personal Services equals Y. Setting the flag to N or blank will prevent that CC from being entered in AKPAY."]