HR_RETIREDAT_VW

(SQL View)
 Index Back

HTML Email - EE Termination

Contains HTML Email Approval new information for the HR Request Termination transaction.

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , A.ACTION , A.ACTION_REASON_SS , WF.ACTION_DESCR , WF1.DESCR , EMP.NAME , REQ.NAME , %Sql(HR_HT_EMAIL_DATE,A.ACTION_DT_SS ) , CAST(STA.COMMENTS AS VARCHAR(4000)) , 'X' FROM PS_HR_RETIRE_DAT A , PS_PERSON_NAME EMP , PS_PERSON_NAME REQ , PSOPRDEFN OPR , PS_HR_RETIRE_STA STA , PS_ACTION_TBL_VW WF , PS_ACTN_REASON_VW WF1 WHERE A.EMPLID = EMP.EMPLID AND A.ORIGINATORID = OPR.OPRID AND OPR.EMPLID =REQ.EMPLID 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 WF.ACTION = A.ACTION AND WF1.ACTION = A.ACTION AND WF1.ACTION_REASON = A.ACTION_REASON_SS

# 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 Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 ACTION Character(3) VARCHAR2(3) NOT NULL Action
6 ACTION_REASON_SS Character(3) VARCHAR2(3) NOT NULL Action Reason field for use on Self Service panels.
7 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
9 EMPLNAME Character(50) VARCHAR2(50) NOT NULL EmplName
10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
11 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
12 COMMENTS Long Character CLOB Comment
13 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.