WM_ETM_SRCH_VW (SQL View)	Index Back
WO Time Entry Search WO Time Entry Search

WM_ETM_SRCH_VW

(SQL View)

WO Time Entry Search

SELECT DISTINCT A.EMPLID , C.PERIOD_END_DT , C.VERSION_NUM , C.TIME_SHEET_ID , A.NAME , C.EMPLID AS EMPLID2 , A.EMPL_STATUS , C.TIME_SHEET_STATUS , C.POST_STATUS_EX , C.DTL_TOTAL , C.POL_TOTAL , C.CREATION_DT FROM PS_WM_TE_AUTH_OPR A , PS_OPR_DEF_TBL_WM B , PS_EX_TIME_HDR C WHERE B.OPRID = A.OPRID AND B.TIME_RPTR_METH = 'E' AND B.WM_TIME_SUBMIT = 'Y' AND C.EMPLID = A.EMPLID AND C.EX_ORIGIN = 'A' AND C.POST_STATUS_EX IN ('N','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PERIOD_END_DT Date(10) DATE 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 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Employee ID

7 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
A=Active
D=Deceased
I=Inactive
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

8 TIME_SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Time Sheet Status
ADJ=Adjusted
APR=Approved
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Project Manager
HDA=Hold by Approver
HDU=Hold by Project Manager
HLD=Hold
MFS=Marked for Submit
PAR=Approvals in Process
PND=Pending
PRO=In Process
SFA=Submission in Process
SUB=Submitted for Approval
XML=Submitted, Pending Validation

9 POST_STATUS_EX Character(1) VARCHAR2(1) NOT NULL Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted

10 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total

11 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal

12 CREATION_DT Date(10) DATE Creation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: WM_TE_AUTH_OPR
2	PERIOD_END_DT	Date(10)	DATE	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Employee Status A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
8	TIME_SHEET_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Time Sheet Status ADJ=Adjusted APR=Approved DEN=Denied DNA=Denied by Approver DNU=Denied by Project Manager HDA=Hold by Approver HDU=Hold by Project Manager HLD=Hold MFS=Marked for Submit PAR=Approvals in Process PND=Pending PRO=In Process SFA=Submission in Process SUB=Submitted for Approval XML=Submitted, Pending Validation
9	POST_STATUS_EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses Post Status C=Closed M=Marked for Unpost N=Not Applied O=Unpost In Process P=Posted S=Close In Process U=Unposted
10	DTL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total
11	POL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	PolTotal
12	CREATION_DT	Date(10)	DATE	Creation Date