SFA_EA_STATSRCH(SQL View) |
Index Back |
|---|---|
External Awards Status ViewSearch view of external award staging table for the primary purposes of managing data by processing status. |
| SELECT A.INSTITUTION , A.AID_YEAR , A.SFA_EA_PROC_STAT , A.SFA_EA_TRANS_NBR , A.SFA_EA_SEQNO , B.SFA_EA_TRANS_SRCE , B.TRANSACTION_DATE , B.FILENAME FROM PS_SFA_EASTAGE_DTL A , PS_SFA_EASTAGE_HDR B WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR |
| # | 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 | SFA_EA_PROC_STAT |
Character(1) | VARCHAR2(1) NOT NULL |
External award processing status.
A=Adjusted D=Duplicate E=Error I=In Process Abend K=Skip P=Processed R=Reported S=Suspend U=Unprocessed Default Value: E |
| 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 | SFA_EA_TRANS_SRCE | Character(2) | VARCHAR2(2) NOT NULL |
External Award data source (file, self service, manual entry, loans, SF)
01=Manual Entry 02=External File 03=Loan Certification File 04=Student Financials 05=Self Service |
| 7 | TRANSACTION_DATE | Date(10) | DATE | TRANSACTION_DATE |
| 8 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |