EX_TIM2_ADD_VW(SQL View) |
Index Back |
---|---|
Time Report Add ViewTime 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) |