PF DME Query Related Tables

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
cBreeze
Basic Member
Posts: 20
Basic Member

    I can't seem to pull in the Dept description, PaPosition and Supervisor  fields in my query.

    I am looking to get a PA52 'Term' Action from Persaction, Get the dept name from department and Supervisor from Paposition and include the supervisor name in an email.

    I get fields from related table "Employee", but not from the other related tables

    Any suggestion as to what I am doing wrong, is greatly appreciated,

    Thanks,

    Curt

    PROD=DEV&FILE=PERSACTION&FIELD=COMPANY;ACTION-TYPE;EFFECT-DATE;ACTION-CODE;EMPLOYEE;ACTION-NBR;DEPARTMENT;SUPERVISOR;NEW-VALUE;POSITION;EMPLOYEE.DEPARTMENT;EMPLOYEE.FIRST-NAME;EMPLOYEE.LAST-NAME;EMPLOYEE.POSITION;EMPLOYEE.SCHEDULE;DEPARTMENT.NAME;POSITION.POSITION;POSITION.SUPERVISOR;SUPERVISOR.CODE;SUPERVISOR.DESCRIPTION;SUPERVISOR.EMPLOYEE;SUPERVISOR.FULL-NAME&OUT=CSV&DELIM=~

     

    COMPANY~ACTION-TYPE~EFFECT-DATE~ACTION-CODE~EMPLOYEE~ACTION-NBR~DEPARTMENT~SUPERVISOR~NEW-VALUE_1~NEW-VALUE_2~NEW-VALUE_3~NEW-VALUE_4~NEW-VALUE_5~NEW-VALUE_6~NEW-VALUE_7~NEW-VALUE_8~NEW-VALUE_9~NEW-VALUE_10~NEW-VALUE_11~NEW-VALUE_12~NEW-VALUE_13~NEW-VALUE_14~NEW-VALUE_15~NEW-VALUE_16~NEW-VALUE_17~NEW-VALUE_18~NEW-VALUE_19~NEW-VALUE_20~NEW-VALUE_21~NEW-VALUE_22~NEW-VALUE_23~NEW-VALUE_24~NEW-VALUE_25~NEW-VALUE_26~NEW-VALUE_27~NEW-VALUE_28~NEW-VALUE_29~NEW-VALUE_30~NEW-VALUE_31~NEW-VALUE_32~NEW-VALUE_33~NEW-VALUE_34~NEW-VALUE_35~NEW-VALUE_36~POSITION~EMPLOYEE.DEPARTMENT~EMPLOYEE.FIRST-NAME~EMPLOYEE.LAST-NAME~EMPLOYEE.POSITION~EMPLOYEE.SCHEDULE~DEPARTMENT.NAME~POSITION.POSITION~POSITION.SUPERVISOR~SUPERVISOR.CODE~SUPERVISOR.DESCRIPTION~SUPERVISOR.EMPLOYEE~SUPERVISOR.FULL-NAME

    1~E~09/30/2010~MGRTERM~488461~1~~~22~ 20100930~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~8505~EMP1~TERMTEST1~2203850500~N-EXEMPT~~~~~~~

     

    cBreeze
    Basic Member
    Posts: 20
    Basic Member

      ariables in Process : DesignerTest Workunit : 116, ActivityType=ASSGN, ActivityName=Assign6980, ActivityId=ASSGN6 Date:10/07/2010 Time:10:17:28

      FirstName(Type=String) = EMP1

      LastName(Type=String) = TERMTEST1

      PCT_EMPLOYEE(Type=String) = 488461

      PCT_COMPANY(Type=String) = 1

      PCT_ACTION_CODE(Type=String) = MGRTERM

      PCT_EFFECT_DATE(Type=String) = 09/30/2010

      Emp_Department(Type=String) = 8505

      Emp_Position(Type=String) = 2203850500

      POS_Description(Type=String) = null

      Emp_Schedule(Type=String) = N-EXEMPT

      Emp_Supervisor(Type=String) = 8300860002

      HSU_Description(Type=String) =

      HSU_Employee(Type=String) =

      HSU_Full_Name(Type=String) =

      PCT_New_Value_01(Type=String) = 22