EX_INACT_EE3_VW

(SQL View)
Index Back

Inactive employee transactions

Used in EX WorkCenter

SELECT A.EMPLID ,B.EMPL_STATUS , A.TRAVEL_AUTH_ID , A.TRAVEL_AUTH_STATUS , A.CURRENCY_CD , A.TOTAL_AMT ,A.TRAVEL_AUTH_NAME ,A.DATE_FROM ,A.DATE_TO ,A.CREATION_DT ,A.LASTUPDDTTM ,A.OPRID_LAST_UPDT FROM PS_EX_TAUTH_HDR A , PS_JOB B WHERE A.TRAVEL_AUTH_STATUS NOT IN ('CLS', '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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

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 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
4 TRAVEL_AUTH_STATUS Character(3) VARCHAR2(3) NOT NULL Describes the current status of the travel authorization - whether pending, submitted or approved. This field is associated with the header record of travel authorizations and is found on many records and panels within travel authorization objects. The status will change depending on the action taken upon the travel authorization. PeopleCode is used to update the status.
APR=Approved
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
PAR=Approvals in Process
PND=Pending
PRO=In Process
RCN=Reconciled
RRT=Transaction Rerouted
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount
7 TRAVEL_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Field used to give a descriptive name to each travel authorization. Associated with the header information of a travel authorization and found on many records and panels within travel authorization objects.
8 DATE_FROM Date(10) DATE Date From
9 DATE_TO Date(10) DATE Date To
10 CREATION_DT Date(10) DATE Creation Date

Default Value: %date

11 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

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