RD_WRKR_JOB_V (SQL View)	Index Back
Worker Job Details Information Stores the Worker details information. If HRMS is used the maintenance of the Workers job information will be done in HRMS. For Workers not managed by HRMS, the maintenance of their job information will be done here.

RD_WRKR_JOB_V

(SQL View)

Worker Job Details Information

Stores the Worker details information. If HRMS is used the maintenance of the Workers job information will be done in HRMS. For Workers not managed by HRMS, the maintenance of their job information will be done here.

SELECT A.PERSON_ID , A.BO_ID FROM PS_RD_WRKR_JOB A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_RD_WRKR_JOB B WHERE A.PERSON_ID = B.PERSON_ID AND A.BO_ID = B.BO_ID AND EFFDT <= %CurrentDateIn) AND A.EMPL_STATUS = 'A'

Parent record: RD_WRKR_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID