HR_OBD_STAT_VW

(SQL View)
 Index Back

OBD Status

OnBoarding status

SELECT A.EMPLID , A.EMPL_RCD , B.PTAI_LIST_STATUS , %DatePart(A.LASTUPDDTTM) , %DatePart(B.CREATED_DTTM) FROM PS_HR_OBD_TRIGGER A , PS_PTAI_LIST B , PS_PTAI_CONTEXT C , PS_PTAI_CONTEXT D WHERE B.PTAI_PARENT_TMPL = A.AGC_LIST_ID AND C.PTAI_LIST_ID = B.PTAI_LIST_ID AND C.RECNAME = 'HR_OBD_CONTEXT' AND C.FIELDNAME = 'EMPLID' AND C.PTAI_KEY_VALUE = A.EMPLID AND D.PTAI_LIST_ID = B.PTAI_LIST_ID AND D.RECNAME = 'HR_OBD_CONTEXT' AND D.FIELDNAME = 'EMPL_RCD' AND D.PTAI_KEY_VALUE = %NumToChar(A.EMPL_RCD) UNION SELECT A.EMPLID , A.EMPL_RCD , 'NS' , %DatePart(A.LASTUPDDTTM) , %DateNull FROM PS_HR_OBD_TRIGGER A WHERE NOT EXISTS( SELECT 'X' FROM PS_PTAI_LIST B , PS_PTAI_CONTEXT C , PS_PTAI_CONTEXT D WHERE B.PTAI_PARENT_TMPL = A.AGC_LIST_ID AND C.PTAI_LIST_ID = B.PTAI_LIST_ID AND C.RECNAME = 'HR_OBD_CONTEXT' AND C.FIELDNAME = 'EMPLID' AND C.PTAI_KEY_VALUE = A.EMPLID AND D.PTAI_LIST_ID = B.PTAI_LIST_ID AND D.RECNAME = 'HR_OBD_CONTEXT' AND D.FIELDNAME = 'EMPL_RCD' AND D.PTAI_KEY_VALUE = %NumToChar(A.EMPL_RCD) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 HR_OBD_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL AG Instance status
CA=Cancelled
CP=Complete
IP=In Progress
NS=Not Started
4 HR_OBD_TRG_DT Date(10) DATE OnBoarding trigger creation date
5 HR_OBD_INST_DT Date(10) DATE OnBoarding instance creation date