EX_TIME_ADD_VW (SQL View)	Index Back
Time Report Add View Time Report Add View

EX_TIME_ADD_VW

(SQL View)

Time Report Add View

SELECT DISTINCT a.emplid , a.period_end_dt , a.version_num , a.time_sheet_id , a.lastupddttm FROM PS_EX_TIME_HDR a , ps_personal_data b WHERE a.emplid = b.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.

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

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

5 LASTUPDDTTM DateTime(26) TIMESTAMP 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: EX_EE_AUTH_1_VW
2	PERIOD_END_DT	Date(10)	DATE NOT NULL	Represents the date termination point for a given time set utilized in cash worksheet processing.
3	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
4	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP	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.