TL_TR_STATUS (SQL Table)	Index Back
Time Reporter Status The Time Reporter Status Record maintains information necessary for the accurate execution of Time Administration Rules. There is one Time Reporter Status row for every Time Reporter. On this row, a status indicates whether Time Administration needs to be run for this Time Reporter. In addition, the datetime of last update and the earliest change date since the last Time Administration run are maintained for use by Time Administration processing.

TL_TR_STATUS

(SQL Table)

Time Reporter Status

The Time Reporter Status Record maintains information necessary for the accurate execution of Time Administration Rules. There is one Time Reporter Status row for every Time Reporter. On this row, a status indicates whether Time Administration needs to be run for this Time Reporter. In addition, the datetime of last update and the earliest change date since the last Time Administration run are maintained for use by Time Administration processing.

Parent Record Of TL_TR_STAT_VLD TL_VALID_TR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: TL_EMPL_DATA

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

3 TA_STATUS Character(1) VARCHAR2(1) NOT NULL Time Administration Run Needed
Y/N Table Edit

4 EARLIEST_CHGDT Date(10) DATE Earliest Date of Change

5 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 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 Prompt Table: TL_EMPL_DATA
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	TA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Time Administration Run Needed Y/N Table Edit
4	EARLIEST_CHGDT	Date(10)	DATE	Earliest Date of Change
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP NOT NULL	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance