HR_FPTDAT_VW2

(SQL View)
 Index Back

Stage Record for FT/PT Change

Used for 8.3 Workflow Enhancements. Located on Page.HR_MGR_FULL_PART.

SELECT A.EMPLID ,A.EMPL_RCD ,A.ACTION_DT_SS ,A.EFFSEQ ,B.NAME , A.WF_STATUS ,A.ACTION , A.FULL_PART_TIME_NEW ,X.XLATSHORTNAME ,CASE A.FULL_PART_TIME_NEW WHEN 'F' THEN 'P' ELSE 'F' END , XX.XLATLONGNAME , A.ORIGINATORID ,D.Name ,D.Name , C.STD_HOURS ,C.HOURLY_RT , C.ANNUAL_RT ,C.CURRENCY_CD , J.DESCR , ' ' , CAST(STA.COMMENTS AS VARCHAR(4000)) , 'X' FROM PS_HR_FULLPART_DAT A , PS_PERSON_NAME B , PS_CURRENT_JOB C ,PS_PERSON_NAME D , PSOPRDEFN OPR , PSXLATITEM X , PSXLATITEM XX , PS_HR_FULLPART_STA STA , PS_JOBCODE_TBL J WHERE J.SETID = C.SETID_JOBCODE AND J.JOBCODE = C.JOBCODE AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.empl_rcd = C.empl_rcd AND A.EMPLID=STA.EMPLID AND a.empl_rcd = sta.empl_rcd AND a.action_dt_ss = sta.action_dt_ss AND A.EFFSEQ = STA.EFFSEQ AND STA.SEQNO=1 AND OPR.EMPLID=D.EMPLID AND OPR.OPRID=A.ORIGINATORID AND X.FIELDVALUE= A.FULL_PART_TIME_NEW AND X.FIELDNAME='FULL_PART_TIME' AND XX.FIELDNAME='FULL_PART_TIME' AND XX.FIELDVALUE = CASE A.FULL_PART_TIME_NEW WHEN 'F' THEN 'P' ELSE 'F' END AND J.EFFDT = ( SELECT MAX(JJ.EFFDT) FROM PS_JOBCODE_TBL JJ WHERE J.SETID = JJ.SETID AND J.JOBCODE = JJ.JOBCODE AND JJ.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ACTION_DT_SS Date(10) DATE NOT NULL Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 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
7 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Default Value: DTA

Prompt Table: ACTION_TBL

8 FULL_PART_TIME_NEW Character(1) VARCHAR2(1) NOT NULL New Full/Part Time Status
D=On Demand
F=Full-Time
P=Part-Time
9 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
10 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
11 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
12 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
13 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
14 REQUESTOR Character(30) VARCHAR2(30) NOT NULL REQUESTOR
15 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
16 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
17 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
20 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
21 COMMENTS Long Character CLOB Comment
22 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.