Input Data Sent to TCD Systems

Time and Labor interfaces with many data collection systems. Input data to be sent to the TCD system varies by vendor. To accommodate as many vendors as possible, PeopleSoft allows you to define a generic set of input data to pass to your TCD. The TCD vendor uses only the data it must send to TCDs to meet the customer's time reporting needs.

Time and Labor uses the definitions of TCD type to control the data going to your TCD. It does not send data that your TCD cannot process. This reduces the traffic on the network and the amount of data the TCD has to ignore.

Time Reporter

The Time Reporter data structure contains general information about the time reporter and foreign keys to related data on other data structures that follow.

#	Data Element	Type	Length	Source	Notes
1	Empl ID	Char	11	TL_EMPL_DATA	Identifier.
2	Empl RCD#	Num	3	TL_EMPL_DATA	Identifier used in PS applications to accommodate multiple concurrent jobs (positions).
3	Badge ID	Char	20	BADGE_TABLE	Identifier.
4	Time Reporting Status	Char	1	TL_EMPL_DATA	Active or Inactive.
5	Last Name	Char	30	PERSONAL_DATA	Last name.
6	First Name	Char	30	PERSONAL_DATA	First name.
7	Hire Date	Date	10	EMPLOYMENT	Needed for calculating anniversary date.
8	Service Date	Date	10	EMPLOYMENT	Needed for determining seniority.
9	Birth Date	Date	10	PERSONAL_DATA	Needed for displaying a 'Happy Birthday' message.
10	Restriction Profile ID	Char	10	TL_TCDGRP_TBL or TL_EMPL_DATA	Identifies the employee's restriction profile. Blank means there are no restrictions for the time reporter.
11	Task Template ID	Char	10	TL_TASKGRP_TBL	Identifies the employee's task template ID.
12	Task Profile ID	Char	10	TL_EMPL_DATA	Identifies the employee's task profile.

With a few exceptions, Time and Labor obtains this information from the Employee Profile process and direct selects from tables. The Restriction Profile ID is from the TCD Group unless there is an override Restriction Profile on the Time and Labor Employee Data (TL_EMPL_DATA) record. The TASK_PRFL_TMPLT_ID is from the Taskgroup Table based on the employee's assigned Taskgroup in TL_EMPL_DATA.

Time and Labor sends both Badge ID and Empl ID/Empl Rcd#. The TCD can use either in collecting data.

This record is sent as a full table and as incremental changes are made in PeopleSoft. For example, for setup of the TCD, a TCD would receive all the reporters for that TCD. If a reporter was just activated in Time and Labor Employee Data, an incremental message is sent to all TCD's in the reporters TCD group.

The Task Template ID specified on this message is in the TCD Task Template message only if the template is valid for the TCDs to which this reporter can report time.

Schedule

The Schedule data structure contains time reporters' daily schedules.

Time reporters' daily schedules are provided to your TCD. The TCD uses this to determine when the time reporter is scheduled to punch in/out for work, meals, and breaks. Based on user-defined criteria (in restriction profiles), the TCD issues warning/error messages or prevents the user from using it.

The TCD definition defines whether this type of TCD can accept schedules. Time and Labor does not send schedules or restriction profiles if the TCD cannot accommodate them.

#	Data Element	Type	Length	Source	Notes
1	Badge ID	Char	20	TL_SCHEDULE	Identifier.
2	Emplid	Char	11	TL_EMPL_DATA	Identifier.
3	Empl Rcd#	Num	3	TL_EMPL_DATA	Identifier.
4	Punch Date Time	DateTime	See Interface Specifications	TL_SCHEDULE	Identifier.
5	Sequence Number	Num	3	TL_SCHEDULE	Identifier − needed when schedule spans multiple days.
6	Punch Type	Char	1	TL_SCHEDULE	(1 = In, 2 = Out, 3 = Meal, 4 = Break, 5 = Transfer).

Note: This data structure contains multiple instances of schedules per day. If the vendor requires that there is only one schedule record per day, the vendor must reformat the input data before sending to TCDs.

Restriction Profile

The Restriction Profile data structure contains customer defined restriction information. The vendor determines which restriction profiles to send to which TCDs based on the assignments of time reporters to restriction profile on the Time Reporter data structure. The vendor should be able to send all restriction profiles received from Time and Labor to all TCDs.

The TCD requires restriction profiles to determine when to allow or disallow punches to occur.

The TCD definition defines whether this type of TCD can accept schedules. Time and Labor does not send schedules or restriction profiles if the TCD cannot process them.

#	Data Element	Type	Length	Source	Notes
1	Restriction Profile ID	Char	10	TL_RESTRCTN_TBL	Identifier.
2	Early In Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
3	Early In Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
4	Late In Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
5	Late In Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
6	Early Out Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
7	Early Out Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
8	Late Out Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
9	Late Out Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
10	Early Meal Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
11	Early Meal Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
12	Late Meal Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
13	Late Meal Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
14	Early Break Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
15	Early Break Margin	Num	4	TL_RESTRCTN_TBL	Minutes.
16	Late Break Restriction Ind	Char	1	TL_RESTRCTN_TBL	Y/N.
17	Late Break Margin	Num	4	TL_RESTRCTN_TBL	Minutes.

Total Hours

The Total Hours data structure contains hours already worked for the week. Total Hours includes any overtime hours earned to date for the period. PeopleSoft provides the total hours by TRC for the current period for the time reporter up to the current date.

The TCD vendor uses this information to send to TCDs to be displayed when inquired by time reporters and supervisors. The TCD definition defines whether this type of TCD can accept hours.

#	Data Element	Type	Length	Source	Notes
1	Badge ID	Char	20	BADGE_TABLE	Identifier.
2	Empl ID	Char	11	TL_EMPL_DATA	Identifier.
3	Empl RCD#	Num	3	TL_EMPL_DATA	Identifier.
4	Time Reporting Code	Char	5	TL_PAYABLE_TIME	Identifier.
5	Total Payable Hours	Num	12.6	TL_PAYABLE_TIME	Number.

Note: Total Hours information comes from the Payable Time Table. To determine total payable hours, Time Administration (Apply Rules) must be executed before such data can be published.

Time Reporting Code

This data structure contains a list of Time Reporting Codes (TRCs) that are allowable at your TCD (such as sick, vacation, holiday, meal allowance, and so on). This is for elapsed time reporting only.

#	Data Element	Type	Length	Source	Notes
1	TCD ID	Char	10	TL_TCD_TBL	Identifies which clock gets this information.
2	Time Reporting Code	Char	5	TL_TRC_TBL	Identifier.
3	Description	Char	30	TL_TRC_TBL	Description.
4	TRC Type	Char	1	TL_TRC_TBL	Amount, Hours, or Units
5	Unit of Measure	Char	3	TL_TRC_TBL	Unit of Measure for TRC Type Units

The interface process only extracts TRCs with the Send To TCD field = Y. The default for this field is N. Ensure that you set this field to Y when the TRC is to be sent to the TCD. This indicator has been added to the TL_TRC_TBL to avoid sending extraneous TRCs to TCDs.
The TCD system may need to convert character codes to numeric codes before using them.
The data in this table is derived from the TRC Program attached to the TCD.

TCD Supervisor

This data structure contains a list of supervisors who are authorized to perform supervisor functions at various TCDs. Each TCD Group can be associated to one or more TCD supervisors. A TCD supervisor may be associated with many TCD Groups.

The TCD Interface process assigns supervisors to TCDs. The vendor does not need to derive this relationship.

#	Data Element	Type	Length	Source	Notes
1	TCD ID	Char	10	TL_TCDGPTCD_TBL	Identifies which clock gets this information.
2	Supervisor ID	Char	11	TL_TCD_SUPERV	Identifier.
3	Badge ID	Char	20	BADGE_TABLE	Identifier.
4	Supervisor PIN #	Num	20	TL_TCD_SUPERV	PIN for supervisor.

TCD Task Profile

This data structure contains a list of Task Profiles associated with each TCD. Task Profiles contain task and cost allocation data used in the Labor Distribution process in Time and Labor. The system requires Task Profiles for positive task profile reporting. Positive task profile reporting in Time and Labor means the time reporter must indicate the type of task being performed. For example, Time reporter 111111 is assigned to TCD AAAAA. The valid Task Profiles for TCD AAAAA include Packaging, Shipping, Receiving, and Cleaning. Time reporter 11111 selects one of the Task Profiles by pressing a function key at the TCD to indicate the task being performed.

Unlike positive task profile reporting, default task profile reporting refers to time reporters who routinely perform the same tasks and their cost allocation information remains unchanged. A time reporter swipes the badge when starting and stopping work. The TCD system does not need any task information from Time and Labor for these time reporters. Cost allocation data defined on the default Task Profile in Time and Labor is used to allocate costs accordingly.

#	Data Element	Type	Length	Source	Notes
1	TCD ID	Char	10	TL_TCD_TASKGRP	Identifier.
2	Task Profile ID	Char	10	TL_TASKGRP_TBL	Identifier.
3	Task Profile Description	Char	30	TL_TSKPRF_TBL	Identifier.

The TCD Task Profile table is derived from the following Time and Labor tables:

TCD Taskgroup − contains a list of Taskgroups associated with each TCD.
Taskgroup Profile − contains a list of task profiles associated with each Taskgroup.
Task Profile − contains task profile definitions. Time and Labor selects only records with SEND_TO_TCD = Y.

TCD Task Template

This data structure contains a list of Task Templates associated with each TCD. Task Templates are required for positive task element reporting. Positive task element reporting requires the time reporter to enter a value for each task element on the Task Template. For example, Time reporter 111111 is assigned to TCD AAAAA. The valid Task Templates for TCD AAAAA include Packaging, Shipping, Receiving, and Cleaning. The Packaging task template includes the following task elements: Customer and Account Code. Time reporter 11111 selects one of the Task Templates by pressing a function key at the TCD to indicate the task being performed. Additionally, the time reporter is required to enter the value for Customer and Account Code when prompted.

This data structure also contains a list of Rule Elements associated with each TCD. Rule Elements are needed in cases where the type of work or the job the time reporter performs influences their pay. Rule Element reporting requires the time reporter to enter a value for each Rule Element. As far as the TCD is concerned, Rule Elements are just another form of Task Elements.

This type of reporting is more complex and requires a few tables to be sent to the TCD system. If data validation is required, PeopleSoft provides all the valid values for certain task elements.

The following tables are sent to the TCDs for positive task element reporting:

#	Data Element	Type	Length	Source	Notes
1	TCD ID	Char	10	TL_TCD_TASKGRP _TBL	Identifier.
2	Task Template ID	Char	10	TL_TASKGRP_TBL	Identifier.
3	Task Template Description	Char	30	TL_TSKPRF_TMPLT	Identifier.

The TCD Task Template table is derived from the following Time and Labor tables:

TCD Taskgroup− contains a list of Taskgroups associated with each TCD.
Taskgroup − contains a task template ID associated with each Taskgroup.
Task Template − contains header information for task templates.

If template reporting is used, but the TCD vendor/customer does not present a list of templates to select from, a default template is sent for each time reporter in the Time Reporter message. This default enables automatic prompt for task elements based on the time reporter at the TCD.

Task Template Detail

#	Data Element	Type	Length	Source	Notes
1	Task Template ID	Char	10	TL_TSKPRF_TMPLT	Identifier.
2	Task Element Code	Char	3	TL_TSKPRF_TMPLT	Identifier.
3	Task Element Description	Char	30	TL_TASKELE_TBL	Description.
4	Required	Char	1	TL_TSKPRF_TMPLT	Is this element required or optional.

The Task Template Detail Table contains all the valid Task Element Codes associated with each Task Template. It is derived from the following Time and Labor tables:

Task Template Element − contains task element codes associated with a Task Template.
Task Element − contains task element codes and associated field names.
PSDBFIELD (PeopleTools table) − contains field names and associated descriptions.

If the time reporter has to report Rule Elements, Time and Labor adds the Rule Element list to the end of each template. The Rule Element codes are RE1, RE2, RE3, RE4, and RE5. The Time and Labor system does not allow Task Element Codes with these values. The Required field is always Y.

Task Element Code Value

#	Data Element	Type	Length	Source	Notes
1	Task Element Code	Char	3	TL_TASK_ELE_TBL	Identifier.
2	Task Element Value	Char	25	A Prompt Table	Description.
3	Task Element Value Source	Char	2	(TL/PC)	Because PROJECT values and ACTIVITY values can come from two different places, the Source field will be filled in only for those Task Element Codes.

The Task Element Code Value Table contains all the valid values associated with each Task Element Code. It is derived from the following Time and Labor tables:

Task Template Element − contains task element codes associated with a Task Template.
Task Element − contains task element codes and associated field names.
PSRECFIELD (PeopleTools table) − contains record names, field names, prompt table names and other edit information. Time and Labor uses rows where the record name is TL_TSK_ELMT_WRK (the name of the task derived work record)

This table also contains all the valid values associated with each Rule Element Code.

This table can be quite large. Ensure that the TCD system can process such a large volume of data.

Reporting Element Tables

Sometimes the Time Reporter has to supply information on the location tax purposes. The time reporter or the supervisor may also have to enter override rate information. The following tables contain values for this information.

Country Table

This table is used for positive reporting of a country other than the reporter's default.

#	Data Element	Type	Length	Source	Notes
1	Country Code	Char	3	COUNTRY_TBL	Identifier.
2	Descr	Char	30	COUNTRY_TBL	Description.

State Table

This table is used for positive reporting of a state other than the reporter's default.

#	Data Element	Type	Length	Source	Notes
1	State Code	Char	6	STATE_NAMES_TBL	Identifier.
2	Descr	Char	30	STATE_NAMES_TBL	Description.

Locality Table

This table is used for positive reporting of a locality other than the reporter's default.

#	Data Element	Type	Length	Source	Notes
1	Locality ID	Char	10	LOCAL_TAX_TBL	Identifier.
2	Descr	Char	30	LOCAL_TAX_TBL	Description.

Rate Code Table

This table is used for positive reporting of a comp rate code in conjunction with a Time Reporting Code to specify a different compensation rate. This is used for elapsed time reporting only. Either this or the override rate is entered to adjust a reporter's compensation.

#	Data Element	Type	Length	Source	Notes
1	Rate Code	Char	6	COMP_RT_REG_VW	Identifier.
2	Descr	Char	30	COMP_RT_REG_VW	Description.

Currency Code Table

This table is used for positive reporting of a conjunction with a Time Reporting Code, Rate Code, or Override Rate to specify a currency different from the default. This is used for elapsed time reporting only.

#	Data Element	Type	Length	Source	Notes
1	Currency Code	Char	3	CURRENCY_CD_TBL	Identifier.
2	Descr	Char	30	CURRENCY_CD_TBL	Description.

Override Reason Code Table

This table is used in conjunction with a supervisor overriding a punch. This is used for punch time reporting only.

#	Data Element	Type	Length	Source	Notes
1	Override Reason Code	Char	5	TL_OVRD_RSN_TBL	Identifier.
2	Descr	Char	30	TL_OVRD_RSN_TBL	Description.