TIME_SHEET_IDVERSION_NUMEX_INQ5_SRCH_VW(SQL View) |
Index Back |
|---|
| SELECT a.time_sheet_id , a.version_num FROM PS_EX_TIME_HDR a , ps_personal_data b WHERE b.emplid = a.emplid AND a.time_sheet_status <> 'PND' |
| # | 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 |