M-pathways Time and Labor Data Dictionary




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


FLSA Rt;

Hrly Rt


RECORD_ONLY_ADJ

Record Only Adjustment Code

Character

1

M_TLDW1

TL_PAYABLE_TIME

R

A code indicating whether a row of payable time data was entered into the system as a record only adjustment.

Y = Yes;

N = No


RECORD_ONLY_ADJ_COMMENTS

Record Only Adjustment Comments

Character

20

M_TLDW1

TL_PAYABLE_TIME

R

A line of text containing information about a record only adjustment. These adjustments do not impact a person’s pay and/or leave balances.

049099;

06/02/05 KWC;

0 PTO TIME AVAILABLE


REG_EARNS

Regular Earnings

Signed Number

10,2

M_PYDW1

PAY_EARNINGS

R

The dollar amount of pay associated with regular hours.

0.00;

26.75;


141.67

REG_EARNS_HRS

Regular Earnings Hours

Signed Number

6,2

M_PYDW1

PAY_EARNINGS

R

The regular hours associated with standard hours for exception pay employees.

0.00;

80.0;


168.00;

248.00


REG_HRLY_EARNS

Regular Hourly Earnings

Signed Number

10,2

M_PYDW1

PAY_EARNINGS

R

The sum of the dollar amount of pay associated with exception hours reduced from regular earnings.

-9,602.64;

-235.77;


0.00

REG_HRS

Regular Hours

Signed Number

6,2

M_PYDW1

PAY_EARNINGS

R

The sum of exception hours that reduce from regular hours which come from job standard hours.

-56.00;

-8.00;


0.00

REG_PAY

Regular Salaried Earnings Amount

Signed Number

10,2

M_PYDW1

PAY_EARNINGS

R

The amount representing earnings by regular salaried employees.

0.00;

4,821.29;

3,581.50


REG_PAY_INCLUDED

Regular Pay Included Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether regular pay is included in the earnings amount related to an earnings code.

Y = Yes;

N = No


REG_TEMP

Regular/Temporary Code

Character

1

M_TLDW1

JOB

R

A code indicating whether a JobCode or a job is considered a regular or temporary JobCode or job.

R = Regular;

T = Temporary



REG_TEMP_DESCRSHORT

Regular/Temporary Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code indicating whether a JobCode or a job is considered a regular or temporary JobCode or job.

Regular;

Temporary



REVERSED

Reversed Code

Character

1

M_PYDW1

PAY_ERN_DIST

R

A code indicating whether a check in hand is cancelled.

Y = Yes;

N = No


RPTD_TIME_OPRID


Reported Time Operator Identification

Character

30

M_TLDW1

TL_RPTD_ELPTIME

R

The unique identifier of the person or process which entered reported time hours into the system.

92340009;

SJEFFRIE;

TLSYSTEM;

SYSADM


RPTD_TIME_SEQNUM

Reported Time Sequence Number

Number

30

M_TLDW1

TL_RPTD_ELPTIME

R

A system assigned number uniquely identifying each row of reported time for a specific employee appointment for a specific day.

1;

100;


156

RULE_PGM_DESCRSHORT

Rule Program Short Description

Character

10

M_TLDW1

TL_WRKGRP_TBL

R

An abbreviated textual description of the code representing the time reporting rules applied to a time and labor workgroup.

AFSCRULPGM;

IUOERULPGM;

PAEXCRULPGM


RULE_PGM_ID

Rule Program Identification Code

Character

12

M_TLDW1

TL_WRKGRP_TBL

R

A code representing the time reporting rules applied to a time and labor workgroup.

AFSCRULEPGM;

IUOERULEPGM;

PAEXCRULEPGM


RUN_ID

Pay Run Identification Code

Character

10

M_PYDW1

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

A code that uniquely identifies a Run Control for batch processes.

011 = 04-30-98;

BA1 = 01-B1-2001;

MC1 = 03-Em-2001


SEND_TO_PAYROLL

Send to Payroll Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating whether a time reporting code is sent to the payroll calculation process.

Y = Yes;

N = No


SEPCHK

Separate Check Number

Number

1

M_PYDW1

PAY_CHECK

PAY_ERN_DIST



R

The number used for a separate check.

0;

1;

2



SERVICE_DT

Service Date

Date




M_TLDW1

JOB

R

The date on which the current continuous employment relationship was established as defined in the Standard Practice Guide.

08/01/2001

SHORTCODE

ShortCode Number

Character

6

M_TLDW1

M_PYDW1
M_HRDW1



TL_PAYABLE_TIME

TL_RPTD_ELPTIME

TL_TSKPRF_DETL

PAY_EARNINGS PAY_ERN_DIST

DEPT_BUDGET_ERN


R

A code that represents a unique combination (blank and non-blank) of chartfields; fund, department, class, program, and project/grant. (HR, HRSNAP) If the shortcode field in the Addl_Pay_Data table is blank, the payments are distributed to the general ledger system based on the Department Budget Earnings distribution in effect on that date.

000094 = USDA-6J89B;

012984 = VA Hospital/Med Admin;

035677 = Research Agreement (SAE)


SHORTCODE_DESCR

ShortCode Description

Character

30

M_TLDW1

M_PYDW1
M_HRDW1



TL_PAYABLE_TIME

TL_RPTD_ELPTIME

TL_TSKPRF_DETL

PAY_EARNINGS PAY_ERN_DIST

DEPT_BUDGET_ERN


R

A textual description of the code that represents a unique combination (blank and non-blank) of chartfields; fund, department, class, program, and project/grant.

USDA-6J89B;

VA Hospital/Med Admin;

Research Agreement (SAE);


SPON_RES_POOL

Sponsored Research Pool Code

Character

1

M_HRDW1

DEPT_BUDGET_ERN

R

A code related to a department indicating whether the funding from this department is coming from a pool account or a sponsored project.

P = Pool Account;

S = Sponsored Project



SRT_ELIG_FLG

Sponsored Research Eligibility Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings will be distributed based on the sponsored research table.

Y = Yes;

N = No


STATIC_GROUP_DESCR

Static Group Description

Character

30

M_PYDW1

TL_GROUP_DTL

R

A textual description of the code uniquely identifying a user-defined group of employees that is used in time and labor to enter or report time, or run a query to review time and labor data.

LS&A Facilities;

suzannew derm monthlycampusres;

OSTFB


STATIC_GROUP_ID

Static Group Identification Code

Character

5

M_TLDW1

TL_GROUP_DTL

R

A code uniquely identifying a user-defined group of employees that is used in time and labor to enter or report time, or run a query to review time and labor data.

00001;

03647;


OB038

STD_HOURS

Standard Hours

Number

4,2

M_TLDW1

JOB

R

The number of hours the person will work in the associated appointment during the course of one week.

0.00;

2.20;


26.68;

40.00


SUBJECT_FICA

Subject to Federal Insurance Contributions Act Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code is eligible for Federal Insurance Contributions Act withholding.

Y = Yes;

N = No


SUPERVISOR_ID


Supervisor Identification Code

Character

11

M_TLDW1

JOB

R

A code representing the EMPLID of the supervisor for a given employee in a given job.

25582542

SUPERVISOR_NAME


Supervisor Name

Character

50

M_TLDW1

JOB

R

The name of the supervisor for a given employee in a given job. Person name format is Last,First Middle.

Adamson, Sonya T;

Holden, Peter



SVH_ELIG_FLG


Sick Vacation Holiday Eligibility Code

Character

1

M_PYDW1

EARNINGS_TBL

R

For employees that participate in the sick, vacation, holiday pool, a code indicating whether sick, vacation, holiday charges are charged directly to the department or to the sick, vacation, holiday pool.

Y = Yes;

N = No


TASK_PRFL_TMPLT_DESCR

Task Profile Template Description

Character

30

M_TLDW1

TL_TSKPRF_DETL

R

A textual description of the code representing the template used to apply time reporting rules to a task profile.

Campus Task Profile;

Campus Hospital Split;

Hospital Task Profile

Sponsored Research Profile



TASK_PRFL_TMPLT_ DESCRSHORT

Task Profile Template Short Description

Character

10

M_TLDW1

TL_TSKPRF_DETL

R

An abbreviated textual description of the code representing the template used to apply time reporting rules to a task profile.

Campus;

Hospital


Chsplit;

Sponsres


TASK_PRFL_TMPLT_ID

Task Profile Template Identification Code

Character

10

M_TLDW1

TL_TSKPRF_DETL

R

A code representing the template used to apply time reporting rules to a task profile.

CAMPUS1 = Campus Task Profile;

CHSPLIT = Campus Hospital Split;

Hospital1 = Hospital Task Profile

SPONSRES1 = Sponsored Research Profile



TASK_PROFILE_EFF_STATUS

Task Profile Effective Status Code

Character

1

M_TLDW1

TL_TSKPRF_DETL

R

A code specifying the current status of a task profile.

A = Active;

I = Inactive



TASK_PROFILE_EFFDT

Task Profile Effective Date

Date




M_TLDW1

TL_TSKPRF_DETL

R

The date on which the task profile status becomes effective.

01/01/1999

TASK_PROFILE_END_DT

Task Profile End Date

Date




M_TLDW1

TL_TSKPRF_DETL

R

The last date on which the task profile is effective. September 9, 3999 represents that the task profile is open-ended.

01/01/1999

TASK_PROFILE_ID

Task Profile Identification Code

Character

10

M_TLDW1

TL_EMPL_DATA

TL_TSKPRF_DETL



R

A code made up of EMPLID and EMPL_RCD number which uniquely identifies a time and labor task profile.

1005113000;

1006790000;

0377993630


TASKGROUP

Taskgroup Code

Character

10

M_TLDW1

TL_EMPL_DATA

TL_PAYABLE_TIME

TL_RPTD_ELPTIME


R

A code used to group employees based on which central payroll office is responsible for their maintenance in the system.

CAMPUS = Campus Taskgroup;

CHSPLIT = Campus Hospital Split;

HOSPITAL = Hospital Task Group


TASKGROUP_DESCR

Taskgroup Code Description

Character

30

M_TLDW1

TL_EMPL_DATA

TL_PAYABLE_TIME

TL_RPTD_ELPTIME


R

A textual description of the code used to group employees based on which central payroll office is responsible for their maintenance in the system.

Campus Taskgroup;

Campus Hospital Split;

Hospital Task Group


TAX_METHOD

Tax Method Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code which identifies the tax method used when calculating pay for an earning code.

A = Annualized;

L = Lump Sum;

S = Supplemental


TAX_METHOD_DESCRSHORT

Tax Method Short Description

Character

10

M_PYDW1

EARNINGS_TBL

R

An abbreviated textual description of the code which identifies the tax method used when calculating pay for an earning code.

Annualized;

Lump Sum;

Supplemntl


TIME_PERIOD_DESCR

Time Period Description

Character

30

M_TLDW1

TL_WRKGRP_TBL

R

A textual description of the code representing the time period for which time will be reported for a workgroup.

1   2   3   4   5   6   7


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

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