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

TL_MASS_DATA

(SQL Table)

T&L Mass Time Reported

Each TL_MASS_SESSION will have one or more TL_MASS_TRs. 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 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

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

4 TRC_PROGRAM Character(5) VARCHAR2(5) NOT NULL TRC Program ID

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	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	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	TRC_PROGRAM	Character(5)	VARCHAR2(5) NOT NULL	TRC Program ID
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description