HR_MGR_EMPL_VW

(SQL View)
 Index Back

HTML Email - Reporting Chg

Contains information for the HR Reporting Change transaction for HTML Email.

SELECT A.TRANSACTION_NBR ,A.ACTION_DT_SS , A.ACTION , A.ACTION_REASON , A.WF_STATUS , A.HR_REPCHNG_REASON , A.SUPERVISOR_ID , A.REPORTS_TO , A.APPROVAL_REQUIRED , B.NAME , D.NAME_DISPLAY , %Sql(HR_HT_EMAIL_DATE,A.ACTION_DT_SS) , WF.XLATLONGNAME ,STA.COMMENTS ,'X' FROM PS_HR_MGR_REP_DAT A ,PS_HR_MGR_REP_STA STA , PS_PERSON_NAME B , PS_HR_REP_TRANS_DV D , PS_HR_XLAT_EFF_VW WF WHERE B.EMPLID = A.SUPERVISOR_ID AND D.TRANSACTION_NBR = A.TRANSACTION_NBR AND WF.FIELDNAME = 'WF_STATUS' AND WF.FIELDVALUE = A.WF_STATUS AND A.TRANSACTION_NBR = STA.TRANSACTION_NBR AND STA.SEQNO=1

  • Related Language Record: HR_MGR_EMPLLVW

    • # 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 ACTION_DT_SS Date(10) DATE Termination Date
    3 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Default Value: DTA

    Prompt Table: ACTION_TBL

    4 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    5 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
    6 HR_REPCHNG_REASON Character(3) VARCHAR2(3) NOT NULL Action / Reason
    DTA=Reporting Change

    Default Value: DTA

    7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: HR_ACTIVE_DVW

    8 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA

    9 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
    N=No Approval Required
    Y=Approval Required
    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    12 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    13 DESCR Character(30) VARCHAR2(30) 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.