EX_TIME_HDR_VW2

(SQL View)
Index Back

EX TIME HDR VIEW.

Time report header view for duplication check.

SELECT time_sheet_id ,emplid ,MAX(version_num) AS version_num FROM PS_EX_TIME_HDR WHERE time_sheet_status NOT IN('PND','DEN','DNA','DNU') GROUP BY time_sheet_id,emplid

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

Default Value: 1