SFA_EASTDNT_VW1(SQL View) |
Index Back |
|---|---|
EA Staging View by StudentStaging Detail view by Student. |
| SELECT B.EMPLID , B.INSTITUTION , B.AID_YEAR , A.SFA_EA_TRANS_NBR , A.TRANSACTION_DATE , A.SFA_EA_TRANS_SRCE , B.SFA_EA_PROC_STAT , B.SFA_EA_PROC_DTTM , B.SFA_EA_TYPE , B.SFA_EA_SOURCE , B.SFA_EA_PROGRAM_CD FROM PS_SFA_EASTAGE_HDR A , PS_SFA_EASTAGE_DTL B WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 4 | SFA_EA_TRANS_NBR |
Number(15,0) | DECIMAL(15) NOT NULL |
Transaction number used for staging external awards to the database.
Prompt Table: SFA_EASTAGE_HDR |
| 5 | TRANSACTION_DATE | Date(10) | DATE | TRANSACTION_DATE |
| 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 | 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 |
| 8 | SFA_EA_PROC_DTTM | DateTime(26) | TIMESTAMP | External award load process date/time stamp. |
| 9 | SFA_EA_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
External Award type (customer defined).
Prompt Table: SFA_EA_TYPE |
| 10 | SFA_EA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
External Award source (customer defined).
Prompt Table: SFA_EA_SOURCE |
| 11 | SFA_EA_PROGRAM_CD | Character(3) | VARCHAR2(3) NOT NULL |
External Award program code (customer defined).
Prompt Table: SFA_EA_PROGRAM |