M-pathways Time and Labor Data Dictionary




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

1

M_PYDW1

PAY_EARNINGS

PAY_OTH_EARNS



R

A code indicating the source of the exception pay.

T = Time and Labor Record;

U = User updated/Created Record.



TL_SOURCE_DESCR

Time and Labor Source Code Description

Character

30

M_PYDW1

PAY_EARNINGS

PAY_OTH_EARNS



R

A textual description of the code indicating the source of the exception pay.

Time and Labor Record;

User updated/Created Record.



TL_VAC_ELIG_DT

Time and Labor Vacation/Paid Time Off Eligibility Date

Date




M_TLDW1

TL_EMPL_PGM

R

The date that is used to determine the vacation time or paid time off (PTO) accrual rate.

01/01/1999

TOTAL_GROSS_AMT

Total Gross Amount

Signed Number

10,2

M_PYDW1

PAY_CHECK

R

The dollar amount paid as gross pay.

0.00;

-4,419.07;

39.62


TRC

Time Reporting Code

Character

5

M_TLDW1

TL_PAYABLE_TIME

TL_RPTD_ELPTIME

TL_TRC_TBL


R

A code representing the types of time to which employees track their time. The code can represent hours, dollars, or units.

EDU = EducationalTime;

HOM = Holiday on Off Day-Add’l Pay;

SCK = Sick - Preventative;

CAT = Cash Adjustment



TRC_ADD_GROSS

Time Reporting Code Distribute Costs Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating whether the hours or dollars associated with a time reporting code add to an employee’s gross pay.

Y = Yes;

N = No


TRC_DESCR

Time Reporting Code Description

Character

30

M_TLDW1

TL_PAYABLE_TIME

TL_RPTD_ELPTIME

TL_TRC_TBL


R

A textual description of the code representing the types of time to which employees track their time.

Educational Time;

Holiday on Off Day-Add’l Pay;

Sick - Preventative;

Cash Adjustment



TRC_DESCRSHORT

Time Reporting Code Short Description

Character

10

M_TLDW1

TL_PAYABLE_TIME

TL_RPTD_ELPTIME

TL_TRC_TBL


R

An abbreviated textual description of the code representing the types of time to which employees track their time.

Educationl;

HolODAPay;

Sick – Pre;

RateAdj


TRC_EFF_STATUS

Time Reporting Code Effective Status Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code specifying the current status of a time reporting code.

A = Active:

I = Inactive



TRC_EFFDT

Time Reporting Code Effective Date

Date




M_TLDW1

TL_TRC_TBL

R

The date on which a time reporting code becomes effective.

01/01/1999

TRC_END_DT

Time Reporting Code End date

Date




M_TLDW1

TL_TRC_TBL

R

The last date on which the time reporting code information is effective. September 9, 3999 represents that the time reporting code Effectiveness” is open-ended.

01/01/1999

TRC_FACTOR_MULT

Time Reporting Code Multiplication Factor Number

Signed Number

9,4

M_TLDW1

TL_TRC_TBL

R

A number used to adjust the time reporting code hours reported as appropriate.

1.00;

2.00;


.6667

TRC_MAX_QTY

Time Reporting Code Maximum Quantity Number

Number

8,2

M_TLDW1

TL_TRC_TBL

R

The maximum number of hours, units or amounts that can be recorded for a time reporting code.

0.00;

24.00;


1000.00

TRC_PROGRAM

Time Reporting Code Program Code

Character

5

M_TLDW1

TL_WRKGRP_TBL

R

A code representing the time reporting program in which certain time reporting codes are valid.

AFSCM = AFSCME1 TRC PROGRAM;

CMPNS = CAMPNURSE TRC PROGRAM;

IUONG = IUOEENGR1 TRC PROGRAM


TRC_PROGRAM_DESCRSHORT

Time Reporting Code Program Short Description

Character

10

M_TLDW1

TL_WRKGRP_TBL

R

An abbreviated textual description of the code representing the time reporting program in which certain time reporting codes are valid.

AFSCME1;

CAMPNURSE;

IUOEENGR1


TRC_RATE

Time Reporting Code Rate

Signed Number

8,2

M_TLDW1

TL_TRC_TBL

R

A number representing the rate at which an employee will be compensated for a particular time reporting code. This field is populated when TRC_TYPE equals ‘U’ (Units).

0.00;

10.00;


140.00

TRC_RATE_OVR_FLAG

Time Reporting Code Override Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating whether the time reporting code rate can be overridden.

Y = Yes;

N = No


TRC_TYPE

Time Reporting Code Type Code

Character

1

M_TLDW1

TL_TRC_TBL

R

A code representing the type of compensation related to a time reporting code.

A = Amount;

H = Hours;

U = Units


TRC_TYPE_DESCRSHORT

Time Reporting Code Type Code Short Description

Character

10

M_TLDW1

TL_TRC_TBL

R

An abbreviated textual description of the code representing the type of compensation related to a time reporting code.

Amount;

Hours;


Units

TSKPRF_SEQNUM

Task Profile Detail Sequence Number

Number

3

M_TLDW1

TL_TSKPRF_DETL

R

A system assigned number that identifies a unique task profile row.

1;

50;


65

USED_TO_PAY_RETRO

Used To Pay Retroactively Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code could be used for retroactive pay.

Y = Yes;

N = No


WITHHOLD_FWT

Withhold Federal Withholding Tax Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code is eligible for Federal Withholding Tax.

Y = Yes;

N = No


WORKGROUP

Workgroup Code

Character

10

M_TLDW1

TL_EMPL_DATA

TL_WRKGRP_TBL



R

A code representing a grouping of employees with similar time reporting requirements.

CAMPNURSE = Campus Nurses;

MNURSEMO = Nurse Monthly;

SNONEXCAMP = Self-service NONEXCAMP


WORKGROUP_DESCR

Workgroup Name Description

Character

30

M_TLDW1

TL_EMPL_DATA

TL_WRKGRP_TBL



R

A textual description of the code representing a grouping of employees with similar time reporting requirements.

Campus Nurses;

Nurse Monthly;

Self-service NONEXCAMP


WORKGROUP_DESCRSHORT

Workgroup Name Short Description

Character

10

M_TLDW1

TL_EMPL_DATA

TL_WRKGRP_TBL



R

An abbreviated textual description of the code representing a grouping of employees with similar time reporting requirements.

Campus Nur;

Nurse Mont;



SNONEXCAMP

WORKGROUP_EFFDT

Workgroup Effective Date

Date




M_TLDW1

TL_WRKGRP_TBL

R

The date on which a grouping of employees with similar time reporting requirements becomes effective.

01/01/1999
1   2   3   4   5   6   7


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

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