HGA_LVDN_AWJ_VW (SQL View)	Index Back
JOB in Fl Approval JOB in Fl Approval

HGA_LVDN_AWJ_VW

(SQL View)

JOB in Fl Approval

SELECT HDR.TRANSACTION_NBR , HDR.LVDN_PRGM_ID , HDR.LVDN_REQUEST_TYPE , C.DESCR FROM PS_GP_ABS_LVDN_HDR HDR , PS_JOB JOB , PS_JOBCODE_TBL C WHERE JOB.EMPLID = HDR.EMPLID AND JOB.EMPL_RCD = HDR.EMPL_RCD AND JOB.SETID_JOBCODE = C.SETID AND JOB.JOBCODE = C.JOBCODE AND C.EFF_STATUS = 'A' AND %EffdtCheck(JOBCODE_TBL, C, %CurrentDateIn) AND JOB.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOB JOB2 WHERE JOB.EMPLID=JOB2.EMPLID AND JOB.EMPL_RCD=JOB2.EMPL_RCD AND JOB2.EFFDT<=%CurrentDateIn) AND JOB.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = JOB.EMPLID AND EMPL_RCD = JOB.EMPL_RCD AND EFFDT = JOB.EFFDT)

# 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 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description

#	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	JOB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Description