SCC_POISDT_PVW

(SQL View)
Index Back

Batch Publish PER_POI_SCR_DT

View to support batch publish of Batch Publish PER_POI_SCR_DT, typically for message PERS_POI_SYNC.

SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.POI_TYPE , %DateOut(B.EFFDT) , A.AUDIT_ACTN FROM PS_SCC_PER_POI_STG A , PS_PER_POI_SCR_DT B WHERE A.AUDIT_ACTN IN ('C', 'A') AND B.EMPLID = A.EMPLID AND B.POI_TYPE = A.POI_TYPE AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_PER_POI_SCR_DT B2 WHERE B2.EMPLID = B.EMPLID AND B2.POI_TYPE = B.POI_TYPE AND B2.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCC_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequence ID
3 SCC_SEQ_ID3 Number(3,0) SMALLINT NOT NULL Sequence Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
6 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

7 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values