SCC_PERDFPS_PVW

(SQL View)
Index Back

SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.EFFDT , A.FP_ACTION_2 , A.ACTION_REASON , A.FP_ACTION_REQ , A.FP_SUPDOC_REQ , A.LAST_UPDATE_DATE , A.AUDIT_ACTN FROM PS_SCC_PERDFPS_STG A WHERE A.AUDIT_ACTN IN ('C', 'A')

# 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 EFFDT Date(10) DATE Effective Date
6 FP_ACTION_2 Character(3) VARCHAR2(3) NOT NULL Action after Retroactive Event
7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
8 FP_ACTION_REQ Character(1) VARCHAR2(1) NOT NULL Action ?
N=No
Y=Yes
9 FP_SUPDOC_REQ Character(1) VARCHAR2(1) NOT NULL Supporting Document Required
10 LAST_UPDATE_DATE Date(10) DATE Date of last update
11 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