GP_ABSLVDN_T_VW

(SQL View)
 Index Back

Leave Donation Transac Inquiry

Leave Donation Transaction History

SELECT HDR.TRANSACTION_NBR , HDR.EMPLID , HDR.EMPL_RCD , HDR.LVDN_PRGM_ID , HDR.LVDN_REQUEST_TYPE , DTL.LVDN_PIN_NUM , DTL.LVDN_UNITS , DTL.RECIPIENT_EMPLID , DTL.RECIPIENT_EMPL_RCD , HDR.WF_STATUS , HDR.ACTION_DT_SS , HDR.COUNTRY2 , HDR.LVDN_TRANS_STATUS , HDR.TERMINATION_DT , HDR.LVDN_PROCESS_DT , DTL.GP_PAYGROUP , DTL.CAL_ID , HDR.LASTUPDDTTM , HDR.LASTUPDOPRID , PER.NAME , JOB.JOBTITLE FROM PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDN_DTL DTL , PS_PERSON_NAME PER , PS_GP_ABS_EEJOB_VW JOB WHERE HDR.TRANSACTION_NBR = DTL.TRANSACTION_NBR AND HDR.EMPLID = DTL.EMPLID AND HDR.EMPL_RCD = DTL.EMPL_RCD AND HDR.LVDN_PRGM_ID = DTL.LVDN_PRGM_ID AND HDR.LVDN_REQUEST_TYPE = DTL.LVDN_REQUEST_TYPE AND HDR.EMPLID = PER.EMPLID AND HDR.EMPLID = JOB.EMPLID AND HDR.EMPL_RCD = JOB.EMPL_RCD

# 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

Prompt Table: EMPLMT_SRCH_GBL

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLMT_SRCH_GBL

4 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program
5 LVDN_REQUEST_TYPE Character(3) VARCHAR2(3) NOT NULL Leave Donation Request Type
ADJ=Adjust
DON=Donate
RCV=Receive
RET=Return
TER=Terminate
6 LVDN_PIN_NUM Number(8,0) INTEGER NOT NULL Leave Donation Target Entitlement

Prompt Table: GP_PIN_AE0_VW

7 LVDN_UNITS Signed Number(8,2) DECIMAL(6,2) NOT NULL Leave Donation Request Units
8 RECIPIENT_EMPLID Character(11) VARCHAR2(11) NOT NULL Leave Donation Recipient Emplid

Prompt Table: %EDITTABLE

9 RECIPIENT_EMPL_RCD Number(3,0) SMALLINT NOT NULL Recipient Nbr
10 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
11 ACTION_DT_SS Date(10) DATE Termination Date
12 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
13 LVDN_TRANS_STATUS Character(1) VARCHAR2(1) NOT NULL Leave Donation Transaction Status
P=Processed
R=Recurring
U=Unprocessed
14 TERMINATION_DT Date(10) DATE Termination Date
15 LVDN_PROCESS_DT Date(10) DATE Process Date
16 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
17 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
18 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

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20 NAME Character(50) VARCHAR2(50) NOT NULL Name
21 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title