SCCPU_EADTL_BND (SQL View)	Index Back
EA Staging - Detail Record External Award Staging detail record.

SCCPU_EADTL_BND

(SQL View)

EA Staging - Detail Record

External Award Staging detail record.

SELECT A.SFA_EA_TRANS_NBR , A.SFA_EA_SEQNO , A.EMPLID FROM PS_SFA_EASTAGE_DTL A WHERE A.SFA_EA_PROC_STAT NOT IN ('A', 'P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.

2 SFA_EA_SEQNO Number(5,0) INTEGER NOT NULL Unique sequence for EA transactions.

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: SFA_EA_STU_SRCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFA_EA_TRANS_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Transaction number used for staging external awards to the database.
2	SFA_EA_SEQNO	Number(5,0)	INTEGER NOT NULL	Unique sequence for EA transactions.
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: SFA_EA_STU_SRCH