SFA_PG_CSH_DTL

(SQL Table)
Index Back

Pell SAS Cash Detail

# 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_ATTEND_ID Character(6) VARCHAR2(6) NOT NULL Pell Attending Campus ID
8 PG_OPE_ID_NBR Character(8) VARCHAR2(8) NOT NULL OPE ID Number
9 SFA_PG_REGION_CD Character(2) VARCHAR2(2) NOT NULL Region Code
10 PG_INST_STATE Character(2) VARCHAR2(2) NOT NULL Institution State
11 PG_PAYPER_END_DT Character(8) VARCHAR2(8) NOT NULL Pay Period End Dt
12 SFA_PG_PROCESS_DT Character(8) VARCHAR2(8) NOT NULL COD Process Date
13 SFA_PG_CSHTRN_TYPE Character(2) VARCHAR2(2) NOT NULL Cash Transaction Type
14 SFA_PG_TRANS_DATE Character(8) VARCHAR2(8) NOT NULL Transaction Date
15 SFA_PG_TRANS_AMOUT Signed Number(15,2) DECIMAL(13,2) NOT NULL Transaction Amount
16 PG_PAY_CNTLNBR Number(13,0) DECIMAL(13) NOT NULL Payment Control Number
17 PG_SOA_DTL_SEQ Number(6,0) INTEGER NOT NULL Pell SOA Detail Sequence Nbr