SFA_PG_CSH_SUMM

(SQL Table)
Index Back

Pell SAS Cash Summary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_PG_SAS_RUN_DT Date(10) DATE PELL SAS Run Date
2 SFA_PG_SAS_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL PELL SAS - Sequence Number
3 SFA_PG_SAS_DTLSEQ Number(9,0) DECIMAL(9) NOT NULL Detail Sequence Number
4 PG_RECORD_INDIC Character(1) VARCHAR2(1) NOT NULL Record Indicator
5 SFA_PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID
6 PG_REPORTING_ID Character(6) VARCHAR2(6) NOT NULL Pell Reporting Campus ID
7 PG_OPE_ID_NBR Character(8) VARCHAR2(8) NOT NULL OPE ID Number
8 SFA_PG_REGION_CD Character(2) VARCHAR2(2) NOT NULL Region Code
9 PG_INST_STATE Character(2) VARCHAR2(2) NOT NULL Institution State
10 PG_PAYPER_END_DT Character(8) VARCHAR2(8) NOT NULL Pay Period End Dt
11 SFA_PG_PROCESS_DT Character(8) VARCHAR2(8) NOT NULL COD Process Date
12 SFA_PG_CSHSUM_TYPE Character(2) VARCHAR2(2) NOT NULL Cash Summary Type
13 SFA_PG_CASH_BAL Signed Number(13,2) DECIMAL(11,2) NOT NULL Beginning Cash Balance
14 SFA_PG_NETDRAW_PAY Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Drawdown/Payments
15 SFA_PG_NAPD Signed Number(15,2) DECIMAL(13,2) NOT NULL NAPD
16 SFA_PG_CSH_GT_NAPD Signed Number(15,2) DECIMAL(13,2) NOT NULL Cash GT NAPD
17 PG_SOA_DTL_SEQ Number(6,0) INTEGER NOT NULL Pell SOA Detail Sequence Nbr