TL_EMPL_DAT_STG (SQL Table)	Index Back
Time Employee Time Profile Staging for job modernization. This table contains a snapshot of basic information about the time reporter. The information will be used as a building block by Time Reporting and as well as almost all other processes in Time and Labor.

TL_EMPL_DAT_STG

(SQL Table)

Time Employee Time Profile

Staging for job modernization. This table contains a snapshot of basic information about the time reporter. The information will be used as a building block by Time Reporting and as well as almost all other processes in Time and Labor.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %Date

4 HCR_ACTN_SEQN Number(3,0) SMALLINT NOT NULL Sequence number

5 TIME_RPTG_STATUS Character(1) VARCHAR2(1) NOT NULL Time Reporter Status
A=Active
I=Inactive
Default Value: A

6 TIME_RPTR_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter
P=Punch Time Reporter
Default Value: E

7 ELP_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Elapsed Reporting Template
Prompt Table: TL_ELP_TMPLT_VW

8 PCH_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Punch Reporting Template
Prompt Table: TL_PCH_TMPLT_VW

9 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
Prompt Table: TL_TR_PRDS_VW

10 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup
Prompt Table: TL_WRKGRP_TBL

11 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
Prompt Table: TL_TASKGRP_TBL

12 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
Prompt Table: TL_TSKGRP_DVW

13 TCD_GROUP_ID Character(10) VARCHAR2(10) NOT NULL TCD Group ID
Prompt Table: TL_TCDGRP_VW

14 RESTRICTION_PRF_ID Character(10) VARCHAR2(10) NOT NULL Restriction Profile ID
Prompt Table: TL_RESPRF_TBL

15 TL_TIME_TO_PAY Character(1) VARCHAR2(1) NOT NULL The field indicates whether the time is to be sent to payroll or not
Y/N Table Edit
Default Value: Y

16 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
Prompt Table: TL_RULE_ELEMNT1

17 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
Prompt Table: TL_RULE_ELEMNT2

18 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
Prompt Table: TL_RULE_ELEMNT3

19 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
Prompt Table: TL_RULE_ELEMNT4

20 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
Prompt Table: TL_RULE_ELEMNT5

21 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Default Value: PSOPTIONS.BSE_TIMEZONE
Prompt Table: PSTIMEZONE

22 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
4	HCR_ACTN_SEQN	Number(3,0)	SMALLINT NOT NULL	Sequence number
5	TIME_RPTG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Time Reporter Status A=Active I=Inactive Default Value: A
6	TIME_RPTR_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time. E=Elapsed Time Reporter P=Punch Time Reporter Default Value: E
7	ELP_TR_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Elapsed Reporting Template Prompt Table: TL_ELP_TMPLT_VW
8	PCH_TR_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Punch Reporting Template Prompt Table: TL_PCH_TMPLT_VW
9	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID Prompt Table: TL_TR_PRDS_VW
10	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup Prompt Table: TL_WRKGRP_TBL
11	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
12	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID Prompt Table: TL_TSKGRP_DVW
13	TCD_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	TCD Group ID Prompt Table: TL_TCDGRP_VW
14	RESTRICTION_PRF_ID	Character(10)	VARCHAR2(10) NOT NULL	Restriction Profile ID Prompt Table: TL_RESPRF_TBL
15	TL_TIME_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	The field indicates whether the time is to be sent to payroll or not Y/N Table Edit Default Value: Y
16	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1 Prompt Table: TL_RULE_ELEMNT1
17	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2 Prompt Table: TL_RULE_ELEMNT2
18	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3 Prompt Table: TL_RULE_ELEMNT3
19	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4 Prompt Table: TL_RULE_ELEMNT4
20	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5 Prompt Table: TL_RULE_ELEMNT5
21	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Default Value: PSOPTIONS.BSE_TIMEZONE Prompt Table: PSTIMEZONE
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance