SFA_FWS_STG

(SQL Table)
Index Back

Federal Work Study Staging

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

Default Value: 2022

Prompt Table: SFA_FWS_STG_SRC

3 SFA_FWS_AWRD_TYPE Character(4) VARCHAR2(4) NOT NULL FWS Financial Award Type
FSG=FSEOG
FWS=Federal Work Study

Default Value: FWS

4 SFA_FWS_SEQ Number(6,0) INTEGER NOT NULL Sequence
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

6 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: SFA_COD_YEAR_VW

7 SFA_FWS_START_DT Date(10) DATE Earnings Period Start Date
8 SFA_FWS_END_DT Date(10) DATE Earnings Period End Date
9 ISIR_TXN_NBR Number(2,0) SMALLINT NOT NULL Transaction Num
10 SFA_FWS_INST_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Institutional Share Amount
11 SFA_FWS_STATUS Character(1) VARCHAR2(1) NOT NULL FWS Status
A=Accepted
E=Error
P=Pending Transmission
T=Transmitted

Default Value: P

12 SFA_FWS_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Earnings Amount
13 SFA_FWS_FED_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Federal Share Amount
14 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time