SFA_EA_LOAD_DSB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	SFA_EA_TRANS_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Transaction number used for staging external awards to the database.
5	SFA_EA_SEQNO	Number(5,0)	INTEGER NOT NULL	Unique sequence for EA transactions.
6	DISBURSEMENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Disbursement ID
7	SFA_EA_DISB_SEQNO	Number(2,0)	SMALLINT NOT NULL	External award disbursement sequence.
8	SCHEDULED_AWARD	Number(12,2)	DECIMAL(11,2) NOT NULL	Scheduled Award
9	OFFER_BALANCE	Number(12,2)	DECIMAL(11,2) NOT NULL	Offer Balance
10	ACCEPT_BALANCE	Number(12,2)	DECIMAL(11,2) NOT NULL	Accept Balance
11	AUTHORIZED_BALANCE	Number(12,2)	DECIMAL(11,2) NOT NULL	Authorized Balance
12	DISBURSED_BALANCE	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Disbursed Balance
13	NET_DISB_BALANCE	Number(12,2)	DECIMAL(11,2) NOT NULL	Net Disb Balance
14	SFA_AGGR_BALANCE	Number(12,2)	DECIMAL(11,2) NOT NULL	FA-Aggregates: Aggregate Balance
15	DISBURSED_AMOUNT	Number(12,2)	DECIMAL(11,2) NOT NULL	Disbursed Amount
16	SFA_EA_PAY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	External award paid out (Y/N). Y/N Table Edit
17	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
19	AGGREGATE_AREA	Character(10)	VARCHAR2(10) NOT NULL	Aggregate Area
20	AGGREGATE_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Aggregate Level
21	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code