Functional Description
B0700058Establish Connection to Vertex
Purpose
Before any tax calculation can occur, the application must successfully connect to the Payroll Tax
Database. An application acquires a connection handle with the VprtOpenPRT function and holds that link
to the Quantum Database throughout the payroll cycle.
Setup Notes and Prerequisites
The Establish Connection to Vertex routine is called in the initialize section of the Pre-Payroll
Driver UBE (R07200).
Technical Specification
Parameters:
Data Item Data Structure Description I/O Required Notes
Location of the database
Database Server name
User ID
User Password
Related Tables
none
Related Business Functions
Source Name Function Name
B0700059Disconnect from Vertex
Processing
1.0These four parameters are populated in the Application P7306 "Vertex Constants Revision", perform a "FormConnect" and the
form "Work with Connections" will appear. Tab over to the Payroll form and enter the values for the four parameters in upper
case.
2.0Depending upon the working environment (AS/400, UNIX, Windows NT, etc), populate the Vertex API function
pointers to be used later in the payroll process.
3.0Hold the Vertex API function pointer in a cache. This will be shared among other Business Functions.
4.0Based on the four parameters above, execute the Vertex API function to connect to the Vertex database.
5.0 Store the connection handle in the cache.
D0700058 - Establish Connection to Vertex
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| cDoNotUse | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cVertexConnectionFailed | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cVertexLibraryFailedFlag | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
| cVertexInvalidPointerFlag | EV04 | char | OPT | NONE |
PeopleSoft event point processing flag 04. | ||||
| B0700004 Set Tax Calculation Inputs | ||||
| B0700008 Perform Tax Calculations | ||||
| B0700009 Create Tax Detail Records | ||||
| B0700010 Vertex Tax Calculations | ||||
| B0700059 Disconnect from Vertex | ||||
| N0700057 Get Vertex Database Connection |
| None |