HGA_LVDN_AWD_VW

(SQL View)
 Index Back

Leave Donation Detail Record

Leave Donation Detail Transaction Record used for fluid approvals

SELECT DTL.TRANSACTION_NBR , DTL.LVDN_PRGM_ID , DTL.LVDN_REQUEST_TYPE , DTL.EMPLID , DTL.EMPL_RCD , DTL.SEQNUM , DTL.LVDN_PIN_NUM_ELIG , DTL.LVDN_PIN_NUM , DTL.LVDN_UNITS , DTL.RECIPIENT_TYPE , ' ' , DTL.RECIPIENT_EMPLID , DTL.RECIPIENT_EMPL_RCD , ' ' , DTL.RECIPIENT_OTHER_NM , DTL.RETURNED_FLAG , DTL.CAL_ID , DTL.GP_PAYGROUP , PIN.DESCR , 'Request Type Desc' , 'Status' , 'Units' , HDR.ACTION_DT_SS , '201' , PRG.DESCR , PRG.UNIT_TYPE , 'Units' , PRG.LVDN_PRGM_CATEGORY , 'Category' , PRG.LVDN_PRGM_TYPE , 'Prog Type' , PRG.BEGIN_DT , PRG.END_DT , PRG.LVDN_CONTRIB_TYPE , 'Con Type ' , PRG.LVDN_CONTRIB_FREQ , 'Freq' , PRG.LVDN_PRGM_MIN , PRG.LVDN_PRGM_MAX , PRG.PYE_CEILING_LIMIT , HDR.BGN_DT , HDR.END_DT , HDR.COMMENTS , HDR.LVDN_RECURRING_IND FROM PS_GP_ABS_LVDN_DTL DTL , PS_GP_ABS_LVDN_HDR HDR , PS_GP_ABS_LVDN_PRG PRG , PS_GP_PIN PIN WHERE DTL.TRANSACTION_NBR = HDR.TRANSACTION_NBR AND DTL.LVDN_PRGM_ID = HDR.LVDN_PRGM_ID AND DTL.LVDN_REQUEST_TYPE = HDR. LVDN_REQUEST_TYPE AND PIN.PIN_NUM = DTL.LVDN_PIN_NUM_ELIG AND PRG.COUNTRY = HDR.COUNTRY2 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
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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
7 LVDN_PIN_NUM_ELIG Number(8,0) INTEGER NOT NULL Eligible Entitlement

Prompt Table: GP_ABS_LVDN_DVW

8 LVDN_PIN_NUM Number(8,0) INTEGER NOT NULL Leave Donation Target Entitlement

Prompt Table: GP_ABS_LVDNT1VW

9 LVDN_UNITS Signed Number(8,2) DECIMAL(6,2) NOT NULL Leave Donation Request Units
10 RECIPIENT_TYPE Character(1) VARCHAR2(1) NOT NULL Recipient Type
E=Self
O=Other Employee
11 DESCR10 Character(10) VARCHAR2(10) NOT NULL Description field of length 10
12 RECIPIENT_EMPLID Character(11) VARCHAR2(11) NOT NULL Leave Donation Recipient Emplid

Prompt Table: GP_ABS_LD_ENM_V

13 RECIPIENT_EMPL_RCD Number(3,0) SMALLINT NOT NULL Recipient Nbr
14 DISPLAY_NAME Character(50) VARCHAR2(50) NOT NULL Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created
15 RECIPIENT_OTHER_NM Long Character CLOB Leave Donation Other Recipient

Prompt Table: EMPLMT_SRCH_GBL

16 RETURNED_FLAG Character(1) VARCHAR2(1) NOT NULL Leave Returned Flag

Default Value: N

17 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
18 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
19 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
20 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
21 STATUS_FIELD Character(30) VARCHAR2(30) NOT NULL Payment Status
22 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
23 ACTION_DT_SS Date(10) DATE Termination Date
24 HGA_ABS_CUR_BAL Character(20) VARCHAR2(20) NOT NULL Absence Request Approval Pagelet - Current Balance
25 PLAN_DESCR Character(40) VARCHAR2(40) NOT NULL Plan Description
26 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
27 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
28 LVDN_PRGM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Leave Donation Program Category
B=Bank
I=Individual
29 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
30 LVDN_PRGM_TYPE Character(1) VARCHAR2(1) NOT NULL Leave Program Type
E=Emergency
V=Voluntary
31 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
32 BEGIN_DT Date(10) DATE Begin Date
33 END_DT Date(10) DATE end date
34 LVDN_CONTRIB_TYPE Character(1) VARCHAR2(1) NOT NULL Leave Donation Contribution Type
B=Recurring or One-Time
O=One-Time
R=Recurring
35 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
36 LVDN_CONTRIB_FREQ Character(1) VARCHAR2(1) NOT NULL Leave Donation Payee Contribution Frequency
A=Annually
M=Monthly
Q=Quarterly
37 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
38 LVDN_PRGM_MIN Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Program Minimum Hours
39 LVDN_PRGM_MAX Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Program Maximum Hours
40 PYE_CEILING_LIMIT Signed Number(14,2) DECIMAL(12,2) NOT NULL Leave Donation Payee Contribution Limit for Program
41 BGN_DT Date(10) DATE Begin Date
42 PLAN_END_DT Date(10) DATE Plan End Date
43 COMMENTS Long Character CLOB Comment
44 LVDN_RECURRING_IND Character(1) VARCHAR2(1) NOT NULL This indicates a recurring occurrence.
N=No
Y=Yes