HR_REP_TRANS_VW

(SQL View)
 Index Back

Reporting Chg Transaction Data

Reporting change information for Selected Employee used in HTML Email.

SELECT A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.JOB_DESCR_SS , A.POSITION_FLAG , A.ORIGINATORID , B.NAME , C.NAME_DISPLAY FROM PS_HR_REPORT_TRANS A , PS_PERSON_NAME B , PS_PERSON_NAME C WHERE B.EMPLID = A.EMPLID AND C.EMPLID = ( SELECT EMPLID FROM PSOPRDEFN WHERE OPRID = A.ORIGINATORID)

  • Parent record: HR_MGR_REP_DAT

    • # 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 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
    5 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    6 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country