M-pathways Time and Labor Data Dictionary




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

BWR Time Period Calendar;

Monthly Time Period


TIME_PERIOD_DESCRSHORT

Time Period Short Description

Character

10

M_TLDW1

TL_WRKGRP_TBL

R

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

Bi-Weekly;

BWR Time P;

Monthly


TIME_PERIOD_ID

Time Period Identification Code

Character

12

M_TLDW1

TL_WRKGRP_TBL

R

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

BI-WEEKLY = Bi-Weekly Time Period;

BIWEEKLY_BWR = BWR Time Period Calendar;

PSMONTH = Monthly Time Period


TIME_RPTG_STATUS

Time Reporting Status Code

Character

1

M_TLDW1

TL_EMPL_DATA

R

A code specifying the status of an employee in time and labor.

A = Active;

I = Inactive



TIME_RPTG_TYPE

Time Reporting Type Code

Character

1

M_TLDW1

TL_WRKGRP_TBL

R

A code representing the type of time reported for a workgroup.

E = Exception Time Reporting;

P = Positive Time Reporting



TIME_RPTG_TYPE_ DESCRSHORT

Time Reporting Type Short Description

Character

10

M_TLDW1

TL_WRKGRP_TBL

R

An abbreviated textual description of the code representing the type of time reported for a workgroup.

Exception;

Positive


TIME_RPTR_DESCRSHORT

Time Reporter Short Description

Character

10

M_TLDW1

TL_EMPL_DATA

R

An abbreviated textual description of the code representing the way an employee record is set up to report time in Time and Labor.

Elapsed;

Punch


TIME_RPTR_IND

Time Reporter Indicator Code

Character

1

M_TLDW1

TL_EMPL_DATA

R

A code representing the way an employee record is set up to report time in time and labor.

E = Elapsed;

P = Punch



TIMEKEEP_SYS

Timekeeping System Code

Character

1

M_HRDW1

HE_DEPT_TBL

R

A code indicating the timekeeping system used by a department.

C = Central;

H = Hospital;

M = MATRS;

P = Plant



TIMEKEEP_SYS_DESCRSHORT

Timekeeping System Short Description

Character

10

M_HRDW1

HE_DEPT_TBL

R

An abbreviated textual description of the code indicating the timekeeping system used by a department.

Central;

Hospital;

MATRS;

Plant


TL_ACTIVE

Time and Labor Active Code

Character

1

M_TLDW1

TL_LVACR_GRND

R

A code indicating whether the grandfathered leave program is active or not.

Y = Yes;

N = No


TL_COMMENTS

Time and Labor Comment

Character

254

M_TLDW1

TL_RPTD_ELPTIME

R

A line of text containing information about an employee’s reported time.

$8.00 bonus;

Early payroll tgaray 12/2/05;

Prior period adj due to late paperwork jshmoe 10/06/2006


TL_ENROLL_EFFDT

Time and Labor Enrollment Effective Date

Date




M_TLDW1

TL_EMPL_DATA

R

The date when the employee’s time and labor enrollment information becomes effective.

01/01/1999

TL_ENROLL_END_DT

Time and Labor Enrollment End Date

Date




M_TLDW1

TL_EMPL_DATA

R

The last date on which the employee’s time and labor enrollment information is effective. September 9, 3999 represents that the enrollment is open-ended.

01/01/1999


TL_EXTENDED_SICK

Time and Labor Extended Sick Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating whether extended sick time is related to a time reporting code.

Y = Yes;

N = No


TL_LEAVE_ADJUSTED

Time and Labor Adjusted Hours

Signed Number

7,3

M_TLDW1

TL_LEAVE_DATA

R

The number of hours associated with a time and labor leave balance adjustment.

8.000;

-8.000


TL_LEAVE_BALANCE

Time and Labor Leave Plan Balance Hours

Signed Number

7,3

M_TLDW1

TL_LEAVE_DATA

R

The number of hours an employee has accumulated in a time and labor leave plan.

648.800;

0.000;


308.846

TL_LEAVE_BENEFIT_PLAN

Time and Labor Leave Benefit Plan

Character

6

M_TLDW1

TL_LEAVE_PLAN

R

A code representing a time and labor leave plan.

5U = Sick;

5Y = Vacation;

5Z = Paid TimeOff


TL_LEAVE_BENEFIT_PLAN_ DESCR

Time and Labor Leave Benefit Plan Description

Character

30

M_TLDW1

TL_LEAVE_PLAN

R

A textual description of the code representing a time and labor leave plan.

Sick;

Vacation;

Paid TimeOff


TL_LEAVE_COMMENTS

Time and Labor Leave Comments

Char

500

M_TLDW1

TL_LEAVE_DATA

R

A line of text containing comments associated with an employee’s leave programs, plans or data.

-0.034 No PTO payout- jshmoe 2/13/02;

LOA 1/7/03/jshmoe 1/31/03;

Transfer into accrual system as of 3/13/06. 4/6/06 jshmoe


TL_LEAVE_DATA_POSTING_ DATE

Time and Labor Leave Data Posting Date

Date




M_TLDW1

TL_LEAVE_DATA

R

The date of an employee's time and labor leave plan accruals, usages or adjustments.

01/03/2003

TL_LEAVE_EARNED

Time and Labor Leave Earned Hours

Signed Number

7,3

M_TLDW1

TL_LEAVE_DATA

R

A number of hours an employee accrued in a time and labor leave plan.

8.000;

16.000;


1056.000

TL_LEAVE_EFFSEQ

Time and Labor Leave Effective Sequence Number

Number

3

M_TLDW1

TL_LEAVE_DATA

R

A number which uniquely identifies an inserted leave data row that has the same effective date as TL_LEAVE_DATA_POSTING_DATE.

01/03/2003

TL_LEAVE_FTE

Time and Labor Leave Full Time Equivalent

Character

4,3

M_TLDW1

TL_LEAVE_DATA

R

The percent of effort used for an employee’s time and labor leave plan accrual. This combines FTE for all eligible jobs.

1.000;

.500;


.750

TL_LEAVE_NEAR_MAX

Time and Labor Leave Near Max Code

Character

1

M_TLDW1

TL_LEAVE_DATA

R

A code indicating whether an employee is within three months of reaching the maximum allowed vacation or paid time off (PTO) accrual.

Y = Yes;

N = No


TL_LEAVE_ORIGIN

Time and Labor Leave Origin Code

Character

1

M_TLDW1

TL_LEAVE_DATA

R

A code representing the source of information regarding an employee’s time and labor leave plan accrual or usage.

A = Accrual/Renewal;

E = Event Maintenance;

L = Loaded Balance;

P = Payroll;

M = Manual Entry


TL_LEAVE_ORIGIN_DESCR

Time and Labor Leave Origin Description

Character

30

M_TLDW1

TL_LEAVE_DATA

R

A textual description of the code representing the source of information regarding an employee’s time and labor leave plan accrual or usage.

Accrual/Renewal;

Event Maintenance;

Loaded Balance;

Payroll;


Manual Entry

TL_LEAVE_PGM

Time and Labor Leave Program

Character

3

M_TLDW1

TL_EMPL_PGM

R

A code representing the time and labor leave program an employee is enrolled in.

AFS = Afscme;

HEX = Hospital Exempt;

NON = No Leave Program


TL_LEAVE_PGM_DESCR

Time and Labor Leave Program Description

Character

30

M_TLDW1

TL_EMPL_PGM

R

A textual description of the code representing the time and labor leave program an employee is enrolled in.

Afscme;

Hospital Exempt;

No Leave Program


TL_LEAVE_PGM_DESCRSHORT

Time and Labor Leave Program Short Description

Character

10

M_TLDW1

TL_EMPL_PGM

R

An abbreviated textual description of the code representing the time and labor leave program an employee is enrolled in.

Afscme;

Umhse;


None

TL_LEAVE_PLAN_EFFDT

Leave Plan Effective Date

Date




M_TLDW1

TL_LEAVE_PLAN

R

The date on which employee’s time and labor leave plan becomes effective.

01/01/1999

TL_LEAVE_PLAN_END_DT

Leave Plan End Date

Date




M_TLDW1

TL_LEAVE_PLAN

R

The last date on which a time and labor leave plan is in effect for an employee.

September 9, 3999 represents that the leave plan is open-ended.



01/01/1999

TL_LEAVE_PLAN_TYPE

Leave Plan Type Code

Character

2

M_TLDW1

TL_LEAVE_DATA

TL_LEAVE_PLAN



R

A code identifying a type of time and labor leave plan available to an employee.

5U = Sick;

5Y = Vacation;

5Z = Paid Time Off


TL_LEAVE_PLAN_TYPE_DESCR

Leave Plan Type Description

Character

10

M_TLDW1

TL_LEAVE_DATA

TL_LEAVE_PLAN



R

A textual description of the code identifying a type of time and labor leave plan available to an employee.

Sick;

Vacation;

Paid Time Off


TL_LEAVE_PLAN_TYPE_ DESCRSHORT

Leave Plan Type Short description.

Character

30

M_TLDW1

TL_LEAVE_DATA

TL_LEAVE_PLAN



R

An abbreviated textual description of the code identifying a type of time and labor leave plan available to an employee.

Sick;

Vacation;

PTO


TL_LEAVE_SOLD

Leave Sold Hours

Signed Number

7,3

M_TLDW1

TL_LEAVE_DATA

R

The number of paid time off hours (PTO) that an employee has sold.

-34.668;

0.000;


276.000

TL_LEAVE_TAKEN

Leave Taken Hours

Signed Number

7,3

M_TLDW1

TL_LEAVE_DATA

R

The number of hours an employee used in a particular time and labor leave plan.

-8.000

4.000;


32.000;

190.100


TL_NEXT_RENEW_YR

Time and Labor Next Extended Sick Renewal Year

Number

4

M_TLDW1

TL_EMPL_PGM

R

The next year in which an employee’s extended sick plan will renew.

2009;

2011


TL_ORIGINAL_DATE

Time and Labor Original Date

Date




M_TLDW1

TL_LVACR_GRND

R

The original vacation/paid time off (VAC/PTO) eligibility date for an employee grandfathered into a leave accrual plan.

01/01/1999

TL_OT_FLG

Time and Labor Overtime Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating whether the time reporting code should be included on the overtime liability report.

Y = Yes;

N = No


TL_QUANTITY

Time and Labor Quantity Number

Signed Number

10,3

M_TLDW1

TL_PAYABLE_TIME

TL_RPTD_ELPTIME



R

The number of hours or amounts reported to a time reporting code for an employee for a specific date.

-320.000;

0.000;


868.000

TL_REASON

Time and Labor Reason Code

Character

1

M_TLDW1

TL_LVACR_GRND

R

A code representing the reason an employee was grandfathered into a leave accrual plan.

F = FLSA;

M = MVN Nurses;

J = FLSA 6/1/05 to MO


TL_REASON_DESCR

Time and Labor Reason Code Description

Character

30

M_TLDW1

TL_LVACR_GRND

R

A textual description of the code representing the reason an employee was grandfathered into a leave accrual plan.

FLSA;

MVN Nurses;

FLSA 6/1/05 to MO


TL_SICK_ELIG_DT

Time and Labor Sick Time Eligibility Date

Date




M_TLDW1

TL_EMPL_PGM

R

The date that is used to determine the renewal of the sick time and extended sick time balances.

01/01/1999

TL_SOURCE

Time and Labor Source Code

1   2   3   4   5   6   7


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

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