SFA_EA_TRANS_NBRSFA_EA_SEQNOSFA_EA_DISB_SEQNOPrompt Table: STDNT_FA_TRM_V3
Y/N Table Edit
SFA_EASTAGE_DSB(SQL Table) |
Index Back |
|---|---|
EA Staging - Disbursement InfoUsed for disbursement detail n Financial Aid External Award staging. |
| # | 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 | SFA_EA_DISB_SEQNO |
Number(2,0) | SMALLINT NOT NULL | External award disbursement sequence. |
| 4 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: STDNT_FA_TRM_V3 |
| 5 | DISBURSEMENT_ID | Character(2) | VARCHAR2(2) NOT NULL | Disbursement ID |
| 6 | SCHEDULED_AWARD | Number(12,2) | DECIMAL(11,2) NOT NULL | Scheduled Award |
| 7 | DISBURSED_AMOUNT | Number(12,2) | DECIMAL(11,2) NOT NULL | Disbursed Amount |
| 8 | SFA_EA_PAY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
External award paid out (Y/N).
Y/N Table Edit |