GP_ABSLVDN_I_VW (SQL View)	Index Back
Leave Donation Hist Inquiry Self Service Leave Donation History

GP_ABSLVDN_I_VW

(SQL View)

Leave Donation Hist Inquiry

Self Service Leave Donation 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 , HDR.WF_STATUS , HDR.ACTION_DT_SS , HDR.LVDN_TRANS_STATUS , HDR.LASTUPDDTTM , HDR.LASTUPDOPRID FROM PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDN_DTL DTL 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

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

9 ACTION_DT_SS Date(10) DATE Termination Date

10 LVDN_TRANS_STATUS Character(1) VARCHAR2(1) NOT NULL Leave Donation Transaction Status
P=Processed
R=Recurring
U=Unprocessed

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

#	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	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
9	ACTION_DT_SS	Date(10)	DATE	Termination Date
10	LVDN_TRANS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Leave Donation Transaction Status P=Processed R=Recurring U=Unprocessed
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	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.