HR_OBD_INST_VW (SQL View)	Index Back
OBD Template Instances OnBoarding template instances

HR_OBD_INST_VW

(SQL View)

OBD Template Instances

OnBoarding template instances

SELECT A.EMPLID , A.EMPL_RCD , A.AGC_LIST_ID , B.PTAI_LIST_ID , B.PTAI_LIST_STATUS , B.PTAI_LABEL , B.LAST_UPDATE_DTTM , B.LASTUPDOPRID 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)

# 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 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id
Prompt Table: HR_OBD_TMPL_VW3

4 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID

5 PTAI_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL Status
CA=Cancelled
CP=Complete
IP=In Progress

6 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Date

8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	AGC_LIST_ID	Character(31)	VARCHAR2(31) NOT NULL	Activity Guide Composer List Id Prompt Table: HR_OBD_TMPL_VW3
4	PTAI_LIST_ID	Character(31)	VARCHAR2(31) NOT NULL	Action Items - Action Item List ID
5	PTAI_LIST_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Status CA=Cancelled CP=Complete IP=In Progress
6	PTAI_LABEL	Character(100)	VARCHAR2(100) NOT NULL	Action Items - Label
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %Date
8	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.