HGA_LVDN_AWH_VW

(SQL View)
 Index Back

Leave Donation App Dtl

Leave Donation Detail for fluid approval

SELECT HDR.TRANSACTION_NBR , HDR.LVDN_PRGM_ID , HDR.LVDN_REQUEST_TYPE , HDR.EMPLID , HDR.EMPL_RCD , HDR.LVDN_CONTRIB_TYPE , HDR.PRG_LVDN_UNITS , HDR.WF_STATUS , HDR.ACTION_DT_SS , HDR.BGN_DT , HDR.END_DT , HDR.TERMINATION_DT , HDR.LVDN_REASON , HDR.LVDN_RECURRING_IND , HDR.COMMENTS , HDR.CONFIRM_ACCEPT , HDR.COUNTRY2 , HDR.LVDN_ENTRY_SRC , HDR.LVDN_TRANS_STATUS , HDR.LVDN_PROCESS_DT , HDR.LASTUPDOPRID , HDR.LASTUPDDTTM , PRG.UNIT_TYPE , PRG.LVDN_PRGM_CATEGORY , PRG.LVDN_PRGM_TYPE , PRG.BEGIN_DT , PRG.END_DT , PRG.LVDN_PRGM_MIN , PRG.LVDN_PRGM_MAX , PRG.LVDN_CONTRIB_FREQ , PRG.PYE_CEILING_LIMIT , PRG.PYE_CONTRIB_MIN , PRG.PYE_CONTRIB_MAX , PRG.DESCR FROM PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDN_PRG PRG WHERE HDR.COUNTRY2 = PRG.COUNTRY AND PRG.LVDN_PRGM_ID = HDR.LVDN_PRGM_ID

# 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 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program

Prompt Table: GP_ABS_LVDN_EVW

3 LVDN_REQUEST_TYPE Character(3) VARCHAR2(3) NOT NULL Leave Donation Request Type
ADJ=Adjust
DON=Donate
RCV=Receive
RET=Return
TER=Terminate
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: GP_EMP_SEC_VW

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

Prompt Table: EMPLMT_SRCH_GBL

6 LVDN_CONTRIB_TYPE Character(1) VARCHAR2(1) NOT NULL Leave Donation Contribution Type
B=Recurring or One-Time
O=One-Time
R=Recurring
7 PRG_LVDN_UNITS Signed Number(8,2) DECIMAL(6,2) NOT NULL Leave Donation Program Adjustment 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

Default Value: %Date

10 BGN_DT Date(10) DATE Begin Date
11 END_DT Date(10) DATE end date
12 TERMINATION_DT Date(10) DATE Termination Date
13 LVDN_REASON Character(3) VARCHAR2(3) NOT NULL Leave Donation Reason
10=Waiting Period
20=Short Term Disability
30=Paid Family Leave
40=Other
14 LVDN_RECURRING_IND Character(1) VARCHAR2(1) NOT NULL This indicates a recurring occurrence.
N=No
Y=Yes

Default Value: N

15 COMMENTS Long Character CLOB Comment
16 CONFIRM_ACCEPT Character(1) VARCHAR2(1) NOT NULL Confirm and Accept
N=No
Y=Yes

Y/N Table Edit

17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
18 LVDN_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Leave Donation Entry Source
A=Administrator
E=Employee Self Service
19 LVDN_TRANS_STATUS Character(1) VARCHAR2(1) NOT NULL Leave Donation Transaction Status
P=Processed
R=Recurring
U=Unprocessed
20 LVDN_PROCESS_DT Date(10) DATE Process Date
21 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.
22 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

23 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
24 LVDN_PRGM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Leave Donation Program Category
B=Bank
I=Individual
25 LVDN_PRGM_TYPE Character(1) VARCHAR2(1) NOT NULL Leave Program Type
E=Emergency
V=Voluntary
26 BEGIN_DT Date(10) DATE Begin Date
27 PLAN_END_DT Date(10) DATE Plan End Date
28 LVDN_PRGM_MIN Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Program Minimum Hours
29 LVDN_PRGM_MAX Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Program Maximum Hours
30 LVDN_CONTRIB_FREQ Character(1) VARCHAR2(1) NOT NULL Leave Donation Payee Contribution Frequency
A=Annually
M=Monthly
Q=Quarterly
31 PYE_CEILING_LIMIT Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Payee Contribution Limit for Program
32 PYE_CONTRIB_MIN Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum
33 PYE_CONTRIB_MAX Signed Number(7,2) DECIMAL(5,2) NOT NULL Maximum
34 DESCR Character(30) VARCHAR2(30) NOT NULL Description