EX_TIM2_ADD_VW

(SQL View)
Index Back

Time Report Add View

Time Report Add View - Audit

SELECT DISTINCT a.emplid , a.period_end_dt , a.version_num , a.time_sheet_id 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_VALID2_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

Default Value: 1

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