HR_TERMINT_PH_V

(SQL View)
 Index Back

HTML Email - EE Termination

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

SELECT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , PH.EMPLOYEE_PHOTO , A.ACTION , A.ACTION_REASON_SS , WF.ACTION_DESCR , WF1.DESCR , EMP.NAME , REQ.NAME , REQ.NAME , %Sql(HR_HT_EMAIL_DATE,A.ACTION_DT_SS ) , CAST(STA.COMMENTS AS VARCHAR(4000)) , 'X' FROM ps_hr_term_dat A , PS_PERSON_NAME EMP , PS_PERSON_NAME REQ , PSOPRDEFN OPR , PS_HR_TERM_STA STA , PS_ACTION_TBL_VW WF , PS_ACTN_REASON_VW WF1 , %Table(USER_PH_LIST_FL) PH 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 AND PH.EMPLID = A.EMPLID

# 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 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph
6 ACTION Character(3) VARCHAR2(3) NOT NULL Action
7 ACTION_REASON_SS Character(3) VARCHAR2(3) NOT NULL Action Reason field for use on Self Service panels.
8 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
9 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
10 EMPLNAME Character(50) VARCHAR2(50) NOT NULL EmplName
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 REQUESTOR Character(30) VARCHAR2(30) NOT NULL REQUESTOR
13 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
14 COMMENTS Long Character CLOB Comment
15 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.