SCC_POITRN_PVW (SQL View)	Index Back
Batch Publish PER_POI_TRANS View to support batch publish of Batch Publish PER_POI_TRANS, typically for message PERS_POI_SYNC.

SCC_POITRN_PVW

(SQL View)

Batch Publish PER_POI_TRANS

View to support batch publish of Batch Publish PER_POI_TRANS, 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) , T.EFF_STATUS , T.EXPECTED_END_DATE , T.DESCR254 , A.AUDIT_ACTN FROM PS_SCC_PER_POI_STG A , PS_PER_POI_SCR_DT B , PS_PER_POI_TRANS T 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) AND T.EMPLID = B.EMPLID AND T.POI_TYPE = B.POI_TYPE AND T.EFFDT = B.EFFDT

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

8 EXPECTED_END_DATE Date(10) DATE Expected End Date of a job.

9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

10 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

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
8	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
9	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
10	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