TL_MASS_TMP (SQL Table)	Index Back
T&L Mass Time Reporters Each TL_MASS_SESSION will have one or more TL_MASS_TRs (Mass Time Reporters). This entity exists to identify the Time Reporter(s) to be processed as part of this Session when submitted.

TL_MASS_TMP

(SQL Table)

T&L Mass Time Reporters

Each TL_MASS_SESSION will have one or more TL_MASS_TRs (Mass Time Reporters). This entity exists to identify the Time Reporter(s) to be processed as part of this Session when submitted.

Parent record: TL_MASS_SESSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: TL_ADM_NAME_VW

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: TL_ADM_EERCD_VW

4 BEGIN_DT Date(10) DATE Begin Date

5 END_DT Date(10) DATE end date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_ADM_NAME_VW
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: TL_ADM_EERCD_VW
4	BEGIN_DT	Date(10)	DATE	Begin Date
5	END_DT	Date(10)	DATE	end date