{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Coversheet","Connect Information","Template","Data Input","Staging & Submission","Errors","Earnings Code"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":57,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Coversheet","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Excel To CI Utility"]
[null,null,"The purpose of this workbook is to upload data from Excel into PeopleSoft using the Component Interface to execute business logic for each transaction. This source workbook contains both worksheets and Excel VBA code modules.  The Worksheets can be copied to other workbooks for distribution without copying the code modules."]
[]
[null,"Process:"]
[null,"1)","Connection Information sheet: The information provided on this sheet is required to create a new template or submit data to the database. You will need to specify environment information as well as information in regard to how each transaction should be handled. The Action will be filled in automatically. By default, character fields which are left blank or only contain blanks will not be submitted for update. There is an option to override this setting."]
[]
[null,"2)","Template sheet: Here you create the template that you are going to use. The template is based upon the structure of a Component Interface on the PeopleSoft database."]
[null,null,"2.1. New Template: When prompted, enter the name of your PeopleSoft User ID, password, and the Component Interface you wish to use. The connect information previously provided is used to retrieve the PeopleSoft Component Interface properties. The Component Interface structure is displayed graphically."]
[null,null,"2.2. Manipulate Template: Here input cells are selected for inclusion on the Data Input and Staging & Submisson sheets.  The purpose of each button provided to allow manipulation of the template is more fully described by mousing over the button on the toolbar."]
[null,null,"2.3. New Data Input: This button copies the selected input cells into the Data Input sheet. The Data Input sheet becomes active, and you will be prompted before the structures and data on that sheet are deleted."]
[]
[null,"3)","Data Input sheet: Here you enter data values for submission to the PeopleSoft database."]
[null,null,"3.1. Stage Data for Submission: The data entered on the Data Input sheet is then staged in hierarchical form in preparation for submission to the database."]
[]
[null,"4)","Staging & Submission sheet: The last step is to format the data and submit to the database."]
[null,null,"4.1. Submit Data: This submits the data to the database.  Your PeopleSoft User ID and Password will be required. Each row submitted is marked with the reply from the database which will either be OK, Warning, or Error."]
[null,null,"4.2. Post Results: This posts the status for each row submitted to the database on the Data Input sheet so that data in a status of error can be corrected and resubmitted."]

{"sheet":"Connect Information","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"read":"row_number_cap"}
[]
[]
[]
[]
[]
[null,"Web Server Machine Name:","hprod.onehcm.usg.edu",null,"Optional Keys:"]
[null,"Protocol:"]
[null,"HTTP Port:"]
[null,"Portal:","EMPLOYEE"]
[null,"PeopleSoft Site Name:","hprod"]
[null,"Node:","PSFT_HR"]
[null,"Language Code:","ENG"]
[]
[null,"Chunking Factor:","40"]
[null,"Error Threshold:"," "]
[null,"Submit Blanks as Input:"]
[null,"Action:","UPDATE"]
[null,"Action:"]
[null,"Submit Options"]
[]
[null,"Allow Blanks:"," "]
[null,"BOR_CI_ADDL_PAY"]
[null,"Submit Options"]

{"sheet":"Template","index":2,"n_rows":15,"n_cols":41,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["BOR_CI_ADDL_PAY"]
[]
[null,null,"Collection","BOR_CI_ADDL_PAY","BOR_CI_ADDL_PAY","COLL_PAY_ERNCD","COLL_PAY_EFFDT","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA"]
[null,null,"Property","EMPLID","EMPL_RCD","KEYPROP_ERNCD","KEYPROP_EFFDT","KEYPROP_ADDL_SEQ","PROP_DEPTID","PROP_JOBCODE","PROP_POSITION_NBR","PROP_ACCT_CD","PROP_GL_PAY_TYPE","PROP_ADDL_PAY_SHIFT","PROP_OTH_HRS","PROP_HOURLY_RT","PROP_OTH_PAY","PROP_ADDLPAY_REASON","PROP_SEPCHK","PROP_EARNINGS_END_DT","PROP_GOAL_AMT","PROP_GOAL_BAL","PROP_OK_TO_PAY","PROP_DISABLE_DIR_DEP","PROP_PRORATE_ADDL_PAY","PROP_PAY_PERIOD1","PROP_PAY_PERIOD2","PROP_PAY_PERIOD3","PROP_PAY_PERIOD4","PROP_PAY_PERIOD5","PROP_TAX_PERIODS","PROP_TAX_METHOD","PROP_ADDL_PAY_FREQUENCY","PROP_DED_TAKEN","PROP_DED_SUBSET_ID","PROP_DED_TAKEN_GENL","PROP_DED_SUBSET_GENL","PROP_BUSINESS_UNIT","PROP_COMP_RATECD","PROP_STATE","PROP_LOCALITY"]
[null,null,"Record Type","000","000","100","110","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111"]
[null,null,"Field Type","CHARACTER","NUMBER","CHARACTER","DATE","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","SIGNED_NUMBER","NUMBER","SIGNED_NUMBER","CHARACTER","NUMBER","DATE","SIGNED_NUMBER","SIGNED_NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,"Field Length","11","3","3","10","2","10","6","8","25","6","1","4.2","12.6","8.2","3","2","10","8.2","8.2","1","1","1","1","1","1","1","1","2","1","1","1","3","1","3","5","6","6","10"]
[null,null,"Key / Required","Y/ ","Y/ ","Y/R","Y/ ","Y/R"," / "," / "," / "," / "," / "," /R"," / "," / "," / "," / "," / "," / "," / "," / "," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," / "," /R"," /R"," /R"," / "," /R"," / "," / "," / "," / "," / "]
[null,null,"Sequence","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38"]
["Status","Line No","Record Type","Empl ID","Empl Record","Earnings Code","Effective Date","Additional Pay Sequence Number","Department","Job Code","Position Number","Combination Code","General Ledger Pay Type","Additional Pay Shift","Other Hours","Hourly Rate","Other Pay","Reason for Additional Pay","Separate Check Nbr","Earnings End Date","Goal Amount","Current Goal Balance","OK to Pay","Disable Direct Deposit","Prorate Additional Pay","First Pay Period","Second Pay Period","Third Pay Period","Fourth Pay Period","Fifth Pay Period","Tax Periods","Tax Method","Tax Frequency","Deductions Taken","Deduction Subset ID","General Deductions Taken","General Ded Subset ID","Business Unit","Comp Rate Code","State","Locality"]
["Template",null,"000","",""]
["Template",null,"100",null,null,""]
["Template",null,"110",null,null,null,""]
["Template",null,"111",null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Data Input","index":3,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["BOR_CI_ADDL_PAY"]
["Record Type 000","Record Type 000","Record Type 100","Record Type 110","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111","Record Type 111"]
["Empl ID","Empl Record","Earnings Code","Effective Date","Additional Pay Sequence Number","Combination Code","Other Pay","Reason for Additional Pay","Separate Check Nbr","Earnings End Date","Goal Amount","OK to Pay","First Pay Period","Second Pay Period","Third Pay Period"]

{"sheet":"Staging & Submission","index":4,"n_rows":11,"n_cols":41,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["BOR_CI_ADDL_PAY"]
[null,null,null,"BOR_CI_ADDL_PAY","BOR_CI_ADDL_PAY","COLL_PAY_ERNCD","COLL_PAY_EFFDT","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA","COLL_PAY_DATA"]
[null,null,null,"EMPLID","EMPL_RCD","KEYPROP_ERNCD","KEYPROP_EFFDT","KEYPROP_ADDL_SEQ","PROP_DEPTID","PROP_JOBCODE","PROP_POSITION_NBR","PROP_ACCT_CD","PROP_GL_PAY_TYPE","PROP_ADDL_PAY_SHIFT","PROP_OTH_HRS","PROP_HOURLY_RT","PROP_OTH_PAY","PROP_ADDLPAY_REASON","PROP_SEPCHK","PROP_EARNINGS_END_DT","PROP_GOAL_AMT","PROP_GOAL_BAL","PROP_OK_TO_PAY","PROP_DISABLE_DIR_DEP","PROP_PRORATE_ADDL_PAY","PROP_PAY_PERIOD1","PROP_PAY_PERIOD2","PROP_PAY_PERIOD3","PROP_PAY_PERIOD4","PROP_PAY_PERIOD5","PROP_TAX_PERIODS","PROP_TAX_METHOD","PROP_ADDL_PAY_FREQUENCY","PROP_DED_TAKEN","PROP_DED_SUBSET_ID","PROP_DED_TAKEN_GENL","PROP_DED_SUBSET_GENL","PROP_BUSINESS_UNIT","PROP_COMP_RATECD","PROP_STATE","PROP_LOCALITY"]
[null,null,null,"000","000","100","110","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111","111"]
[null,null,null,"CHARACTER","NUMBER","CHARACTER","DATE","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","SIGNED_NUMBER","NUMBER","SIGNED_NUMBER","CHARACTER","NUMBER","DATE","SIGNED_NUMBER","SIGNED_NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","NUMBER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER","CHARACTER"]
[null,null,null,"11","3","3","10","2","10","6","8","25","6","1","4.2","12.6","8.2","3","2","10","8.2","8.2","1","1","1","1","1","1","1","1","2","1","1","1","3","1","3","5","6","6","10"]
[null,null,null,"Y/ ","Y/ ","Y/R","Y/ ","Y/R"," / "," / "," / "," / "," / "," /R"," / "," / "," / "," / "," / "," / "," / "," / "," /R"," /R"," /R"," /R"," /R"," /R"," /R"," /R"," / "," /R"," /R"," /R"," / "," /R"," / "," / "," / "," / "," / "]
[null,null,null,"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38"]
["Status","Line No","Record Type","Empl ID","Empl Record","Earnings Code","Effective Date","Additional Pay Sequence Number","Department","Job Code","Position Number","Combination Code","General Ledger Pay Type","Additional Pay Shift","Other Hours","Hourly Rate","Other Pay","Reason for Additional Pay","Separate Check Nbr","Earnings End Date","Goal Amount","Current Goal Balance","OK to Pay","Disable Direct Deposit","Prorate Additional Pay","First Pay Period","Second Pay Period","Third Pay Period","Fourth Pay Period","Fifth Pay Period","Tax Periods","Tax Method","Tax Frequency","Deductions Taken","Deduction Subset ID","General Deductions Taken","General Ded Subset ID","Business Unit","Comp Rate Code","State","Locality"]
["STOP"]

{"sheet":"Errors","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Earnings Code","index":6,"n_rows":164,"n_cols":2,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["$AC","All Earnings Codes - System Cd"]
["$NA","N/A - Retro Place Holder"]
["3PS","Third Party Sick Pay"]
["A17","Non Resident Alien Income Code"]
["A18","Non Resident Alien Income Code"]
["A19","Non Resident Alien Income Code"]
["ACA","ACA Tracking"]
["ADH","Admin NonInstructional Staff"]
["ADM","Non-Instructional Assignment"]
["AFF","Adjustment to FICA-SocSecMed"]
["AFM","Adjust FICA,Fed WH, State WH"]
["AMM","Admin Leave-Exempt"]
["AMN","Administrative Leave-NonEx"]
["AS7","Additional Straight Time 17"]
["AS8","Additional Straight Time 18"]
["AS9","Additional Straight Time 19"]
["AST","Additional Straight Time"]
["AWD","Employee Award"]
["CAC","Car Allowance"]
["CAR","Car Allowance-Reportable"]
["CCB","Campus Closure Non-Exempt"]
["CCM","Campus Closure-Exempt"]
["CFR","Summer Comp for Research"]
["CIG","Call In Guaranteed"]
["CIP","Call In Pay"]
["COM","Communications Allowance"]
["CPL","Comp Time in Lieu of Sick"]
["CPT","Comp Time Taken"]
["DCA","Deferred Comp Allowance"]
["DFN","Dual Faculty-Non Ret Elig"]
["DFR","Dual Faculty-Ret Eligible"]
["DFT","Deferred Holiday Taken"]
["DLA","Donated Leave Award"]
["DLM","Donated Leave-Exempt"]
["DOM","Donation - Exempt"]
["DON","Donation Non-Exempt"]
["DOT","DualApptOvertime"]
["DSN","Dual Appt Staff Non-Ret Elig"]
["DSR","Dual Staff-Ret Eligible"]
["EDU","Education Assistance"]
["EF7","Extra Pay Annualized17 Faculty"]
["EF8","Extra Pay Annualized18 Faculty"]
["EF9","Extra Pay Annualized19 Faculty"]
["ELH","Extended Leave Non-Exempt"]
["ELM","Extended Leave Exempt"]
["ENF","Extra Pay-PT Faculty"]
["ENS","Extra Pay-PT Staff"]
["ES7","Extra Pay Annualized 17 Staff"]
["ES8","Extra Pay Annualized 18 Staff"]
["ES9","Extra Pay Annualized 19 Staff"]
["ESL","Education Support Leave Non-Ex"]
["ESM","Education Support Leave Exempt"]
["EX7","Extra Pay Annualized 17"]
["EX8","Extra Pay Annualized 18"]
["EX9","Extra Pay Annualized 19"]
["EXF","Extra Pay Annualized - Faculty"]
["EXS","Extra Pay Annualized - Staff"]
["FUM","Furlough Exempt"]
["FUR","Furlough Non-Exempt"]
["HL7","Holiday 17"]
["HL8","Holiday 18"]
["HL9","Holiday 19"]
["HM7","Holiday Monthly 17"]
["HM8","Holiday Monthly 18"]
["HM9","Holiday Monthly 19"]
["HOL","Holiday Non-Exempt"]
["HOM","Holiday Exempt"]
["HON","Housing-No RET"]
["HOR","Housing Reportable NoNetPay"]
["HOU","Housing Adds to Gross"]
["IWB","Inclement Weather Non-Exempt"]
["IWM","Inclement Weather-Exempt"]
["JDU","Jury Duty Unpaid Non-Exempt"]
["JRM","Jury Duty Exempt"]
["JUM","Jury Duty Unpaid Exempt"]
["JUR","Jury Duty Non-Exempt"]
["MID","Military Differential"]
["MIL","Military Duty Non-Exempt"]
["MLM","Military Leave Exempt"]
["MO7","Moving Reimbursement Taxabl 17"]
["MO8","Moving Reimbursement Taxabl 18"]
["MO9","Moving Reimbursement Taxabl 19"]
["MV7","Moving Reimburse Non-Taxabl 17"]
["MV8","Moving Reimburse Non-Taxabl 18"]
["MV9","Moving Reimburese Non-Taxbl 19"]
["NME","Non Qualified Moving Expenses"]
["ONC","On Call Pay"]
["OV7","Overtime 17"]
["OV8","Overtime 18"]
["OV9","Overtime 19"]
["OVL","Faculty Overload"]
["OVT","Overtime"]
["PAC","Payout Accrued Comp Time"]
["PEC","Payout Expired Comp Time"]
["POE","457F Deferred Comp Pensionable"]
["PSS","Participant SupportStipdendNSF"]
["QME","Qualified Moving Expenses"]
["RAS","Retro Additional Straight Time"]
["RCG","Retro Call In Guarranteed"]
["RCP","Retroactive Call-in Pay"]
["RCS","Retro Pay Comp Time Sick"]
["RCT","Retro Comp Time"]
["REG","Regular"]
["RML","Retro Military Leave Pay"]
["RTF","Retro Furlough"]
["RTH","Retro Holiday"]
["RTJ","Retro Jury Duty"]
["RTO","Retro Overtime"]
["RTP","Retro Pay"]
["RTS","Retro Sick"]
["RTV","Retro Vacation"]
["RTW","Retro Telework Non-Exempt"]
["S10","Shift Differentail 10%"]
["S50","Shift Differential 0.50"]
["S75","Shift Differential 0.50 OT"]
["SC7","Sick 17"]
["SC8","Sick 18"]
["SC9","Sick 19"]
["SCK","Sick Leave Non-Exempt"]
["SGC","Shift Diff - GCSU"]
["SKM","Sick Leave Exempt"]
["SNF","Supp Pay-Non-Ret Elig Faculty"]
["SNS","Supp Pay Non Ret Elig Staff"]
["STU","Student Pay"]
["SUB","Subsistence - Adds to Gross"]
["SUF","Supp Pay Ret Eligible Faculty"]
["SUM","Summer Pay"]
["SUR","Subsistence (No Net Pay)"]
["SUS","Supp Pay RET Eligible Staff"]
["TFG","Taxable Fringe Adds to Gross"]
["TFR","Taxable Fringe - Reportable"]
["TRV","Travel Expenses - Taxable"]
["TWH","Teleworking Non-Exempt"]
["TWM","Teleworking Exempt"]
["TXT","Taxable Travel Expense/Advance"]
["UC7","Uncompensated 17"]
["UC8","Uncompensated 18"]
["UC9","Uncompensated 19"]
["UHM","Unscheduled Holiday-Exempt"]
["UM7","Uncompensated Monthly 17"]
["UM8","Uncompensated Monthly 18"]
["UM9","Uncompensated Monthly 19"]
["UNC","Uncompensated Non-Exempt"]
["UNH","Unscheduled Holiday Non-Exempt"]
["UNM","Uncompensated Exempt"]
["VAC","Vacation Non-Exempt"]
["VAM","Vacation Exempt"]
["VC7","Vacation 17"]
["VC8","Vacation 18"]
["VC9","Vacation 19"]
["VCS","Vacation Cash Out Non-Exempt"]
["VF7","Vacation Payout Faculty 17"]
["VF8","Vacation Payout Faculty 18"]
["VF9","Vacation Payout Faculty 19"]
["VM7","Vacation Monthly 17"]
["VM8","Vacation Monthly 18"]
["VM9","Vacation Monthly 19"]
["VOH","Voting Non-Exempt"]
["VOM","Voting Exempt"]
["VPF","Vacation Payout Faculty"]
["VPS","Vacation Payout Staff"]
["VS7","Vacation Payout Staff 17"]
["VS8","Vacation Payout Staff 18"]
["VS9","Vacation Payout Staff 19"]