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~~~~~~~
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
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