Business

User Tools

Site Tools

Trace: • purchasing_requisition_nextyearaccountcode • select_org • Set up alternate approvers as needed • Column Sort • Create/Modify Invoice - BAR3000
finance:utilities:extractmacm

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
finance:utilities:extractmacm [2017/08/15 20:07] – emorenofinance:utilities:extractmacm [2022/10/03 20:41] (current) – emoreno
Line 5: Line 5:
 //**Finance > Utilities > Extract MACM**// //**Finance > Utilities > Extract MACM**//
  
-<WRAP round intro>This program creates the quarterly Finance and Human Resources reports required by the Texas Department of Human Services for reimbursement of medical case management and Medicaid outreach activity expenses. Users can create an individual Finance or Human Resources extract or both extracts at the same time. The reports are saved in an Excel format for quarterly submittal to the Texas Department of Human Services. +<WRAP round intro>This utility creates the quarterly Finance and Human Resources reports required by the Texas Department of Human Services for reimbursement of medical case management and Medicaid outreach activity expenses. Users can create an individual Finance or Human Resources extract or both extracts at the same time. The reports are saved in an Excel format for quarterly submittal to the Texas Department of Human Services. 
-Note:  At this time, all extracts have been in accordance with the Houston Consortium specifications, but can be used as a tool for any other consortium.+ 
 + 
 +**Note**:  At this time, all extracts have been in accordance with the Houston Consortium specifications, but can be used as a tool for any other consortium.
 </WRAP> </WRAP>
  
  
-====Create a MACM extract::====+====Create a MACM extract:====
  
-Under **Finance**:+VCV Under **Finance**:
  
  
-^Current File ID|The field is a display-only field and reflects the current file ID with which the user is logged on (e.g., C).| +^Current File ID|Displays the current file ID to which you are logged on (e.g., C).| 
-^Current Acct Periods|Type an accounting period, or click {{:images:dropdown.gif|}} to select an accounting period (e.g., 1-12). Users can either leave blank or enter up to three accounting periods from the current file ID. At least one accounting period under Current or Previous is required to perform an extract. MACM reporting does not follow the normal CYTD quarter process (e.g., the MACM first quarter would be July/August/September, the MACM second quarter would be October/November/December, etc.).| +^Current Acct Periods|Type an accounting period, or click {{:images:dropdown.gif|Drop-down Arrow}} to select an accounting period (e.g., 1-12). You can either leave blank or enter up to three accounting periods from the current file ID. At least one accounting period under Current or Previous is required to perform an extract. MACM reporting does not follow the normal CYTD quarter process (e.g., the MACM first quarter would be July/August/September, the MACM second quarter would be October/November/December, etc.).| 
-^Previous File ID|The field is a display-only field and reflects the previous file ID to which the user is logged on (e.g., 3).| +^Previous File ID|Displays the previous file ID to which you are logged on (e.g., 3).| 
-^Previous Acct Periods|Type an accounting period, or click {{:images:dropdown.gif|}} to select an accounting period (e.g., 1-12). Users can either leave blank or enter up to three accounting periods from the previous file ID. At least one accounting period under Current or Previous is required to perform an extract. MACM reporting does not follow the normal CYTD quarter process (e.g., the MACM first quarter would be July/August/September, the MACM second quarter would be October/November/December, etc.).|+^Previous Acct Periods|Type an accounting period, or click {{:images:dropdown.gif|Drop-down Arrow}} to select an accounting period (e.g., 1-12). Users can either leave blank or enter up to three accounting periods from the previous file ID. At least one accounting period under Current or Previous is required to perform an extract. MACM reporting does not follow the normal CYTD quarter process (e.g., the MACM first quarter would be July/August/September, the MACM second quarter would be October/November/December, etc.).|
 ^Breakdown by Organization| Select to display the report by organization. By default, the field is not selected.| ^Breakdown by Organization| Select to display the report by organization. By default, the field is not selected.|
  
-Under **Fund/Yrs Available**: 
  
-Select the funds to extract. If a fund/year is available, it is displayed in the left side of the page under **Fund/Yrs Available**. The right side of the page displays the funds/years selected for extract. At least one fund/year account is required to perform an extract. +VCV Under **Fund/Yrs Available**, select the checkbox next to the fund/yr(s) to be moved to the **Fund/Yrs To Extract** column. 
-  * Click the row of the desired fund/year to highlight it. + 
-  * Use the following buttons to include or exclude an entry or entries from the extract:+VCV Use the following buttons to move the selected fund/years to the right side of the page.  
 + 
  
 {{page>general:fourarrowbuttons}} {{page>general:fourarrowbuttons}}
  
  
-Once all entries have been selected for extract, click **Execute**. When the processing is complete, the General Ledger Revenue and Expense Report is displayed.+VCV Once all entries have been selected for extract, click **Execute**. 
  
-++++Review the report.|{{page>general:printreport&inline}}+++++When the processing is complete, the General Ledger Revenue and Expense Report is displayed. [[general:printreport|Review the report.]]
  
-Click **Process** to accept and save the extract. A message is displayed indicating that the Finance file was  +  * Click **Process** to accept and save the extract.
-created. Click **OK**.+
  
-Click **Cancel** to discard the extract and return to the Extract MACM page. A message is displayed indicating that the process was canceled, and no Finance file was created. Click **OK**.+<div indent> A message is displayed indicating that the Finance file was created successfully. Click **OK**. 
 +</div>
  
-Under **Human Resources**:+  * Click **Cancel** to discard the extract and return to the Extract MACM page. 
  
-Because the data from each district varies to such a high degree, all MACM requirements related to staff cannot be extracted in one simple download. Job codes vary from district to district in a user-generated table; therefore, the time study participants extracted should be modified to include only those eligible to participate.+<div indent> A message is displayed indicating that the process was canceled, and no Finance file was created. Click **OK**. 
 +</div>
  
-**Note**:  If the user’s district has multiple pay frequencies, all pay frequencies are extracted. Users need to consider the appropriate beginning and ending pay dates.+VCV Under **Human Resources**, since each LEA's data varies to such a high degree, all MACM requirements related to staff cannot be extracted in one simple download. Job codes vary from district to district in a user-generated table; therefore, the time study participants extracted should be modified to include only those eligible to participate. 
 + 
 +**Note**:  If your LEA has multiple pay frequencies, all pay frequencies are extracted. Be sure to consider the appropriate beginning and ending pay dates.
  
 ^Begin Date|Type the first pay date of the first month to start the extract. This is a required field.| ^Begin Date|Type the first pay date of the first month to start the extract. This is a required field.|
 ^End Date|Type the last pay date of the last month to end the extract. This is a required field.| ^End Date|Type the last pay date of the last month to end the extract. This is a required field.|
  
-Click Retrieve. The list of available funds is based on the dates entered in the **Begin Date** and **End Date** fields.+VCV Click **Retrieve**. The list of available funds is based on the dates entered in the **Begin Date** and **End Date** fields.
  
-Under **Fund/Yrs Available**:+VCV Under **Fund/Yrs Available**:
  
   * The list of available funds is based on the dates entered in the **Begin Date** and **End Date** fields.   * The list of available funds is based on the dates entered in the **Begin Date** and **End Date** fields.
Line 56: Line 62:
   * Once all entries have been selected for extract, click **Execute**.   * Once all entries have been selected for extract, click **Execute**.
  
 +When the processing is complete, the MACM Salary Benefit Report is displayed. [[general:printreport|Review the report.]]
  
-====Other functions and features:==== +  * Click **Process** to accept and save the extract. 
- +
-^{{:tsds:images:trash_delete.gif|}} | ++ Delete a row.|{{page>general:delete_a_row}}++|  /*Table row with text link*/ +
  
 +<div indent>A message is displayed indicating that the HRS file was created. Click **OK**.
 +</div>
 +\\
 +  * Click **Cancel** to discard the extract and return to the Extract MACM page. 
  
 +<div indent> A message is displayed indicating that the process was canceled and no HRS file was created. Click **OK**.
 +</div>
  
 {{indexmenu_n>65}} {{indexmenu_n>65}}
finance/utilities/extractmacm.1502827641.txt.gz · Last modified: 2017/08/15 15:07 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.