M-pathways Time and Labor Data Dictionary




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

Time and Labor Data Element Dictionary


The Time and Labor Data Element Dictionary contains all the elements found in the U-M Data Warehouse Time and Labor Tables, ordered alphabetically by element name. Here is a description of the information that the dictionary provides for each element:


Physical Element Name

Name for the element you can use in SQL queries.

Logical Element Name

Descriptive name of the element.

Format Type

Type of value of the element (for example: character, number, or date). Note: If the format type for an element is character or date, you must enclose the variable value in single quotes when entering queries.

Format Length

Total length of the element. For data elements in the format “number,number”, the first number represents the total length of the element. The second number represents the number of digits to the right of the decimal.

Data Sets

The names of the data sets that contain the element.

Table Locations

The names of the tables in which the element is located.

Security Code

The level of security imposed on the element. Values are:




P

Public data

Data with no access restriction that may be released to the general public.




R

Private/
Confidential data

Data available to University employees who need to access these data to perform their official University duties. Unless otherwise noted, all institutional data is designated as Private/Confidential.




S

Sensitive data

Data available only to University employees who have specific authorization for access. Never release sensitive data in a manner that enables identifying data element values with a specific person or persons.

Element Definition

Description of the element.

Examples of Valid Values

Either the specific codes that are valid for the element, or samples of the kind of values for the element.




Physical Element Name


Logical Element Name

Format
Type


Format Length

Data Set


Table Locations


Security Code


Element Definition


Examples of
Valid Values


ABBR_FLG

Annual Base Benefits Rate Code

Character

1

M_PYDW1

EARNINGS_TBL

PAY_ERN_DIST



R

A code indicating whether the earnings code adds to the Annual Base Benefits Rate.

Y = Yes;

N = No


ACCOUNT

Account Code

Character

6

M_PYDW1

PAY_ERN_DIST

R

A code used to record and summarize financial transactions such as assets, liabilities, fund balances, revenues, expenses, statistics or budget accounts.

122100 = Accounts & Notes Receivable;

615020 = Postage/ Mailing;

SHR = Investment Shares


ACCOUNTING_DT

Accounting Date

Date




M_PYDW1

PAY_ERN_DIST

R

The accounting date associated with the transaction.

01/01/1999

ACCOUNTING_PERIOD

Accounting Period Code

Number

3

M_TLDW1

M_PYDW1


CALENDAR

PAY_ERN_DIST



R

A code used to identify the university accounting period which represents a fiscal calendar month.

3;

4;

9;



ADD_GROSS

Add to Gross Pay Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code indicating whether the earnings code adds to gross pay.

Y = Yes;

N = No


ADDL_NBR

Additional Pay Line Number

Number

3

M_PYDW1

PAY_EARNINGS

PAY_OTH_EARNS



R

A system assigned number which uniquely identifies pay other earnings entries.

1;

2;

3



ALLOCATION_AMT

Allocation Amount

Number

11,6

M_TLDW1

TL_TSKPRF_DETL

R

The percentage of the appointment that is to be disbursed to the shortcode.

20;

50;


100

ALLOW_EMPLTYPE

Allowable Employee Type Code

Character

1

M_PYDW1

EARNINGS_TBL

R

A code representing the type of employee to which an earnings code applies.

A = All Types Allowable;

H = Hourly and Exception Hourly;

S = Salary


ALLOW_EMPLTYPE_ DESCRSHORT

Allowable Employee Type Short Description

Character

10

M_PYDW1

EARNINGS_TBL

R

An abbreviated textual description of the code representing the type of employee to which an earnings code applies.

All;

Hourly;


Salaried

ANNL_BENEF_BASE_RT

Annual Benefits Base Rate

Number

14,2

M_TLDW1

JOB

R

A number indicating the salary used for benefits. It is system populated based on all eligible compensation rates and additional pay.

0.00;

63,043.31;

100,760.00


APPL_JRNL_ID

Journal Template

Character

10

M_PYDW1

PAY_ERN_DIST

R

A value indicating the type of transaction creating the accounting entries. This identifies the transaction source and pay frequency.

PYBIWEEKLY;

PYMONTHLY;

PYWEEKLY


APPT_DEPT_DESCR


Appointing Department Description

Character

30

M_TLDW1
M_PYDW1

JOB

TL_MISS_TIME

PAY_EARNINGS


R

A textual description of the code indicating the department which is granting an appointment and may be responsible for commitment of title and tenure. This may or may not be the department responsible for funding the appointment.

Physics Department;

College of Lit, Science & Arts;

UMH Administration


APPT_DEPT_GRP

Appointing Department Group Code

Character

20

M_TLDW1

JOB

R

A code indicating the department group of the employee’s appointing 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


APPT_DEPT_GRP_CAMPUS

Appointing Department Group Campus Code

Character

20

M_TLDW1

JOB

R

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

UM_ANN-ARBOR;

UM_DEARBORN;

UM_FLINT


APPT_DEPT_GRP_CAMPUS_ DESCR

Appointing Department Group Campus Description

Character

30

M_TLDW1

JOB

R

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

Univ of Mich-Ann-Arbor;

Univ of Mich-Dearborn;

Univ of Mich-Flint


APPT_DEPT_GRP_DESCR

Appointing Department Group Description

Character

30

M_TLDW1

JOB

R

A textual description of the code indicating the department group of the employee’s appointing 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


APPT_DEPT_GRP_VP_AREA

Appointing Department Group Vice President Area Code

Character

20

M_TLDW1

JOB

R

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

PRVST_EXC_VP_ACA_AFF;

VP_STUDENT_AFFAIRS;

EXC_VP_MED_AFF


APPT_DEPT_GRP_VP_AREA_ DESCR

Appointing Department Group Vice President Area Description

Character

30

M_TLDW1

JOB

R

A textual description of the code indicating the vice presidential area of the employee’s appointing 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


APPT_DEPTID

Appointing Department Identification Code

Character

10

M_TLDW1
M_PYDW1

M_HRDW1


JOB

TL_MISS_TIME

PAY_CHECK

PAY_EARNINGS

PAY_ERN_DIST

DEPT_BUDGET_ERN



R

A code indicating the department which is granting an appointment and may be responsible for commitment of title and tenure. This may or may not be the department responsible for funding the appointment.

184500 = Physics Department;

170000 = College of Lit, Science & Arts;

311679 = UMH Administration


APPT_PERIOD

Appointment Period Code

Character

1

M_TLDW1

JOB

R

A code describing the time period associated with the full time rate for an appointment.

4 = U-Year AA;

B = Biweekly;

H = Half Term;

7 = 12 Months



APPT_PERIOD_DESCR

Appointment Period Description

Character

30

M_TLDW1

JOB

R

A textual description of the code describing the time period associated with the full time rate for an appointment.

U-Year Ann Arbor (9/12);

Biweekly;

Half Contract Term;

Per 12 Months



APPT_PERIOD_DESCRSHORT

Appointment Period Short Description

Character

10

M_TLDW1

JOB

R

An abbreviated textual description of the code describing the time period associated with the full time rate for an appointment.

U-Year AA;

Biweekly;

Half Term;

12 Months



BENEFIT_GRP

Benefit Group Code

Character

1

M_HRDW1

HE_DEPT_TBL

R

A code indicating whether a department is considered a hospital department for benefits purposes.

H = Hospital;

O = Other



BENEFIT_GRP_DESCRSHORT

Benefit Group Short Description

Character

10

M_HRDW1

HE_DEPT_TBL

R

An abbreviated textual description of the code indicating whether a department is considered a hospital department for benefits purposes.

Hospital;

Other


CAL_DATE

Calendar Date

Date




M_TLDW1

CALENDAR

R

The numerical representation of a specific day based on the Gregorian Calendar. In the format MM/DD/CCYY.

01/01/1999

CAL_DAY

Calendar Day Code

Character

3

M_TLDW1

CALENDAR

R

A code representing the day of the week.

Mon;

Tue;


Sat

CAL_DAY_DESCRSHORT

Calendar Day Short Description

Character

10

M_TLDW1

CALENDAR

R

An abbreviated textual description of the code representing the day of the week.

Monday;

Tuesday;


Saturday

CAL_DAY_NBR_IN_WEEK

Calendar Day Number In Week

Number

1

M_TLDW1

CALENDAR

R

A number representing the order of a day in a week.

1 = Sunday;

2 = Monday;

3 = Tuesday


CAL_MONTH_CODE

Calendar Month Code

Character

2

M_TLDW1

CALENDAR

R

A code representing the calendar month.

07 = July;

08 = August;

12 = December


CAL_MONTH_DESCR

Calendar Month Description

Character

30

M_TLDW1

CALENDAR

R

The name of the calendar month.

July;

August;


December

CAL_MONTH_DESCRSHORT

Calendar Month Short Description

Character

10

M_TLDW1

CALENDAR

R

The abbreviated name of the calendar month.

Jul;

Aug;


Dec

CAL_QUARTER

Calendar Quarter Code

Character

3

M_TLDW1

CALENDAR

R

A code representing the quarter in relation to calendar year.

CQ1 = 1st Qtr (Jan-Mar);

CQ2 = 2nd Qtr (Apr-June);

CQ3 = 3rd Qtr (July-Sept);

CQ4 = 4th Qtr (Oct-Dec)



CAL_QUARTER_DESCR

Calendar Quarter Code Description

Character

30

M_TLDW1

CALENDAR

R

A textual description of the code representing the quarter in relation to calendar year.

1st Qtr (Jan-Mar);

2nd Qtr (Apr-June);

3rd Qtr (July-Sept);

4th Qtr (Oct-Dec)



CAL_YEAR

Calendar Year

Character

4

M_TLDW1

CALENDAR

R

A number representing the year beginning January 1 and ending December 31 in the format of CCYY.

1998;

1999;


2000

CHECK_DT

Paycheck Issue Date

Date




M_PYDW1

PAY_CHECK

PAY_ERN_DIST



R

The date on which the funds are either debited or credited on an actual account for payroll purposes. This represents the paydate.
1   2   3   4   5   6   7


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

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