SFA_EASTAGE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	SCCFP_MAP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Mapping ID - the unique key that identifies the file mapping
7	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
8	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
9	SFA_EA_FILECONTROL	Character(1)	VARCHAR2(1) NOT NULL	External award file integrity control flag.
10	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
11	SFA_EA_TRANS_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Transaction number used for staging external awards to the database.
12	SFA_EA_STDNT_COUNT	Number(5,0)	INTEGER NOT NULL	External award student count as read from file.
13	SFA_EA_AWARD_TOTAL	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	External award amount total read from file.
14	SFA_EA_RSLT_COUNT	Number(5,0)	INTEGER NOT NULL	Actual total transaction count from EA File staging process.
15	SFA_EA_RSLT_TOTAL	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Actual award total from EA File staging process.
16	SFA_EA_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	File status resulting from an EA Staging process. E=Error P=Processed W=Warning
17	SFA_EA_AWRD_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Externa Award load action. B=Offer/Accept O=Offer Default Value: B