Child pages
  • NEWCNT - New Contract

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Newpay Option

NEWPAY offers the ability to select and sort records based on pay accounts. This report allows sorting subtotaling, and page breaking based on account code, employee ID, employee name, and/or job number.

Specific records may be selected to be reported based on a range of accounts, or using wildcard account code selections. In addition to selections on account code, selections may also be made by specific employees, paygroups, job status, building and department codes. There is also an option to include or exclude hourly jobs.

The report will calculate the amount to be charged to the pay accounts based on the remaining contract obligation to be paid. Fixed amount pay accounts will be included and taken into consideration for these calculations.

Screen 1 of 4

Code Block
 --------------------------------------------------------------------------
|                    NEWPAY - Pay Account Report Generation                |
|Report File Specifications:                                               |
| Output File                                      NEWPAY.TXT              |
| Print Options Page? (Y/N)                        _                       |
| Optional heading                       ________________________________  |
|                                                                          |
|Sort, Subtotal, and Pagebreak Options:                                    |
| Sort: ________         Subtotal: _________       Pagebreak: __________   |
|                                                                          |
|Selection Criteria:                                                       |
| Job Status: _________     Include Hourly Emps:  _                        |
| Building:   ___ ___ ___ ___ ___ ___ ___ ___ ___ ___                      |
| Department: ___ ___ ___ ___ ___ ___ ___ ___ ___ ___                      |
| Specific Employees:    ________ ________ ________ ________ ________      |
|                        ________ ________ ________ ________ ________      |
|                        ________ ________ ________ ________ ________      |
|                        ________ ________ ________ ________ ________      |
|                                                                          |
| Report new contract pay account information                      1 of 4  |
|  PF4 Execute         F9  Cancel          S8  Next Screen                 |
|  F6  First Screen    F10 Reset                                           |
|  F7  Help            F11 Save/Recall                                     |
|  F8  Exit            S7  Prev Screen                                     |
|_________________________________________________________________________ |

Field Definitions

  • NEWPAY.TXT is the default file name for the detail report. This can be changed by entering a new file name in the Output file field.
  • The creation of option page showing detail of how the report was run is controlled by the Print options pages?field.
    • "Y" (yes) will generate the page
    • "N" (no) will not generate the page. A printed record of the various sort and selection options and dates chosen can be helpful when researching problems.
  • Information entered in the Optional heading field will appear at the top of each page of the report. This field can also be used to enter a date, date range, or specific selection options you would like printed at the top of each page.
  • The Sort optionsfield offers the following choices:
    • ID - Employee ID
    • N - Employee Name
    • A - Pay Account
    • J - Employee Job Number
  • In the Subtotal option field, enter the field you wish the report to subtotal on. The choices are the same as the Sort Option list shown above. The option selected must also be one of the Sort Options chosen.
  • In the Pagebreak option field, enter the field you wish the report to pagebreak on. The choices are the same as the Sort Options listed above. The option selected must also be one of the Sort Options chosen.
  • Enter any combination of job status options separated by commas in the Job Statusfield.
    • 0 - Inactive employees
    • 1 - Active employees
    • 8 - Deceased employees
    • 9 - Terminated employees
  • The Include Hourly Emps:field offers the following choices:
    • Y - Hourly employees will be included on report.
    • N - Hourly employees will Not be included on report.
  • In the Building field, enter the building code you wish to select.
  • In the Department field, enter the Department code you wish to select.
  • Enter Specific Employees if desired by SSN, ID, or employee name. A name should be entered as LAST, FIRST. If left blank, all employees will be selected.

Screen 2 of 4

Code Block
borderStylenone
 __________________________________________________________________________________
|                  NEWPAY - Pay Account Report Generation                         |
|Specific Employees (Cont):                                                       |
|                    __________  __________  __________  __________  __________   |
|                    __________  __________  __________  __________  __________   |
|                    __________  __________  __________  __________  __________   |
|                    __________  __________  __________  __________  __________   |
|                    __________  __________  __________  __________  __________   |
|                    __________  __________  __________  __________  __________   |
|                                                                                 |
|Include or Exclude pay groups? (I,E)                    _                        |
|Pay Groups:      __  __  __  __  __  __  __  __  __  __  __  __  __  __  __      |
|                 __  __  __  __  __  __  __  __  __  __  __  __  __  __  __      |
|                 __  __  __  __  __  __  __  __  __  __  __  __  __  __  __      |
|                 __  __  __  __  __  __  __  __  __  __  __  __  __  __  __      |
|                                                                                 |
|Press <next screen> for wildcard account selection options                       |
|                                                                                 |
|Report new contract pay account information                            2 of 4    |
| PF4 Execute         F9  Cancel          S8  Next Screen                         |
| F6  First Screen    F10 Reset                                                   |
| F7  Help            F11 Save/Recall                                             |
| F8  Exit            S7  Prev Screen                                             |
----------------------------------------------------------------------------------

Field Definitions

  • The Include or Exclude pay groups?field offers the following choices:
    • I - Pay groups entered will be Included in the resulting report.
    • E - Pay groups entered will be Excluded from the resulting report.
  • The Pay Groups field allows for selection based on the available Pay Groups. Leaving this field blank will cause all the pay groups to be selected.

Screen 3 of 4

Code Block
borderStylenone
__________________________________________________________________________________
|                       NEWPAY - Pay Account Report Generation                    |
| -Wildcard budget account selection -       Fnd Func Obj SCC   Subj  Opu IL Job  |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                             Wildcard       ___ ____ ___ ____ ______ ___ __ ____ |
|                                                                                 |
|Press <next screen> for range account selection options                          |
|                                                                                 |
| Report new contract pay account information                              3 of 4 |
|  PF4 Execute         F9  Cancel           S8  Next Screen                       |
|  F6  First Screen    F10 Reset                                                  |
|  F7  Help            F11 Save/Recall                                            |
|  F8  Exit            S7  Prev Screen                                            |
-----------------------------------------------------------------------------------

Field Definitions

This screen presents the option to substitute wildcard or short-cut characters which will allow you to access specific account dimensions for reporting purposes. Enter the appropriate account selection to use as a wildcard. You may use %, *, # or @ for wildcards:

HTML Table
border3
width75%


Table Row (tr)


Table Head (th)
Wildcard


Table Head (th)
Meaning



Table Row (tr)


Table Cell (td)

%


Table Cell (td)

Represents a single character.



Table Row (tr)


Table Cell (td)

*


Table Cell (td)

Represents any number of characters.



Table Row (tr)


Table Cell (td)

#


Table Cell (td)

Represents a single numeric character.



Table Row (tr)


Table Cell (td)

@


Table Cell (td)

Represents a single alphabetic character.



Screen 4 of 4

Code Block
borderStylenone
________________________________________________________________________________
|                     NEWPAY - Pay Account Report Generation                    |
| - Range budget account selection -       Fnd Func Obj SCC  Subj   Opu  IL Job |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|                             From         ___ ____ ___ ____ _____  ___  __ ___ |
|                             To           ___ ____ ___ ____ _____  ___  __ ___ |
|Enter the appropriate account selection to start the range.                    |
|Report new contract pay account information                             4 of 4 |
| PF4 Execute          F9 Cancel           S8 Next Screen                       |
| F6  First Screen     F10 Reset                                                |
| F7  Help             F11 Save/Recall                                          |
| F8  Exit             S7  Prev Screen                                          |
---------------------------------------------------------------------------------

Field Definitions

Selecting a Range of Salary Accounts

This screen allows you the option of selecting ranges of accounts.

For example, if you wanted to select all salary accounts, enter the following:

Code Block
              FND FUNC OBJ SCC  SUBJ   OPU IL JOB

    FROM:     ___ ____ ___ ____ ______ ___ __ ___
              001      100
    TO:       ___ ____ ___ ____ ______ ___ __ ___
              001      199

Import Option

In order for the Import option to properly build new contract records, the data columns must contain a heading in Row One. The heading allows the Import program to determine what the data in that column represents. These headings must match what is defined below in order for the Import program to recognize and load the data.

There are three required fields: EMPLOYEE_ID, JOB_NO, and CONTRACT_TYPE. The remainder of the data is optional and will be dependent upon the contract type being imported. For example, if importing a mid-year contract change with retro-spread, the days since raise should also be included in the import file. Information not specified in the fields for the spreadsheet will be pulled in from the existing JOBSCN.

The following is a list of valid import field and valid values:

  • EMPLOYEE_ID
    • SSN
    • Employee ID
  • JOB_NO
  • CONTRACT_TYPE
    • 1 - Mid-contract with no retro
    • 2 - Mid-contract with retro spread
    • 3 - Mid-contract with lump sum retro
    • 4 - New contract
  • CONTRACT_AMOUNT
    • Required for stretch paid jobs
  • CONTRACTUAL_OBLIGATION
    • Calculated for contracted jobs
  • PAY_UNIT
    • Hourly, H, or 1
    • Daily, D, or 2
  • HOURS_IN_DAY
    • Required for contracted hourly jobs
  • RETIRE_HOURS
  • UNIT_AMOUNT
    • Will be calculated for contracted jobs
  • DAYS_SINCE_RAISE
    • Required for all mid-year contract updates with retro, either lump sum or spread over remaining pays
  • WORK_DAYS_IN_CONTRACT
  • PAYS_IN_CONTRACT
  • ODHS_HIRE_DATE
    • If importing a New Contract (Contract-Type=4) and an ODHS Hire date is not supplied in the import file, it will be set to the contract start date. For all other contract types, if the date is not supplied in the import file, the value from JOBSCN will be used.
  • APPOINTMENT_TYPE
    • 1 - Certified
    • 2 - Classified
  • EQUAL_PAYS
    • Y - Stretch paid
    • N - Not stretch paid
  • PAY_GROUP
  • CALENDAR_TYPE
  • CONTRACT_START_DATE
    • If importing a New Contract (Contract-Type=4) and a contract start date is not supplied in the import file, it will be set to the contract start date entered in the prompting screen. For all other contract types, if the date is not supplied in the import file, the value from JOBSCN will be used.
  • CONTRACT_STOP_DATE
  • CONTRACT_RENEW_DATE
    • Not in use at this time
  • LIMITED_CONTRACT_EXP_DATE
    • Not in use at this time
  • RETIREMENT_CODE
    • 400 or 450
    • SERS or STRS
    • 0 or Space - No retirement
  • RESET_PERSONAL_LEAVE
  • RESET_VACATION_LEAVE
  • RESET_SICK_ADV
  • ADD_VACATION_UNITS
  • SALARY_SCHEDULE_ID
  • SALARY_SCHEDULE_COLUMN
  • SALARY_SCHEDULE_STEP
  • EXTENDED_SERVICE
  • JOB_TITLE
  • JOB_STATUS
    • 0 or 1 - Inactive
    • 1 or A - Active
    • 8 or D - Deceased
    • 9 or T - Terminated
  • BUILDING
  • DEPARTMENT
  • CHECK_DISTRIBUTION
  • EMIS_SPEC_ED_FTE
  • DAYS_IN_PERIOD
  • CALENDAR_START_DATE
  • CALENDAR_STOP_DATE
  • POSITION_CODE
  • BUILDING_IRN
  • EMIS_HOURS_IN_DAY
  • EMIS_CONTRACT_AMOUNT
  • EMIS_WORK_DAYS_IN_CONTRACT
  • EMIS_FTE_UNIT
  • ASSIGNMENT_AREA_1
  • ASSIGNMENT_AREA_2
  • ASSIGNMENT_AREA_3
  • USER_CONTRACT_TYPE
  • HQPD
    • * - NA
    • N - No
    • Y - Yes
  • PARAPROF
    • * - NA (not valid for position codes 505 or 414)
    • 1 - Associate Degree
    • 2 - At least 2 yrs study at accredited institute of higher ed
    • 3 - Achieved passing score on local assessment
    • 4 - Achieved a passing score on the statewide parapro assessment
    • N - Does not meet the definition of a qualified paraprofessional

Screen 1 of 1

Code Block
 ------------------------------------------------------------------------------
 |                          NEWCNT - Import                                    |
 |                                                                             |
 |Import File Specifications:                                                  |
 | Import filename:            NEWCNT_IMPORT.CSV                               |
 | Format of import file:      CSV                                             |
 | Contract start date:        __/__/____                                      |
 |                                                                             |
 |Output File Specifications:                                                  |
 | Error output file:          NEWIMPORT.TXT                                   |
 | Print options page:  (Y,N)  _                                               |
 | Optional heading:           ___________________________________             |
 |                                                                             |
 |                                                                             |
 |                                                                             |
 | Import New Contract Data                                      1 of 1        |
 |  XX Execute           XX Reset                                              |
 |  XX Help              XX Save/Recall                                        |
 |  XX Exit                                                                    |
 |  XX Cancel                                                                  |
 ______________________________________________________________________________|

Field Definitions

  • Enter the name of the file to be imported in the Import filename field.
  • Enter the format of the file in the Format of import filefield. The format choices are as follows:
    • CSV - Comma Separated Value
    • TAB - Tab-delimited
  • Enter a default contract start date in the Contract start date field. This date will be used if a contract start date is not provided in the import file.
  • NEWIMPORT.TXT is the default file name for the error report. These can be changed by entering a new file name in the Error output file field.
  • The Import program has the ability to create an options page for each report that is generated detailing how the program was run. The creation of the page is controlled by the Print options pages? field. "Y" (yes) will generate the page and "N" (no) will not generate the page. A printed record of the various sort and selection options and dates chosen can be helpful when researching problems.
  • Information entered in the Optional heading field will appear at the top of each page of the report. This field can also be used to enter a date, date range, or specific selection options you would like printed at the top of each page.

sample reports

...