Generate Payroll

# of Employee Problems

TIMESHEET

ABSENT_EMPLOYEE_PROB_COUNT

only applies to HR entries Size: 10 Format: ###########

Absence Code

TIMESHEET

ABSENCE_CODE

only applies to HR entries Size: 10

Absence Description

TIMESHEET

ABSENCE_CODE_DESC

only applies to HR entries Size: 30

Batch Balance Status

TIMESHEET

BATCH_BALANCED_YN

Y=Yes, N=No, Size: 3

Batch Number

TIMESHEET

BATCH_NO

Size: 15

Batch Sequence Number

TIMESHEET

BATCH_SEQUENCE_NO

Development only Size: 10

Complete/Closed Batch

TIMESHEET

COMPLETE_BATCH_NO

Size: 15

Cost Center Code

TIMESHEET

COST_CENTER_CODE

Size: 10

Cost Center Description

TIMESHEET

COST_CENTER_DESC

Size: 30

Date Changed, if any, associated with these timesheets

TIMESHEET

CHANGED_DATE

Size: 11 Format: DD-MMM-YYYY

Date associated with Timesheet

TIMESHEET

TIMESHEET_DATE

Size: 11 Format: DD-MMM-YYYY

Default Pay Code

TIMESHEET

DEFAULT_PAY_RATE

from the Function Line associated with the timesheets Size: 10 Format: ########.##

Delete Status

TIMESHEET

DELETED_YN

Y=Yes, N=No, Size: 3

Disable Edit Status

TIMESHEET

DISABLE_EDIT_YN

Y=Yes, N=No, Size: 6

Distribution Percentage

TIMESHEET

DISTRIBUTION_PERCENTAGE

Size: 6

District Specific

TIMESHEET

CANCELLATION_NUMBER

Size: 7

District Specific

TIMESHEET

TIMESHEET_LOCATION_NAME

Size: 30

Dollar Value

TIMESHEET

TIMESHEET_DOLLAR_AMOUNT

associated with the timesheets Size: 10 Format: ########.##

Employee Name

TIMESHEET

ABSENT_EMPLOYEE_NAME

only applies to HR entries Size: 30

Employee Name and Number

TIMESHEET

ABSENT_EMPLOYEE_NAME_AND_NO

only applies to HR entries Size: 30

Employee Number

TIMESHEET

* ABS_EMPLOYEE_NO

only applies to HR entries Size: 10

Employee Number

TIMESHEET

ABSENT_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

Employee Problem

TIMESHEET

ABSENT_EMPLOYEE_PROBLEM

only applies to HR entries Size: 30

Employee Unit Types

TIMESHEET

ABS_EMP_UNIT_TYPE_SELECTION

Internal Lookup: U=Units Entered In PRM, H=Hours, D=Days, Size: 10

Function Line Identifier

TIMESHEET

FUNCTION_LINE_ID

Development use Size: 10

Function Line order number

TIMESHEET

FL_ORDER_NO

01=Order 1, 02=Order 2, 03=Order 3, 04=Order 4, 05=Order 5, 06=Order 6, 07=Order 7, Size: 5

General Ledger Account Number

TIMESHEET

GL_ACCT_NO

Size: 20

General Ledger Account Number

TIMESHEET

GL_ACCT_NO_FORMATTED

Formatted Size: 20

Hours

TIMESHEET

HOURS

associated with timesheets in this batch Size: 10 Format: ########.##

Hours in this batch

TIMESHEET

EXPANDED_HOURS

associated with timesheets Size: 10 Format: ########.##

Input or Overide Pay Rate

TIMESHEET

INPUT_PAY_RATE

Size: 10 Format: ########.##

Number associated with costing distribution

TIMESHEET

DISTRIBUTION_NUMBER

Size: 4

Occupation Code

TIMESHEET

OCCUPATION_CODE

associated with timesheet Size: 4

Occupation Code Description

TIMESHEET

OCCUPATION_CODE_DESC

associated with timesheet Size: 30

Occupation Code Premium

TIMESHEET

OCCUPATION_PREMIUM

on timesheets in this batch Size: 10 Format: ########.##

PRM Position Code

TIMESHEET

POSITION_CODE

Size: 8

Pay Code

TIMESHEET

PAY_CODE

associated with timesheet Size: 2

Pay Code Description

TIMESHEET

PAY_CODE_DESC

associated with timesheet Size: 30

Pay Code Premium

TIMESHEET

PAY_CODE_PREMIUM

on timesheets in this batch Size: 10 Format: ########.##

Reason for timesheet

TIMESHEET

TIMESHEET_REASON

Size: 50

Salary Grid Code

TIMESHEET

SALARY_GRID_CODE

Size: 6

Setting of the Pay Rate Update

TIMESHEET

PAY_RATE_UPDATED_YN

Was timesheet updated by the Pay Rate Update Process Size: 10

Shift Code

TIMESHEET

SHIFT_CODE

associated with timesheet Size: 5

Shift Code Description

TIMESHEET

SHIFT_CODE_DESC

associated with timesheet Size: 30

Shift Code Premium

TIMESHEET

SHIFT_PREMIUM

on timesheets in this batch Size: 10 Format: ########.##

Sub-Ledger Account Number

TIMESHEET

SL_ACCT_NO

Size: 10

Sub-Ledger Account Number

TIMESHEET

SL_ACCT_NO_FORMATTED

Formatted Size: 10

Time Changed, if any, associated with these timesheets

TIMESHEET

CHANGED_TIME

Size: 10

Timesheet Number

TIMESHEET

TIMESHEET_NUMBER

Size: 5

User Name of Person editing these timesheets

TIMESHEET

USER_NAME

Size: 15

Amount of Cheque

CHEQUE_HISTORY

CHEQUE_AMOUNT

Size: 10 Format: ########.##

Cheque Number

CHEQUE_HISTORY

CHEQUE_NUMBER

Size: 13

Date Cheque Issued

CHEQUE_HISTORY

ISSUE_DATE

Size: 11 Format: DD-MMM-YYYY

Date Cheque was cancelled

CHEQUE_HISTORY

CANCELLED_DATE

Size: 11 Format: DD-MMM-YYYY

Date cheque was returned

CHEQUE_HISTORY

RETURN_DATE

Size: 11 Format: DD-MMM-YYYY

Name associated with cheque

CHEQUE_HISTORY

FULL_NAME

Size: 50

Not used

CHEQUE_HISTORY

EXTERNAL_CHEQUE_NUMBER

Size: 13

Type of Cheque

CHEQUE_HISTORY

CHEQUE_TYPE_CODE

CP Cancellation of a Payroll history Payment; CM Cancellation of a Manual Cheque Entry; CC Cancellation of a cheque cancellation Size: 4

Action Take

AUDIT

ACTION_CODE

What action was taken: change, add, delete, program name (associated with processes like updates, global changes, etc) Size: 10

Change; Add; Delete; Kill

AUDIT

UNIQUE_ID

Size: 10

Date this change was made

AUDIT

CHANGE_DATE

Size: 11 Format: DD-MMM-YYYY

Field Number

AUDIT

FIELD_NO

Development use Size: 8

Field information after change

AUDIT

FIELD_AFTER_CHANGE

Size: 40

Field information prior to the change

AUDIT

FIELD_BEFORE_CHANGE

Size: 40

Product the change originated from

AUDIT

CHANGED_BY_OPS_OR_PRM

OPS=OPS, PRM=PRM, Size: 7

Program code

AUDIT

FILE_ID

Development use Size: 3

Programming identifying number

AUDIT

FIELD_SUB_NUMBER

Size: 2

The User who made the change

AUDIT

USER_NAME

Size: 30

The field item changed descriptor

AUDIT

FIELD_NAME

Size: 20

The program name associated with this change

AUDIT

PROGRAM_NAME

Size: 10

Time this change was made

AUDIT

CHANGE_TIME

Size: 11

Username from VMS or SMS

AUDIT

USERNAME_SOURCE_CODE

Size: 4