M-pathways Time and Labor Data Dictionary




старонка4/7
Дата канвертавання24.04.2016
Памер1.35 Mb.
1   2   3   4   5   6   7

Name


Character

50

M_TLDW1

M_PYDW1


NO_VARIANCE_TBL TL_EMPL_DATA

TL_EMPL_PGM

TL_GROUP_DTL

TL_LEAVE_DATA

TL_LEAVE_PLAN

TL_LVACR_GRND

TL_MISS_TIME

TL_PAYABLE_TIME

TL_RPTD_ELPTIME

PAY_CHECK

PAY_ERN_DIST


R

The name by which a person is known. Person name format is Last,First Middle.


de la Garza, Barbara Marie;

Smith, Joseph L;

Washington, William Boyd


NEEDS_APPR_FLAG

Needs Approval Code

Character

1

M_TLDW1

TL_WRKGRP_TBL

R

A code indicating whether or not a workgroup’s time reporting codes need approval before being sent to payroll. For example, the Self Service Workgroups need approval.

Y = Yes;
N = No

NET_PAY

Net Pay

Signed Number

10,2

M_PYDW1

PAY_CHECK

R

The dollar amount of gross pay amount less any employee contributions to deductions and taxes.

Note: This field will contain NULL for data prior to March 11, 2004.



1,522.14;

1,082.53;

840.14;

-914.62


OFF_CYCLE

Off Cycle Code

Character

1

M_PYDW1

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

A code indicating whether the process of calculating and creating a paycheck for one or more employees outside the normally-scheduled (on-cycle) payroll run for their pay group. Off-Cycle processing includes reversals, reversal/adjustments, salary transfers, online checks and manual checks.

Y = Yes;

N = No


ORIG_TRANS_DT

Original Transaction Date

Date




M_PYDW1

PAY_ERN_DIST

R

The original check date.

09/22/2000

OTH_EARNS

Other Earnings

Signed Number

10,2

M_PYDW1

PAY_OTH_EARNS

R

The amounts the employee is receiving or is being taxed on by earn code.

1,481.37;
3,398.44;
8,900.05

OTH_HRS

Other Hours

Signed Number

6,2

M_PYDW1

PAY_OTH_EARNS

R

The number of hours associated with the OTH_EARNS field. Examples of this would be HOL (holiday), VAC (vacation), SCK (sick), earnings codes that are paid for a specified number of hours. OTH_HRS is not populated when an amount Time Reporting Code (such as CAT) is used.

0.00

8.00;
11.50





OTH_PAY

Other Pay

Signed Number

10,2

M_PYDW1

PAY_OTH_EARNS

R

The dollar amount on an earnings code of Human Resource managed payments to be distributed to an employee in addition to regular pay.

-15,695.77;

34.76;


150.34;

5,667.48;

29,037.17


OVERRIDE_RSN_CD

Override Reason Code

Character

5

M_TLDW1

TL_RPTD_ELPTIME

R

A code indicating the reason an override was applied to an employee’s reported time.

OBA = One Time Bank Adjustment;

PTA = Adjustment to PTO Balance:

REP = Time Reporting Error


OVERRIDE_RSN_DESCR

Override Reason Description

Character

30

M_TLDW1

TL_RPTD_ELPTIME

R

A textual description of the code indicating the reason an override was applied to an employee’s reported time.

One Time Bank Adjustment;

Adjustment to PTO Balance:

Time Reporting Error


OVERRIDE_RSN_DESCRSHORT

Override Reason Short Description

Character

10

M_TLDW1

TL_RPTD_ELPTIME

R

An abbreviated textual description of the code indicating the reason an override was applied to an employee’s reported time.

OTB Adj;

PTO Adj:


Rep Error

PAGE_NUM

Page Number

Number

4

M_PYDW1

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

A sequential number uniquely identifying each page. This is the page in a paysheet and will include the transactions for multiple employees.

1;

2;

3



PAY_BEGIN_DT

Pay Period Begin Date

Date




M_PYDW1

PAY_CHECK

R

The start date of the pay period.

03/10/2001

PAY_EARNS_BEGIN_DT

Pay Earnings Begin Date

Date




M_PYDW1

PAY_EARNINGS

R

The start date of the pay period for which time has been reported.

This date can be different from PAY_BEGIN_DT if a prior period adjustment has been processed.



01/01/1999;

07/02/2006



PAY_EARNS_END_DT


Pay Earnings End Date

Date




M_PYDW1

PAY_EARNINGS

R

The end date of the pay period for which time has been reported.

This date can be different from PAY_END_DT if a prior period adjustment has been processed.



3/31/2006;

07/15/2006



PAY_END_DT

Pay Period End Date

Date




M_TLDW1

M_PYDW1


NO_VARIANCE_TBL TL_MISS_TIME TL_PAYABLE_TIME

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS


R

The end date of the pay period.

03/31/2006;

7/29/2006




PAY_FREQUENCY

Pay Frequency Code

Character

1

M_TLDW1

M_PYDW1


TL_EMPL_PGM

TL_MISS_TIME

JOB

PAY_CHECK



PAY_EARNINGS

R

A code representing how often employees in a pay group are paid.

B = Biweekly;

M = Monthly;

W = Weekly


PAY_FREQUENCY_DESCRSHORT

Pay Frequency Short Description

Character

10

M_TLDW1

M_PYDW1


TL_EMPL_PGM

TL_MISS_TIME

JOB

PAY_CHECK



PAY_EARNINGS

R

An abbreviated textual description of the code representing how often employees in a pay group are paid.

Biweekly;

Monthly;


Weekly

PAY_OFF_CYCLE_CAL

Off Cycle Calendar Code

Character

1

M_PYDW1

PAY_CHECK

R

A code indicating whether the pay date is Off Cycle or not.

Y = Yes;

N = No


PAY_PERIOD

Pay Period Code

Character

1

M_PYDW1

PAY_CHECK

R

A code representing the established time segments for which employees in a pay group are paid. Pay Periods are defined by their beginning and ending dates.

1;

2;

3



PAYABLE_STATUS

Payable Status Code

Character

2

M_TLDW1

TL_PAYABLE_TIME

R

A code specifying the status of reported time in relation to calculating pay.

CL = Closed;

RP = Rejected



PAYABLE_STATUS_DESCR

Payable Status Description

Character

30

M_TLDW1

TL_PAYABLE_TIME

R

A textual description of the code specifying the status of reported time in relation to calculating pay.

Closed;

Rejected


PAYABLE_STATUS_ DESCRSHORT

Payable Status Short Description

Character

10

M_TLDW1

TL_PAYABLE_TIME

R

An abbreviated textual description of the code specifying the status of reported time in relation to calculating pay.

Closed;

Rejected by Payroll



PAYABLE_TIME_OPRID


Payable Time Operator Identification

Character

30

M_TLDW1

TL_PAYABLE_TIME

R

The unique identifier of the person or process that approved time as payable for self service time entry.

blank;

DSELL;



PAYABLE_TIME_SEQ_NBR

Payable Time Sequence Number

Number

15

M_TLDW1

TL_PAYABLE_TIME

R

A system assigned number that uniquely identifies each row of time and labor data used to calculate pay for a specific employee appointment for a specific day.

20393000008;

20607000011;

20809000066


PAYCHECK_NBR

Paycheck Number

Number

7

M_PYDW1

PAY_CHECK

R

A number used to identify a paycheck.

1371;

1372;


1373

PAYCHECK_OPTION

Paycheck Option Code

Character

1

M_PYDW1

PAY_CHECK

R

A code representing the method of payment to an individual; or the type of transaction being processed. This field would represent whether an individual was paid via direct deposit or by check. This field is also used if a check or advice is reversed.


& = Check and Advice;

A = Advice;

C = Check


PAYCHECK_OPTION_DESCR

Paycheck Option Code Description

Character

30

M_PYDW1

PAY_CHECK

R

A textual description of the code representing the method of payment to an individual; or the type of transaction being processed. This field would represent whether an individual was paid via direct deposit or by check. This field is also used if a check or advice is reversed.

Check and Advice;

Advice;


Check

PAYCHECK_STATUS

Paycheck Status Code

Character

1

M_PYDW1

PAY_CHECK

R

A code indicating the pay check status.

F = Confirmed;

V = Reversal



PAYCHECK_STATUS_ DESCRSHORT

Paycheck Status Short Description

Character

10

M_PYDW1

PAY_CHECK

R

An abbreviated textual description of the code indicating the paycheck status.

Confirmed;

Reversal


PAYGROUP

Pay Group Code

Character

3

M_TLDW1
M_PYDW1

JOB

TL_EMPL_DATA

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_ERNS



R

A code indicating a set of employees grouped together for payroll processing.

BWC = Reg Bwlky;

MGS = Grad Stdnt;

MPP = Mo P Paid


PAYGROUP_DESCR

Pay Group Description

Character

30

M_TLDW1
M_PYDW1

JOB

TL_EMPL_DATA

PAY_EARNINGS

PAY_OTH_EARNS



R

A textual description of the code indicating a set of employees grouped together for payroll processing.

Regular Bi-Weekly;

Grad Student;

Mthly Pre Pd-Hosp & Spon 12 Mo


PAYGROUP_DESCRSHORT

Pay Group Short Description

Character

10

M_TLDW1
M_PYDW1

JOB

TL_EMPL_DATA

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

An abbreviated textual description of the code indicating a set of employees grouped together for payroll processing.

Reg Bwlky;

Grad Stdnt;

Mo P Paid


PERCENT_EFFORT

Percent Effort

Number

5,2

M_HRDW1

DEPT_BUDGET_ERN

R

The employee's percent effort associated with each shortcode related to a job. Used for effort certification and not required to be provided unless needed for that purpose.

0.25;

3.50;


77.50;

100.00


PERUNIT_OVR_RT

Unit Override Rate

Number

18,6

M_PYDW1

EARNINGS_TBL

R

A number representing the override rate of pay.

0.000000;

2.000000;

5.000000


POSTING_PTO

Posting Paid Time Off Code

Character

1

M_HRDW1

HE_DEPT_TBL

R

A code indicating that a message will be printed on the job posting stating this position has paid time off benefits rather than sick and vacation benefits.

Y = Yes;

N = No


PROGRAM_CODE

Program Code

Character

5

M_PYDW1

M_HRDW1


PAY_ERN_DIST

DEPT_BUDGET_ERN




R

A code identifying a group of related activities, cost centers, revenue centers, responsibility centers and academic programs. These activities may occur within a single department or across multiple departments.

ADMIS = Admissions;

RERET = Recruitment & Retention



PROJECT_GRANT

Project/Grant Code

Character

15

M_PYDW1

M_HRDW1


PAY_ERN_DIST

DEPT_BUDGET_ERN




R

A code used to accumulate financial information on a set of activities over a limited time span. Used for contracts and grants, construction projects and unit-defined projects.

C026993;

F000101



PY_TL_XREF_NUM

Payroll Time and Labor Cross Reference Number

Number

15

M_TLDW1

M_PYDW1


TL_PAYABLE_TIME

PAY_EARNINGS

PAY_OTH_EARNS


R

A unique number for each time reporting code that links TL_PAYABLE_TIME from time and labor with PAY_OTH_EARNS in Payroll.

604000000001;

751000000043;

891000000040


RATE_TYPE_USED

Rate Type Used Code

Character

1

M_PYDW1

PAY_EARNINGS

PAY_OTH_EARNS



R

A code representing the type of rate used when calculating pay.

F = FLSA Rt;

H = Hrly Rt



RATE_TYPE_USED_ DESCRSHORT

Rate Type Used Short Description

Character

10

M_PYDW1

PAY_EARNINGS

PAY_OTH_EARNS



R

An abbreviated textual description of the code representing the type of rate used when calculating pay.
1   2   3   4   5   6   7


База данных защищена авторским правом ©shkola.of.by 2016
звярнуцца да адміністрацыі

    Галоўная старонка