M-pathways Time and Labor Data Dictionary




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

01/01/1998

CLASS

Class Code

Character

5

M_PYDW1

M_HRDW1


PAY_ERN_DIST

DEPT_BUDGET_ERN



R

A code used to group related activities directed towards the accomplishment of a set of common identifiable objectives or purposes.

11000 = General Academic Instruction;

21000= Departmental Research;

72000 = Utilities;

1100x = Gen Acad Instr-ICRX



CLASS_INDC

Classified/ Unclassified Indicator Code

Character

1

M_TLDW1

JOB

R

A code used to catagorize appointments for administrative purposes. For example, when performing salary analysis, you may choose to exclude summer salary (CLASS_INDC = 'S').

A = Actg Appt;

C = Regular;

O = Over load;

S = Summer;

T = Temporary


CLASS_INDC_DESCRSHORT

Classified/ Unclassified Indicator Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code used to categorize appointments for administrative purposes. For example, when performing salary analysis, you may choose to exclude summer salary (CLASS_INDC = 'S').

Actg Appt;

Regular;


Over load;

Summer;


Temporary

COMP_ANNUAL_RT

Compensation Annual Rate

Number

14,2

M_TLDW1

JOB

R

A system calculated number based on compensation rate, compensation frequency, and standard hours indicating the annual base compensation rate for a specific employee appointment.

0.00;

45,048.00;

337,030.00


COMP_FREQUENCY

Compensation Frequency Code

Character

1

M_TLDW1

JOB

R

A code indicating how the compensation rate is expressed. For example, if the compensation rate is annual, the compensation rate is expressed as a yearly rate.

A= Annual;

H = Hourly;

B = Biweekly


COMP_FREQUENCY_ DESCRSHORT

Compensation Frequency Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code indicating how the compensation rate is expressed.

Annual;

Hourly;


Biweekly

COMP_HOURLY_RT

Compensation Hourly Rate

Number

18,6

M_TLDW1

JOB

PAY_EARNINGS



R

A system calculated number indicating the hourly compensation rate for a specific employee appointment.

0.000000;

23.654500;

101.019231


COMP_MONTHLY_RT

Compensation Monthly Rate

Number

18,3

M_TLDW1

JOB

R

A system calculated number indicating the monthly compensation rate for a specific employee appointment.

0.000;

4100.113;

17510.000


COMPANY

Company Code

Character

3

M_PYDW1

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

A code representing an entity identified by a Federal Employer Identification Number.

STR = Stdnt Rfnd ;

UOM = Univ of Michigan



COMPRATE

Compensation Rate

Number

14,2

M_TLDW1

M_PYDW1


JOB

PAY_ERN_DIST

PAY_OTH_EARNS


R

A number representing the base compensation received by an employee for a job.

0.00;

934.52;


50,047.00;

573,681.68



COMPRATE_USED

Compensation Rate Used

Number

18,6

M_PYDW1

PAY_OTH_EARNS

R

The hourly compensation rate used to calculate dollars for earnings code quantities. For example, shift time will have a smaller COMPRATE_USED value than regular time. The PAY_OTHER_EARNS COMPRATE field is a subset of COMPRATE_USED, it only holds the hourly compensation rate for shift and on-call earnings codes.

0.00;
1.00;
13.50;
81.20



COMPRATE_USED_REG

Compensation Rate Used for Regular Pay

Number

18,6



M_PYDW1

PAY_EARNINGS

R

The base hourly compensation rate.

Used only in the system for a limited number of cash earnings codes that contain a unit override rate.

COMP_HOURLY_RT is a more useful field for reporting purposes.


12.00;
15.50;
27.80;
51.00

CONCURRENT_JOB_ID

Concurrent Job Identification Code

Character

15

M_TLDW1

JOB

R

A code made up of employee identification number and employment record number allowing for a count of appointments in a department.

255825421;

001435690



COVERAGE_ELECT


Coverage Election Code

Character

1

M_TLDW1

TL_LEAVE_PLAN

R

A code indicating the type of coverage election.

E = Elect;

W = Waive;

T = Terminated


COVERAGE_ELECT_ DESCRSHORT


Coverage Election Short Description

Character

10

M_TLDW1

TL_LEAVE_PLAN

R

An abbreviated textual description of the code indicating the type of coverage election.

Elect;

Waive;


Terminated

COVERAGE_ELECT_DT

Coverage Election Date

Date




M_TLDW1

TL_LEAVE_PLAN

R

The date on which a coverage election is made.

09/09/2005

CWS_ELIG_FLG

College Work Study Eligibility Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code will be eligible for the college work study subsidy.

Y = Yes;

N = No


DATE_UNDER_REPORT

Time Under Report Date

Date




M_TLDW1

TL_PAYABLE_TIME

TL_RPTD_ELPTIME



R

The date for which a specific time and labor time reporting code and hours or dollars was submitted.

3/31/2006;

4/30/2006



DEPT_BUDGET_ERN_EFFDT

Department Budget Earnings Effective Date

Date




M_HRDW1

DEPT_BUDGET_ERN

R

The date on which the distribution of job compensation across shortcode(s) becomes effective.

12/03/2001

DEPT_BUDGET_ERN_END_DT

Department Budget Earnings End Date

Date




M_HRDW1

DEPT_BUDGET_ERN

R

The last date on which the department budget earnings row is effective.

September 9, 3999 represents that the distribution of job compensation across shortcode(s) is open-ended.



10/15/2001

DEPT_BUDGET_ERN_SEQ

Department Budget Earnings Sequence Number

Number

2

M_HRDW1

DEPT_BUDGET_ERN

R

A system assigned number, which in combination with the appointing department identification number, employee identification number, employment record number, and effective date identifies a unique department budget earnings row.

0;

1;

2;



3

DEPT_DESCR

Department Name

Character

30

M_HRDW1

HE_DEPT_TBL

HRMS_RPT_RECIPIENT



R

A textual description of the code that identifies each academic or administrative unit that has programmatic, operational and fiscal (including budgetary) responsibility.

Physics Department;

College of Lit, Science & Arts;

UMH Administration


DEPT_EFF_STATUS

Department Effective Status Code

Character

1

M_HRDW1

HE_DEPT_TBL

R

A code specifying the current status of a U of M department.

A = Active;

I = Inactive



DEPT_EFFDT

Department Effective Date

Date




M_HRDW1

HE_DEPT_TBL

R

The date when the department status becomes effective.

01/01/1998

DEPT_END_DT

Department End Date

Date




M_HRDW1

HE_DEPT_TBL

R

The last date on which the department status is effective.

September 9, 3999 represents that the department status is open-ended.



01/01/1999

DEPT_GRP

Department Group Code

Character

20

M_HRDW1

HE_DEPT_TBL

R

A code used to group U of M departments for reporting purposes. This code is used to group U of M schools, colleges, administrative areas, and vice presidential areas.

COLLEGE_OF_LS&A;

MEDICAL_SCHOOL;

UM_HOSPITAL


DEPT_GRP_CAMPUS

Department Group Campus Code

Character

20

M_HRDW1

HE_DEPT_TBL

R

A code used to identify department groups by campus.

UM_ANN-ARBOR;

UM_DEARBORN;

UM_FLINT


DEPT_GRP_CAMPUS_DESCR

Department Group Campus Description

Character

30

M_HRDW1

HE_DEPT_TBL

R

A textual description of the code used to identify department groups by campus.

Univ of Mich-Ann-Arbor;

Univ of Mich-Dearborn;

Univ of Mich-Flint


DEPT_GRP_DESCR

Department Group Description

Character

30

M_HRDW1

HE_DEPT_TBL

R

A textual description of the code used to group U of M departments for reporting purposes. This description is used to group U of M schools, colleges, administrative areas, and vice presidential areas.

College of Lit, Science and Arts;

Medical School;

U of M Hospital


DEPT_GRP_VP_AREA


Department Group Vice President Area Code

Character

20

M_HRDW1

HE_DEPT_TBL

R

A code used to group department groups by President, Vice President, or Chancellor, based on direct reporting lines.

PRVST_EXC_VP_ACA_AFF;

VP_STUDENT_AFFAIRS;

EXC_VP_MED_AFF


DEPT_GRP_VP_AREA_DESCR

Department Group Vice President Area Description

Character

30

M_HRDW1

HE_DEPT_TBL

R

A textual description of the code used to group department groups by President, Vice President, or Chancellor, based on direct reporting lines.

Provost & Exec VP Academic Aff;

VP for Student Affairs;

Exec. VP for Medical Affairs


DEPT_MANAGER_ID

Department Manager Identification Code

Character

11

M_HRDW1

HE_DEPT_TBL

R

A system assigned number used to uniquely identify a person in a department who receives financial reports such as Statement of Activity.

25582542

DEPT_MANAGER_CAMPUS_ID

Department Manager Campus Identification Code

Character

16

M_HRDW1

HE_DEPT_TBL

R

The U of M uniqname assigned to a person in a department who receives financial reports such as Statement of Activity.

jsmith;

anndoe


DEPT_TENURE_FLG

Department Tenure Flag

Character

1

M_HRDW1

HE_DEPT_TBL

R

A code indicating whether a department is a tenure granting department.

Y = Yes;

N = No


DEPTID

Department Identification Code

Character

10

M_HRDW1

HE_DEPT_TBL

HRMS_RPT_RECIPIENT



R

A code that identifies each academic or administrative unit that has programmatic, operational and fiscal (including budgetary) responsibility.

184500 = Physics Department;

170000 = College of Lit, Science & Arts;

311679 = UMH Administration


DIST_PCT

Distribution Percentage

Number

6,3

M_HRDW1

DEPT_BUDGET_ERN

R

The percentage of an employee’s compensation rate that is distributed to a specific shortcode for payment.

0.000;

0.740;


3.992;

75.000;


100.000

EARNINGS_AMT

Earnings Amount

Signed Number

13,2

M_PYDW1

PAY_ERN_DIST

R

A number representing the dollar amount distributed to an individual by the University for the appropriate pay period.

0.00;

-1,036.67;

412.06


EARNINGS_PAYMENT_TYPE

Earnings Payment Type Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code used to indicate the type of earnings payment allowed.

A = Amounts Only;

B = Both Hours and Amounts OK;

E = Either Hours or Amounts OK


EFFECT_ON_FLSA

Effect on Fair Labor Standards Act Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating how Fair Labor Standards Act (FLSA) regulations impact the calculation of the overtime rate for an earnings code.

A = Amounts Only;

B = Both Hours and Amounts;

H = Hours only;

N = None


EFFECT_ON_FLSA_ DESCRSHORT

Effect on Fair Labor Standards Act Code Short Description

Character

10

M_PYDW1

EARNINGS_TBL

R

An abbreviated textual description of the code indicating how Fair Labor Standards Act (FLSA) regulations impact the calculation of the overtime rate for an earnings code.

Amts Only;

Both;


Hours Only

None


ELIG_FOR_RETROPAY

Eligible for Retro Pay Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code is eligible for retropay.

Y = Yes;

N = No


EMPL_PGM_EFF_STATUS

Employee Leave Program Effective Status Code

Character

1

M_TLDW1

TL_EMPL_PGM

R

A code specifying the current status of an employee leave program.

A = Active;

I = Inactive



EMPL_PGM_EFFDT

Employee Leave Program Effective Date

Date




M_TLDW1

TL_EMPL_PGM

R

The date on which the employee leaves program status becomes effective.

01/01/1999

EMPL_PGM_END_DT

Employee Leave Program End Date

Date




M_TLDW1

TL_EMPL_PGM

R

The last date on which the employee leave program is effective. September 9, 3999 represents that the employee leave program is open-ended.

01/01/1999

EMPL_RCD

Employee Record Number

Number

3

M_TLDW1

M_PYDW1


M_HRDW1

JOB

NO_VARIANCE_TBL TL_EMPL_DATA

TL_GROUP_DTL

TL_MISS_TIME

TL_PAYABLE_TIME

TL_RPTD_ELPTIME

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

DEPT_BUDGET_ERN



R

A system assigned number which along with employee identification number, effective date and effective sequence, identifies an employee’s unique job(s).

0;

1;

2;



3

EMPL_STATUS

Employee Status Code

Character

1

M_TLDW1

JOB

R

A code indicating an employee’s status related to a specific job. (HR)

(HR)

A = Active;

R = Retired

(HRSNAP)


A = Active;

L = Leave of Absence;

P = Leave With Pay


EMPL_STATUS_DESCR

Employee Status Description

Character

30

M_TLDW1

JOB

R

A textual description of the code indicating an employee’s status related to a specific job.

(HR)

Active;


Retired

(HRSNAP)


Active;

Leave of Absence;

Leave With Pay


EMPL_TYPE

Employee Type Code

Character

1

M_TLDW1

M_PYDW1


JOB

PAY_CHECK



R

A code indicating what type of employee an individual is considered to be related to a specific job.

E = Excep Hrly;

H = Hourly;

N = Not Appl ;

S = Salaried



EMPL_TYPE_DESCRSHORT

Employee Type Short Description

Character

10

M_TLDW1

M_PYDW1


JOB

PAY_CHECK



R

An abbreviated textual description of the code indicating what type of employee an individual is considered to be related to a specific job.

Excep Hrly;

Hourly;


Not Appl ;

Salaried


EMPLID

Employee Identification Code

Character

11

M_TLDW1

M_PYDW1


JOB

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_EARNINGS

PAY_ERN_DIST



R

A system assigned number to uniquely identify a person at U of M. Commonly referred to as UMID.


25582542


ERNCD

Earnings Code

Character

3

M_TLDW1
M_PYDW1

TL_PAYABLE_TIME

TL_TRC_TBL

EARNINGS_TBL

PAY_ERN_DIST

PAY_OTH_EARNS


R

A code identifying the type of pay used to calculate a payroll amount.

REG = Regular ;

SWP = SckWOPay;

OTP = OTPrem;

HOL = Holiday

LTD = Disability;

FEL = Fellowship



ERNCD_DESCR

Earnings Code Description

Character

30

M_TLDW1
M_PYDW1

TL_PAYABLE_TIME

TL_TRC_TBL

EARNINGS_TBL

PAY_ERN_DIST

PAY_OTH_EARNS


R

The textual description of the code identifying the type of pay used to calculate a payroll amount.

Regular ;

Sick Without Pay;

Overtime 1.5;

Holiday;


Long Term Disability;

Fellowship



ERNCD_DESCRSHORT

Earnings Code Short Description

Character

10

M_TLDW1
M_PYDW1

TL_PAYABLE_TIME

TL_TRC_TBL

EARNINGS_TBL

PAY_OTH_EARNS



R

An abbreviated textual description of the code identifying the type of pay used to calculate a payroll amount.

Regular ;

SckWOPay;

OTPrem;

Holiday;


Disability;

Fellowship



ERNCD_EFF_STATUS

Earnings Code Effective Status Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code specifying the current status of an earnings code.

A = Active;

I = Inactive



ERNCD_EFFDT

Earnings Code Effective Date

Date




M_PYDW1

EARNINGS_TBL

R

The effective date of an earnings code.

01/01/1999

ERNCD_REG_HRS


Earnings Code Regular Hours Code

Character

3

M_PYDW1

PAY_EARNINGS

R

A code identifying the earnings code used to calculate the regular pay portion of a payroll amount.

NGC = Regular;

REG = Regular




EXCPTN_TIME_RPTING_END_DT


Exception Time Reporting End Date

Date




M_TLDW1

NO_VARIANCE_TBL

R

The end date of the reporting period for which exception time was reported for a monthly employee. For the monthly paygroup (MOR) it is one month behind the PAY_END_DT.

3/31/2006;
4/30/2006

FISCAL_QUARTER

Fiscal Quarter Code

Character

3

M_TLDW1

CALENDAR

R

A code representing the quarter, in relation to a fiscal year.

Q1 = 1st Qtr (July-Sept);

Q2 = 2nd Qtr (Oct-Dec);

Q3 = 3rd Qtr (Jan-Mar);

Q4 = 4th Qtr (Apr-June)



FISCAL_QUARTER_DESCR

Fiscal Quarter Description

Character

30

M_TLDW1

CALENDAR

R

A textual description of the code representing the quarter, in relation to a fiscal year.

1st Qtr (July-Sept);

2nd Qtr (Oct-Dec);

3rd Qtr (Jan-Mar);

4th Qtr (Apr-June)



FISCAL_YEAR

Fiscal Year

Number

4

M_TLDW1

M_PYDW1


CALENDAR

PAY_ERN_DIST



R

The U of M fiscal year in the format CCYY. The U of M fiscal year runs from July through June. For example, July 1, 2000–June 30, 2001 is Fiscal Year 2001.

2000;

2001


(PY) 2002;

2003


FLSA_CATEGORY

Fair Labor Standards Act Category Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code representing the Fair Labor Standards Act (FLSA) category which an earning code falls into.

O = Overtime;

R = Regular;

X = Excluded


FLSA_CATEGORY_DESCRSHORT

Fair Labor Standards Act Category Code Short Description

Character

10

M_PYDW1

EARNINGS_TBL

R

An abbreviated textual description of the code representing whether Fair Labor Standards Act (FLSA) category which an earning code falls into.

Overtime;

Regular;


Excluded

FLSA_RT

Fair Labor Standards Act Rate

Number

18,6

M_PYDW1

PAY_EARNINGS

R

The pay rate used to calculate the portion of a payroll amount that was impacted by Fair Labor Standards Act (FLSA).

12.45;
13.77;
29.06

FLSA_STATUS

Fair Labor Standards Act Status Code

Character

1

M_TLDW1

JOB

R

A code that defines groups of JobCodes according to the Fair Labor Standards Act (FLSA), used to administer overtime payments and to trigger some benefits.

A = Administr;

N = Nonexempt;

X = No FLSA


FLSA_STATUS_DESCRSHORT

Fair Labor Standards Act Status Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code that defines groups of JobCodes according to the Fair Labor Standards Act (FLSA), used to administer overtime payments and to trigger some benefits.

Administrative;

Nonexempt;

No FLSA Required


FORM_ID

Form Identification Code

Character

6

M_PYDW1

PAY_CHECK

R

A code that defines the type of payment form. Can be used to determine if a payment was direct deposited or a physical check.

UMADV = Um Payroll Advice Stock;

UMCHK = Um Payroll Check Stock



FTE

Full Time Equivalent

Number

3,2

M_TLDW1

JOB

R

The system calculated percent of effort derived from standard hours for an employee in a job.

0.00;

0.33;


1.00

FUND_CODE

Fund Code

Character

5

M_PYDW1

M_HRDW1


PAY_ERN_DIST

DEPT_BUDGET_ERN



R

A code used to identify the source of funds and intended use of the funds.

10000 = General;

52000 = Auxiliary-Internal Services





FUNDING_DEPT_DESCR

Funding Department Description

Character

30

M_HRDW1

DEPT_BUDGET_ERN

R

A textual description of the code indicating the department which is responsible for providing this particular funding for a specific job.

Physics Department;

College of Lit, Science & Arts;

UMH Administration


FUNDING_DEPT_GRP

Funding Department Group Code

Character

20

M_HRDW1

DEPT_BUDGET_ERN

R

A code indicating the department group of the employee’s funding department.

This code is used to group U of M schools, colleges, administrative areas, and vice presidential areas.



COLLEGE_OF_LS&A;

MEDICAL_SCHOOL;

UM_HOSPITAL


FUNDING_DEPT_GRP_CAMPUS

Funding Department Group Campus Code

Character

20

M_HRDW1

DEPT_BUDGET_ERN

R

A code indicating the campus of the employee’s funding department.

UM_ANN-ARBOR;

UM_DEARBORN;

UM_FLINT


FUNDING_DEPT_GRP_CAMPUS_DESCR

Funding Department Group Campus Description

Character

30

M_HRDW1

DEPT_BUDGET_ERN

R

A textual description of the code indicating the campus of the employee’s funding department.

Univ of Mich-Ann-Arbor;

Univ of Mich-Dearborn;

Univ of Mich-Flint


FUNDING_DEPT_GRP_DESCR

Funding Department Group Description

Character

30

M_HRDW1

DEPT_BUDGET_ERN

R

A textual description of the code indicating the department group of the employee’s funding department.

This code is used to group U of M schools, colleges, administrative areas, and vice presidential areas.



College of Lit, Science and Arts;

Medical School;

U of M Hospital


FUNDING_DEPT_GRP_VP_AREA

Funding Department Group Vice President Area Code

Character

20

M_HRDW1

DEPT_BUDGET_ERN

R

A code indicating the vice presidential area of the employee’s funding department by President, Vice President, or Chancellor, based on direct reporting lines.

PRVST_EXC_VP_ACA_AFF;

VP_STUDENT_AFFAIRS;

EXC_VP_MED_AFF


FUNDING_DEPT_GRP_VP_AREA_DESCR

Funding Department Group Vice President Area Description

Character

30

M_HRDW1

DEPT_BUDGET_ERN

R

A textual description of the code indicating the vice presidential area of the employee’s funding department by President, Vice President, or Chancellor, based on direct reporting lines.

Provost & Exec VP Academic Aff;

VP for Student Affairs;

Exec. VP for Medical Affairs


FUNDING_DEPTID

Funding Department Identification Code

Character

10

M_PYDW1

M_HRDW1


PAY_ERN_DIST

DEPT_BUDGET_ERN




R

A code indicating the department which is responsible for providing this particular funding for a specific job.

184500= Physics Department

170000 = College of Lit, Science & Arts;

311679 = UMH Administration


FUNDING_END_DT

Funding End Date

Date




M_HRDW1

DEPT_BUDGET_ERN

R

The date on which a department is no longer responsible for providing this particular funding for a specific job except in the case of University Year appointments where the fiscal responsibility extends beyond the Funding End Date represented.  September 9, 3999 represents that the funding for a specific job is open-ended.

11/17/2001

FUNDING_NEXT_HIGHER_DEPTID

Funding Department Next Higher Department Identification Code

Character

10

M_HRDW1

DEPT_BUDGET_ERN

R

A code representing the department on the department tree one level up from the employee’s funding department.

This data is based on the Department Security Tree.



172200 = LS&A Natural Science Departmen;

102500 = Off Provost & Exec VP Acad Aff



HOLIDAY_DESCR

Holiday Code Description

Character

30

M_TLDW1

CALENDAR

R

A textual description of the date recognized as a holiday by U of M.

Memorial Day;

Independence Day;

Christmas


HOLIDAY_IND

Holiday Indicator

Character

1

M_TLDW1

CALENDAR

R

A code indicating whether a specific date is recognized as a holiday for university employees with the exception of International Union of Operating Engineers (IUOE) employees.

Y = Yes;

N = No


HOLIDAY_SCHEDULE

Holiday Schedule Code

Character

6

M_TLDW1

TL_WRKGRP_TBL

R

A code indicating whether a workgroup gets 8 hours of holiday payable time created automatically.

HOL = Regular Holiday Schedule;

IUOE = IUOE Holiday Schedule;

NONE = No Holiday Schedule


HOLIDAY_SCHEDULE_DESCR

Holiday Schedule Code Description

Character

30

M_TLDW1

TL_WRKGRP_TBL

R

A textual description of the code indicating whether a workgroup gets 8 hours of holiday payable time created automatically.

Regular Holiday Schedule;

IUOE Holiday Schedule;

No Holiday Schedule


HOLIDAY_SCHEDULE_ DESCRSHORT

Holiday Schedule Code Short Description

Character

10

M_TLDW1

TL_WRKGRP_TBL

R

An abbreviated textual description of a code indicating whether a workgroup gets 8 hours of holiday payable time created automatically.

Reg Hol;

IUOE Hol;

No Hol


HOURS1

Time and Labor Hours 1

Signed Number

9,5

M_PYDW1

PAY_ERN_DIST

R

The breakdown of hours worked by earn code, shortcode and pay period.

0.00000;

-8.00000;

15.125


HR_FLG

Human Resource Print Flag Code

Character

1

M_PYDW1

EARNINGS_TBL

PAY_ERN_DIST



R

A code indicating whether the earnings code will print on the Human Resource Notice of Appointment (NOA).

Y = Yes;

N = No


HRMS_RPT_RECIPIENT_ ADDRESS1

Human Resource Management System Report Recipient Address 1

Character

55

M_HRDW1

HRMS_RPT_RECIPIENT

R

The first of three address lines which contain the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department.

C/O Hospital Financial Service;

MATHEMATICS



HRMS_RPT_RECIPIENT_ ADDRESS2

Human Resource Management System Report Recipient Address 2

Character

55

M_HRDW1

HRMS_RPT_RECIPIENT

R

The second of three address lines which contain the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department.

300Nib Ni7E18;

4858 EAST HALL



HRMS_RPT_RECIPIENT_ ADDRESS3

Human Resource Management System Report Recipient Address 3

Character

55

M_HRDW1

HRMS_RPT_RECIPIENT

R

The third of three address lines which contain the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department. This will be blank for addresses delivered to by Campus Mail.

3621 State Street

HRMS_RPT_RECIPIENT_CAMPUS_ID

Human Resource Management System Report Recipient Campus Identification Code

Character

16

M_HRDW1

HRMS_RPT_RECIPIENT

R

The U of M uniqname assigned to a person receiving Human Resource Management Systems (HRMS) reports for a department.

jsmith;

anndoe


HRMS_RPT_RECIPIENT_CITY

Human Resource Management System Report Recipient City

Character

30

M_HRDW1

HRMS_RPT_RECIPIENT

R

The name of the city associated with the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department. This will be blank for addresses delivered to by Campus Mail.

Ann Arbor

HRMS_RPT_RECIPIENT_ COUNTRY

Human Resource Management System Report Recipient Country Code

Character

3

M_HRDW1

HRMS_RPT_RECIPIENT

R

A code representing the country associated with the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department.

USA = United States

HRMS_RPT_RECIPIENT_EFFDT

Human Resource Management System Report Recipient Effective Date

Date




M_HRDW1

HRMS_RPT_RECIPIENT

R

The date the person in a department is to begin receiving Human Resource Management Systems (HRMS) reports for a department.

08/11/2001

HRMS_RPT_RECIPIENT_EMPLID

Human Resource Management System Report Recipient Employee Identification Code

Character

11

M_HRDW1

HRMS_RPT_RECIPIENT

R

A system assigned number used to uniquely identify a person receiving Human Resource Management Systems (HRMS) reports for a department.

25582542

HRMS_RPT_RECIPIENT_NAME

Human Resource Management System Report Recipient Name

Character

50

M_HRDW1

HRMS_RPT_RECIPIENT

R

The name of the person receiving Human Resource Management Systems (HRMS) reports for a department.

Winkeler, John

HRMS_RPT_RECIPIENT_PHONE

Human Resource Management System Report Recipient Phone

Character

24

M_HRDW1

HRMS_RPT_RECIPIENT

R

The work phone number of the person receiving Human Resource Management Systems (HRMS) reports for a department.

7348721379


HRMS_RPT_RECIPIENT_POSTAL

Human Resource Management System Report Recipient Postal Code

Character

12

M_HRDW1

HRMS_RPT_RECIPIENT

R

The campus zip of the person receiving Human Resource Management Systems (HRMS) reports for a department.

0428;

1109



HRMS_RPT_RECIPIENT_STATE

Human Resource Management System Report Recipient State Code

Character

6

M_HRDW1

HRMS_RPT_RECIPIENT

R

A code representing the state associated with the work address of the person receiving Human Resource Management Systems (HRMS) reports for a department. This will be blank for addresses delivered to by Campus Mail.

MI = Michigan


HRMS_RPT_TYPE

Human Resource Management System Report Type Code

Character

1

M_HRDW1

HRMS_RPT_RECIPIENT

R

A code indicating the type of Human Resource Management Systems (HRMS) report.

G = Gross Pay;

P = Personnel;

T = Time Rpt


HRMS_RPT_TYPE_DESCRSHORT

Human Resource Management System Report Type Short Description

Character

10

M_HRDW1

HRMS_RPT_RECIPIENT

R

An abbreviated description of the code indicating the type of Human Resource Management Systems (HRMS) report.

Gross Pay Register;

Personnel;

Time Report


HRS_ONLY

Hours Only Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code will only pay for hours reported. A value of “Y” indicates that the Earnings Code “Reduces from REG”, meaning that it subtracts equivalent REG hours thus keeping the gross amount the same.

Y = Yes;

N = No


HRS_REPRESENT_DESCR

Hours Represent Description

Character

30

M_TLDW1

TL_TRC_TBL

R

A textual description of the code indicating whether the earnings code will only pay for hours reported.

Actual Hours;

Compensation Only Hours



HRS_REPRESENT_IND

Hours Represent Indicator

Character

1

M_TLDW1

TL_TRC_TBL

R

A code indicating the type of hours represented by a specific time reporting code

A = Actual Hours;

C = Compensation Only Hours



INCOME_CD_10422

Income Code for 1042-S

Character

2

M_PYDW1

EARNINGS_TBL

R

A code that identifies the income category for 1042 tax reporting.

15 = Scholarship/Fellowhsip Grants;

18 = Teaching;

19 = Studying and Training


IUOE_HOLIDAY_IND

International Union of Operating Engineers Holiday Indicator

Character

1

M_TLDW1

CALENDAR

R

A code indicating whether a specific date is recognized as a holiday for university International Union of Operating Engineers (IUOE) employees.

Y = Yes;

N = No


JOB_ACTION

Job Action Code

Character

3

M_TLDW1

JOB

R

A code indicating the type of action that has occurred related to a job.

DTA = Data Change;

HIR = Hire;

PAY = Pay Rate Change


JOB_ACTION_DESCR

Job Action Description

Character

30

M_TLDW1

JOB

R

A textual description of the code indicating the type of action that has occurred related to a job.

Data Change;

Hire;


Pay Rate Change


JOB_ACTION_DT

Job Action Date

Date




M_TLDW1

JOB

R

The date the action related to a job was entered into the system.

08/15/2001

JOB_ACTION_REASON

Job Action Reason Code

Character

3

M_TLDW1

JOB

R

A code providing more detailed information regarding the reason an action occurred related to a job.

AR7 = Merit;

CTR = Effort Change;

HIR = New Hire


JOB_ACTION_REASON_DESCR

Job Action Reason Description

Character

30

M_TLDW1

JOB

R

A textual description of the code providing more detailed information regarding the reason an action occurred related to a job.

Merit;

Effort Change;

New Hire


JOB_EFFDT

Job Effective Date

Date




M_TLDW1

JOB

R

The date on which job related information became effective.

08/15/2001

JOB_EFFSEQ

Job Effective Sequence Number

Number

3

M_TLDW1

JOB

R

A system assigned number that in conjunction with the employee identification code, employment record number, and job effective date identifies a unique job row.

0;

1;

2;



3

JOB_END_DT

Job End Date

Date




M_TLDW1

JOB

R

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

10/15/2001


JOB_FAMILY

Job Family Code

Character

6

M_TLDW1

JOB

R

A code that groups JobCodes with similar classification and compensation structures, benefits plans, and applicable Standard Practice Guide sections.

10 = Regular Instructional;

210 = Information Technology;

260 = Patient Care Services


JOB_FAMILY_DESCR

Job Family Description

Character

30

M_TLDW1

JOB

R

A textual description of the code that groups JobCodes with similar classification and compensation structures, benefits plans, and applicable Standard Practice Guide sections.

Regular Instructional;

Information Technology;

Patient Care Services


JOB_INDICATOR

Job Indicator Code

Character

1

M_TLDW1

JOB

R

A code indicating whether a specific job is considered the employee’s primary or secondary job. An employee’s primary job is typically the one in which the employee has the largest appointment effort or hours as of the job effective date. Temporary appointments will always have a job indicator of N = Not Applicable.


P = Primary Job;

S = Secondary Job;

N = Not Applicable


JOBCODE

JobCode

Character

6

M_TLDW1

M_PYDW1


JOB

PAY_EARNINGS

PAY_ERN_DIST


R

A code indicating a job classification title established by the Office of Human Resource and Affirmative Action.

100800 = Chancellor;

201000 = Professor;

240500 = Accountant Assoc


JOBCODE_BEN_FAMILY

JobCode Benefit Family Code

Character

4

M_TLDW1

JOB

R

A code indicating the benefit family associated with the employee’s job code.

30 = House Off;

37 = Res Fello

40 = P/A Exemp


JOBCODE_BEN_FAMILY_DESCR

JobCode Benefit Family Description

Character

30

M_TLDW1

JOB

R

A textual description of the code indicating the benefit family associated with the employee’s job code.

House Officer;

Research Fellow;

Professional/Admin Exempt


JOBCODE_BEN_FAMILY_ DESCRSHORT

JobCode Benefit Family Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code indicating the benefit family associated with the employee’s job code.

House Off;

Res Fello;

P/A Exemp


JOBCODE_DESCR


JobCode Description

Character

30

M_TLDW1

M_PYDW1


JOB

PAY_EARNINGS

PAY_ERN_DIST


R

A textual description of the code indicating a job classification title established by the Office of Human Resource and Affirmative Action.

Chancellor;

Professor;

Accountant


LINE_NUM


Line Number

Number

2

M_PYDW1

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

PAY_OTH_EARNS



R

A sequential number uniquely identifying each line. This line on a page in a paysheet defines the transaction for a single employee.

1;

2;

3



LVE_ACCRL_GRNDFATHRD_ COMMENTS

Leave Accrual Grandfathered Comments

Character

254

M_TLDW1

TL_LVACR_GRND

R

A line of text containing information about an employee being grandfathered into a particular leave accrual plan.

FLSA change;

Per memo from Jennifer Tomko;

Reinstated original date of hire eff 11/1/05, alouks 12/14/05


LVE_ACCRL_GRNDFATHRD_ EFFDT

Leave Accrual Grandfathered Effective Date

Date




M_TLDW1

TL_LVACR_GRND

R

The date on which the grandfathered leave accrual plan assignment becomes effective.

01/23/2005


LVE_ACCRL_GRNDFATHRD_END_DT

Leave Accrual Grandfathered End Date

Date




M_TLDW1

TL_LVACR_GRND

R

The last date on which the grandfathered leave accrual plan assignment is effective.

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



05/31/2005


MAIL_DROP

Mail Drop Identification

Character

50

M_PYDW1

PAY_CHECK

R

A code used to identify the distribution point for an individuals payroll check or deposit.

0001 = Payroll Office Default;

0020 = LS&A Cashiers Office;

0026 = Campus Payroll Office


MAIL_DROP_DESCR

Mail Drop Description

Character

30

M_PYDW1

PAY_CHECK

R

A textual description of the code used to identify the distribution point for an individual’s payroll check or deposit.

Payroll Office Default;

LS&A Cashiers Office;

Campus Payroll Office


MANAGER_NAME

Manager Name

Character

50

M_HRDW1

HE_DEPT_TBL

R

The name of the person in a department who receives financial reports such as Statement of Activity. Person name format is Last, First Middle.

Schmoe,Joseph;

Doe,Mary L



MISS_TIME

Missing Time Code

Character

1

M_TLDW1

TL_LEAVE_DATA

R

A code indicating whether time has not been reported for an employee for a given pay period in time and labor.

Y = Yes;
N = No

MONTH_DAYS_COUNT

Month Days Count

Number

2

M_TLDW1

CALENDAR

R

The number of days in a month.

29;

30;


31

MONTH_WORK_DAYS_COUNT

Month Work Days Count

Number

2

M_TLDW1

CALENDAR

R

The number of work days in a month.

23;

21


MULTIPLICATION_FACTOR

Multiplication Factor

Signed Number

9,4

M_PYDW1

EARNINGS_TBL

R

A number used to adjust the hourly pay rate as appropriate. For a specific earnings code, the multiplication factor times the hours reported times the hourly pay rate equals the earnings amount.

0.5000;

1.0000;


1.5000;

-0.5000;


-1.0000


NAME
1   2   3   4   5   6   7


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

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