EX_EMAILUSER_TR (SQL Table)	Index Back
Email User for Time Reports This table is used to store the list of Approvers that are routed for Email Approvals for Time Reports and Adjustments.

EX_EMAILUSER_TR

(SQL Table)

Email User for Time Reports

This table is used to store the list of Approvers that are routed for Email Approvals for Time Reports and Adjustments.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

3 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
2	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
3	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.