EX_INACT_EE5_VW (SQL View)	Index Back
Inactive employee transactions Used in EX WorkCenter

EX_INACT_EE5_VW

(SQL View)

Inactive employee transactions

Used in EX WorkCenter

SELECT A.TIME_SHEET_ID ,B.EMPL_STATUS , A.EMPLID , A.TIME_SHEET_STATUS , A.CREATION_DT , A.OPRID_LAST_UPDT , A.LASTUPDDTTM , A.VERSION_LBL ,A.VERSION_NUM , A.DTL_TOTAL , A.POL_TOTAL , A.PERIOD_END_DT FROM PS_EX_TIME_HDR A , PS_JOB B WHERE A.TIME_SHEET_STATUS NOT IN ('APR', 'DEN', 'DNA', 'DNU') AND A.EMPLID = B.EMPLID AND B.EMPL_STATUS IN ('D','I','R', 'Q','X', 'S','T','U','V')

# 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 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

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

4 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

5 CREATION_DT Date(10) DATE Creation Date

6 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime

8 VERSION_LBL Character(1) VARCHAR2(1) NOT NULL Used to show version in search pages
O=Original Version
P=Partial Submit
R=Revision

9 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

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 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.

#	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	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
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
4	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
5	CREATION_DT	Date(10)	DATE	Creation Date
6	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
8	VERSION_LBL	Character(1)	VARCHAR2(1) NOT NULL	Used to show version in search pages O=Original Version P=Partial Submit R=Revision
9	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
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	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.