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

HGA_JOB_VW

(SQL View)

JOB in Fl Approval

SELECT DAT.TRANSACTION_NBR , DAT.EMPLID , DAT.EMPL_RCD , DAT.BGN_DT , DAT.PIN_TAKE_NUM , DAT.END_DT , C.DESCR FROM PS_GP_ABS_SS_DAT DAT , PS_JOB JOB , PS_JOBCODE_TBL C WHERE JOB.EMPLID = DAT.EMPLID AND JOB.EMPL_RCD = DAT.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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 BGN_DT Date(10) DATE NOT NULL Begin Date

5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

6 END_DT Date(10) DATE NOT NULL end date

7 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
6	END_DT	Date(10)	DATE NOT NULL	end date
7	JOB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Description