SCC_PERDFPS_STG

(SQL Table)

# 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

#	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