HRS_POST_LST (SQL View)	Index Back
Job Board Transaction View Collects the last job board transaction information from REQ_JOBOARD_LOG.

HRS_POST_LST

(SQL View)

Job Board Transaction View

Collects the last job board transaction information from REQ_JOBOARD_LOG.

SELECT A.HRS_JOB_OPENING_ID , A.TRANSACTION_CD , A.ACTIONDTTM , A.ASSOCIATED_COST FROM PS_HRS_POST_LOG A WHERE A.ACTIONDTTM = ( SELECT MAX(B.ACTIONDTTM) FROM PS_HRS_POST_LOG B WHERE A.MERCHANTID = B.MERCHANTID AND A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID) AND A.MERCHANTID = 'RECRUITUSA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

2 TRANSACTION_CD Character(2) VARCHAR2(2) NOT NULL Action code for posting requisitions to internet
A=Add
D=Delete
P=Pending
U=Update

3 ACTIONDTTM DateTime(26) TIMESTAMP Datetime action was taken on a worklist

4 ASSOCIATED_COST Signed Number(10,2) DECIMAL(8,2) NOT NULL Associated cost of posting requisition to internet.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
2	TRANSACTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Action code for posting requisitions to internet A=Add D=Delete P=Pending U=Update
3	ACTIONDTTM	DateTime(26)	TIMESTAMP	Datetime action was taken on a worklist
4	ASSOCIATED_COST	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Associated cost of posting requisition to internet.