GP_ABSLVDN_H_VW

(SQL View)
 Index Back

Leave Donation Approval

Abs Mgmt Leave Donation Approval

SELECT HDR.TRANSACTION_NBR , HDR.EMPLID , HDR.EMPL_RCD , HDR.ACTION_DT_SS , HDR.LVDN_PRGM_ID , 0 , HDR.PRG_LVDN_UNITS , HDR.LVDN_REQUEST_TYPE , HDR.WF_STATUS , HDR.LVDN_TRANS_STATUS , PERSON.NAME , EEJOB.JOBTITLE , ST.EOAWSTEP_STATUS , ST.OPRID FROM PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDNXREF XREF , PS_EOAW_STEP_VW ST , PS_GP_ABS_EEJOB_VW EEJOB , PS_PERSON_NAME PERSON WHERE XREF.EOAWTHREAD_ID = ST.EOAWTHREAD_ID AND XREF.EOAWPRCS_ID = ST.EOAWPRCS_ID AND HDR.TRANSACTION_NBR = XREF.TRANSACTION_NBR AND HDR.EMPLID = PERSON.EMPLID AND HDR.EMPLID = EEJOB.EMPLID AND HDR.EMPL_RCD = EEJOB.EMPL_RCD AND XREF.EOAWPARENT_THREAD = ( SELECT MAX(XREF2.EOAWPARENT_THREAD) FROM PS_GP_ABS_LVDNXREF XREF2 WHERE XREF.TRANSACTION_NBR = XREF2.TRANSACTION_NBR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 ACTION_DT_SS Date(10) DATE Termination Date
5 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program
6 CURR_AVAILABLE_BAL Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Program Maximum Hours
7 PRG_LVDN_UNITS Signed Number(8,2) DECIMAL(6,2) NOT NULL Leave Donation Program Adjustment Units
8 LVDN_REQUEST_TYPE Character(3) VARCHAR2(3) NOT NULL Leave Donation Request Type
ADJ=Adjust
DON=Donate
RCV=Receive
RET=Return
TER=Terminate
9 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
10 LVDN_TRANS_STATUS Character(1) VARCHAR2(1) NOT NULL Leave Donation Transaction Status
P=Processed
R=Recurring
U=Unprocessed
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
13 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).